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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Could not load file or assembly

Author  Topic 

amirs
Constraint Violating Yak Guru

260 Posts

Posted - 2015-01-08 : 23:09:43
Dear Memeber

i am using sql server2008 R2

I have connect a sql server the following error is occured

"Could not load file or assembly;Microsoft.SqlServer.ConnectionInfo, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91; or one of its dependencies. The system cannot find the file specified. at SQLServerInitInMsqladm() at SQLServerInit()"

please tell me any one facing this problem and its solution.

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2015-01-12 : 01:54:44
These problems can be tricky. First thing , Use this query to list the CLR objects and associated procedures
http://www.sqlserver-dba.com/2014/11/how-to-list-all-clr-objects-and-associated-procedures.html

A couple of things to check
1)SMO objects need to be of the same version as the destination SQL Server . Can you confirm the versions?
2)SMO objects need to have the same bit rate - 32 versus 64.Otherwise you get an architecture mismatch. Can you check?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -