We help IT Professionals succeed at work.
Get Started

Linked server error for sql 2008

2,469 Views
Last Modified: 2012-05-09
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
ADDITIONAL INFORMATION:

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)



Comment
Watch Question
C# ASP.NET Developer
Top Expert 2010
Commented:
This problem has been solved!
Unlock 1 Answer and 10 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE