Welcome to the world (new face) of Knowledge Sharing Network.
To track the older blog posts refer to our historical knowledge sharing site  and you will find this as your destination for SQL Server knowledge pool.

Follow SQLMaster on Twitter SqlServer-QA.net - Knowledge Sharing Network (@sqlmaster)

SQL Server Installation : SMO related problems and client toosl issue - 'Microsoft.SqlServer.Management.Smo.Table.UrnSuffix' not found - SQL Server Knowledge Sharing Network (@sqlmaster)

SQL Server Installation : SMO related problems and client toosl issue - 'Microsoft.SqlServer.Management.Smo.Table.UrnSuffix' not found

A typical problem occurs when SQL Server client tools do have any issues.

There is no easy way to say that SSMS (client tools) are corrupted, unless you can reproduce the same issue on other machine it cannot be assured. If it is a bug from tools you can easily file them on Microsoft connect site and preferably search for similar problem before posting a new one. 

Here is an interesting issue happened on my laptop and not on other desktop when I was trying to connect to a SQL intance (2008 version). As a part of testing I was trying to add a new login to that instance from Management Studio from the laptop which presented with an error :Method 'Microsoft.SqlServer.Management.Smo.Table.UrnSuffix' not found. (SQLEditors).

I was able to add the login and do the rest of stuff using scripts within the SSMS tool but not through certain steps using GUI. As referred tried to reproduce the issue from another machine where no issues reported, so that confirmed that client tools on laptop are stuffed. So attempted to repair the installation of SQL Server on my machine, well not an easy option from SQL Server Installation Center when used setup. Next thought was to uninstall the client tools & reinstall, which isn't a viable option to go.

So here is the process I followed which is a reliable way to correct any corrupted files on your SQL Server tools:

Launch Installation Center -> Maintenance -> Repair

On the SELECT INSTANCE screen, select only "Repair shared features only" option from the drop down list.

As a part of repair process I have restarted the laptop to ensure all the changes are affected for good, it does work. Just an additional note that if you are unable to recover the problem with this REPAIR method then you have to opt the way to uninstall & reinstall of tools and services again.  You need to perform the uninstall from Control Panel --> Add/Remove Programs, on the SELECT INSTANCE screen,  select only "Remove shared features only" option from the drop down list. Make sure that you have un-checked the necessary boxes that might even uninstall the SQL Server services. 

There is a note about actual SSMS and SSMSE (for SQL Express editions), for the earlier you have to go by SQL setup media that was used and for SSMSE you can download from http://msdn.microsoft.com/en-us/library/ms365247.aspx here to reinstall.

Edit:

Also I fould few refereces about SMI installation from this link: http://msdn.microsoft.com/en-us/library/ms162189.aspx  and you can obtain SMO management featuer pack from SQL Server 2008 R2 Feature Pack, get yours now link.

Published Wednesday, July 7, 2010 2:36 PM by ssqa.net

Comments

No Comments