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.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  Getting Error when Execute sp_addlinkedserver

Author  Topic  sonimitu Starting Member 1 Post Posted - 2009-03-16 : 03:58:49 Hi, All, Plz help me .. I am getting error when i excecute [b]sp_addlinkedserver[\b] OLE DB provider "SQLNCLI" for linked server "gnr_app_server" returned message "Login timeout expired". OLE DB provider "SQLNCLI" for linked server "gnr_app_server" 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 0 Named Pipes Provider: Could not open a connection to SQL Server [53]. OLE DB provider "SQLNCLI" for linked server "gnr_app_server" returned message "Invalid connection string attribute". Soni Mitesh