SQL Server Browser has no Service Type

Question

I have SQL Server 2008 R2 (x64) Developer Edition running Windows 7 (x64).

After installing, when I look to SQL Server Configuration Manager, installed SQL Server Browser service has no Service Type. Also I can't connect to this Server from different computer. 

From another PC whit installed Management studio I can see this server, but I can't login. 

I'm newbie in this. Thanks

Answer 1

Hi,

SQL Server Browser does not have the type field populated in SQL Config Manager. Can you connect successfully from the local server version of SSMS? It sounds like the browser service is running. What error do you receive? Did you enable remote connections for the server instance? Have you configured the firewall to allow the SQL server ports?

http://blogs.msdn.com/b/sql_protocols/archive/2006/09/30/sql-server-2005-remote-connectivity-issue-troubleshooting.aspx

---

Sean Massey | Consultant, iUNITE

Feel free to contact me through My Blog, Twitter or Hire Me.
Please click the Mark as Answer or Vote As Helpful button if a post solves your problem or is helpful!

Answer 2

Is your SQL Browser service running, if not try to RUN it....

share the error if it fails on startup...

Answer 3

To assure databases Access , you have to follow up the following :

1- Assure static Port is assigned for SQL Service from Computer Management >>>Services & applications >>> SQL Server Configuration Manager >>SQL Server Network Configurations >>Protocol for Instance name>>TCP>>IP address >IPAl l>>TCP port >>>>>then assign any appropriate port like TCP 1433 (Default )

2- Assure the below same TCP ports assigned per 1^st step +UCP 1434 (SQL browser port) are open from your source to destination

3- If still persist, you have to work out the usage of alias through SQL Server Client network utility by opening Run >>Cliconfg.exe >>Alias >>>Add >>>TCP /IP >>>then specify the appropriate alias (MAY be the same as the original connection string) >>>>and mark out dynamic port to let static by the same port above  

4- If still persist, you might use the same connection string but with adding the suffix (,TCP port) like Servername\Instancename ,1433

Please let me work out it and let me know your feedback

---

Shehap (DB Consultant/DB Architect) Think More deeply of DB Stress Stabilities

Answer 4

Boondock,

Please read the following link to know that are you facing problem because of SQL Server Browser? And let me know your problem resolved or not?

http://www.mssqltips.com/sqlservertip/1946/overview-of-the-sql-server-browser-service/

Best regards