Solved

Microsoft SQL Express 2008 SQL Browser Will Not Start

Posted on 2014-12-09
12
327 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
Comment Utility
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
Comment Utility
I've already done that as mentioned in the OP.
0
 
LVL 7

Expert Comment

by:Ray
Comment Utility
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
 
LVL 1

Author Comment

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

Expert Comment

by:Ray
Comment Utility
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
Comment Utility
Nothing else is bound to 1434.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 7

Expert Comment

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

Author Comment

by:sc456a
Comment Utility
Same error.
0
 
LVL 7

Expert Comment

by:Ray
Comment Utility
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
Comment Utility
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 45

Expert Comment

by:Vitor Montalvão
Comment Utility
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
Comment Utility
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how the fundamental information of how to create a table.

743 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now