pkrug


I am trying to connect to a sql server 2005 server using either windows auth or sql server auth but I can not. When I click on the connect button to connect to a server it never connects. I can not cancel once I press connect. It never times out after I press connect. I removed all registered servers that were registered previously. I have uninstalled all software that involved sql server (and sql2000) run a registry cleaner(not microsofts), installed the software to a new directory and still I can not connect to the sql2005 server (the only db).

Any ideas

I am running Windows XP with latest services packs for both windows and sql server. I have visual studio 2005 installed on my machine and I have had sql express installed on it previously.




Re: SQL Server Management Studio - Connecting to Server never connects to server

pkrug


I tested the connection from my machine to the production database system using osql and it worked fine. I regestered the server tested the connection (using the management studio) and it tested fine. When I try to connect to the database engine it does not work. Any ideas Things to test






Re: SQL Server Management Studio - Connecting to Server never connects to server

pkrug

I tested two scenarios.

1) I had another user login to my machine and launch the Sql Server studio and then I had them connect to the same db server I was trying to connect to. They could connect.

2) I logged into another machine, launched SQL Server Management Studio and I was successful connecting to the server.

When I had the other user login to my machine and launch the SQL Server Management Studio I noticied that it ran a configuration utility for first use. When I uninstalled the SQL Server Management Studio on my machine it never came up again. Is there any way that I can get the configuration utility to run again on my account

Any ideas how to fix this problem