June 28, 2010 at 1:36 am
Hi Experts,
I have uninstalled and installed SQL Server 2008 but still SQL browser is not starting.
When i checked the error log i found
The SQLBrowser service was unable to establish SQL instance and connectivity discovery.
Please help
TIA
June 28, 2010 at 1:41 am
Have you tried running it with the -c command line switch?
Does it return any errors?
-- Gianluca Sartori
June 28, 2010 at 1:43 am
Thanks for the reply,
I tried and got
C:\Windows\system32>net start sqlbrowser -c
The SQL Server Browser service is starting.
The SQL Server Browser service could not be started.
The service did not report an error.
More help is available by typing NET HELPMSG 3534.
June 28, 2010 at 1:46 am
Don't start it as service.
Stop the service, open a command prompt and run sqlbrowser.exe -c.
-- Gianluca Sartori
June 28, 2010 at 1:59 am
Got this message
C:\Program Files\Microsoft SQL Server\90\Shared>sqlbrowser.exe -c
SQLBrowser: starting up in console mode
SQLBrowser: starting up SSRP redirection service
SQLBrowser is successfully listening on ::[1434]
SQLBrowser is successfully listening on 0.0.0.0[1434]
SQLBrowser: failed starting SSRP redirection services -- shutting down.
SQLBrowser: starting up OLAP redirection service
SQLBrowser: Stopping the OLAP redirector
June 28, 2010 at 2:05 am
I have remove 2008 R2 and now installed 2008 but when i tried right click and start on sqlbrowser.exe its showing sql server 2008 r2 console..
anything to do with this??
June 28, 2010 at 2:08 am
Ratheesh.K.Nair (6/28/2010)
C:\Program Files\Microsoft SQL Server\90\Shared>sqlbrowser.exe -c
It doesn't look like SQLServer2008 installation path.
Are you sure?
-- Gianluca Sartori
June 28, 2010 at 2:28 am
ya thats the location
June 28, 2010 at 3:19 am
90 stands for SQLServer 2005.
How many instances are running on that machine?
Try running this from a command prompt and post here the results.
sc query | findstr /I "SQL"
-- Gianluca Sartori
June 28, 2010 at 3:28 am
I have only one instance now..
C:\Program Files\Microsoft SQL Server\90\Shared>sc query | findstr /I "SQL"
DISPLAY_NAME: SQL Server Integration Services 10.0
SERVICE_NAME: MSSQLFDLauncher
DISPLAY_NAME: SQL Full-text Filter Daemon Launcher (MSSQLSERVER)
SERVICE_NAME: MSSQLSERVER
DISPLAY_NAME: SQL Server (MSSQLSERVER)
SERVICE_NAME: MSSQLServerOLAPService
DISPLAY_NAME: SQL Server Analysis Services (MSSQLSERVER)
DISPLAY_NAME: SQL Server Reporting Services (MSSQLSERVER)
SERVICE_NAME: SQLWriter
DISPLAY_NAME: SQL Server VSS Writer
June 28, 2010 at 4:03 am
SQL browser settings are stored under this registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\SQL Browser
You could disable the SSRP listener setting the key to a value of 0, but this would prevent the remote machines from using the browser service.
Anyway it could help identifying the scope of the problem, so I would give this a try.
-- Gianluca Sartori
June 28, 2010 at 4:07 am
If this is a x64 machine, I would also check if there's a registry key like this:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer
If you find a key like this, it could be due to the installation of a 32 bit instance on a x64 machine. After uninstalling, the registry remains garbled, so you could try renaming this key.
-- Gianluca Sartori
June 28, 2010 at 5:56 am
Does it start when running under a local system account? Try that first...
June 28, 2010 at 7:19 am
Thanks Gianluca,
But still am in same situation 🙁
June 28, 2010 at 7:19 am
Twinsoft SME (6/28/2010)
Does it start when running under a local system account? Try that first...
I tried that under all possible accounts but no use
Viewing 15 posts - 1 through 15 (of 20 total)
You must be logged in to reply to this topic. Login to reply