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 |
|
vemulavijay
Starting Member
32 Posts |
 Posted - 2004-12-02 : 13:27:21
|
| hi ,i have win2000 professional and sql server 2000 installed in 2 systems. when i try to access the other system using query analyzer,i get a error message login failed for user 'null'. i even changed windows authentication mode to mixed mode, restared the sql server in both systems. but no use. it gives the same error message. note : i am able to access the files of other system through network. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-12-02 : 14:12:46
|
| Is the other server on a different domain than what your machine is on? Is their a trust relationship setup?Tara |
 |
|
|
vemulavijay
Starting Member
32 Posts |
Posted - 2004-12-02 : 20:58:28
|
| hi tara, thanks for the reply.both systems are on the same workgroup. i have not used any domain. |
|
|
|
vemulavijay
Starting Member
32 Posts |
Posted - 2004-12-02 : 21:01:10
|
| hi ,how to establish trust relationship |
|
|
|
parthi_75
Starting Member
1 Post |
Posted - 2004-12-03 : 02:04:10
|
CHECK FOR CLIENT NETWORK UTILITY AND ADD ANOTHER MACHINE WITH TCP/IP ADDRESS OR MACHINE NAME AFTER THAT GO TO QUERY ANALYZER AND CHOOSE THE SERVER WHIHC U NEED TO ACCESS. HOPE IT HELPS PARTHIquote:
Originally posted by vemulavijay
hi ,i have win2000 professional and sql server 2000 installed in 2 systems. when i try to access the other system using query analyzer,i get a error message login failed for user 'null'. i even changed windows authentication mode to mixed mode, restared the sql server in both systems. but no use. it gives the same error message. note : i am able to access the files of other system through network.
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-12-03 : 12:14:10
|
| If you are using workgroups, then you'll need to use SQL authentication. Windows Authentication will not work.Tara |
|
|
|
|
|
|
sql connection problem