Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







MSDE Licensing


The MSDE licence says that it can be used for up to 5 concurrent users. My app is an ASP.NET app, so won't I just be using one user - the ASP.NET account? I'm wondering whether we can get away with just buying a new server and sticking MSDE on it rather than shelling out for another £5000 SQL server licence...


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Licensing Of MSDE
I expected to find loads of posts regarding licensing but surprising not.

I have SQL Server Developer Edition, which I believe gives me the right to build and distribute applications which use MSDE (http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp).

Is there any requirement for the end user to purchase any microsoft product or license?

View Replies !   View Related
MSDE Text Datatype - Unable To Store More Than 900 Characters. (msde + Visual Studio 2003)
Hello,

I'm not sure if it's the setup I did wrong, but I can't seem to get my
text datatype in my database to store more than 900 characters. 
I'm trying to setup a news database for my website, which will populate
the information into a datagrid.  To test, I manually added a news
item in the database through the visual studio 2003 gui.  I
immediately noticed a problem as the I was getting an error after a
long news item saying:

"The value you entered is not consistent with the data type or length of the column, or over grid buffer limit."

I couldn't find anthing to set the buffer limit and the datatype is
"text" filled with simple text in the column.  As a further test,
I
simply entered 12334567890123... up to 900 characters and still
recevied the error.

I would appreciate someone leading me in the right direction on this one.

Thanks a lot.

View Replies !   View Related
How Do I Change The Name Of A Computer Running MSDE With Out Reinstalling MSDE
I am trying to change the computer name of a machine running MSDE but I get an error when SQL Server starts. With regular SQL when I change the name of a computer I re-run setup and setup fixes this problem. MSDE can only be installed from unattended mode so I canít rerun setup and fix the problem.

My question is "How do I change the name of a computer running MSDE with out reinstalling MSDE"

View Replies !   View Related
Can MSDE 2005 Coexist With MSDE 2003?
    We are using MSDE 2003 (I believe) and wish to install MSDE 2005 to start testing it.If I install MSDE 2005, will it upgrade 2003 or just install itself and let me continue to use MSDE 2003?

View Replies !   View Related
MSDE: Renaming Machine Without Reinstall Of MSDE
We currently have the problem, that all our machines are produced with the
same name and afterwards the name is changed. So we have the problem that
the checksum key for the MSDE isn't valid anymore. As MSDE can only be installed
from unattended mode so I canít rerun setup and fix the problem. Does anyone
know a solution for this problem ?? A program recalculating the cheksum ??

regards,

Manfred

View Replies !   View Related
Licensing
Is there a way to get Licensing information(product key) off an installed version of SQL Server 2005?  Most Microsoft Software has the product key in the about dialog box, but SQL Server doesn't have this anywhere.
Thanks,
 
 

View Replies !   View Related
Licensing
I know that I can have up to 2 GB RAM for the Standard Edition of SQLServer, but if I had two instances, can I have 2 GB per instance, say for 2instances which would equal 4 GB, or is it 2 GB for that installation of SQLServer and all of it's instances?Thanks.

View Replies !   View Related
SQL Licensing
Hello all,
Can anyone describe in plain English what the SQL licensing requirement and the NT requirement for licensing is when taking into account web access?
More specifically I have an application running on NT with IIS and SQL. If I need to support say 500 user connections in SQL, what are my NT and SQL licensing requirements?

Thanks in advance,
Ed Molinari

View Replies !   View Related
Licensing
Could any of you explain to me how the licensing works? I was told that each concurrent query to the database (doesn't matter if it is the same service that begins the query) requires a license, is this true?

If possible could you please send an e-mail to me if you reply to this article.

Kevin Neal, CNA
Technical Support Specialist
SafeLink Internet Services
kevin@safelink.net
http://www.safelink.net

View Replies !   View Related
SQL Licensing
Help me please!!!

I'm going crazy trying to find out the license deal for SQL Server 2000 Developer Edition. It seems that here (in the UK) the Developer edition exists and you can buy it but, Micrisoft (UK) and various resellers etc don't know the licensing deal!!!

Now, i've read a snippet somewhere about the developer edition that for a fixed price of around $499 you get a server license limited to 8 connections and you don't have to buy any CALs! However my reseller thinks that you still have to buy CALs up to maximum of 8? Well, i don't think so!!

Has anyone got this edition and know the deal?

Many thanks...

View Replies !   View Related
SQL Licensing DMO
Hi,
is there any method using SQLDMO to reference the current license activity on SQL 7, using say VB?

Thanks

Lenin

View Replies !   View Related
Licensing
We are about to deploy an application that uses SQL Server 7.0. Enterprise edition running on a dual processor machine. We expect a maximum concurrent usage of about 500 users, normally about 150/200. Could anyone advise me what the cheapest license arrangement would be, I've had conflicting views from Microsoft and two third party software suppliers? We intend to use the machine in future for other applications but as yet have very little idea of usage.
Joe

View Replies !   View Related
Licensing
greetings,

I have several servers running sql enterprise. how do I tell version, licensing model, and client licensing(cal) installed on the server.

Thanks in advance.

View Replies !   View Related
Licensing
Can any one please clear my confusion. when we install 2000 it always give option ofr licence (processor or per seat) but i installed 2005 couple of times but can' see any option in whole installation about type of licenscing. any one have any idea where and how to choose type of licence for SQL Server 2005.

Thanks

View Replies !   View Related
Licensing
Hi SQL TEAM

I'm in a bit of a situation.

Please bare with me as i explain.

We would like to host a web server

Web Server = Windows 2003 Server Standard Edition running IIS

All the website hosted on this server will be available to the public.

Question 1.How do i licenses Windows 2003 Server Standard Edition?
Question 2.Do i need a CAL for every single person browsing to any of the websites hosted on the above server.
As far as i know you can not get a PER CPU license for Windows 2003 Server, is this true.
Question 3. Where would a CAL be required.
Question 4. How about remote desktop to the above server? that requires a CAL.

Thanks in advance for any replies

View Replies !   View Related
Licensing
Hi,



I need to know if I have to buy an extra license for my subscriber server in the following two scenarios. I have checked similar threads in the forum but could not find an exact answer.



Scenario 1 :


Server A : Publisher - SQL Server 2005 Standard Edition.

Server B : Subscriber - SQL Server 2005 Standard Edition

Server B has ONLY the replica of one or more DBs of Server A

I have already purchased SQL Server processor license for Server A

Replication Type : Transaction Replication


Scenario†2 :


Server A : Publisher - SQL Server 2005 Standard Edition.

Server B : Subscriber - SQL Server 2005 Standard Edition

Server B has the replica of one or more DBs of Server A plus one or more operational (mostly reporting) DBs

I have already purchased SQL Server processor license for Server A

Replication Type : Transaction Replication



Thanks

Hamed



View Replies !   View Related
Licensing
I have a multiple processor server. Can I intall a single processor sql server 2005 on that machine and limit it to one processor only?

View Replies !   View Related
Regarding MS SQL Licensing


Hi all,

I could not find a forum for asking licensing related questions for MS SQL. Hope this is the right one.

Our application is basically a chat server which needs MS SQL. At any time many users login to Chat Server from different machines. Chat server communicates with Database for each of the user logged in.

In this case, what kind of licensing do we need ? Will only 1 CAL† license suffice ?
Or each User who is loggin in to our system needs a seperate license ?

Thanks

Sumukh

View Replies !   View Related
SQL Licensing
The company I work for has the latest MSDN subscription which has the SQL 2005 Standard edtion, as well as others, and I am trying to figure out what the license is for the SQL. I.E. Processor or what. Any help would be greatly appreciated.

Thanks,

LPATTERSON

View Replies !   View Related
Licensing
Obviously I'm missing something here (Like a brain??), but from the documentation I'm somewhat confused as to the licensing aspect of the everywhere edition.

Scenario: I have a client (small business for example) and I'm updeating their MS Access application, currently having the front and back ends seperate. May I substitute SQL Everywhere edition in place of the data back-end without further licensing, or will a CAL be required?

Thanks,

View Replies !   View Related
Licensing


Hello
We have a sql server 2005 Enterprise Edition installed on one of our servers where we gor†processor license.
The question is can i install a second instance of Sql Server 2000 with out buying any extra licenses or should we buy licenses for this second instance seperately.

Thanks in Advance...


View Replies !   View Related
SQL Express Licensing
Hi...First, I am not sure whether I put this post correctly or not. My issue is I developed one simple web application with using ASP.Net 2.0, VB 2005 and SQL express. I wonder that if i install it to my customer's pc, do they need to pay for SQL express's licensing since it is free now.. Thanks in advance.Regards, Anson

View Replies !   View Related
Licensing Question
Quick licensing question...If I am developing an asp.net application using sql server 2005...what is the licensing situation?  Do I need just the one CAL for the server with IIS that is hosting the application?  or is it one CAL per database connection?  One CAL for every person using my application?  I'm not sure and I want to make sure that I comply with the licensing for my application.  Thanks in advance!Phil

View Replies !   View Related
SQL Client && Licensing
Greetings All, does anyone know if there are licencing considerationsinvolved if I just want to install MSSQL clients and tools? I need toconnect to a MSSQL database server out on the network and I want toused Enterprise Manager, however my boss says that you may need to payfor licensing? Can anyone shed any light on this?Regards, TFD.

View Replies !   View Related
SQL Server Licensing
How does one find out what type of licensing is employed on a SQLServer Box. i.e is it Per Process or Per CAL?Martyn

View Replies !   View Related
Licensing Question
We are about to build web application that connects to a MS SQLdatabase. We are planning on building the application to connect tothe database through one user account, say "webuser" that allvisitors to the site will use. For example let's say the site is anonline store (for simplicity) and each time a person clicks on aproduct category items are loaded from the database and displayed. Weare planning on using the "webuser" mssql account to achieve thisdata retrieval. What kind of mssql license do I need to purchase?Thanks in advance.

View Replies !   View Related
Processor Licensing
In the processor licensing mode a license is required for each physicalor virtual processor like explained inhttp://www.microsoft.com/sql/howtobuy/default.mspx->But what about dual core processor?->And what about clustering? (if a user install 2 server in cluster mode)tnx

View Replies !   View Related
Licensing Sql Server.
just curious as to quite what This means:(taken from the Server License Eula athttp://www.microsoft.com/sql/howtobuy/servercal.asp)14 LIMITED WARRANTY.Microsoft warrants that the Product will perform substantially inaccordance with the accompanying materials for a period of ninety daysfrom the date of receipt.If an implied warranty or condition is created by yourstate/jurisdiction and federal or state/provincial law prohibitsdisclaimer of it, you also have animplied warranty or condition, BUT ONLY AS TO DEFECTS DISCOVEREDDURING THE PERIOD OF THIS LIMITED WARRANTY (NINETY DAYS). AS TO ANYDEFECTS DISCOVERED AFTER THE NINETY (90)-DAY PERIOD, THERE IS NOWARRANTY OR CONDITION OF ANY KIND. Some states/jurisdictions do notallow limitations on how long an implied warranty or condition lasts,so the above limitation may not apply to you.Any supplements or updates to the Product, including, withoutlimitation, any (if any) service packs or hot fixes provided to youafter theexpiration of the ninety-day Limited Warranty period are not coveredby any warranty or condition, express, implied, or statutory.LIMITATION ON REMEDIES; NO CONSEQUENTIAL OR OTHER DAMAGES. Yourexclusive remedy for any breach of this Limited Warranty is as setforth below. Except for any refund elected by Microsoft, YOU ARE NOTENTITLED TO ANY DAMAGES, INCLUDING BUT NOT LIMITED TO CONSEQUENTIALDAMAGES, if the Product does not meet Microsoft's Limited Warranty,and, to the maximum extent allowed by applicable law, even if anyremedy fails ofits essential purpose. The terms of Section 16 below ("Exclusion ofIncidental, Consequential, and Certain Other Damages") are alsoincorporated into this Limited Warranty. Some states/jurisdictions donot allow the exclusion or limitation of incidental or consequentialdamages, so the above limitation or exclusion may not apply to you.This Limited Warranty gives you specific legal rights. You may haveothers which vary from state/jurisdiction to state/jurisdiction. YOUREXCLUSIVE REMEDY. Microsoft's and its suppliers' entire liability andyour exclusive remedy shall be, at Microsoft's option from time totime exercised subject to applicable law, (a) return of the price paid(ifany) for the Product, or (b) repair or replacement of the Product,that does not meet this Limited Warranty and that is returned toMicrosoft with a copy of your receipt. You will receive the remedyelected by Microsoft without charge, except that you are responsibleforany expenses you may incur (e.g. cost of shipping the Product toMicrosoft). This Limited Warranty is void if failure of the Producthasresulted from accident, abuse, misapplication, abnormal use, or avirus. Any replacement Product will be warranted for the remainder ofthe original warranty period or thirty (30) days, whichever is longer.Outside the United States or Canada, neither these remedies nor anyproduct support services offered by Microsoft are available withoutproof of purchase from an authorized international source. To exerciseyour remedy, contact: Microsoft, Attn. Microsoft Sales InformationCenter/One Microsoft Way/Redmond, WA 98052-6399, or theMicrosoft subsidiary serving your country.

View Replies !   View Related
Question About Licensing
We are considering setting up an Active/Passive SQL Cluster for our internal web application. I have a few question about MS licensing that I hope someone can help answer. We are thinking of going with SQL 2000 Enterprise CAL rather than per processor.

From what I've read it sounds like you only need one license to run an Active/Passive cluster. Can anyone that has done this before confirm this.

Also can someone let me know if the CAL license will work for a dual processor unit?

Thanks

View Replies !   View Related
Licensing Question
I have three heavy duty servers with 32-bit dual P4 CPUs, 4GB RAM, SCSI boot drive, fibrechannel RAID (40+ spindle).

I want to purchase SQL Server licenses for these machines. SQL Server 2000 standard edition seems perfect except it only supports 2GB of RAM and from my understanding, to utiliize the /3GB switch in boot.ini, you need to use Enterprise Edition. You use AWE if you have more than 4GB (which we currently don't).

Is there any way to get standard edition to use a full 3GB?
Anyone know what kind of upgrade path will be provided from SQL Server 2000 to SQL Server 2005 licenses?
Will SQL Server 2005 Standard Edition utilize 3-4GB of RAM?

View Replies !   View Related
SQL Mail Licensing
do I require a license to install an outlook client on the DB server if I want to use sql mail, or is it included with sql server?

also is there any benefit to using outlook 2000 over 2003?

thanks

View Replies !   View Related
SQL Licensing Inquiries
Hi There :-)

Please enlighten me on the following issues :

Maximum concurrent user connection value at the connection tab on a sql server property window. Thus, this value constitute the total cals of the server (user + device)? If not, what does this value stands for?
If I have 15 Device Cals and 5 User CALS, how could I setup my SQL Server to recognize these licenses?
Does the free 5 User CALS on SQL 2000 Standard Edition convertible to Device CAL?


Thank You :-)

View Replies !   View Related
SQL Server Licensing
Hi,

My company is embarking on a data warehousing project. We are going to purchase a Windows 2003 server. It would be a dual processor. The specs are not certain yet so cannot give more details on that.

1. The data in the warehouse would be close to 150 GB.
2. There will be maximum of 10 users needs a SQL Server license.
3. Do not need analysis services.

What edition do I go with -Enterprise OR Standara? I want the least priced edition. I looked up the various links on Books Online but I am still not able to decide.

Say I need only 2 GB of RAM. Then here are my questions.

1. Since we are going with a dual-processor, do I need to purchase processor license for each of the two? Why can't I have one license on one processor only? What are the implications of this?

2. The 10 users that I am talking about will be remotely connecting to this Windows 2003 server and accessing the databae.

3. What exactly is Failover clustering? Do I really need it for my warehousing project?

4. Please help me pick the correct license. Here is the link -

http://www.microsoft.com/sql/howtobuy/default.asp

Thanks,

Vivek

View Replies !   View Related
SQL Server Licensing
Is there a way to find the SQL Server licensing information after the software is installed? I mean is there a way to say that it was licensed per cpu or per cal?

View Replies !   View Related
SQL Server Licensing
I have a Windows 2000 Operating System with 4 processor, out of which I'm planning to use only one Processor for the SQL Server and leave the rest of the three processor for the OS.
My question is that do I need to buy the license for all the 4 processors or I can do with the only 1 that will be used for running the SQL?

View Replies !   View Related
Reporting Licensing
We recently purchased Stockamp's Clinic Ontrac system. The system has a built in crystal reports viewer module with capability to add our own reports... The backend of the product is SQL Server. To create a report you have to potentially create a stored procedure - if parameter is needed - and a crystal report. Stockamp is requesting that we have written approval of these reports as well as any ad-hoc reports and queries that we run before we run them in the production environment.

I'm used to large vendors (those that understand a database is only as good as the data you get out of it) and I've never seen a license agreement like this before. Is this common?

View Replies !   View Related
Licensing Mode
Hi all,

This may seem like a stupid question but i have a server licensed per processor (4 processors) but would like to have it licensed per user. The licensing setup in control panel only shows options for per processor or per devide. How do i get to license per user without reinstalling?

Thanks in advance.

View Replies !   View Related
Licensing Mode
I know that PerSeat is each individual computer that accesses SQL Server
and PerServer is the number of concurrent connections to the server.
Is Client Access Licenses the same as PerSeat?

View Replies !   View Related
Licensing Options
Is it necessary to reinstall SqlSvr 6.5 in order to chance
from 'per server' to 'per seat' licensing ?

View Replies !   View Related
SQL Server Licensing
If SQL Server 2000 is loaded onto a 8 processor machine, can I legitimately
load Standard Edition, which will only use 4 of the 8 processors, or as
some interpretations of the license suggest, must I purchase Enterprise
Edition (i.e. you are not permitted to load SQL Server on a machine which
has more processors than the Product is capable of using) ?.

I know the "reasonable" answer, but what is the legal position ?

Ian

View Replies !   View Related
Licensing MOde
Can the licencing mode of SQL Server 2000 be changed after it is installed or do we need to reinstall.

Thanks

View Replies !   View Related
Licensing Mode Changes
At installation I erred in specifying per seat licensing when the server I'm working on is actually a per processor license. Can I change this or must I reinstall SQL 2K?

View Replies !   View Related
Licensing Mode Changes
At installation I erred in specifying per seat licensing when the server I'm working on is actually a per processor license. Can I change this or must I reinstall SQL 2K?

View Replies !   View Related
SMS 2 & SQL 7.0 Licensing Question
I have an SMS 2.0 site set up on one server and SQL 7.0 installed on another server. I have 288 users and have 288 SMS client license and one SMS server license. My question is do I need to have client access licenses for my 288 users for SQL or is the SQL 7.0 licenses included in the SMS package as long as I only use SQL for SMS?

Also does anyone know if SQL 7.0 ask for the number of license that I have during the installation process?

I would appreciate any input anyone may have on this.

Thanks,
Myron

View Replies !   View Related
Connection VS Licensing ???
Hi there,

I've got 5 user licensing with MS SQL Server 7. I would like to know does the licensing refer to the connection with SQL Server. I've developed an application using VB which have multiple connection (more then 5) with SQL Server. Will there be any problem?

View Replies !   View Related
DTS Licensing Problem
I have a laptop that currently runs Windows 98. I have loaded SQL Server 7.0 Desktop Edition onto this computer. I am getting a DTS licensing error when I attempt to transform data using DTS between remote SQL Servers. The only workaround I have found is to create a DTS package and perform the transformations using transfer manager. This works for me now, but I am wondering how I might go about solving this license problem. It is my belief that a demo version of SQL server 7.0 might have existed on this machine long before I loaded my installation. If this is the case, how can I straighten out the registry to fix my licensing problem?

View Replies !   View Related
SQL Server 7 Licensing
Just a quick question with regard to licensing:

I am running SQL 7, SP2 on NT 4. When you purchase an Internet Connector license, does this allow you to increase the no. of default CALs within a system. At present, both my SQL Server service a/c and builtin admin a/c are both requesting a Client to run under in NT's license manager. Am I required to purchase seperate CALs for these a/cs.

View Replies !   View Related
DTS Licensing Error - Please Help
Hello all,
I did explore the archives on this one, but could'nt find anything that closely matched my issue. I'm running SQL 7.0 Server (Desktop version) on my
laptop and when I try to use DTS to transfer data from a SQL Server 7.0 running on NT Server 4.0 in the SAME NT domain. The error I get says that the
licensing arrangement I have does not permit me to use DTS.

Please help!

Regards
Uday

View Replies !   View Related
SQL2000 And Licensing
In a replication environment:

Does SQL 2000 standard edition support replication if it would be configured as a subscriber.
Is SQL 2000 Enterprise Edition required for a Publisher and Distributor or can you get away with standard edition.
In a web site environment how many CALs are needed when users access the database via webservers and middleware.

Thanks

View Replies !   View Related
MS SQL Licensing Question
Hello All,

We're looking into getting SQL Server 2005 Standard for our eCommerce Platform. CDW said that we needed to purchase the SQL Processor Pricing ($5,999) as opposed to SQl Server Plus CAL ($1,849 with 5 CALs). We're under the impression that only 5 people (customers) can connect to the database at a time. I thought that only one CAL was needed which the store used to access the database regardless of the number of connections using the database (or customers perusing the site). Could someone shed some light on this? The last thing we want to go is drop $6000 on something that should have cost $1800. THANKS!

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved