Finding installed MS Server in PCs over Network

Hello y'all,
I am trying to find out if there is code to find out all the MS Servers installed over a Network.
ThanksDownload SQLScan.

http://www.microsoft.com/downloads/details.aspx?FamilyID=9552d43b-04eb-4af9-9e24-6cde4d933600&displaylang=ensql

Finding installed MS Server in PCs over Network

Hello y'all,
I am trying to find out if there is code to find out all the MS Servers installed over a Network.
ThanksPlease don't double post.|||There are a number of ways to do it, all with their own pluses and minuses. Are you thinking in terms of AD (and if so one domain or many), polling, or something else? LAN, WAN, or other? Approximately how many servers, and how are they managed? Will you be able to administer them from the PC where you want to enumerate them, or is this a "drive by" poll?

If you are looking for the "shoot low boys, they're riding shetland ponies" approach, check out SQLDMO (http://support.microsoft.com/default.aspx?scid=kb;en-us;287737).

-PatP

Finding credientials to connect to RS database

First of all sorry that the message is so skatty. I have a lot on my plate
right now :)
When I installed our instance of Reporting Services on our report box I
cannot remember if I rsactivate-ed and rsconfig-ed the installation with a
windows user or a DB user. I need to know b/c we recently changed an
account that I believe the RS is running under (To impersonate) I think
it's happening because all my jobs have "Login failed" as the status.
Is there a was to decrypt the XML values in the config files using the keys
in the DB so I can tell what credentials everything is running with? Or is
there some way I can easily get the user that is being impersonated to
connect to the RS database?
Thanks
ScottIs this RS2000/2005?
Is this for a perticular report?
Just open up the Reporting Services Configuration and look at the DB
connection/server.
regards,
Stas K.|||For 2000
It's all encrypted
"Sorcerdon" <sorcerdon@.gmail.com> wrote in message
news:1144694663.719163.201870@.e56g2000cwe.googlegroups.com...
> Is this RS2000/2005?
> Is this for a perticular report?
> Just open up the Reporting Services Configuration and look at the DB
> connection/server.
> regards,
> Stas K.
>|||Hi Scott,
Welcome to use MSDN managed newsgroup Support and thanks Stas's help.
In Reporting Services 2000, I don't think you can get the credential used
to connect to the RS database directly for the security issue.
I would like to know why you need to know this user. In the ReportServer
database, you may check what users are there in this database.
Also, you may post what the exactly error message you get when you run your
jobs.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||We changed a password to a security account on our network and reports were
not being delivered through subscriptions. I started poking around and used
either rsactivate of rsconfiig to re-assign the user that unattended
operations ran under.
Thanks for everyone's help.
"Wei Lu" <weilu@.online.microsoft.com> wrote in message
news:0do0ntSXGHA.5540@.TK2MSFTNGXA01.phx.gbl...
> Hi Scott,
> Welcome to use MSDN managed newsgroup Support and thanks Stas's help.
> In Reporting Services 2000, I don't think you can get the credential used
> to connect to the RS database directly for the security issue.
> I would like to know why you need to know this user. In the ReportServer
> database, you may check what users are there in this database.
> Also, you may post what the exactly error message you get when you run
> your
> jobs.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hi Scott,
Thanks for the update.
I think the root cause of the Login Fail is the credential you use to
connect to the datasource in the Report is not available. So you may try to
change this credential.
To change the credential stored in the data source, please do the following:
1. Find the datasource your report use in the Report Manager.
2. In the Properties Tab, General section, please change the Connect Using
Section.
Hope this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.sql

Find Whether SQL Server 2005 installed is X86 or X64

I want to find whether SQL Server 2005 x86 is installed or SQL Server 2005 x64 is installed programatically(Any API would do.) If anyone can recommend a registry key that I can rely on find whether it is a 32 bit or 64 bit SQL Server that would suffice.

I am building an installer. Based on the version I need to code my install script.

Thanks in advance,

pls do not duplicate the post.........post in any appropriate forum

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1889595&SiteID=1

sql

Find the serial no from the computer

I lose the original box of SQL server 2000 eng. How can I find the serial
no. from the Server which installed SQL server 2000 before. Thanks much!!Run 'REGEDIT' from Windows Start--> Run.
Traverse the following chain:
"HKEY_LOCAL_MACHINE
SOFTWARE
Microsoft
Microsoft SQL Server
80
Registration"
The "Registration" entry has the product ID. You can also
get the CD-key from here.
--
HTH. Ryan
"Eco" <eco@.hotmail.com> wrote in message
news:epG6QqGgGHA.2416@.TK2MSFTNGP03.phx.gbl...
>I lose the original box of SQL server 2000 eng. How can I find the serial
> no. from the Server which installed SQL server 2000 before. Thanks much!!
>sql

Find the serial no from the computer

I lose the original box of SQL server 2000 eng. How can I find the serial
no. from the Server which installed SQL server 2000 before. Thanks much!!Run 'REGEDIT' from Windows Start--> Run.
Traverse the following chain:
"HKEY_LOCAL_MACHINE
SOFTWARE
Microsoft
Microsoft SQL Server
80
Registration"
The "Registration" entry has the product ID. You can also
get the CD-key from here.
HTH. Ryan
"Eco" <eco@.hotmail.com> wrote in message
news:epG6QqGgGHA.2416@.TK2MSFTNGP03.phx.gbl...
>I lose the original box of SQL server 2000 eng. How can I find the serial
> no. from the Server which installed SQL server 2000 before. Thanks much!!
>

find the date a sp was installed

hi,
i know how to check what version of service pack i have installed on
sql server 2000...but does anyone know how to find out the date it was
installed on.
i am having probs with sql server agent and can see the date the probs
started...and think it was about the time sp4 was installed but am not
sure.
thanks..> i know how to check what version of service pack i have installed on
> sql server 2000...but does anyone know how to find out the date it was
> installed on.
Maybe the sp setup log file is still under the windows directory somewhere?
--
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006|||hi aaron,
what is this setup file called..and in which directory would it be. i
looked in the default sql server log folder and can see no set file.
thanks...
On Feb 28, 3:45 pm, "Aaron Bertrand [SQL Server MVP]"
<ten...@.dnartreb.noraa> wrote:
> > i know how to check what version of service pack i have installed on
> > sql server 2000...but does anyone know how to find out the date it was
> > installed on.
> Maybe the sp setup log file is still under the windows directory somewhere?
> --
> Aaron Bertrand
> SQL Server MVPhttp://www.sqlblog.com/http://www.aspfaq.com/5006|||Search %windir% recursively for *.log files. I don't use SQL Server 2000
anymore so I'm not too familiar with the exact path SP4 happened to use.
--
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
<kieran5405@.hotmail.com> wrote in message
news:1172678113.473947.250540@.s48g2000cws.googlegroups.com...
> hi aaron,
> what is this setup file called..and in which directory would it be. i
> looked in the default sql server log folder and can see no set file.
> thanks...|||<kieran5405@.hotmail.com> wrote in message
news:1172676833.093383.37040@.m58g2000cwm.googlegroups.com...
> hi,
> i know how to check what version of service pack i have installed on
> sql server 2000...but does anyone know how to find out the date it was
> installed on.
>
I'd do a select * from sysobjects in the master DB and look at the date of
some of the system stored procs. I'm pretty sure there's a bunch replaced
there which will have their creation date listed.
> i am having probs with sql server agent and can see the date the probs
> started...and think it was about the time sp4 was installed but am not
> sure.
> thanks..
>
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com|||hi guys,
cheers for that...
i did the select statement and for the returned field 'crdate' - which
i presume means created date...i see the same date repeatedly listed
that sql agent stopped working. i can only conclude that after
installing sp4...the agent stopped working.
when i now try and start the agent i get the error message -
error 32 - the process could not access the file because it is been
used by another process.
does anyone have any ideas how i could fix this or this would be
happening with sp4
thanks...
On Feb 28, 4:13 pm, "Greg D. Moore \(Strider\)"
<mooregr_deletet...@.greenms.com> wrote:
> <kieran5...@.hotmail.com> wrote in message
> news:1172676833.093383.37040@.m58g2000cwm.googlegroups.com...
> > hi,
> > i know how to check what version of service pack i have installed on
> > sql server 2000...but does anyone know how to find out the date it was
> > installed on.
> I'd do a select * from sysobjects in the master DB and look at the date of
> some of the system stored procs. I'm pretty sure there's a bunch replaced
> there which will have their creation date listed.
> > i am having probs with sql server agent and can see the date the probs
> > started...and think it was about the time sp4 was installed but am not
> > sure.
> > thanks..
> --
> Greg Moore
> SQL Server DBA Consulting
> sql (at) greenms.com http://www.greenms.com|||I tracked down a system that had SP4 and a post-SP4 hotfix applied, and
found the following files:
8.00.2039
C:\Windows\sqlsp.log
8.00.2187
C:\Windows\SQL2000-KB916287-v8.00.2187-x86-ENU.log
--
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
<kieran5405@.hotmail.com> wrote in message
news:1172676833.093383.37040@.m58g2000cwm.googlegroups.com...
> hi,
> i know how to check what version of service pack i have installed on
> sql server 2000...but does anyone know how to find out the date it was
> installed on.
> i am having probs with sql server agent and can see the date the probs
> started...and think it was about the time sp4 was installed but am not
> sure.
> thanks..
>sql

find the date a sp was installed

hi,
i know how to check what version of service pack i have installed on
sql server 2000...but does anyone know how to find out the date it was
installed on.
i am having probs with sql server agent and can see the date the probs
started...and think it was about the time sp4 was installed but am not
sure.
thanks..> i know how to check what version of service pack i have installed on
> sql server 2000...but does anyone know how to find out the date it was
> installed on.
Maybe the sp setup log file is still under the windows directory somewhere?
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006|||hi aaron,
what is this setup file called..and in which directory would it be. i
looked in the default sql server log folder and can see no set file.
thanks...
On Feb 28, 3:45 pm, "Aaron Bertrand [SQL Server MVP]"
<ten...@.dnartreb.noraa> wrote:
> Maybe the sp setup log file is still under the windows directory somewhere
?
> --
> Aaron Bertrand
> SQL Server MVPhttp://www.sqlblog.com/http://www.aspfaq.com/5006|||Search %windir% recursively for *.log files. I don't use SQL Server 2000
anymore so I'm not too familiar with the exact path SP4 happened to use.
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
<kieran5405@.hotmail.com> wrote in message
news:1172678113.473947.250540@.s48g2000cws.googlegroups.com...
> hi aaron,
> what is this setup file called..and in which directory would it be. i
> looked in the default sql server log folder and can see no set file.
> thanks...|||<kieran5405@.hotmail.com> wrote in message
news:1172676833.093383.37040@.m58g2000cwm.googlegroups.com...
> hi,
> i know how to check what version of service pack i have installed on
> sql server 2000...but does anyone know how to find out the date it was
> installed on.
>
I'd do a select * from sysobjects in the master DB and look at the date of
some of the system stored procs. I'm pretty sure there's a bunch replaced
there which will have their creation date listed.

> i am having probs with sql server agent and can see the date the probs
> started...and think it was about the time sp4 was installed but am not
> sure.
> thanks..
>
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com|||hi guys,
cheers for that...
i did the select statement and for the returned field 'crdate' - which
i presume means created date...i see the same date repeatedly listed
that sql agent stopped working. i can only conclude that after
installing sp4...the agent stopped working.
when i now try and start the agent i get the error message -
error 32 - the process could not access the file because it is been
used by another process.
does anyone have any ideas how i could fix this or this would be
happening with sp4
thanks...
On Feb 28, 4:13 pm, "Greg D. Moore \(Strider\)"
<mooregr_deletet...@.greenms.com> wrote:
> <kieran5...@.hotmail.com> wrote in message
> news:1172676833.093383.37040@.m58g2000cwm.googlegroups.com...
>
>
> I'd do a select * from sysobjects in the master DB and look at the date of
> some of the system stored procs. I'm pretty sure there's a bunch replaced
> there which will have their creation date listed.
>
>
> --
> Greg Moore
> SQL Server DBA Consulting
> sql (at) greenms.com http://www.greenms.com|||I tracked down a system that had SP4 and a post-SP4 hotfix applied, and
found the following files:
8.00.2039
C:\Windows\sqlsp.log
8.00.2187
C:\Windows\SQL2000-KB916287-v8.00.2187-x86-ENU.log
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
<kieran5405@.hotmail.com> wrote in message
news:1172676833.093383.37040@.m58g2000cwm.googlegroups.com...
> hi,
> i know how to check what version of service pack i have installed on
> sql server 2000...but does anyone know how to find out the date it was
> installed on.
> i am having probs with sql server agent and can see the date the probs
> started...and think it was about the time sp4 was installed but am not
> sure.
> thanks..
>

find the date a sp was installed

hi,
i know how to check what version of service pack i have installed on
sql server 2000...but does anyone know how to find out the date it was
installed on.
i am having probs with sql server agent and can see the date the probs
started...and think it was about the time sp4 was installed but am not
sure.
thanks..
> i know how to check what version of service pack i have installed on
> sql server 2000...but does anyone know how to find out the date it was
> installed on.
Maybe the sp setup log file is still under the windows directory somewhere?
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
|||hi aaron,
what is this setup file called..and in which directory would it be. i
looked in the default sql server log folder and can see no set file.
thanks...
On Feb 28, 3:45 pm, "Aaron Bertrand [SQL Server MVP]"
<ten...@.dnartreb.noraa> wrote:
> Maybe the sp setup log file is still under the windows directory somewhere?
> --
> Aaron Bertrand
> SQL Server MVPhttp://www.sqlblog.com/http://www.aspfaq.com/5006
|||Search %windir% recursively for *.log files. I don't use SQL Server 2000
anymore so I'm not too familiar with the exact path SP4 happened to use.
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
<kieran5405@.hotmail.com> wrote in message
news:1172678113.473947.250540@.s48g2000cws.googlegr oups.com...
> hi aaron,
> what is this setup file called..and in which directory would it be. i
> looked in the default sql server log folder and can see no set file.
> thanks...
|||<kieran5405@.hotmail.com> wrote in message
news:1172676833.093383.37040@.m58g2000cwm.googlegro ups.com...
> hi,
> i know how to check what version of service pack i have installed on
> sql server 2000...but does anyone know how to find out the date it was
> installed on.
>
I'd do a select * from sysobjects in the master DB and look at the date of
some of the system stored procs. I'm pretty sure there's a bunch replaced
there which will have their creation date listed.

> i am having probs with sql server agent and can see the date the probs
> started...and think it was about the time sp4 was installed but am not
> sure.
> thanks..
>
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com
|||hi guys,
cheers for that...
i did the select statement and for the returned field 'crdate' - which
i presume means created date...i see the same date repeatedly listed
that sql agent stopped working. i can only conclude that after
installing sp4...the agent stopped working.
when i now try and start the agent i get the error message -
error 32 - the process could not access the file because it is been
used by another process.
does anyone have any ideas how i could fix this or this would be
happening with sp4
thanks...
On Feb 28, 4:13 pm, "Greg D. Moore \(Strider\)"
<mooregr_deletet...@.greenms.com> wrote:
> <kieran5...@.hotmail.com> wrote in message
> news:1172676833.093383.37040@.m58g2000cwm.googlegro ups.com...
>
> I'd do a select * from sysobjects in the master DB and look at the date of
> some of the system stored procs. I'm pretty sure there's a bunch replaced
> there which will have their creation date listed.
>
> --
> Greg Moore
> SQL Server DBA Consulting
> sql (at) greenms.com http://www.greenms.com
|||I tracked down a system that had SP4 and a post-SP4 hotfix applied, and
found the following files:
8.00.2039
C:\Windows\sqlsp.log
8.00.2187
C:\Windows\SQL2000-KB916287-v8.00.2187-x86-ENU.log
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
<kieran5405@.hotmail.com> wrote in message
news:1172676833.093383.37040@.m58g2000cwm.googlegro ups.com...
> hi,
> i know how to check what version of service pack i have installed on
> sql server 2000...but does anyone know how to find out the date it was
> installed on.
> i am having probs with sql server agent and can see the date the probs
> started...and think it was about the time sp4 was installed but am not
> sure.
> thanks..
>

Find SQL Server Product key installed on server

Hello;

I am trying to get information of SQL Server licensed key which is installed on our servers. I am using SQL Server 2005 standard edition. Is there a way to find out the product key which is installed on servers. I did some searches and found some thirdparty software to get that information but I don't want to use them on production, is there a way which microsoft recommends.

ThanksHello;

I am trying to get information of SQL Server licensed key which is installed on our servers. I am using SQL Server 2005 standard edition. Is there a way to find out the product key which is installed on servers. I did some searches and found some thirdparty software to get that information but I don't want to use them on production, is there a way which microsoft recommends.

Thanks
mmmm. Do you really think that Micro$oft is going to recommend software that could be used by the unscrupulous to pirate their software? :confused:|||Microsoft has a tool that is normally used by bulk licensors of their software that is used for license reporting that does display this information. If you are using bulk licensing (where you deploy from a set of master images, then write a check directly to Microsoft for the copies you have in production use) then check with either your own license administrator (usually a domain admin) or with your Microsoft Sales Representative.

-PatP

Find SQL Server 2005

Hello,

My problem is this:

In the phase of installation of my software, how I can know if SQL Server 2005 (anyone edition) is installed in the guest system?

Thank you.

You could scan LAN vid SqlDataSourceEnumerator.

using System.Data.Sql;

class Program

{

static void Main()

{

// Retrieve the enumerator instance and then the data.

SqlDataSourceEnumerator instance =

SqlDataSourceEnumerator.Instance;

System.Data.DataTable table = instance.GetDataSources();

// Display the contents of the table.

DisplayData(table);

Console.WriteLine("Press any key to continue.");

Console.ReadKey();

}

private static void DisplayData(System.Data.DataTable table)

{

foreach (System.Data.DataRow row in table.Rows)

{

foreach (System.Data.DataColumn col in table.Columns)

{

Console.WriteLine("{0} = {1}", col.ColumnName, row[col]);

}

Console.WriteLine("============================");

}

}

}|||

Thank you Konstantin,

this code is very good and I will use for my application BUT my problem is to find (if exist) an anyone (express, enterprise, standard, etc) instance of SQL Server in the same machine where my application (or in the installation phase of application) is running.

however, thank you.

|||

If you use Visual Studio for building installer, you could add "Windows Installer Search" at Launch Conditions page. But you need to know ComponentIDs for SQL Server.

I think, that this link would be helpful http://msdn2.microsoft.com/en-us/library/1s08hzfe(vs.80).aspx

Find number of licenses

How do you find the number of licenses that are installed on a SQL Server
2000?"Bob" <bobh@.wolv.tds.net> wrote in message news:<vmf1sjk8dk8pd1@.corp.supernews.com>...
> How do you find the number of licenses that are installed on a SQL Server
> 2000?

select serverproperty('NumLicenses')

Simon|||Thanks

"Simon Hayes" <sql@.hayes.ch> wrote in message
news:60cd0137.0309170711.76af02da@.posting.google.c om...
> "Bob" <bobh@.wolv.tds.net> wrote in message
news:<vmf1sjk8dk8pd1@.corp.supernews.com>...
> > How do you find the number of licenses that are installed on a SQL
Server
> > 2000?
> select serverproperty('NumLicenses')
> Simon