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 |
|
mattd_nz
Starting Member
6 Posts |
 Posted - 2004-07-20 : 22:16:17
|
I think I'm going mad - please help! I have successfully managed to set up MySQL databases as linked servers, but can I set up a second SQL Server as linked? I can not, despite a good couple of hours on books online/google!.Ok the server I'm linking to is not in the same Network i.e. when setting up an ODBC source using this server, the name is not listed. I'm told this is something to do with Novell - I can ping the box and if I enter the IP adress in the server box the test connection works fine. So in my first go I check the SQLServer option in Linked Server Properties 'server type' box and use th IP address as the server name - this produces a 7399 Error.Second go. Set up an ODBC data - connects fine, then use this as the 'Data Source' in the.......well what do you know, problem fixed whilst I was testing things and writing my comment.  I'm off to nod quietly in the corner to myself.  The answer was in the error. - needed Uid Pwd in the provider string. Incidentally is there any way to get over the clear text saving of passwords here? which seems rather unsecure. |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-20 : 23:58:10
|
| Use OLE DB for SQL Server.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
Linked Servers ... Again