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 |
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
 Posted - 2001-12-06 : 16:28:09
|
| I have 2 machines on the same networkthey are both on the same domainI can use the enterprise manager to see one the other sql machineand I can even add it but I can't log in with the sa password.However I can loggin with sa password locally.Any thoughts????? |
|
|
manishrawat
Starting Member
9 Posts |
Posted - 2001-12-07 : 11:58:09
|
| Check the SQL server properties in Enterprise manager. Go to security tab.Authentication should be SQL Server and Windows. You might have just set it to Windows.If it is just Windows it won't allow sa or any other sql server login except the Windows Authentication(credentails of logged on user) |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2001-12-10 : 15:17:29
|
| I would also stop using the SA account and setup a personal login with the sysadmin server role. AFAIK there is nothing that SA can do that any other sysadmin cannot.-------------------It's a SQL thing... |
|
|
|
|
|
|
Error loging in