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
 Other SQL Server Topics (2005)
 login failed

Author  Topic 

sandhyakalsotra
Starting Member

22 Posts

Posted - 2011-04-18 : 08:37:17
Sir,
I have server authentication enabled with login sa and password and it was working fine but suddenly the client stopped working and when i tried to connect the server in server authentication mode, it failed.
though the window authentication is logging in. but I need sa login to work on clents.


sandhya

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2011-04-18 : 08:58:57
sa?

Have you traced on the server what is happening? Has the password changed?

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

sandhyakalsotra
Starting Member

22 Posts

Posted - 2011-04-18 : 12:48:35
password is same and it was never fiddled with

sandhya
Go to Top of Page
   

- Advertisement -