Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server & have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for

SQL 2000 - License Key


I have to audit a number of servers and tally with source installation CDs. How can I tell which CD license key has been used on a server , i.e. where (I assume in registry) is the license key held ??

Many thanks.

View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
License Requirements For MS-SQL 2000
We have a win2003 server box that is using MS-SQL 2000. We have a 20user license on this server at the present time. We have a need toallow up to 5 simultaneous additional users access to a subset of thisdata from our IIS server. How does this affect my current SQL ServerLicense? We can restrict access via connection pooling, etc. Can weuse a 30 user license or must we go to a CPU license? Does anyoneknow where to find Microsoft licensing information on this?

View Replies !   View Related
SQL Server 2005 Workgroup Edition Licensing (How To Install Without A License, Then Require License On First Run)
I have a VERY Legitmate use to install sql 4 workgroups on a pc without licensing it.  I am making a disk image for MANY pcs to be imaged and load licensing after the imaging is completed.

I have been able to do this with Windows XP Professional, MS Office 2003 and a couple non-Ms programs.  The information for MS software even came from their KB, so I know what I am doing is legit.  I just can't find any information on doing this for my sql app. 

Any suggestions??




View Replies !   View Related
SQL Server 2000 License Query
Hello.After searching Microsoft's website for hours and confusing myself morethan I was before I started...Can anyone explain to me what the current state of affairs is for SQL2000 licensing?In particular with a server that has multiple processors and multipleinstances of SQL Server 2000 running - for both Standard and EnterpriseEditions of SQL Server 2000.Please help!Regards,Taz

View Replies !   View Related
SQL 2005 License Downgrade To 2000
Does anyone know more details about "downgrade rights". Do you need to askMS for this right? How do you get a CD key (a legit key) for SQL 2000 ifyou urchase SQL 2005.From MS Licensing FAQ at: do I downgrade to SQL Server 2000?A.If you require SQL Server 2000 for existing solutions, you can stillacquire additional licenses by taking advantage of the SQL Server 2005"downgrade rights." The downgrade rights enable you to purchase server plusdevice CALs, server plus user CALs, or processor licenses for SQL Server2005 and install and use the previous version for a reasonable period oftime.

View Replies !   View Related
Sql 2000 Price && License Puzzle...
SQL 2000 pricing and licensing is quite confusing, and even more pain including the upgrading pricing from sql6.5/sql7.0.

I got very clear Windows2000 pricing and upgrading from one Microsoft web address. But just could not find a ONE Microsoft web sit explicitely describe the $ pricing for each of SQL2000 edition (per processor vs. CAL..., including upgrading from SQL 6.5, SQL 7.0). May be I missed that site?


View Replies !   View Related
Sales Of SQL Enterprise Processor 2000 License
Hi all,I'm in the market to purchase 10 SQL 2000 Enterprise processorlicenses. Since License Agreement restrictions prevent the creation ofa secondary market I am turning to people who may know of a company whois offloading their licenses.This is a strictly legitimate, one-time transfer to one of my clientswho does not wish to pay $17K for each processor license.Please contact me at j o s h s a c k e t t _at_ g m a i l _dot_ c o m.Thanks.

View Replies !   View Related
SQL Server 2000 To SS05 - License Upgrade

We have a product which uses SQL Server 2000 Enterprise Edition with Per Seat licensing option. Going forward with a new release of the product, we intend to upgrade to SQL Server 2005. Till now our product was being used in non web based scenarios so the Per Seat licensing option helped our case. In the upcoming release which would use SQL Server 2005 we need to break off from the non web based scenario as the product would use SQL Server over internet.
So isn't it correct to go for the Processor based licensing instead of the Per seat licensing ?

If so then what would be the ideal manner to upgrade the license from Per Seat (in SQL Server 2000) license type to Processor based (in SQL Server 2005) license type ?

I have heard of Software Assurance providing assistance in version upgrades. Would it help in case I need to upgrade from one license type to another ? Or is it applicable only in case of upgrade where the license type is fixed ?

Thanks in advance.


View Replies !   View Related
License Information For Best Practice Analyser For SQL Server 2000
I have downloaed microsoft's Best Practice Analyser for SQL Server 2000. I would like to recomend this tool in our organisation. Before that i want to confirm that is there any restrictions to use this tool or it is an free ware tool.

View Replies !   View Related
SQL Server 2005 License Backwards Compatible With 2000?
If my client has a SQL Server 2005 Standard Edition license, can they use that license for a SQL Server 2000 Standard Edition installation?
thanks for any help...

View Replies !   View Related
Reporting Services 2005 In SQLServer 2000 License
I think this question may have arisen before but I'm not clear on the answer. We have customers using SQLServer 2000 with Reporting Services 2000. We want to upgrade them to Reporting Services 2005 but otherwise with identical setup. The question is, is there any cost involved in doing this from a license point of view?

View Replies !   View Related
Sql License
I inherited a SQL 6.5 server and it appears no licensing
info has been input using License Mgr. I asked my mgr.
and he just gave me the cd rom. He thinks I just need
to punch in the cd key. I don`t think this is correct.
Server is set up for per seat licensing. Can someone
explain what a client access license is or looks like
and how do I go about getting them? I know this software
has been paid for. Thanks, Kat

View Replies !   View Related
SQL 7.0 License
How do you increase the number of license? With 6.5 we were able to do this through the setup on the CD but it will not let me do this with 7.0? The specific error is SQL Server Error 18460. Logon Failed. The maximum simultaneous user count of 5 license s for this Standard Edition server has been exceeded. I have upgraded the licenses in the License manager for Windows NT but SQL 7.0 does not seem to recognize it.

View Replies !   View Related
License On DTS
To all,

Can anyone give me the answer?

I want to use DTS to import some data from remote server to my local server.
Every time I get following error message "The license for the installation of Microsoft SQL Server on your source and destination connections does not permit the use DTS to transfer data".

Both my servers are on SP2. Why I have such error? What should I do?


View Replies !   View Related
Which License?
Hello all,

I need to pick up a SQL Server 7 license, but I am a little confused as to what I need.

I'll be running SQL Server 7 on a web server. I'll be the only one logging to maintain SQL Server. There will be three different apps the run on the server that each will have one to ten databases.

So, what's the minimum license I need? Will the developer's license work?

Any one out there have a license they want to sell - cheap? :)



View Replies !   View Related
SQL License

My company is developing their site with MS SQL which will then be transfered onto another server hosted by our ISP, do I need to purchase a SQL license for that machine - exactly what do I need to purchase.

Any help appreciated!



View Replies !   View Related
New challenge!!!!

I have already installed a SQL Server 2005 cluster with several instances and I want to change the license key to another one.

How can I do this with out having to re-install?


View Replies !   View Related
License Types
i want to check the price of sql server 2005 in my country as a consideration to take when deciding on wich db to build.i dont understand the licensing method. what 5 clt stands for ? whats the basic 64 bit 1 processor dual core license i need for a commercial website ? thanx, 

View Replies !   View Related
License Requirement

Anyone aware of any license requirment for selling any application developed in ASP.NET (C#) using MSDE as backend?

Any response will be highly appreciated.


View Replies !   View Related
Changing License Key
Is there a way to change the license key after installation of SQL7.0?

View Replies !   View Related
Check License ....
Is there a way to check if a sql 2000 server was installed on the license of "per server" or "per # concurrent users"?

Can't find from server property.

View Replies !   View Related
License Manager And SQL
Has anyone had problems with license manager with SQL7 on NT4. I've got several SQL servers on different networks, and some of the have this problem. It seems that for every client connection, even if it's from the same client PC, NT thinks that it's a new access. I had 6 PCs on one network and the SQL license usage showed as 83! What?

If anyone can help, I'll send them a live haggis.



View Replies !   View Related
License Issue
hi I am using DTS Wizard to copy a full database from one sql server into another , I got this error message.

" The license for the installation of Ms sql server on your source and destination connections does not permit the use DTS to transform data. "

How can I work around this issue.



View Replies !   View Related
License Mode
Hi all,

I want to know how I can do to change my SQL server licence mode (from per-ser to per-seat) without reinstall SQL Server.

Thanks in advance.

View Replies !   View Related
License Change?
Hi all,
There is a guy in my company install a sql server himself, but he picked the per seat license rather then the per server (we got the per server license), is there a way to change it without re-install the whole sql server? or need to reinstall from start?

View Replies !   View Related
OLAP License?
I can't find anything written about licensing for OLAP anywhere. Do I presume correctly that it doesn't require one of its own?

Thanks for any info.


View Replies !   View Related
License Modes
Hi ,
I have two servers, One is with per seat mode
another with per license mode.
when i am registering one server which is having per seat mode at one of
my client machine , it is giving u dont have license permission.
Can anyone suggest me regarding license modes if u have two servers.


View Replies !   View Related
SQL Desktop License?
If I just need a desktop version of SQL 7.0 installed for local development. (Not being used as a server) Do I just need a CAL license?


View Replies !   View Related
Hey Gang,

I was wondering if there was an alternative to using SQL SERVER and not having to spend all that money on a license?

View Replies !   View Related
Number Of License
Dear All,


I have different application installed on a server all of them are interface to SQL Server databases.
I want to know if I have 5 user license to one application, 10 user license to other application, 3 user license to third application. So, I have as an example 18 application license.
My question is: What does affect the access of these application to their databases? - Number of application user license or something else.
Thanks n advance.

View Replies !   View Related
Need Help With License Upgrade

I installed sql server 2005 standard edition a few months ago and while installing i realized that it was the 5 CAL version.  I need the per processor license.  so we order the per processor license standard edition.  i go to install it and it tells me to run setup with the SKUUPGRADE option.  i try that and it doesn't work.  so then, i go to control panel and hit change/remove and it installs some stuff.  i install some hotfixes to get it up to build 9.0.3159 like the rest of my servers.  however, i can't find any way to tell what kind of license it's using.  this is one of my production servers so i can't have any restrictions or reduced performance if it still thinks it's running a 5 CAL version.  how do i tell what kind of license it's using?
 i was originally going to uninstall sql server 2005 and reinstall it using the new media, but this server is also one of my production sql server 2000 servers and if it messed up my sql server 2000 installation i would be in huge trouble.

View Replies !   View Related
Sqk 2K Asks For A License Key Why?
I run w2003 standard and SQL 2K on my development machines.
I have installed this environment several times with no problems.
Now I am setting up a new machine, an AMD dual core.
Right after installing and validating w2003 I tried to install SQL 2K developer edition and after the first few dialogs it brings up a license key dialog with an already filled in key and it will not let me continue.
This product doesn't require a key, and no keys are given for it in my MSDN subscription. I just tried this CD in an XP machine and it installs without asking for a key. It never asked for a key when I installed on previous w2003 std. machines either.
Why I sit asking for a key now? Why will it not install on this particular machine?

View Replies !   View Related
License SqlServerCe
 Does anybody know if sqlserverce's license is freeware or shareware??
thanks a lot!

View Replies !   View Related
SQL License Maze
Hi, I'm not sure if this is the correct forum to ask about this, but here it goes.

I was planning to aquire the SQL Workgroup (2 processors, bla bla bla). But I realized it is not as simple as that.

Then I was looking at the different licenses and I'm not sure where I stand. The 2 processors, reporting services and

unlimited Database size is what I need. I currently use the Express Edition so I cant schedule backups within the

SQL Server and also when the database reaches 4GB will have to buy another version of SQL Server.


But which license should I have? I am a developer so all I need is an instance of the SQL Server running, nothing else.

My application will connect to it and do its job from different PCs in the netowork. I dont need any SQL Client application

running and my application uses a single user (sa) to access the SQL Server simultaniously from several PCs on the



So that is why I think this is a maze to me, I don't know where to proceed. Does anyone know which license or whatever

SQL Server 2005 Workgroup version should I use?




View Replies !   View Related
License Question

I have a question concerning the license requirements for SQL Server Express Edition.  I read from a previous MSDN license agreement for MSDE the following non-competition section:

"7.6  If you choose to redistribute MSDE, you also agree:  (i) that your application shall not substantially duplicate the capabilities of Microsoft Access or, in the reasonable opinion of Microsoft, complete with same; and (ii) that unless your application requires your customers to license Microsoft Access in order to operate, you shall not reproduce or use MSDE for commercial distribution in conjunction with a general purpose word processing, spreadsheet or database management software product, or an integrated work or product suite whose components include a general purpose word processing, spreadsheet, or database management software product except for the exclusive use of importing data to the various formats supported by Microsoft Access."

I can't find this section or similar verbiage in the SQL Server Express Edition redistribution EULA or in the newest MSDN license agreement.  My company has a database product that provides other functionalities besides just being a database.  However we didn't use MSDE due to the section quoted above.  I am wondering whether SQL Server Express Edition's license model has changed?

Any help is greatly appreciated.



View Replies !   View Related
SQL Express Commercial License
Hello Everyone,I have been searching hard to get an answer on this question, I hope someone here can help me!Here is my situation:I am planning to build a website for them, that would be used for some event registration (by people outside my company). I also plan to use SQL Express Edition as the database backend for the site. Now this is where I have a question, can I use SQL Express and pay nothing? (It is free right?) There would be a maximum of 600 registrations over a period of 1 month. I don't expect more than 50 concurrent users. The administration side of the application would be used by internal employees (So, the application would be used by internal employees and external people). Where can I find more information about the license?I would be very thankful if someone can guide me on this.ASP_Newbie

View Replies !   View Related
No. Of Connections Available For Per Seat License
We have a MSSQL with per seat license of 20. The MSSQL is sitting in the same machine as the

Does that mean that the the no. of connections and Max Pool Size are limited up to 20 only?

View Replies !   View Related
SQL Server License Checker
Hi all,I am performing a consolidation of all SQL servers in my environment. Ihave run the tool to find out what level patching they have and whatedition they are running on, but is there a tool so I can scan thenetwork and find out what licensing they are setup for (processor if I have to enumerate each one, one at a time I would be OK withthat. I just don't want to have to login to each server and go toControl Panel and click on the Licensing.Command line is super-duper.Thanks,Josh

View Replies !   View Related
Changing License Mode
I inherited a SQL Server 2000 which is configured to run under CPUbased license mode.Is it possible to switch it to be based on 'Per seat mode' withoutuninstall and installing SQL Server?

View Replies !   View Related
SQL Server Per Processor License
If I install an instance of SQL Server on a box with 4 processors but specify in the licensing part of the installation procedure that it's a '2 processor license', does that really mean that SQL Server will only use 2 of the 4 processors? I ask because, having done this, if I check the SQL Server instance's properties, on the Processors tab, there are 4 processors ticked - giving the impression that 4 processors are being used by this SQL Server instance. Can anyone throw some light on this?

Another question... If I wish to reconfigure the same SQL Server instance from a 2 to a 4 processor 'per processor' license, how can this be done?


View Replies !   View Related

Copyright © 2005-08, All rights reserved