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 |
|
muzzettemm
Posting Yak Master
212 Posts |
 Posted - 2009-06-12 : 14:21:15
|
| Hi all I am having a hard time linking two servers together one is GCSQL and the other is GCSQLTEST. I go to Server objects then right click then Link Server then I type in GCSQLTEST where it says link server. then click ok and I get an error message. what am I doing wrong, as you can see I am new at this. Can someone help pleaseI was able to ping it successfully by name . and when I try to link this is the error message I getTITLE: Microsoft SQL Server Management Studio------------------------------"The linked server has been created but failed a connection test. Do you want to keep the linked server?"------------------------------ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)------------------------------The OLE DB provider "SQLNCLI" for linked server "GCSQL" reported an error. Authentication failed.Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "GCSQL".OLE DB provider "SQLNCLI" for linked server "GCSQL" returned message "Invalid authorization specification". (Microsoft SQL Server, Error: 7399)For help, click: Source: MSSQLServer ID: 7399 (SQL Server 09.00.3077) - Events And Errors Message Center: Message Details------------------------------BUTTONS:&Yes&No |
|
|
|
|
|
Problems Linking Servers