Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 No Local servers in 'browse for servers' window

Author  Topic 

hansondodge
Starting Member

4 Posts

Posted - 2011-07-07 : 12:45:48
Hello-

I have a new server with SQL 2008 R2 installed. I can connect to the database engine by either typing the full name or going to browse for servers and going to the 'network servers'. I cannot see the local instances in the 'local servers' tab. i did register all the instances and tested them. Is there something else i am missing to have these instances show up?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-07-07 : 14:37:17
Is the SQL Browser service started?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

hansondodge
Starting Member

4 Posts

Posted - 2011-07-07 : 14:47:59
Yes it is, as NT AUTHORITY\NetworkService, Also tried it as our domain admin account
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-07-07 : 16:26:40
I wouldn't consider this a problem. Just type in the name.

For what it's worth, I just tried it on a local instance and get the same thing you do, even with the browser service running -- which I typically keep disabled.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-07-07 : 16:35:16
Yeah I always type in the name or register my servers. We have hundreds maybe thousands of SQL Servers on our network, so browsing is not something I even attempt to do.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

hansondodge
Starting Member

4 Posts

Posted - 2011-07-08 : 10:04:05
thanks for your input. i appreciate it. im a SQL newb so i figured i would check to make sure i did everything right
Go to Top of Page
   

- Advertisement -