October 22, 2007 at 10:56 am
I have a sql server 2005 remotely, need to connect from client using sql management studio. I am unable to connect from one of the client machine and able to connect from different machine.
The tcp/ip, named pipes and sql browser is enabled in server and windows firewall is off in client.
I am getting (provider: sql network interfaces, error 26 - error locating server/instance specified)
Please throw your suggestions.
October 22, 2007 at 1:14 pm
Can the client machine ping the server machine?
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 22, 2007 at 2:06 pm
yep the client can ping the server machine
October 22, 2007 at 5:30 pm
Try connecting via IP address.
October 29, 2007 at 10:30 pm
Hi Friend,
Plz use the following procedure.
1. Open the following file in any notepad editor
c:\WINNT\SYSTEM32\DRIVERS\ETC\hosts
2. Type the following in the file
IPADDRESS SYSTEMNAME
Ex: 192.144.125.42 MYSYS
3. Save the file and restart the server.
4. And in the management studio while connecting just type the systemname of the sqlserver you are trying to connect.
5. And also make sure the remote connections are on the remote system using the surface area configuration tool.
thanks & regards
chandra mohan n
[font="Verdana"]Thanks
Chandra Mohan[/font]
October 29, 2007 at 10:33 pm
Hi Friend,
Plz use the following procedure.
1. Open the following file in any notepad editor
c:\WINNT\SYSTEM32\DRIVERS\ETC\hosts
2. Type the following in the file
IPADDRESS SYSTEMNAME
Ex: 192.144.125.42 MYSYS
3. Save the file and restart the server.
4. And in the management studio while connecting just type the systemname of the sqlserver you are trying to connect.
5. And also make sure the remote connections are on the remote system using the surface area configuration tool.
thanks & regards
chandra mohan n
[font="Verdana"]Thanks
Chandra Mohan[/font]
October 31, 2007 at 8:08 am
Have you configured the SQL Server via the SQL Server Surface Area Configuration Tool to allow remote connections?
November 5, 2007 at 12:25 pm
did you create and instance on the sql server 2005. you may need to connect stating the server name and the instance for ex:
servername\instancename
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply