SQL Server Performance Forum – Threads Archive

Cannot Connect Sql Server 2005

Hi , I am not able to connect to Sql Server 2005 on my notebook. I am using XP and installed with client. But not able to find any server from the object browser. Already set up the remote connection to allow TCP/IP and name pipe. Anything else I need to do ? Thanks ,
Travis

---

Are you able to ping the server? Roji. P. Thomas
SQL Server MVP
http://toponewithties.blogspot.com

---

KBAhttp://g.msn.com/9SE/1?http://suppo…2645578ba4b6&POS=19&CM=WPU&CE=16&CS=AWP&SR=16 and bloghttp://blogs.msdn.com/sql_protocols…2645578ba4b6&POS=15&CM=WPU&CE=12&CS=AWP&SR=12 should get you relevant checkup. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

---

http://dineshasanka.spaces.live.com/blog/cns!22A79FCE82651673!295.entry —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

---

try putting localhost in the server name instead of the Name of your PC
AKTHAR

---

Sorry, I thought you were trying to connect to a different machine. Roji. P. Thomas
SQL Server MVP
http://toponewithties.blogspot.com

---

Please confirm that Mssqlserver services are running on your notebook? Olu Adedeji

---

Hi , Sorry that I am confusing you all. Actually I am try to connect to server. I am able to ping the server. Services are restarted. Thanks ,
Travis

---

do you have permissions to connect to SQL server?? whats the error message that you are getting while trying to connect to server

---

timeout expired. The timeout period elapsed prior to complete of the operation or the server is not responding

---

Try these steps: to test if the client PC can connect to SQL Server
Create a text file and rename to .udl
Double-click the udl file
Choose the provider for MS SQL Server
Choose or type-in your Server name in the drop-down lists.
Choose Authentication Mode, Windows or SQL.
Test Connection. If you cant connect , it can be:
1. Due to MDAC – try re-installing MDAC
2. Your server may be running more than one Instance , you then need to enter the ServerNameInstanceName Hope this helps AKTHAR

---

One of the KBA refers This problem occurs because the permission cache entries for the Server object are initialized during the connection process. During this process, the SQL Server login is not a member of the sysadmin fixed server role. You experience 100 percent CPU utilization occurs when the permission cache for the Server object is initialized. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

---

]]>