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 |
|
mobasha
Starting Member
45 Posts |
 Posted - 2007-05-20 : 18:14:53
|
| hi every one i know this might be silly , am trying to make a linked server i try it yesterday and i worked just fine but today it is not working i must left s.th out or there is s.th to addi did run this codeEXEC sp_addlinkedserver @server = 'TEST', @srvproduct = 'SQLServer OLEDB Provider', @provider = 'SQLOLEDB', @datasrc = 'mobasha2', @catalog = 'dc_desktop'EXEC sp_addlinkedsrvlogin 'TEST', 'false', 'sa', 'sa', ''can any one tell me whats wrong???????cos if there is am sure that i cant see?MobashA |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-20 : 20:35:26
|
| Did you get any error message? Cau you see it in em? |
 |
|
|
mobasha
Starting Member
45 Posts |
Posted - 2007-05-21 : 01:54:19
|
| yes "sa is not a trusted sql authentication" or so i dont remember it exactly but am sa on both serversMobashA |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-21 : 10:34:39
|
| Ensure you enabled sql authentication on linked server. |
|
|
|
mobasha
Starting Member
45 Posts |
Posted - 2007-05-22 : 02:12:10
|
| yes i checked that and nothing wrong,any way a did try it at work and it worked just fine ///am very confuised about it ????/MobashA |
|
|
|
|
|
|
configuring linked server