Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Registering 300+ SQL Servers to management studio from a list Expand / Collapse
Author
Message
Posted Monday, November 29, 2010 11:38 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 7, 2014 1:20 AM
Points: 5, Visits: 128
Hello

I have a spreadsheet which consist of a list of all SQL servers.Can someone help me with trick or script to register a list of SQL server from a spreadsheet/txt file to management studio.
Register/connect all the SQL server one by one is time consuming when I have a list of 300+ SQL servers to manage them remotely.
Post #1027762
Posted Tuesday, November 30, 2010 4:51 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 8:28 AM
Points: 563, Visits: 1,007
Well in Management Studio, under the Registered Servers window, you can right click on a folder, go to tasks and import a file, which will do the registering. For the format of the file, you may have to export a Server and test.
Post #1027875
Posted Tuesday, November 30, 2010 5:31 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:25 AM
Points: 12,914, Visits: 32,071
learned something new today; thanks graham; didn't even know about the Registered Servers panel until this post. lots of options like automatic discovery of all servers on the network and stuff.

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1027892
Posted Tuesday, November 30, 2010 6:02 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 8:28 AM
Points: 563, Visits: 1,007
Lowell (11/30/2010)
learned something new today; thanks graham; didn't even know about the Registered Servers panel until this post. lots of options like automatic discovery of all servers on the network and stuff.


Glad to help considering all the help I get from this forum....
Post #1027907
Posted Tuesday, November 30, 2010 6:11 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:51 AM
Points: 6,600, Visits: 8,900
If you're using SSMS 2008, there is another neat trick. In the Registered Servers panel, make separate folders for each logical (to you) group. Then, you can right-click the group, select "New Query", and a query window opens up connected to all of the servers. Run something like "SELECT @@ServerName", and you'll get responses from all of the servers.

Wayne
Microsoft Certified Master: SQL Server 2008
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #1027913
Posted Tuesday, November 30, 2010 6:14 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 8:28 AM
Points: 563, Visits: 1,007
WayneS (11/30/2010)
If you're using SSMS 2008, there is another neat trick. In the Registered Servers panel, ake separate folders for each logical (to you) group. Then, you can right-click the group, select "New Query", and a query window opens up connected to all of the servers. Run something like "SELECT @@ServerName", and you'll get responses from all of the servers.


always knew about that, but never actually tried it, cool!
Post #1027915
Posted Wednesday, December 1, 2010 6:14 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, April 11, 2013 8:26 AM
Points: 14, Visits: 291
Same with me too. really useful option. thanks
Post #1028570
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse