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)
 adding a new user to a DB SQL - (2005)

Author  Topic 

macsterling
Yak Posting Veteran

56 Posts

Posted - 2008-08-15 : 12:19:04
I am trying to bring up an application and I am getting an error saying - logon failed for user 'sa' - I have been working on a different SQL application and must have changed something. I have to make sure that both systems can work. How can I fix this?

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2008-08-16 : 07:59:18
Are you using SQL Server Authentication ? Are you sing the right password? You can check the passwords via trying to logon via SQL Server Management Studio. I would recommend you don't use "SA" as user.

Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com
Go to Top of Page
   

- Advertisement -