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 |
|
sqllover
Constraint Violating Yak Guru
338 Posts |
 Posted - 2007-02-10 : 01:25:05
|
| hi, i am trying to connect another system to work in remote system database,i am getting the following errorlogin failes for user 'sa' actually remote system's username='sa'password ='sa'remote system is on also.but i am unable to connect with that system's database.so please help me to connect with that system pleasei tried using enterprice manager i couldn't connnect i tried using sqlserver query analyser also still i couldn't connect |
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2007-02-10 : 04:03:44
|
| There are a few things to check. First off the default username/pw isuser: saPw:The pw should be blank, you have 'sa' typed above, and the only way that's possible is if you changed the password policy option. Also your server needs to be running in mixed authentication mode (You would've selected this during install.)Other then that by default sql server 2005 (and I believe 2000) does not have any connection protocals enabled, so you would need to open up your servers control panel and enable the protocal you are wishing to connect on (i.e. TCP/Named Pipes/etc.)One of those should do the trick and allow you to connect. |
 |
|
|
sqllover
Constraint Violating Yak Guru
338 Posts |
Posted - 2007-02-10 : 04:53:46
|
| hi Vinnie881,am using sqlserver 2000 actually past 1 week it worked fine,but suddently today it maske s problemmy sqlserver username='sa' password='sa'and the username and password of database which i want to use issqlserver username ='sa' password='sa'i installed software correctly.last week it worked fine.but now it shows eror like that.so please help me to solve the error.o that only i can access the database of that remote system which is connectd in lan in my comapany. |
|
|
|
|
|
|
error while connecting to remote server