Compile regsvr file

Question

Post reply

Compile regsvr file

Henrico Bekker

One Orange Chip

Points: 27652
More actions
April 29, 2010 at 11:20 pm

#224017

Cant seem to figure this out?
How can I create a new regsvr file (registered server list) from a text,csv,excel file, with all the sql server names populated in them?
I know the regsvr file also contains connection info, but is there any way to do this with default settings?
or:
can I export the list of sql server on my domain from osql -L > c:\serverlist.???
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Mohan Kumar SSCertifiable Points: 5365 More actions · Answer 1

You can certainly run osql -L > c:\serverlist.txt to export server name

[font="Verdana"]--www.sqlvillage.com[/size][/font]

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 2

Thanx Mohan, I know, BUT - I need that list generated to be importable as a registered server list.

I dont want to build a manual registered server list.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Mohan Kumar SSCertifiable Points: 5365 More actions · Answer 3

you can create regsvr file with little extra effort. you may do it programatically.

regsvr fiile is XML file with extension regsvr.

Easy way to compile regsvr file is to export atleast one server that will create regsvr file for you. open regsvr file using any editor like NOTEPAD and then copy following section, keep on adding in you regsvr file and change server name.

<alias>/RegisteredServersStore/ServerGroup/DatabaseEngineServerGroup/RegisteredServer/irlt-kumar</alias>

</aliases>

<sfc:version DomainVersion="1" />

</docinfo>

<data>

<RegisteredServers:RegisteredServer xmlns:RegisteredServers="http://schemas.microsoft.com/sqlserver/RegisteredServers/2007/08" xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08" xmlns:sml="http://schemas.serviceml.org/sml/2007/02" xmlns:xs="http://www.w3.org/2001/XMLSchema">

<RegisteredServers:Parent>

<sfc:Reference sml:ref="true">

<sml:Uri>/RegisteredServersStore/ServerGroup/DatabaseEngineServerGroup</sml:Uri>

</sfc:Reference>

</RegisteredServers:Parent>

<RegisteredServers:Name type="string">SQLVillage</RegisteredServers:Name>

<RegisteredServers:ServerName type="string">SQLVillage</RegisteredServers:ServerName>

<RegisteredServers:UseCustomConnectionColor type="boolean">false</RegisteredServers:UseCustomConnectionColor>

<RegisteredServers:CustomConnectionColorArgb type="int">0</RegisteredServers:CustomConnectionColorArgb>

<RegisteredServers:ServerType type="ServerType">DatabaseEngine</RegisteredServers:ServerType>

<RegisteredServers:ConnectionStringWithEncryptedPassword type="string">server=SQLVillage;trusted_connection=true;pooling=false;multipleactiveresultsets=false</RegisteredServers:ConnectionStringWithEncryptedPassword>

<RegisteredServers:CredentialPersistenceType type="CredentialPersistenceType">None</RegisteredServers:CredentialPersistenceType>

</RegisteredServers:RegisteredServer>

</data>

</document>

[font="Verdana"]--www.sqlvillage.com[/size][/font]