March 1, 2009 at 2:05 am
hello
am gettimng the error login failed for user sa...and wen i chk error log file..it is howing tht login failed for user bcz an attempt to login using sql authentication while server is configured as windows authentication....
i dont know how to resolve...i need help
March 1, 2009 at 5:48 am
If your SQL Server is configured for Windows authentication only, you will not be able to connect with the sa account. Only Windows user accounts and members of Windows security groups are able to do so. If you have to have a SQL Server-based login, like sa, connect, you need to configure your SQL Server for Mixed Mode and then restart SQL Server.
You didn't say whether bcz was a SQL Server login or a Windows login. If it's a SQL Server login, then it is like sa. It will not be able to connect until you switch SQL Server into Mixed Mode. But before you do that, you should try and give permissions and connect with your Windows user account.
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply