Posts Tagged ‘SQL Management Studio’

Error when using SQL Management Studio 2008 in Windows 7 x64 with Vault Installed

Friday, October 30th, 2009

I have been using my new Windows 7 machine for the last few days and have hit a few problems getting things set up. Fortunately, I have managed to work around most of them. This was one of the first ones.

I was using Microsoft SQL Management Studio 2008. When I attempted to pop out the list of databases on a server in object explorer, I got the following error: –

“Unable to cast COM object of type ‘System.__ComObject’ to interface type ‘Microsoft.VisualStudio.OLE.Interop.IServiceProvider’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{6D5140C1-7436-11CE-8034-00AA006009FA}’ failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).”

After a little research, I found several pages with different solutions to the problem. A common thread is that it seems to involve SourceGear Vault Client (source control software). I suspect that this is only a problem for people who are using old versions of it (I’m using the spectacularly old version of 2.0.6!).

The solution which finally worked for me was to copy the Vault client folder, uninstall Vault, copy it back and make manual shortcuts. Then, in order to register it as a source control provider, I used the following registry file: –
Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SourceCodeControlProvider]
"ProviderRegKey"="Software\\SourceGear\\Vault Client"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SourceCodeControlProvider\InstalledSCCProviders]
"SourceGear Vault Client"="Software\\SourceGear\\Vault Client"

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SourceGear]

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SourceGear\Vault Client]
"SCCServerName"="SourceGear Vault Client"
"SCCServerPath"="C:\\Program Files (x86)\\SourceGear\\Vault Client\\VaultIDE.dll"

To use a registry file, you need to copy and paste the code into a new notepad file and save it with a .reg extension. When you double click on it, Windows will ask if you want to add it to the registry. You may need to change your SCCServerPath before saving the file.

Thanks to Henrik Bruun’s post on this page for the registry fix.

SQL Management Studio 2008 Import/Export Data (Replacement for DTS)

Wednesday, July 1st, 2009

The old SQL Enterprise Manager used to have something called Data Transfer Services, which allowed you to transfer data between SQL Server and a different database using ODBC.  This was curiously lacking in SQL Server Management Studio 2005 (at least the Express one) unless I missed it.

However, in the 2008 version, you can right click on a database, select All Tasks and there are options for Import Data and Export Data, which open an appropriate wizard to guide you through the process.

Installing SQL Server 2008 Management Studio Express

Wednesday, March 4th, 2009

I used to use SQL Server 2005 Express and recently upgraded to 2008.  SQL Management Studio 2005 won’t connect to 2008 – it gives an error, so I went looking for management studio express 2008, which I couldn’t find anywhere.  I then tried downloading SQL Server 2008 Express to dig it out from there, which does work, but requires several pre-requisites.  You might want to bear this in mind (and I might have missed something – let me know if I have)…

  1. Make sure you have .NET Framework 3.5SP1 installed
  2. Make sure you have Windows Installer 4.5 installed
  3. Make sure you have Windows Powershell installed
  4. Uninstall management studio 2005 if you have it installed
  5. Reboot (might not be necessary, but probably sensible)
  6. Download and run SQL Server 2008 Express With Tools
  7. Installation > New SQL Server stand-alone installation or add features to an existing installation
  8. follow through until you get to the features list
  9. Select Management Tools – Basic
  10. You’ll probably have to reboot again

That should be it.  You should be able to download everything that you need freely from Microsoft’s site (I usually find it easiest googling it – Microsoft’s search engine seems a bit rubbish).