1

I have a basic peer network (WORKGROUP) with PCs connected to sql server 2008 on a Windows 7 machine. I took one XP pc and the server home and connected to the server with no problems. When I plugged them back in at the office, I got the following error with my sql server tcpip odbc connection (sql server login not windows auth):

--------------------------- Microsoft SQL Server Login --------------------------- Connection failed: SQLState: '01000' SQL Server Error: 67 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). Connection failed: SQLState: '08001' SQL Server Error: 17 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

The next day I took a different client machine running windows 7 and the server home again. The client could login fine but when I plugged them back in at the office I got the same issue. I can ping the server no problems and share files. Same problem with Firewall turned off on all machines. TPC enabled on server port 1433. The two client machines cant log in using SQL server management studio either when they were working fine before.

All other pcs which remained in the office can still connect no problem.

Improve this question
12
  • Log in via SSMS on the SQL server machine itself, and check the accounts and permissions. Commented Jan 11, 2012 at 9:31
  • In ssms logins are unchanged. All clients are connecting using the same sqlserver login and pwd Commented Jan 11, 2012 at 10:05
  • faulty client can see the server instance using osql -l Commented Jan 11, 2012 at 10:25
  • error - both clients (the xp and the windows 7 one) are 32bit but the server is 64bit Commented Jan 11, 2012 at 11:12
  • using ms network monitor from client gets 'Icmp: Destination Unreachable Message, Port Unreachable, 81.200.**.**:1434' Commented Jan 11, 2012 at 11:34

1 Answer 1

Reset to default
1
  • Allocated the client a static IP in its TCPIPv4 settings identical to its DHCP assigned IP
  • Reserved that address in the netgear router lan ip table
  • ipconfig /release
  • ipconfig /renew
  • Rebooted pc and router now connects via servername
  • Took both home again and back without issue
Improve this answer
1
  • Great to see that you found a solution to your problem. Please come back and put this answer as your accepted one, so that it won't stay open (and get repeatably bumped up). Commented Jan 14, 2012 at 2:23

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.