How to determine what patches are needed to restore Master

I have had to rebuild our SQL server from scratch due to hardware failure.
Because of a version mismatch... this has presented a problem to me in
restoring the Master database. The previous admin did not leave notes on
what patches were installed on the server, and all that I know is SP1 was
installed minimum.
I have since installed SP1, but I seem to be missing a couple more patches.
Is there any way to determine what patches I need from the error message
given during restore? Current version: 134218112 Master Database
Version: 134218262
Thank you all in advance for your assistance.Was able to extract the actual software version information...
The current software version is: 8.00.384
The backup Master version is : 8.00.534

How to determine the version of SQL Server programatically.

What is the official supported way to determine the version of SQL server and installed Service Pack programatically.

Different components such as Analysis Services or SSIS can have service pack applied at different times. So what is the right officially supported way to determine the version of those components.

Thank you in advance.

you can try this,

select @.@.version

select serverproperty('productversion')

you can refer, http://support.microsoft.com/kb/321185

|||

Thank you for the pointer to this kb article. However, I probably did not formulate my question correctly. I would need to determine the version by running some executable in the command line rather than connecting to SQL Server database. For example I can have just SQL server Integration Services installed but not the database itself.

Is there officially supported solution in this case?

|||How do you need to get the value back ? You could use the SQLCMD to execute and retrieve the value to the command line. Perhaps you can elaborate a bit more on the situation and the environment where the applciation is started.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Thank you for your answer. I do understand that I can invoke sqlcmd. However what if database is not installed and all what I do have installed is Integration Services. What should I do in this situation. Besides I can apply the service pack to each of sql server major components separately. So if I do have the database with one version and analysis services with another version I will get simply incorrect value for Analysis Services invoking this command. What I actually need is a supported way to determine the version of the component I do need. Ideally it should work as version command in windows command line for each of the major component of SQL server that can be installed independently of each other. However, I can understand that this expectation might not be realistic. What I actually need is officially supported way so I will not make a mistake determining the version.

|||Try to read the below registry key value, whcih will provide you the version of Database Engine.

HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion

read the string value "CurrentVersion"

It will provide you the Version number. This can be done without connecting to SQL server.
|||Thank you for the reply. What I can do in the case of Integration Services and Analysis Services in case if database Engine is not installed.|||

Look at the Services registration:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Services

Jens K. Suessmeyer

http://www.sqlserver2005.de

How to determine the version of SQL Server programatically.

What is the official supported way to determine the version of SQL server and installed Service Pack programatically.

Different components such as Analysis Services or SSIS can have service pack applied at different times. So what is the right officially supported way to determine the version of those components.

Thank you in advance.

you can try this,

select @.@.version

select serverproperty('productversion')

you can refer, http://support.microsoft.com/kb/321185

|||

Thank you for the pointer to this kb article. However, I probably did not formulate my question correctly. I would need to determine the version by running some executable in the command line rather than connecting to SQL Server database. For example I can have just SQL server Integration Services installed but not the database itself.

Is there officially supported solution in this case?

|||How do you need to get the value back ? You could use the SQLCMD to execute and retrieve the value to the command line. Perhaps you can elaborate a bit more on the situation and the environment where the applciation is started.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Thank you for your answer. I do understand that I can invoke sqlcmd. However what if database is not installed and all what I do have installed is Integration Services. What should I do in this situation. Besides I can apply the service pack to each of sql server major components separately. So if I do have the database with one version and analysis services with another version I will get simply incorrect value for Analysis Services invoking this command. What I actually need is a supported way to determine the version of the component I do need. Ideally it should work as version command in windows command line for each of the major component of SQL server that can be installed independently of each other. However, I can understand that this expectation might not be realistic. What I actually need is officially supported way so I will not make a mistake determining the version.

|||Try to read the below registry key value, whcih will provide you the version of Database Engine.

HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion

read the string value "CurrentVersion"

It will provide you the Version number. This can be done without connecting to SQL server.
|||Thank you for the reply. What I can do in the case of Integration Services and Analysis Services in case if database Engine is not installed.|||

Look at the Services registration:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Services

Jens K. Suessmeyer

http://www.sqlserver2005.de

How to determine the version of SQL Server programatically.

What is the official supported way to determine the version of SQL server and installed Service Pack programatically.

Different components such as Analysis Services or SSIS can have service pack applied at different times. So what is the right officially supported way to determine the version of those components.

Thank you in advance.

you can try this,

select @.@.version

select serverproperty('productversion')

you can refer, http://support.microsoft.com/kb/321185

|||

Thank you for the pointer to this kb article. However, I probably did not formulate my question correctly. I would need to determine the version by running some executable in the command line rather than connecting to SQL Server database. For example I can have just SQL server Integration Services installed but not the database itself.

Is there officially supported solution in this case?

|||How do you need to get the value back ? You could use the SQLCMD to execute and retrieve the value to the command line. Perhaps you can elaborate a bit more on the situation and the environment where the applciation is started.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Thank you for your answer. I do understand that I can invoke sqlcmd. However what if database is not installed and all what I do have installed is Integration Services. What should I do in this situation. Besides I can apply the service pack to each of sql server major components separately. So if I do have the database with one version and analysis services with another version I will get simply incorrect value for Analysis Services invoking this command. What I actually need is a supported way to determine the version of the component I do need. Ideally it should work as version command in windows command line for each of the major component of SQL server that can be installed independently of each other. However, I can understand that this expectation might not be realistic. What I actually need is officially supported way so I will not make a mistake determining the version.

|||Try to read the below registry key value, whcih will provide you the version of Database Engine.

HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion

read the string value "CurrentVersion"

It will provide you the Version number. This can be done without connecting to SQL server.
|||Thank you for the reply. What I can do in the case of Integration Services and Analysis Services in case if database Engine is not installed.|||

Look at the Services registration:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Services

Jens K. Suessmeyer

http://www.sqlserver2005.de

how to determine sql version info

This info is from mss management studio express. how can i determine if SP2 is installed?

Microsoft SQL Server Management Studio Express 9.00.3042.00
Microsoft Data Access Components (MDAC) 6.0.6000.16386 (vista_rtm.061101-2205)
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 7.0.6000.16448
Microsoft .NET Framework 2.0.50727.312
Operating System 6.0.6000

Hi there,

I believe that the following article should be able to help you: http://support.microsoft.com/default.aspx/kb/321185

How to determine SQL version from a command line

Hi, I am trying to run a command line script against 50
SQL servers to determine the SQL ver and SP level
installed but when I run srvinfo -ns this returns way more
info then I require and does not include SP level. I have
run registry searches but this will only give the
installed version of SQL, it will not give me the latest
ver, i.e. if it has had an SP installed or not. Any help
would be great. ThanksYou can use OSQL from the command line to connect to SQL Server. Once
connected issue SELECT @.@.VERSION or use SERVERPROPERTY
Without using SQL you could always do a DIR and seach for sqlservr.exe, from
it's size and file data you should be able to work out which version.
--
HTH
Ryan Waight, MCDBA, MCSE
"Jonathon" <Jonathon_Taaffe@.hotmail.com> wrote in message
news:296d601c3919f$d3ea6f90$a601280a@.phx.gbl...
> Hi, I am trying to run a command line script against 50
> SQL servers to determine the SQL ver and SP level
> installed but when I run srvinfo -ns this returns way more
> info then I require and does not include SP level. I have
> run registry searches but this will only give the
> installed version of SQL, it will not give me the latest
> ver, i.e. if it has had an SP installed or not. Any help
> would be great. Thanks|||Jonathan,
Refer to following url:
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185
You can run these queries from command prompt, using osql utility by passing quries to -Q
parameter.
--
- Vishal|||You can run 'select @.@.version' with osql in dos.
>--Original Message--
>Hi, I am trying to run a command line script against 50
>SQL servers to determine the SQL ver and SP level
>installed but when I run srvinfo -ns this returns way
more
>info then I require and does not include SP level. I have
>run registry searches but this will only give the
>installed version of SQL, it will not give me the latest
>ver, i.e. if it has had an SP installed or not. Any help
>would be great. Thanks
>.
>|||In article <296d601c3919f$d3ea6f90$a601280a@.phx.gbl>, Jonathon
<Jonathon_Taaffe@.hotmail.com> writes
>Hi, I am trying to run a command line script against 50
>SQL servers to determine the SQL ver and SP level
>installed but when I run srvinfo -ns this returns way more
>info then I require and does not include SP level. I have
>run registry searches but this will only give the
>installed version of SQL, it will not give me the latest
>ver, i.e. if it has had an SP installed or not. Any help
>would be great. Thanks
If you are looking for any SQL Servers then you could try SQL Scan as
well-
http://www.microsoft.com/sql/downloads/securitytools.asp
I use a combination of methods to monitor what servers appear on the
network and in what state.
The registry will tell you which SP you are running, but it will not
tell you if there are any patches on top as well.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVers
ion]
The CurrentVersion value gives you the base version, e.g 8.00.194 = SQL
Server 2000 RTM.
The CSDVersion key will then tell you the service pack level, e.g.
8.00.761 = SP3a. Note this is actually quite useful because the TSQL
@.@.VERSION and similar will only give you 8.00.760, which means SP3 or
SP3a. However since I also have the latest security patch installed
@.@.VERSION says 8.00.818, so a combination is often better.
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org|||I've just tried, it worked without problem.
From a cmd line :-
OSQL -Sservername -Q"select @.@.Version" -E
--
HTH
Ryan Waight, MCDBA, MCSE
"Ray Miao" <rmiao@.bloomberg.com> wrote in message
news:03d801c391b4$f2bded60$a401280a@.phx.gbl...
> You can run 'select @.@.version' with osql in dos.
> >--Original Message--
> >Hi, I am trying to run a command line script against 50
> >SQL servers to determine the SQL ver and SP level
> >installed but when I run srvinfo -ns this returns way
> more
> >info then I require and does not include SP level. I have
> >run registry searches but this will only give the
> >installed version of SQL, it will not give me the latest
> >ver, i.e. if it has had an SP installed or not. Any help
> >would be great. Thanks
> >.
> >

How to determine MSDE version and Service Pack level

How can I determine what versioin and service pack of MSDE i have?You might try to look at @.@.VERSION for this information.

Assuming you don't have Query Analyzer, so use the command-line utility osql.

Shell out to a command prompt and type:

osql -E -q "PRINT @.@.VERSION"

Terri|||I tried this and the response was:

[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).

Is there a next step?

Thanks,
Bob|||Those are the messages I get when the SQL Server is not started.

You need to start SQL Server. You do this through the SQL Server Service Manager in your systray.

Also, this is a good link to keep handy:HOW TO: Manage the SQL Server Desktop Engine (MSDE 2000) by Using the Osql Utility

Terri|||Thank you Terri,

After a reboot and restart it worked and brought me to my next problem(s).

I think what I really need to do is uninstall MSDE and start over. I don't seem to able to get into my DB, the path where MSSQL ended up is too long to work with in a command shell, etc. Is there an easy way to get uninstall all of it? Without a ADD/REMOVE option or Uninstall I'm lost.

Thanks for the first anser and the link. I bookmarked it and will use it on the next go around.

Thanks,
Bob|||Thanks to tmorton for the answer that worked. It was really simple.|||Codfish -- glad to be of help.

Disker -- the path were MSSQL was installed is going to be long -- and it shouldn't matter. You should never need to type it in. The install should add it to your PATH so that you will be able to go to the command shell and type OSQL from anywhere and have it work.

Please don't uninstall/reinstall unless absolutely necessary.

You say that you "don't seem to be able to get into" your DB. What tool(s) are you trying to use for this? What error(s) are you receiving?

Terri|||Thanks for the help Terri,

Some hardware/software specs -

Running XP PRO Sp1, IIS on AMD 900, 512MB. IIS is running as is SQLSERVR, SQLMANGR, and sqlagent. These are listed in Task Manager [processes] as running and also in Services as Started. I have the little server icon on the task bar with a little blue or green arrow blinking every so often. I installed MSDE from a command line after entering SAPWD="mypassword" The password I chose is 9 alpha-numeric.

I did follow your suggestion yesterday and read through the OSQL commands. This did allow me to create another DB. This command returned a message saying that it had created the DB giving the name and the space allocated. I checked on this and did find the two files ending with .mdf and .ldf in C:\Program Files\Microsoft SQL Server\MSSQL\Data.

For SQL management I've been trying a few things. First, I tried SQL Server Web Data Administrator. When I use this the IIS option only gives me a page of HTML. The Cassini model gives me a login screen which asks for username, password, server and the two options of windows authentication or SQL. I have tried both and cannot gain access being given a incorrect password or username message.

My newest attempt and what I would like to use is Enterprise Manager and have downloaded SQLEntMan_0.5.1.zip to use. I unzipped this to a folder named EntMan but cannot get that to start up. I tried browsing to the folder with IE but it just shows me the files.

So it seems that I have installed MSDE semi-correctly in that I can find it and create databases through OSQL. I can see the DB but cannot access it through any interface I have tried so far.

Thanks so much for your time and help. I really appreciate it.|||Instead of this moving target -- let's try to concentrate on getting SQL Server Web Data Administrator working for you. (I prefer this over ASP Enterprise Manager strictly because I have installed and used it myself and can more easily help you troubleshoot it.)

With the hardware/software specs you listed, I am assuming that all of the elements of your environment are local to your workstation (IIS, SQL).

Is your local IIS able to serve up any ASP.NET pages at all? Get back to us on this and we can move forward from there.

Terri|||HI,

If I type http://localhost/or http://desktop/ it takes me to a web page which displays the localstart.asp page which states the following:

Your Web service is now running.
You do not currently have a default Web page established for your users. Any users attempting to connect to your Web site from another machine are currently receiving an Under Construction page. Your Web server lists the following files as possible default Web pages: default.htm,default.asp,index.htm,iisstart.asp. Currently, only iisstart.asp exists.

To add documents to your default Web site, save files in c:\inetpub\wwwroot\.

I assume this means IIS is capable of serving up pages.

I have the SQL Server Web Adm. Version 2.0 installed to c: as is everything else.

I won't do anything else until I hear back.

Thanks,

Bob|||Yes, IIS is serving up pages, but specifically can it serve up ASP.NET pages (.aspx extension)?

Create test.aspx and put it into your wwwroot directory and try to access it from your browser (http://localhost/test.aspx):

<%@. Page Language="VB" %>
<html>
 <head>
 <title>ASP.NET Test</title>
 </head
 <body>
 <center>
 <form action="test.aspx" method="post">
 <% Dim I As Integer
 For I = 0 to 7 %>
 <font size="<%=I%>">Welcome to ASP.NET</font><br>
 <% Next %>
 </form>
 </center>
 </body>
</html>

What you should see is "Welcome to ASP.NET" 7 times in increasingly bigger font sizes. If you don't, then IIS is not serving up your .ASPX pages correctly and you will need to repair te IIS mappings:

To repair IIS mappings for ASP.NET with Aspnet_regiis.exe

1. ClickStart, and then clickRun.
2. In theRun dialog box, typecmd, and then clickOK.
3. At the command prompt, type:
"systemroot\Microsoft.NET\Framework\version\aspnet_regiis.exe"-i

In this path,systemroot is the folder containing your operating system files (C:\Windows on Windows XP systems, C:\WinNT on Windows 2000 Server systems, and so on), andversion is the version number of the .NET Framework installed on your server.

Note You must include the quotation marks in the command.

For more information about Aspnet_regiis.exe, use step 3 with the -? option or see the ASP.NET IIS Registration Tool topic in the .NET Framework version 1.1 documentation.|||Ok I created the page but it didn't do what it was supposed to do so I ran the repair. This started and completed installing ASP.NET. The path I used was

C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspnet_regiis.exe" -i

Then I checked to see if the ASP.NET State Service was running and it is. Then I rebooted just to be safe, double-checked ASP.NET and tried the page again. What I get is the text for the test page you've given above. I used Frontpage to create the page and did a copy and paste of your text and entered it into the html tab in Frontpage. I then saved the page to wwwroot as a .aspx page. What I get when I use IE to go to the page is the text that was pasted in and not the page as it should appear.

IE works for any other page I go to so I don't see that as a problem. I don't have a firewall running on this box so there is problem there either. I also checked the page from another PC on my mini network using http://desktop/test/aspx and get the same text page as I do locally.

Sorry for all the work. This gets really frustrating.

Bob|||At this point I am going to have to ask you to post this problem to theSetup forum. :-( Something isn't right with your setup. Each time I've seen this, aspnet_regiis.exe -i has solved it. The people over in that forum have seen it all and should be able to get you on the right track.

To be clear -- by "this problem" I mean the inability to view the test page.

Once you are able to view that test page correctly, then give Web Data Administrator another try. (And post back if you are having trouble with it.)

Terri
PS - Don't give up!|||OK, will do.

Thanks Terri. Hope to get back to you with a note saying everything works fine.

Bob|||Back again!

I now have IIS serving .asp pages to my local PC as well as another located on the network. Both seem to be working fine so I take this to mean that my IIS problem is resolved.

Back to the SQL Web Data Administrator - I've tried this again and it's still not working the way it should. When I activate the administrator it pops with the little window saying Web Server Configuration. It lists the following options:

Desired Port:
IIS
Cassini Personal Web Server
Restore Faults

and Start and Stop buttons.

If I leave the setting on IIS and click Start it opens a webpage entitled Web Data Administrator. Moving further down I have a welcome message and then the line -

Please enter a SQL Server name:

Username: [Desktop\bob shadowed entry]
Password
Server (local)

Authentication Method:

Windows Intergrated
SQl Login

and then Login

If I select SQL Login and enter "sa" as the username and then my password leaving the (local) as the server I get the following error:

Invalid username and/or password, you are using a windows login that is not your own, or server does not exist.

This is where I'm stuck at this point. I appreciate your help and patience.

Thanks,
Bob

p.s. Should we move this to another Subject heading or start a new thread?

How to determine MSDE or SQL 2005 Express vs. SQL 2000 or SQL 2005

Hi all,
I need to determine if MSDE or SQL 2005 Express is installed versus the
full version of SQL 2000 or SQL 2005. I only want my installation to
run if the full versions of SQL is installed. Where can I find this
information? Is it in the registry, can I do a SQL query that tells me
this info?
Basically I need a way of distinguishing between the free and full
versions. Any help would greatly be appreciated. Thanks in advance.
Hi,
Sorry, I should've been more clear. This is for an installation
package, so I want the install package to check the version of SQL on a
user's machine. It would need to query the database or check a
registry key, or file version, etc.
If I did select @.@.version would this say it's MSDE ot SQL 2005 Express?
I just found something that I'm not sure will work or not:
SELECT SERVERPROPERTY ('edition')
It looks like it will return either
Personal Edition
or
Standard Edition
depending on what you have (I assume Enterprise Edition as well).
Is this enough to determine whether or not it is MSDE (and SQL 2005
Express) or a full install?
Thanks.
Tom wrote:[vbcol=seagreen]
> If you use the SQL Server Mgt Studio, you right click on the registered
> server and one of the general properties is the 'Product' name, which states
> that it is SQL Server Express or SQL Server Developer etc.
>
> "Flash08" <stuart.karp@.gmail.com> wrote in message
> news:1168982219.854052.130750@.q2g2000cwa.googlegro ups.com...
|||SERVERPROPERTY is probably the safest thing to use. The possible return
values are listed here:
http://msdn2.microsoft.com/en-us/library/ms174396.aspx
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Flash08" <stuart.karp@.gmail.com> wrote in message
news:1168988743.254141.202070@.m58g2000cwm.googlegr oups.com...
> Hi,
> Sorry, I should've been more clear. This is for an installation
> package, so I want the install package to check the version of SQL on a
> user's machine. It would need to query the database or check a
> registry key, or file version, etc.
> If I did select @.@.version would this say it's MSDE ot SQL 2005 Express?
> I just found something that I'm not sure will work or not:
> SELECT SERVERPROPERTY ('edition')
> It looks like it will return either
> Personal Edition
> or
> Standard Edition
> depending on what you have (I assume Enterprise Edition as well).
> Is this enough to determine whether or not it is MSDE (and SQL 2005
> Express) or a full install?
> Thanks.
>
> Tom wrote:
>
sql

How To Determine if SP3a installed on client PC?

How can I tell (preferably by a version attribute on some DLL or EXE) that
Service Pack 3a has been installed on a client PC? KB articles such as
321185 do a great job of showing how to use SERVERPROPERTY to determine what
version the SERVER is running, but that's not my question. I need to know if
Service Pack 3a has been installed on a CLIENT, not the SERVER.
Fred wrote:
> How can I tell (preferably by a version attribute on some DLL or EXE)
> that Service Pack 3a has been installed on a client PC? KB articles
> such as 321185 do a great job of showing how to use SERVERPROPERTY to
> determine what version the SERVER is running, but that's not my
> question. I need to know if Service Pack 3a has been installed on a
> CLIENT, not the SERVER.
Run Query Analyzer and go to Help | About. If it's version 760 it's
SP3a.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Is there a programmatic way to determing this? We use CA's SDO tool to push
client software and we need to figure out a way to programmatically test (a
DLL or EXE or registry key entry I assume) to see if SQL Server 2000 Service
Pack 3a is already deployed on a particular client PC.
"David Gugick" wrote:

> Fred wrote:
> Run Query Analyzer and go to Help | About. If it's version 760 it's
> SP3a.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>
|||Fred wrote:
> Is there a programmatic way to determing this? We use CA's SDO tool
> to push client software and we need to figure out a way to
> programmatically test (a DLL or EXE or registry key entry I assume)
> to see if SQL Server 2000 Service Pack 3a is already deployed on a
> particular client PC.
>
Can your CA software check the file version of a file? If so, just check
the ISQLW.EXE file against the version you want (2000.80.760.0 for
SP3/SP3a)
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||SELECT @.@.VERSION
Star Fleet Admiral Q @. your Service!
http://www.google.com
Google is your "Friend"
"Fred" <Fred@.discussions.microsoft.com> wrote in message
news:B7E829FB-A6EF-4408-8628-61EFFF8F51D3@.microsoft.com...
> How can I tell (preferably by a version attribute on some DLL or EXE) that
> Service Pack 3a has been installed on a client PC? KB articles such as
> 321185 do a great job of showing how to use SERVERPROPERTY to determine
> what
> version the SERVER is running, but that's not my question. I need to know
> if
> Service Pack 3a has been installed on a CLIENT, not the SERVER.

How to detect INSTALLED SQL version?

Hello,
I need to detect whether the computer has SQL Server 2000 SP3 installed
before
attempting to connect to it, for example during my custom setup program. Wha
t
is the recommended way of doing this?
TIA,
A.SELECT TOP 0 NULL AS Property , NULL AS Variable
UNION ALL SELECT 'Version' , SERVERPROPERTY( 'ProductVersion' )
UNION ALL SELECT 'Level' , SERVERPROPERTY( 'ProductLevel' )
UNION ALL SELECT 'Engine Edition' , SERVERPROPERTY( 'Edition' )
"Abbey" <Abbey@.discussions.microsoft.com> wrote in message
news:1D2E126E-B6FE-411C-B157-FD3BBB49CE82@.microsoft.com...
> Hello,
> I need to detect whether the computer has SQL Server 2000 SP3 installed
> before
> attempting to connect to it, for example during my custom setup program.
What
> is the recommended way of doing this?
> TIA,
> A.
>|||HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL
Server\MSSQLServer\MSSQLServer\CurrentVe
rsion\
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL Server\<instance
name>\MSSQLServer\CurrentVersion\
Key name = CSDVersion (not CurrentVersion).
"Abbey" <Abbey@.discussions.microsoft.com> wrote in message
news:1D2E126E-B6FE-411C-B157-FD3BBB49CE82@.microsoft.com...
> Hello,
> I need to detect whether the computer has SQL Server 2000 SP3 installed
> before
> attempting to connect to it, for example during my custom setup program.
> What
> is the recommended way of doing this?
> TIA,
> A.
>|||This won't work "before attempting to connect to it"... you have to be
connected to the server to run your query...

> SELECT TOP 0 NULL AS Property , NULL AS Variable
> UNION ALL SELECT 'Version' , SERVERPROPERTY( 'ProductVersion' )
> UNION ALL SELECT 'Level' , SERVERPROPERTY( 'ProductLevel' )
> UNION ALL SELECT 'Engine Edition' , SERVERPROPERTY( 'Edition' )|||Hello Aaron,
Thanks for that suggestion - I'll try it and let you know...
Regards,
Abbey
"Aaron Bertrand [SQL Server MVP]" wrote:

> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL
> Server\MSSQLServer\MSSQLServer\CurrentVe
rsion\
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL Server\<instance
> name>\MSSQLServer\CurrentVersion\
> Key name = CSDVersion (not CurrentVersion).
>
> "Abbey" <Abbey@.discussions.microsoft.com> wrote in message
> news:1D2E126E-B6FE-411C-B157-FD3BBB49CE82@.microsoft.com...
>
>|||Is there any harm in opening a connection to check the database version?
If it's the wrong version you can always run "wrong version" code and
disconnect the connection.
"Rebecca York" <rebecca.york {at} 2ndbyte.com> wrote in message
news:4362481f$0$134$7b0f0fd3@.mistral.news.newnet.co.uk...
> SELECT TOP 0 NULL AS Property , NULL AS Variable
> UNION ALL SELECT 'Version' , SERVERPROPERTY( 'ProductVersion' )
> UNION ALL SELECT 'Level' , SERVERPROPERTY( 'ProductLevel' )
> UNION ALL SELECT 'Engine Edition' , SERVERPROPERTY( 'Edition' )
>
> "Abbey" <Abbey@.discussions.microsoft.com> wrote in message
> news:1D2E126E-B6FE-411C-B157-FD3BBB49CE82@.microsoft.com...
> What
>sql

How to detect if SQL Reporting Services is installed ?

From an ASP.Net application I need to detect if on a given node, Repoting
services is installed and if so, which version. Does anyone know a stored
procedure or a Web Services API to do this ?
thanks,RaviHello Ravi,
There are a couple ways to determine RS version:
1) Check the registry at:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Reporting Services\Version
2) Use the webservice API like this:
For RS 2000:
ReportingService rs1 = new ReportingService();
rs1.Credentials = System.Net.CredentialCache.DefaultCredentials;
rs1.ServerInfoHeaderValue = new ServerInfoHeader();
rs1.ListChildren("/", false);
Console.WriteLine(rs1.ServerInfoHeaderValue.ReportServerEdition);
Console.WriteLine(rs1.ServerInfoHeaderValue.ReportServerVersionNumber);
For RS 2005:
ReportingService2005 rs = new ReportingService2005();
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
rs.ServerInfoHeaderValue = new ServerInfoHeader();
rs.ListChildren("/", false);
Console.WriteLine(rs.ServerInfoHeaderValue.ReportServerVersion);
Console.WriteLine(rs.ServerInfoHeaderValue.ReportServerEdition);
Console.WriteLine(rs.ServerInfoHeaderValue.ReportServerVersionNumber);
Note that there is a new property in 2005, "ReportServerVersion". Also be
aware that ReportServerVersionNumber returns differntly formatted values
for 2000 and 2005.
-Chris
> From an ASP.Net application I need to detect if on a given node,
> Repoting services is installed and if so, which version. Does anyone
> know a stored procedure or a Web Services API to do this ?
> thanks,Ravi
>|||Thanks Chris, that was very helpful.
I have started using the #1 to read the registry. But my requirement is that
I need to be able to detect RS and its version on local and remote machines,
including ones behind firewall. Reading Registry in these secanrios leads to
lot of security issues. Further, I also need to detect if RS is currently
running, I need this to enable a button to launch Report Builder.
Using the RS2005 Web Services seems to be a better approach. Do you know of
an API to also detect if Report Services is currently running ? Do you know
what happens if Report Services is not installed on a remote machine but we
try to call a Web Service ?
thanks for your time and help,
Ravi
"Chris Baldwin" wrote:
> Hello Ravi,
> There are a couple ways to determine RS version:
> 1) Check the registry at:
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Reporting Services\Version
> 2) Use the webservice API like this:
> For RS 2000:
> ReportingService rs1 = new ReportingService();
> rs1.Credentials = System.Net.CredentialCache.DefaultCredentials;
> rs1.ServerInfoHeaderValue = new ServerInfoHeader();
> rs1.ListChildren("/", false);
> Console.WriteLine(rs1.ServerInfoHeaderValue.ReportServerEdition);
> Console.WriteLine(rs1.ServerInfoHeaderValue.ReportServerVersionNumber);
> For RS 2005:
> ReportingService2005 rs = new ReportingService2005();
> rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
> rs.ServerInfoHeaderValue = new ServerInfoHeader();
> rs.ListChildren("/", false);
> Console.WriteLine(rs.ServerInfoHeaderValue.ReportServerVersion);
> Console.WriteLine(rs.ServerInfoHeaderValue.ReportServerEdition);
> Console.WriteLine(rs.ServerInfoHeaderValue.ReportServerVersionNumber);
> Note that there is a new property in 2005, "ReportServerVersion". Also be
> aware that ReportServerVersionNumber returns differntly formatted values
> for 2000 and 2005.
> -Chris
>
> > From an ASP.Net application I need to detect if on a given node,
> > Repoting services is installed and if so, which version. Does anyone
> > know a stored procedure or a Web Services API to do this ?
> >
> > thanks,Ravi
> >
>
>

How to de-install SQL Server 7.0

I am unable to de-install 120 days evaluation version of
SQL Server from my desktop running Windows XP Home
edition. While attempting to un-install, I get the
following message:
" unInstallShield has detected that 'C:\MSSQL7
\BINN\sqlmangr.exe' is in use. Please close the
application using this file and unInstallShield again."
Please advise.SQLMANGR.exe is the manager program in the task tray at the bottom of your
screen that allows you to stop and start SQL processes. Right click on the
icon that looks like a little server with a red or green arrow and close
it... or you can kill the sqlmangr.exe process from Task Manager...
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"TJ" <tajammalw@.msn.com> wrote in message
news:075401c399c6$eab57240$a101280a@.phx.gbl...
> I am unable to de-install 120 days evaluation version of
> SQL Server from my desktop running Windows XP Home
> edition. While attempting to un-install, I get the
> following message:
> " unInstallShield has detected that 'C:\MSSQL7
> \BINN\sqlmangr.exe' is in use. Please close the
> application using this file and unInstallShield again."
> Please advise.