Hi all,
I am performing a consolidation of all SQL servers in my environment. I
have run the tool to find out what level patching they have and what
edition they are running on, but is there a tool so I can scan the
network and find out what licensing they are setup for (processor vs.
seat)?
Even if I have to enumerate each one, one at a time I would be OK with
that. I just don't want to have to login to each server and go to
Control Panel and click on the Licensing.
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.
I downloaded SQL Server 2005 from Microsoft's website and tried to install.
First I downloaded and installed filename "dotnetfx.exe" according to the install guide. Installed without any issues.
Then i tried to install filename: "SQLEXPR.exe"- the main SQL Server software- which I also downloaded from Microsoft. I get the error below and here is how i got it.
------------------ ERROR: The SQL Server system configuration Checker cannot be executed due to WMI configuration on the machine YOUR-07NFK16HDF Error:2147749896(0x80041008) --------------------
I clicked on the executable file SQLEXPR.exe, then, after extracting the file,
after the end user license agreement...
the next screen says "installing prerequisites Microsoft SQL server 2005 setup support files, the required components were installed successfully"
then i hit "next", then I see the screen with message (below:
"system configuration check....SQL server setup is scannong your computers configuration". During this process(system configuration check), this is when I get the error ERROR- above. The pop-up error screen has a help icon.
clicking on help gives me the info below and says i must send it across the internet
Link ID = 20476 Product Name = Microsoft SQL server Product version = 9.00.2047.00 message source = setup.rll messageID = 70342
the resulting information says that there is no such information about message source in the knowledge database.
----- pls what is the problem. Is it with the downloaded file(I got it from Microsoft's SQL Server home page)...and pls what is the WMI configuration on my machine?
Im using a Toshiba Satellite Pro Laptop, WIn XP with SP2.
I found the databases are performance is very poor and I was told to repair the database after running consistency checker.
I presume to repair the database, it needs to be started in single user mode.
We got many databases in the dataserver being used on 24/7 basis. Could any please suggest any efficient method/way of repairing database objects(table) minimising the downtime.
Also please tell me how to start individual database in singe used mode.
My install of SQL keeps failing at the System Configuration Check stage, I currently have XP Home Edition installed on my PC, do I need to have XP Professional installed instead due to the fact that IIS can only be installed with XP Pro???
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?
Hi, We have MSDN subscription and got VS2005 and SQLServer2005. Our developer develops applications bey using them. One of the application that he has runs periodically and export data from SQLServer2005 to xml files in development machine. We are wondering if we need to buy SQLServer 2005 license for this process. Thanks for your help.
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
Today many applications (SAP, SIEBEL, MANUGISTICS, PEOPLESOFT, and soon) does not have a client direct access to connect to the database.They use an Application Server that has only one connection to thedatabase and the users get connected to this application server.THE QUESTION: How to control SQL Server User License in this new model,automatically?You cannot enable SQL Server Audit because users are not connecteddirectly to the database.You cannot use Identity Management applications because they do notwork on NOT Enterprise Business software.How to do that if you have hundred of applications and database?Regards,Marcio
We have a .NET Remoting application whose "server instance" connects to SQL Server Express and send data via remoting to its client application. There is no need for other direct access to SQL Server except for the "server instance". Now my software vender advices us to upgrade to SQL Server WorkGroup edition and now we are facing the question which license to buy. Could you advice us?
Do I need a license to use the SQL Server Express in a production environment ?? I thought I needed an existing SQL Server license such as SQL 7 ?? Please let me know. :)
I'm setting up SQL Server 2005 Replication. I have purchase a processor license for SQL Server 2005. Do I need a Windows CAL for each device that will be accessing the replication via IIS?
I'm a .net developer creating applications that depends on SQL Server as a back end database engine.
I read about the features and pricing options of the different SQL Server 2005 editions here, I also read the SQL Server 2005 express EULA and knew that it's now alright to use it in commercial applications.
I use the SQL Server express engine only for the purpose of development and testing, is this use is lawful?
And if the answer is yes, what's the need for the "Developer Edition" mentioned in the page referenced above?
We have installed the SQL Server 2005 Enterprise trail version for 180 days. As it specifies in the documentation that it exprires after 180 days and in the mean time we have actually made a purchase of the License. Now...do we need to uninstall the trail verision and reset/restart everything again? Please advise.
I would like to setup about 20 websites (each with database search engines) and would like to use SQL Server 2005. This setup will be run by myself (i.e. single user)
I'm a little confused about which license I need. Do I go for the $23k full version or free license (Express) or something in between??
Could someone please advise. Would be happy to submit further details if required
How do we determine on a SQL 2005 server what license type was selected during the install? Where is the informationkept and how it is tracked by SQL Server 2005.
I have a SQL server installed in per server license mode... I am getting some error saying
"THE MAXIMUM SIMULTANEIOUS USER COUNT OF 1 LICENSE FOR THIS STANDARD EDITION SERVER HAS BEEN EXCEEDED. ADDITIONAL LICENSE SHOULD BE OBTAINED AND INSTALLED OR YOU SHOULD UPGRADE TO A FULL VERSION""
can someone tell me how to go from per server to per seat....
I am looking for the SQL Server 2000 Licensing Setup Utility Programand cannot find it. Everything I read says, goto ControlPanel->Administrative Tools->SQL Server License Utility. When I gothere, I do not see... Any help would be Greatly appreciated!Setup:Win 2000 ServerSQL Server 2000 Standard Edition Svc Pk 3.Thanks.
I have one cluster (two machines) of sql server 2005 active/passive called "ClustA" with one Ent. server edition license and another separate server called "STDA" as warm standby server for "ClustA".
I'm trying to open an SDF file. After many searches on the net, it appears that there are two ways to do this:
Open the file in VS 2005 Open the file in SQL Server Management StudioI don't have, and don't plan to purchase, a license to full SQL Server 2005. I do have Visual Studio 2005 Pro. When I open an SDF file in Visual Studio, I get the following (oh so informative) error:
The operation could not be completed. Unspecified error
Since I don't have full SQL server, I downloaded SQL Server Management Studio Express. There's one major problem: the Server type combo box is disabled in the "Connect to Server" dialog. Try as I might, I can find no mention anywhere as to why this is the case. I'm guessing that functionality isn't supported in the Express version of the tool, but as far as I can tell, nobody thinks it might perhaps be reasonable to document why this combo box is disabled. It certainly doesn't show up in the document that shows up when I click the help button on this dialog.
Could somebody at Microsoft please tell me if it is even possible to edit these files without buying a full SQL Server license? I'm trying to use SQL Server Compact Edition to replace legacy code that uses an MDB file (via ADO) for a desktop application. From everything I have read, this is the officially recommended thing to do. But if I now have to buy a full SQL Server lincense to accomplish what used to be a simple double click on an MDB file, then there's something seriously wrong.
I need to find all information about distributing SQL Server XE and applications using it . Is it legal ?? should it be used just for educational use?!!! could it be used to develop a commercial software !! what limitations are controlling this ??
I'm trying to find the SQL Server License Number used to install the software on the server. Does the installation program stores the information on the Registry or not? Looking through registry I found the ProductCode but I'm not sure if that is the valid License Number ... It does looks more like the unistall code ...
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 ?
The wrong Cd set was used to install Sql Server 2005 enterprise edition. I need to ensure the license for Sql server is the license from the other CD. is there a way to switch the license without un-installing SQL Server?
Hello, This is chirag patel. we are going to SSRS with our asp.net application to generate reports and charts. i having query about license of SSRC.
Is it completely free with SQL Server ? i mean if my web application will have SQL server 2005 as Database on production server , then do we need to purchase anything else to use SSRC ??
can anyone please let me know brief detail about license of SSRC if we want to use SSRC with web based application ??
Hi, 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.
I need to install Microsoft SQL Server 2005 Standard Edition 64-bit running on Windows Server 2003 R2 Standard Edition 64-bit. Instead of installing it on every single machine I thought of installing it on one of them, updating it with all the necessary updates, creating a ghost image of the updated system and database and copying the image on all the other machines. After doing it I however need to update both the system and SQL Server license keys. And there comes my question whether one can change the SQL Server license key after the installation??
