Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

LINK Server/Provider Expand / Collapse
Author
Message
Posted Tuesday, February 17, 2009 7:50 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 14, 2009 7:33 AM
Points: 112, Visits: 61
Good dya,

I am using SQL server 2005. When I tried link a server, I click the server objects and then linked servers. Then when click the Provider in other to select the provider type I received the following error message after about 5 minutes:

TITLE: Microsoft SQL Server Management Studio
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Cannot insert the value NULL into column 'Description', table 'tempdb.dbo.#OLEDBProv__________________________________________________________________________00000000001D'; column does not allow nulls. INSERT fails.
The statement has been terminated. (Microsoft SQL Server, Error: 515)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.4035&EvtSrc=
MSSQLServer&EvtID=515&LinkId=20476

Can some help with this issue?



Post #658526
Posted Tuesday, February 17, 2009 9:05 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 11:40 AM
Points: 282, Visits: 2,209
see if this is related at all:
http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/46eb7c06-e2fd-463b-b3d4-2ebbd81215cc/


MCITP, Database Administrator
A hodgepodge of Information Technology and Life
LinkedIn Profile
My Twitter
Post #659034
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse