Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SQL SERVER NOT ABLE TO CONNECT

Author  Topic 

alerizwe
Starting Member

4 Posts

Posted - 2008-05-18 : 01:51:48
Hi,

I have sql server 2005 with service pack 2 installed on my laptop.
I want to connect to a remote database and the problem is with correct credentials the login screen keeps on showing and nothing happens. However if i enter invalid credentials it shows login denied screen. All other workstation in my department are able to connect. Even i was connecting to it without any problems. Suddenly this thing started.


Anybody having some idea why its happening.

Thanks in advance.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-18 : 21:42:27
Maybe network link issue. Can you ping the server from your laptop?
Go to Top of Page

alerizwe
Starting Member

4 Posts

Posted - 2008-05-19 : 00:11:39
Yes i am able to ping the server. The issue is that i am even unable to connect to my local database.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-19 : 23:32:36
Is sql service running? Which protocol do you use for sql connection?
Go to Top of Page

alerizwe
Starting Member

4 Posts

Posted - 2008-05-27 : 04:02:43
Yes sql service is running... i have enables both TCP and Named Pipe connections.... its just when i enter correct credentials the "connect to server" dialog box shows its processing but nothing happens and when i enter incorrect credentials it shows
"Login failed for user sa".
Go to Top of Page

alerizwe
Starting Member

4 Posts

Posted - 2008-05-27 : 06:08:52
I found the solutoin.... i ve somehow hidden my user's Application Data folder. Removing the hidden option fixed my problem.
Go to Top of Page
   

- Advertisement -