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
Thursday, May 13, 2010
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
GO
RECONFIGURE
GO
sp_configure 'xp_cmdshell', 1
GO
RECONFIGURE
GO
you can then run OSQL command as follows
EXEC master..XP_CMDShell 'OSQL -L'
sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
sp_configure 'xp_cmdshell', 1
GO
RECONFIGURE
GO
you can then run OSQL command as follows
EXEC master..XP_CMDShell 'OSQL -L'
Subscribe to:
Posts (Atom)