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 |
|
d3ng
Yak Posting Veteran
83 Posts |
 Posted - 2008-11-25 : 01:00:59
|
| Hi experts!I would like to ask regarding on how to query two MS SQL DB on different server? I already used the:EXEC sp_addlinkedserver @server='darren', @srvproduct='', @provider='SQLNCLI', @datasrc='developer4\darren'but I am getting this error msg:OLE DB provider "SQLNCLI" for linked server "darren" returned message "Login timeout expired".OLE DB provider "SQLNCLI" for linked server "darren" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".Msg 53, Level 16, State 1, Line 0Named Pipes Provider: Could not open a connection to SQL Server [53].But I already checked my database setup the remote connection checked box is already checked.www.itchytech.com |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-25 : 01:07:36
|
| try this outhttp://sqlserver2000.databases.aspfaq.com/how-do-i-prevent-linked-server-errors.html |
 |
|
|
|
|
|
Query using 2 different database server