Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / DB Engine / SQL Server / March 2008

Tip: Looking for answers? Try searching our database.

SQL Servers are not listed on network ???

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
info@onlyhd.tv - 10 Mar 2008 22:12 GMT
I have about 20 sql servers (2000 and 2005). I setup an MSX/TSX job in
SQL Agent to Register the Server in Active Directory to make sure that
all future targets are registered, etc..

---Enroll the server in Active Directory
use [master]
go
exec sp_ActiveDirectory_SCP @Action = N'create'
go

However, 90% of my servers are NOT listed when I do:

osql -L

or try to choose any network SQL Server connection in SQL Server
Management Studio.   All servers have TCP/IP and Named Pipes Enabled
and remote connectivity enabled (2005).

What can I do to ensure all of my servers can be seen and availble
from a drop down list of servers?

Thanks

Erik
Linchi Shea - 11 Mar 2008 02:05 GMT
Short answer is that you shouldn't count on osql -L to list all your servers.
It is not designed to do so.

Linchi

> I have about 20 sql servers (2000 and 2005). I setup an MSX/TSX job in
> SQL Agent to Register the Server in Active Directory to make sure that
[quoted text clipped - 20 lines]
>
> Erik
info@onlyhd.tv - 11 Mar 2008 21:34 GMT
But what about my list in Sql Management Studio, it barely has sql
servers listed in it.???
IanLowe77@googlemail.com - 14 Mar 2008 14:20 GMT
Hi Erik,

Do you have a mix of SQL Server 2000 and SQL Server 2005 servers? And
is it only the SQL Server 2005 servers that you cannot see?

I've found that at many sites, the SQL Server Browser service has not
been started on the SQL Server, so it can only be seen locally and not
across the network. Microsoft disables this service by default for
added security, so you need to start it manually after performing a
new installation of SQL Server.

Let me know if this helps.

Regards,
Ian Lowe
SQLServerClub.com
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.