Hi,
I am trying to connect a windows 7 professional client to sql server 2005 installed on a windows 7 professional. I am getting the error nº 26 "Error locating server/instance".
Both firewalls are disable.
The ping command works in both sides and I run the portqry command on the two computers and I get a successful result .
The Browser is running in a "Network service", the protocol TCP/IP is enable with tcp dynamic ports.
My string connection is:
"Data Source=Desktop\\xxx; Initial Catalog=SII; Network Library =DBMSSOCN; User ID=admin; Password=yyy";
Where xxx is the instance name and Desktop is the name of the server machine. I am using visual studio 2010 C#.
The Remote server connections are on. I have tried everything but the error keeps appearing.
In the server side, the program runs perfectly.
What can I do…I am losing my mind L
Thanks
Loading
Pravin GhadgePosted Oct 2, 2011, 8:38 AM
Check windows firewall setting of Server PC.
If it is 'On'. Make it 'Off'.
Regards,
Pravin
FafemanPosted Sep 28, 2011, 10:07 AM
the TCP/IP protocol is enable !!!
Any more sugestion?
Thanks,
Fafeman
Pravin MorePosted Sep 28, 2011, 3:19 AM
check weither TCP/IP protocol really enabled on your server? It's off by default, and stays off in most cases .
Check this goto
Start Menu > Microsoft SQL Server > Configuration Tools > SQL Server Configuration Manager > SQL Server Network Configuration....

check this may be it will help you.............
Thanx,
Pravin.