Solved

Microsoft SQL Express 2008 SQL Browser Will Not Start

Posted on 2014-12-09
12
357 Views
Last Modified: 2014-12-10
I'm having an issue with SQL Express 2008 R2 on Windows 7 64bit machines. The SQL Server Browser service will not start, giving the following two errors in Event Viewer. I've done any number of things to troubleshoot, including a clean boot, removing anti-virus, running a secondary scan with another anti-malware utility, completely un-installing and re-installing SQL and the instance, and more...to no avail. Can anyone help?


The SQL Server Browser service port is unavailable for listening, or invalid.

The SQL Server Browser service was unable to establish SQL instance and connectivity discovery.
0
Comment
Question by:sc456a
12 Comments
 
LVL 1

Expert Comment

by:HZarif
ID: 40490334
I had this issue before and the only way i was able to fix it is I backup up my databases and then re-install SQL with a different name of the SQL and then attach the database. Once I confirmed everything is working fine then I uninstalled the broken one so it wouldn't get confusing.
0
 
LVL 1

Author Comment

by:sc456a
ID: 40490360
I've already done that as mentioned in the OP.
0
 
LVL 7

Expert Comment

by:Ray
ID: 40490374
Do you have an older instance of SQL Express or MSDE on the machine?  

http://www.experts-exchange.com/Database/MS-SQL-Server/SQL_Server_2008/Q_26578916.html
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 1

Author Comment

by:sc456a
ID: 40490390
There was, but I manually removed it. No firewall enabled, either.
0
 
LVL 7

Expert Comment

by:Ray
ID: 40490412
Run this from a command prompt first to locate the process id bound to UDP 1434 ->

netstat -aon -p UDP

Look for things bound to 1434

E.g.
UDP 0.0.0.0:1434 *:* 1234

Next look up the PID in Task Manager to see what process this is.
1
 
LVL 1

Author Comment

by:sc456a
ID: 40490424
Nothing else is bound to 1434.
0
 
LVL 7

Expert Comment

by:Ray
ID: 40490433
Try stop the SQL Services, start SQL Browser, then restart the SQL Services.
0
 
LVL 1

Author Comment

by:sc456a
ID: 40490436
Same error.
0
 
LVL 7

Expert Comment

by:Ray
ID: 40490441
What account is used to run SQL Browser?  Local Service/system?

Try switching to a domain account or vice versa
0
 
LVL 7

Accepted Solution

by:
Ray earned 500 total points
ID: 40490447
Try starting SQL browser as a console application to get more details

sqlbrowser.exe -c

What earlier version of SQL did you remove from the workstations? SQL 2000?

If it's SQL 2000, check registry and rename key

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\CurrentVersion to CurrentVersion_Old

HKLM\SOFTWARE\WOW6432\Microsoft\MSSQLSERVER
0
 
LVL 48

Expert Comment

by:Vitor Montalvão
ID: 40490938
Go to SQL Server Configuration Manager and in SQL Server Network Configuration select the instance name and chose TCP/IP protocol (should be enabled) and check which port is using. You can change it to the default port 1433.
0
 
LVL 1

Author Comment

by:sc456a
ID: 40492387
Ray: Localservice is the account. Switching to domain admin had no effect. That command helped me get a little more info which has actually led to the solution!

When I ran sqlbrowser.exe -c I got the following error: "failed starting SSRP redirection services -- shutting down"

This led me to this article: http://www.experts-exchange.com/Database/MS-SQL-Server/SQL-Server-2005/Q_24350132.html

Which led me to deleting some old instance items in the registry under HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL
Server\

Which resolved the problem! I didn't have to reboot or restart SQL. Once I deleted the old instances in that registry path I was able to start the SQL Browser service normally. Thanks, Ray!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question