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)
 Remote login into Server

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.
Go to Top of Page
   

- Advertisement -