April 4, 2013 at 12:25 pm
Hi All,
I have a created a central managment server with windows security. Then when I am trying to register other servers to the CMS I get the below error.
TITLE: Registered Servers
------------------------------
Invalid value for key 'network library'. (System.Data)
I tried googling the above error but no luck. DO any one know what might be causing it?
I have put 2 attachemnts of the scrren shots.
Note: When I use sql server authentication it works. The above error is raised only when I use Windows authentication.
A little insight would be gratly appriciated.
Regards,
DBA
April 4, 2013 at 4:12 pm
What is the version of SQL Server Management Studio you are using?
What is the version of SQL Server of the instance you are connecting to?
Todd Carrier
MCITP - Database Administrator (SQL 2008)
MCSE: Data Platform (SQL 2012)
April 4, 2013 at 4:19 pm
Maybe check the Network Protocol selection under Connection Properites Tab in the New Server Registration window.
Also, check SQL Server Configuration Manager locally for Native Client> Client Protocols> is TCP/IP enabled?
Todd Carrier
MCITP - Database Administrator (SQL 2008)
MCSE: Data Platform (SQL 2012)
April 4, 2013 at 4:30 pm
I am using SQL Server 2008 R2 and SSMS shipped with it.
I have recently upgraded the SP to SP2
April 4, 2013 at 4:34 pm
New Server Registration window does not even open. The error pops up even before that.
Yes, TCP/IP is enabled.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply