Solved

Microsoft SQL Express 2008 SQL Browser Will Not Start

Posted on 2014-12-09
12
365 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

 
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 49

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSIS GUID Variable 2 37
Upgrading to SQL Server 2015 Express 2 36
help converting varchar to date 14 25
T-SQL: Stored Procedure Syntax 3 34
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

726 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