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
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 have a table where each unique entry can have up to 12 'modes', each mode with a start and stop date. A mode is a certain type of characteristic attributed to an entry.
There are 60 different modes and a given mode number can appear in any of the 12 mode fields. I created a very simplistic example table below.
Criteria:
I need to find all entries that have any of the modes = 1
AND for any of the other mode fields = 2 or 3, all modes = 2 or 3 must have a mode_enddate that is NOT NULL.
example:
select * from #temp_work
where (mode1 = 1 or mode2 =1 or mode3 = 1 ...)
And if any of the other mode1-12 fields = 2 or 3 then all mode 2 or 3 mode_enddate must be NOT NULL. I have tried a few different ways to try and get this data, but none of them have been very good.
Create temporary table
create table #temp_work (
id int NULL,
mode1 varchar(20) NULL,
mode_startdate_1 date NULL,
mode_enddate_1 date NULL,
[Code ....
From this limited example, the only valid entry should be ID 1 as the mode = 3 has a NOT NULL mode_enddate.
ID's 2 and 3 both have mode_enddate_X that are NULL, so should not be included.
I have a question, I keep getting the warning where the lookup found duplicate reference key values when caching reference data. It also says to switch over to partial or no cache mode. I switched to partial and and it took way longer to run my package. I have around 200,000 records right now but this table will continue to grow. I guess my question is which mode should I be using? I have another table that will have millions of records in it.
thanks,
I need to display the recovery mode of ALL databases on a server into a table. (Just like the sp_helpdb prcedure extended with the recoverymodel of each Database).
Can anyone give me a hint on this or provide me with a little tsql code snipplet to realize this?
Thanks alot in advance
Hi, all experts here,
Thank you very much for your kind attention.
I am having a question on the SSAS2005 OLAP Cubes storage modes. We know SSAS2005 supports 3 different storage modes: ROLAP, MOLAP, HOLAP.
Do all these three storage modes of cubes store data in another physica analysis services databases which are inrelative from their data warehouse (in case they are built on top of the data warehouse)? (so it does not matter at all even we remove the data warehouse?)
Thank you very much in advance for your help and I am looking forward to hearing from you shortly.
With best regards,
Yours sincerely,
Hi, all experts here,
Thank you very much for your kind attention.
I am having a question on ROLAP and MOLAP storage modes. In ROLAP mode, we store all data in source relational databases and though then we can gain near real-time data for the queries. But with MOLAP and Proactive caching, we can solve this problem by setting update notifications to the MOLAP cubes. Also, with HOLAP, we can combine ROLAP and MOLAP (store leaf data in source relational database, while aggregations in MOLAP format), thus we can actually get the near real-time data for the queries as well once there is any changes to the underlying source relational database.
I am just a bit confused about the distinct benefts we can differenciate between these aspects regarding MOLAP with proactive caching and HOLAP. (not convinced about the reason to use ROLAP storage mode).
I hope my question is clear for your help and thanks a lot in advance for your advices and help for that and I am looking forward to hearing from you shortly.
With best regards,
Yours sincerely,
Hi everyone,
I wonder that SQL Server 2000 support the following lokc modes by default or not.
Shared (S)
Update (U)
Exclusive (X)
Query that show me a Products Tables and its models, 1 product could have 2 or more models
Example Table Products
id Name
1 Product 1
2 Product 2
3 Product 3
Example Table Models
idmodel idproduct model
1 1 Model 1
2 1 Model 2
3 1 Model 3
4 2 Model 1
5 2 Model 2
6 3 Model 1
And I want to show:
Product Model
Product 1 Model 1
Model 2
Model 3
Product 2 Model 1
Model 2
Product 3 Model 1
How can I query to show that?
Is there any way to change the AES mode in SQL server, to obtain the same ciphertext each time for the same plaintext?
View 3 Replies View RelatedTo 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.
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 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-
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
network.
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?
Thanks,
Fábio
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.
Does anybody know if sqlserverce's license is freeware or shareware??
thanks a lot!
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.
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 3 Replies View Related