Determine MS SQL License Mode on Wintel Servers

Hi there.

I am trying to remotely determine the license mode that was used when installing MS SQL (versions 6, 7 and 2000) on a remote server. I do not have a SQL logon and thus am asking is there a file / registry entry that can tell one if SQL was installed PERSEAT or PERSERVER?

Any help would be greatly appreciated as I have tried searching google and have not found anything.I don't think software license information is available through software installation.

All server available information can be seen by executing:

sp_server_info|||Hi there. No Licensing mode information is available from sp_server_info

Any other stored procedures?|||As I told you above it is not available.|||I understand what you are looking for. In an enterprise environment, it is necessary to audit your servers for licenses. You might acquire servers from other departments or even other companies that were built prior to you having ownership of them. An audit is necessary to not only see what version of SQL server is on a machine but also if it is licensed using per seat or per processor (and how many).

Does anyone know a command or stored procedure to reveal this data? Thanks.

Detecting Installed IIS - installing SQL 2005 Standard

I've seen lots of posts but few if any solutions to this apparently common problem.

I'm experiencing a variant - installing SQL 2005 (RTM) on a brand new machine with Server 2003 Standard Ed. SP1, the setup program frequently pauses on steps identified as "Detecting Installed IIS". Setup eventually moves on, but it's taking ages to finish the install.

I've installed this exact version of several identical machines, but this is the first where I've encountered this behavior.

Does anyone have any input on what's really happening here and what to do about it?I guess no one really knows... :)

In my case, I believe that the cause was a DNS issue that caused all name resolution requests to time out. Others have reported issues related to firewalls or antivirus software.|||

Thanks for posting your solution, Carl. What was the DNS issue you were hitting? Did you have to change some settings to get it working? And approximately how long was the slow install? Hours? This issue has appeared a few times on here and I don't think we have a good answer yet other than DNS/firewall/anti-virus issues.

Thanks,
Sam Lester (MSFT)

|||

Now this is stressing the way-back machine!

The slow install was, as I recall, something on the order of 2-5 minutes each time something tried to detect IIS (and it happens several times during the install).

If I recall, the solution was to configure TCP/IP on the install machine to use the local domain controller for DNS rather than my upstream providers' DNS server.

Detecting Installed IIS - installing SQL 2005 Standard

I've seen lots of posts but few if any solutions to this apparently common problem.

I'm experiencing a variant - installing SQL 2005 (RTM) on a brand new machine with Server 2003 Standard Ed. SP1, the setup program frequently pauses on steps identified as "Detecting Installed IIS". Setup eventually moves on, but it's taking ages to finish the install.

I've installed this exact version of several identical machines, but this is the first where I've encountered this behavior.

Does anyone have any input on what's really happening here and what to do about it?I guess no one really knows... :)

In my case, I believe that the cause was a DNS issue that caused all name resolution requests to time out. Others have reported issues related to firewalls or antivirus software.|||

Thanks for posting your solution, Carl. What was the DNS issue you were hitting? Did you have to change some settings to get it working? And approximately how long was the slow install? Hours? This issue has appeared a few times on here and I don't think we have a good answer yet other than DNS/firewall/anti-virus issues.

Thanks,
Sam Lester (MSFT)

|||

Now this is stressing the way-back machine!

The slow install was, as I recall, something on the order of 2-5 minutes each time something tried to detect IIS (and it happens several times during the install).

If I recall, the solution was to configure TCP/IP on the install machine to use the local domain controller for DNS rather than my upstream providers' DNS server.

Detecting Installed IIS - installing SQL 2005 Standard

I've seen lots of posts but few if any solutions to this apparently common problem.

I'm experiencing a variant - installing SQL 2005 (RTM) on a brand new machine with Server 2003 Standard Ed. SP1, the setup program frequently pauses on steps identified as "Detecting Installed IIS". Setup eventually moves on, but it's taking ages to finish the install.

I've installed this exact version of several identical machines, but this is the first where I've encountered this behavior.

Does anyone have any input on what's really happening here and what to do about it?I guess no one really knows... :)

In my case, I believe that the cause was a DNS issue that caused all name resolution requests to time out. Others have reported issues related to firewalls or antivirus software.|||

Thanks for posting your solution, Carl. What was the DNS issue you were hitting? Did you have to change some settings to get it working? And approximately how long was the slow install? Hours? This issue has appeared a few times on here and I don't think we have a good answer yet other than DNS/firewall/anti-virus issues.

Thanks,
Sam Lester (MSFT)

|||

Now this is stressing the way-back machine!

The slow install was, as I recall, something on the order of 2-5 minutes each time something tried to detect IIS (and it happens several times during the install).

If I recall, the solution was to configure TCP/IP on the install machine to use the local domain controller for DNS rather than my upstream providers' DNS server.

sql

Desperate on installing SP 1

after we download sp1 and hit runj, we got "Unspecific Error Occur" popup window, with message:The following unexpected error occur:" then without any detail. here is the hotfix log:

Please help

08/01/2006 14:33:51.967 ================================================================================
08/01/2006 14:33:51.967 Hotfix package launched
08/01/2006 14:33:51.967 Successfully opened registry key: SOFTWARE\Microsoft\Windows\CurrentVersion
08/01/2006 14:33:51.967 Successfully read registry key: CommonFilesDir, string value = C:\Program Files (x86)\Common Files
08/01/2006 14:33:51.967 Successfully opened registry key: SOFTWARE\Microsoft\Windows\CurrentVersion
08/01/2006 14:33:51.967 Successfully read registry key: ProgramFilesDir, string value = C:\Program Files (x86)
08/01/2006 14:33:52.014 Successfully opened registry key: SOFTWARE\Microsoft\Windows\CurrentVersion
08/01/2006 14:33:52.014 Successfully read registry key: CommonFilesDir, string value = C:\Program Files (x86)\Common Files
08/01/2006 14:33:52.014 Successfully opened registry key: SOFTWARE\Microsoft\Windows\CurrentVersion
08/01/2006 14:33:52.014 Successfully read registry key: ProgramFilesDir, string value = C:\Program Files (x86)
08/01/2006 14:33:52.014 Local Computer:
08/01/2006 14:33:52.014 Target Details: ISSQL05
08/01/2006 14:33:52.014 commonfilesdir = C:\Program Files (x86)\Common Files
08/01/2006 14:33:52.014 lcidsupportdir = e:\1af2e497cde06964771333\1033
08/01/2006 14:33:52.014 programfilesdir = C:\Program Files (x86)
08/01/2006 14:33:52.014 supportdir = \\ISSQL05\e$\1af2e497cde06964771333
08/01/2006 14:33:52.014 supportdirlocal = e:\1af2e497cde06964771333
08/01/2006 14:33:52.014 windir = C:\WINDOWS
08/01/2006 14:33:52.014 winsysdir = C:\WINDOWS\system32
08/01/2006 14:33:52.014
08/01/2006 14:33:52.014 Enumerating applicable products for this patch
08/01/2006 14:33:53.530 The patch installation could not proceed due to unexpected errors
08/01/2006 14:33:53.530
08/01/2006 14:33:53.530 Product Status Summary:
08/01/2006 14:33:53.780 Hotfix package closed

I also faced this error after process "Enumerating applicable products for this patch" once installing SQL SP1 but I m not sure why this came up. That was a development machine so I didnt fiddle much with it.

Regards

|||hmm.. I have the same problem.|||

I found sollution in this thread http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=614124&SiteID=1&mode=1

desinstall MS SQL

Hi
I am installing Crystal entreprise, it finds MS SQL Server installed
and ask me my login and password. I found directory MS SQL in program
files but i couldnt find uninstall programm. So I delete directory in
MS SQL in program files. But Crystal Entreprise find again MS SQL on my
machine.
Could you help me please ?
Thanks

PS: Sorry for my french postSo first deleting the SQL Server directories is a problem, you should
deinstall that, if you cant find the uninstall it could be that you
dont have the appropiate permissions to execute the deinstaller (?!).

Is there a service running with the name MSSQLSERVER***** ?

HTH, Jens Suessmeyer|||(minigitoo@.aol.com) writes:
> I am installing Crystal entreprise, it finds MS SQL Server installed
> and ask me my login and password. I found directory MS SQL in program
> files but i couldnt find uninstall programm. So I delete directory in
> MS SQL in program files. But Crystal Entreprise find again MS SQL on my
> machine.

Not really sure why you would uninstall SQL Server just because you
install Crystal Enterprise. Anyway, use Add/Remove Programs in the
control panel to uninstall SQL Server. Just deleting the files does not
help you, as Crystal - as any other civilized piece of software looks in
the registry.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
news:Xns96CFF0C3CF1C2Yazorman@.127.0.0.1...
> (minigitoo@.aol.com) writes:
> > I am installing Crystal entreprise, it finds MS SQL Server installed
> > and ask me my login and password. I found directory MS SQL in program
> > files but i couldnt find uninstall programm. So I delete directory in
> > MS SQL in program files. But Crystal Entreprise find again MS SQL on my
> > machine.
> Not really sure why you would uninstall SQL Server just because you
> install Crystal Enterprise. Anyway, use Add/Remove Programs in the
> control panel to uninstall SQL Server. Just deleting the files does not
> help you, as Crystal - as any other civilized piece of software looks in
> the registry.

And of course at this point if the original poster has no backup of that
directory, there's no easy way to uninstall the program since as I recall,
the uninstl script is normally there.

>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp|||Greg D. Moore (Strider) (mooregr_deleteth1s@.greenms.com) writes:
> "Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
> news:Xns96CFF0C3CF1C2Yazorman@.127.0.0.1...
>> (minigitoo@.aol.com) writes:
>> > I am installing Crystal entreprise, it finds MS SQL Server installed
>> > and ask me my login and password. I found directory MS SQL in program
>> > files but i couldnt find uninstall programm. So I delete directory in
>> > MS SQL in program files. But Crystal Entreprise find again MS SQL on my
>> > machine.
>>
>> Not really sure why you would uninstall SQL Server just because you
>> install Crystal Enterprise. Anyway, use Add/Remove Programs in the
>> control panel to uninstall SQL Server. Just deleting the files does not
>> help you, as Crystal - as any other civilized piece of software looks in
>> the registry.
> And of course at this point if the original poster has no backup of that
> directory, there's no easy way to uninstall the program since as I recall,
> the uninstl script is normally there.

Oops! I didn't think of that. I hope he still has his installation media,
so he can repair his installation to uninstall it.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
news:Xns96D06BE298745Yazorman@.127.0.0.1...
> Oops! I didn't think of that. I hope he still has his installation media,
> so he can repair his installation to uninstall it.

To paraphrase a quote from 30+ years ago...

"We had to install the program to uninstall it".

Very zen actually.

Hmm.. Zen and the Art of Computer Maintenance.

> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp|||Erland Sommarskog wrote:
> Greg D. Moore (Strider) (mooregr_deleteth1s@.greenms.com) writes:
>>"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
>>news:Xns96CFF0C3CF1C2Yazorman@.127.0.0.1...
>>
>>>(minigitoo@.aol.com) writes:
>>>
>>>>I am installing Crystal entreprise, it finds MS SQL Server installed
>>>>and ask me my login and password. I found directory MS SQL in program
>>>>files but i couldnt find uninstall programm. So I delete directory in
>>>>MS SQL in program files. But Crystal Entreprise find again MS SQL on my
>>>>machine.
>>>
>>>Not really sure why you would uninstall SQL Server just because you
>>>install Crystal Enterprise. Anyway, use Add/Remove Programs in the
>>>control panel to uninstall SQL Server. Just deleting the files does not
>>>help you, as Crystal - as any other civilized piece of software looks in
>>>the registry.
>>
>>And of course at this point if the original poster has no backup of that
>>directory, there's no easy way to uninstall the program since as I recall,
>>the uninstl script is normally there.
>
> Oops! I didn't think of that. I hope he still has his installation media,
> so he can repair his installation to uninstall it.

This has some good information on how to manually uninstall SQL Server 2000:
http://support.microsoft.com/defaul...kb;en-us;290991|||thanks

it changes of other one who prefers to send post without intersest, for
giving their "very interesting" think !