Thursday, May 13, 2010

Install SQL server R2 issue

Today I faced with the following error while trying to install SQL server 2008 R2.
Sql2005SsmsExpressFacet:Checks whether SQL Server 2005 Express Tools are installed. FailedThe SQL Server 2005 Express Tools are installed. To continue, remove the SQL Server 2005 Express Tools.

I checked and there was no installation of SQL server express edition.

I then started looking at the registery and the only thing I need to do was to rename one entry in registry. Find shellSEM in the registery and rename it

The full path of the registry location is
HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM

Finding all SQL server on your network from sql server 2005/08

By default xp_cmdshell is disabled on SQL server 2005/08. You need to enable this using

sp_configure 'show advanced options', 1
sp_configure 'xp_cmdshell', 1

you can then run OSQL command as follows

EXEC master..XP_CMDShell 'OSQL -L'