I have recently just stood up a new MS sql 2008 server in a win2008 clustered congfiguration, everything I have gotten working but my linked servers. It is giving me the following errors. I went in and made suer my tcp/ip connections are on but after this I find miinimal information on how ti fix this error. I am trying to create connections to my web servers which run on win 2003. What do I need to do.
TITLE: Microsoft SQL Server Management Studio
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
The OLE DB provider "SQLNCLI10" for linked server "servername" reported an error. Authentication failed.
Cannot initialize the data source object of OLE DB provider "SQLNCLI10" for linked server "Severname".
OLE DB provider "SQLNCLI10" for linked server "Servername" returned message "Invalid authorization specification". (Microsoft SQL Server, Error: 7399)