In SQL 2000 you went to Control Panel and SQL Licensing to view licensing mode and qty. I have searched everywhere for the equivelant in 2005 including books online, knowledge base but can't find anything.
Anybody know where it is hidden as I need to check this server is set up for per processor and check how many processors?
Thanks
Richard
When I installed sql, I mistakenly made it so that only 1 connection is allowed at one time. How can I change this info. to make it so that more than 1 connection are allowed without re-install sql again? Thanks
View 1 Replies View Related
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.
Hi,
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.
Cheers,
Arun
I need to find out how to display, edit and save SQL information using Visual Basic. I can create an SQL database and spreadsheet, but do not know how to incroporate it into my project, and make certain pieces of the information (certain cells) appear in the labels or textboxes that I designate in my VB Project.
Thanks.
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??
Respectfully,
Frustrated
"Frustrated"
I posted this under 'microsoft.public.sqlserver.client' but got no reply.Any help with this problem would be greatly appreciated---------------------I developed a database under SQL Server 2000, with Access 2000 on Windows2000 as client. This had been running fine for several years. The client isnow upgrading to Windows XP, and has come across a display problem on thereports. The figures are correct but are now displayed with lots of trailingzeros e.g365.00000I have built a test system but cannot duplicate the problem :-( . Also theproblem varies between computers, and even between different users on thesame computer. One solution that seems to work is to explicitly cast alloutput from the server e.g.CAST ( TonsLoaded AS INT) TonsLoadedbut this is a pita since there are 141 stored procedures.Has anyone seen this problem? I haven't found anything in the newsgroups orany Knowlege Base article. It looks like it is to do with Windows XP as theclient ...David
View 5 Replies View RelatedI want to be able to see when records have been added to a table. The issue is we have a DTS job scheduled to run every night. The developer who wrote it password protected it and doesn't work here anymore. I want to add a step to this series of DTS jobs and want to run it just prior to his job. Is there a way to see when the records are being added or when this job is being run? Thanks again, you guys are the best.
ddave
I would like to display a portion of report where there is data or no data
There is data subreport display
Product Name Latex Gloves
Product ID
xxxx5678
There NO data in the subReport
Product Name
Product ID
When attemping to install SQL 2005 Express using the following command line arguments
/qb UPGRADE=SQL_Engine INSTANCENAME=MY_INSTANCE
or
/qb UPGRADE=SQL_Engine INSTANCENAME=MY_INSTANCE SECURITYMODE=SQL SAPWD=MY_PASSWORD
the following error occurs.
Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
Edition check:
Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
The following version and editions have been verified.
1. .NET 2.0 installed
2. Windows XP SP2
3. MSDE 8.00.2039(SP4)
4. all MSDE databases are owned by sa
5. Instance and SQLAgent running under user that is member of Administrators
What are the possible reasons this error is occurring?
We have a server instance on SQL Server 2005 SP2 build 3042. We have a 32 bit x86 server. We attempted to upgrade to SP2 build 3054 KB934458. And we got the following error as stated in the Summary.txt file.
Code Snippet
**********************************************************************************
Product Installation Status
Product : SQL Server Database Services 2005 (MSSQLSERVER)
Product Version (Previous): 3042
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB934458_sqlrun_sql.msp.log
Error Number : 29538
Error Description : MSP Error: 29538 SQL Server Setup did not have the administrator permissions required to rename a file: e:SQLDatamssqlsystemresource1.ldf. To continue, verify that the file exists, and either grant administrator permissions to the account currently running Setup or log in with an administrator account. Then run SQL Server Setup again.
----------------------------------------------------------------------------------
The client tools and workstation components were successfully installed. The server is still reporting build 3042.
Here is the portions of the HotFix.log file.
Code Snippet
05/12/2008 09:19:09.041 Copy Engine: Creating MSP install log file at: C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB934458_sqlrun_sql.msp.log
05/12/2008 09:19:09.072 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller"
05/12/2008 09:19:09.103 Registry: Cannot read registry key value "Debug"
05/12/2008 09:21:29.382 MSP Error: 29538 SQL Server Setup did not have the administrator permissions required to rename a file: e:SQLDatamssqlsystemresource1.ldf. To continue, verify that the file exists, and either grant administrator permissions to the account currently running Setup or log in with an administrator account. Then run SQL Server Setup again.
05/12/2008 09:22:33.678 MSP returned 1603: A fatal error occurred during installation.
05/12/2008 09:22:33.724 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller"
Any help would be appreciated.
Hi,
We are performing a SQL 2005 SP1 upgrade from SQL 2000 on our Windows 2003 SP1 Standard Edition.
When we run the upgrade, we got a error "Upgrade Advisor Return -1" as a pop-up window.
When we run the Upgrade Advisor separately, we get this error :
===================================
Common Language Runtime detected an invalid program.
===================================
Common Language Runtime detected an invalid program. (System.Xml)
------------------------------
Program Location:
at System.Xml.Schema.SchemaInfo..ctor()
at System.Xml.Schema.XmlSchemaSet..ctor(XmlNameTable nameTable)
at System.Xml.XmlReaderSettings.get_Schemas()
at Microsoft.SqlServer.UpgradeAdvisor.ReportViewer.UAReportController.LoadAndValidateDataFile()
at Microsoft.SqlServer.UpgradeAdvisor.ReportViewer.UAReport.ValidateDataFile()
at Microsoft.SqlServer.UpgradeAdvisor.ReportViewer.UAIssueReport.Refresh()
at Microsoft.SqlServer.UpgradeAdvisor.ReportPanel.OpenReport(String reportFile)
We are in a lost for solutions. We do hope to hear from anyone asap...
Greatly appreciated for any kind assistance.
Thanks.
Hi,
We are running a test upgrade form sql 2000 standard edition 32 bit to sql 2005 developer edition 32bit. Followed through all the steps and specified the account(SA priveleges and currently used by the 2000 version) and is the local admin on the box for the services and the setup seemed to move fine, except for when it got to the point of installing database services - This is the error message that I got:
MSSQLServer could not be started. Verify you have sufficient priveleges to start system services. The was no choice but to hit cancel and then the set up progressed with a final message of 'SEtup failed'.
Here is a portion of the error log:
Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
Database Mirroring Transport is disabled in the endpoint configuration.
Starting up database 'master'.
Converting database 'master' from version 589 to the current version 611.
Database 'master' running the upgrade step from version 589 to version 590.
Error: 946, Severity: 14, State: 1.
Cannot open database 'master' version 589. Upgrade the database to the latest version.
System Task Aggregate global counters produced an error that was not handled. Major: 9, Minor: 46, Severity:14, State:1
Error: 928, Severity: 20, State: 1.
During upgrade, database raised exception 15151, severity 16, state 1, address 01C4C50B. Use the exception number to determine the cause.
Error: 15151, Severity: 16, State: 1.
Cannot find the endpoint 'TSQL Local Machine', because it does not exist or you do not have permission.
Any help would be greatly appreciated
Thanks KR
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?
Thanks.
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? :)
Thanks....
Michael
jns-michael@home.com
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 2 Replies View RelatedHi,
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!
Thanks,
Sanjay
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?
seethem.
Greetings,
I have a client whose DBA upgraded their SQL 2000 database to SQL 2005. They still have it running in 8.0 compatibility mode, for various reasons, and would like me to help them develop a migration strategy to get them to full 9.0 compatibility.
My question is: can I run the Upgrade Advisor on a SQL 2005 engine database running in 8.0 compatibility mode and get anything useful? I already know there will be some issues with existing DTS packages but it would be nice to catch any other issues in advance.
I know that the Upgrade Advisor was run before the upgrade took place but to my knowledge the report was not saved and none of the recommendations were followed.
Any help would be greatly appreciated.
Cheers,
Lon
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 1 Replies View RelatedHello,
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.
Thanks
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?
Thanks!
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.
thanku
rk
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.
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?
Thanks,
Westley
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.
Simon
Is there a way to change the license key after installation of SQL7.0?
View 1 Replies View RelatedIs 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.
thanks
-D
Does it mean "per hard drive" or "per CPU"(Pentium III, Pentium IV, etc.)? I'm a bit confused about it after reading a lot of books and article talking about processor license. Thanks in advance....
View 4 Replies View RelatedHi,
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.
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?
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?
Thanks.
Hello,
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.
Thanks,
-Jason-