If you receive an error message similar to "Unable to add data connection. Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified" and you are looking for a solution to the same, then you have come to the right place.
The following helped me solve this problem:
Install the following from the Microsoft SQL Server 2008 Feature Pack, August 2008 site:
1) Microsoft SQL Server Management Objects, and
2) Do a repair install on Microsoft SQL Server System CLR Types
This should solve the problem you are having.
Happy debugging!
Showing posts with label SQL Server 2008. Show all posts
Showing posts with label SQL Server 2008. Show all posts
Tuesday, May 25, 2010
Friday, August 8, 2008
Microsoft Launches SQL Server 2008
Microsoft has released a new version of SQL Server which promises to make the life of database administrators easier.
For database administrators, the addition of new management functionality makes SQL Server 2008 a great new product. The new policy management, multiple server query capability, configuration servers, and data collector/management warehouse offer powerful new abilities for database administrators who are often responsible for managing large and complex database environments with hundreds or thousands of databases on dozens or even hundreds of servers.
The new Multiple Server Interaction and Configuration Servers capabilities will come in handy when one needs to execute queries against multiple servers at the same time. One can register servers in the Management Studio and then place those servers together under a grouping. When needed to execute a policy or query against all the servers in the grouping, one can simply right-click on the grouping and do so.
Another great new management feature is the Data Collector. Database administrators often need to collect management data from a large number of servers, and many of these DBAs have created their own custom solution for doing so. The Data Collector is a built-in mechanism that eases the task of collecting management-related data. It allows you to use the SQL Server Agent and SQL Server Integration Services (SSIS) to create a framework that collects and stores your data while providing error handling, auditing, and collection history.
Another new feature, Hot Add CPU, lets you add additional CPUs to a database server without affecting the availability of the databases residing on that server.
SQL Server 2008 also introduces sparse columns, which allow NULL values to be stored without taking up any physical space on the disk. Because sparse columns do not consume actual space, tables that contain sparse columns can actually exceed the 1,024 column limit.
You can access tutorials for SQL Server 2008 at http://technet.microsoft.com/en-us/library/ms167593.aspx and can see the details for various editions of SQL Server at http://technet.microsoft.com/en-us/library/ms144275.aspx
For database administrators, the addition of new management functionality makes SQL Server 2008 a great new product. The new policy management, multiple server query capability, configuration servers, and data collector/management warehouse offer powerful new abilities for database administrators who are often responsible for managing large and complex database environments with hundreds or thousands of databases on dozens or even hundreds of servers.
The new Multiple Server Interaction and Configuration Servers capabilities will come in handy when one needs to execute queries against multiple servers at the same time. One can register servers in the Management Studio and then place those servers together under a grouping. When needed to execute a policy or query against all the servers in the grouping, one can simply right-click on the grouping and do so.
Another great new management feature is the Data Collector. Database administrators often need to collect management data from a large number of servers, and many of these DBAs have created their own custom solution for doing so. The Data Collector is a built-in mechanism that eases the task of collecting management-related data. It allows you to use the SQL Server Agent and SQL Server Integration Services (SSIS) to create a framework that collects and stores your data while providing error handling, auditing, and collection history.
Another new feature, Hot Add CPU, lets you add additional CPUs to a database server without affecting the availability of the databases residing on that server.
SQL Server 2008 also introduces sparse columns, which allow NULL values to be stored without taking up any physical space on the disk. Because sparse columns do not consume actual space, tables that contain sparse columns can actually exceed the 1,024 column limit.
You can access tutorials for SQL Server 2008 at http://technet.microsoft.com/en-us/library/ms167593.aspx and can see the details for various editions of SQL Server at http://technet.microsoft.com/en-us/library/ms144275.aspx
Subscribe to:
Posts (Atom)