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.
| Author |
Topic |
|
dvaddi
Starting Member
21 Posts |
Posted - 2007-11-27 : 10:37:18
|
| Hello,We have a SQL Server 2005. I am able to remote login into the server using my desktop user/password. But when I am unable to login using sa/password. It says , check the username , domain etc.what chagnes do I have to make so , that I can remote login into the server from my desktop using the SA/password.Thanks |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-11-27 : 11:29:32
|
Is the server set to mixed mode? Have you tried connecting as SA from the server itself? There shouldn't be a difference with remote login with SA vs Windows Authentication providing you have the right credentials and SQL Server authentication is enabled. Future guru in the making. |
 |
|
|
|
|
|