SQL Server Express Licensing

Feb 8, 2006

Hi,

I'm a little confused about the licensing of SQL Server 2005 Express Edition. I'd like to know whether:

Suppose I build a VB app which requires a centralised database, and I bundle SQL Server Express as the app's db engine, is this allowed in the licensing?

Suppose that the previous scenario is allowed, can my client opt to have me use the bundled SQL server express to be installed in my machine to host the database for him?

I apologise if this is not the right place to post this question. If that is the case, can someone point me out in the right direction? I have tried calling MS support lines, but they don't seem to know the answer as well.

Thanks in advanced.

View 1 Replies

Licensing For SQL Express Edition AND Windows 2003 Server

Jul 17, 2006

I have a Sql Server Express Edition instaled in a Windows 2003 Server. I will use SQL Authentication. Need I Cal's for Windows 2003 server to each user that will access the SQL Express ? If yes, why ?

View 5 Replies View Related

SQL Express Licensing

Oct 2, 2006

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 1 Replies View Related

SQLserver Express Licensing

Sep 26, 2007

Can anyone tell me if there is a $ price for a license if SQLserver Express is used on a website? I want to replace Mysql.
Thanks
Rich

View 1 Replies View Related

SQL Express Edition Licensing Issue

Apr 20, 2006

Hello Guys,

Just would like to check with you guys if SQL Express Edition is allowed to be used for web hosting company to server his client?

View 3 Replies View Related

Licensing Sql Express For Web Hosting Providers

Oct 24, 2006

For the second time in as many months I've been asked the question. What is the license requirement for me, the service provider, for offering my clients the ability to use SQL Server Express?

I understand the license to say that as long as I'm registered (no cost) there is no further licensing needed in order to offer this to my clients.

Could someone clarify this for me? If I'm incorrect I'd appreciate the right answer.

Thank you!

View 4 Replies View Related

Express Edition, Reporting Services, And Licensing

Mar 15, 2007

Hello,

From reading the licensing considerations page [1], my understanding is that if my environment is 2 servers - an IIS Server and a separate SQL Server Std - I will need a 2nd license of SQL Server to run Reporting Services on my IIS Server? Is this correct? If so, would a license of SQL Server Express Edition w/Advanced Services satisfy the second license requirement, or would I need a license to match the database server?

Essentially, what is the recommended guidance for Reporting Services and Web Applications? It's a known best practice that, for performance, run SQL Server on a dedicated machine separate from IIS. Is it recommended that the database server also serve the reports?

[1] http://www.microsoft.com/sql/howtobuy/howtolicensers.mspx

Thanks,

View 8 Replies View Related

SQL Server Licensing

Apr 10, 2002

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 1 Replies View Related

SQL Server Licensing

Jan 8, 2004

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 12 Replies View Related

SQL Server Licensing

Jan 9, 2004

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 1 Replies View Related

SQL Server Licensing

Jan 15, 2004

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 1 Replies View Related

SQL Server Licensing

Mar 27, 2007

Env.: SQL 2005 on Win2003

I am a DBA and I have a SQL Server 2005 license for each server. To manage the servers, I want to install SQL Server 2005 on my local desktop. Do I need a license for it as well?

Thanks,

Canada DBA

View 3 Replies View Related

SQL Server Licensing

Jul 23, 2005

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 6 Replies View Related

SQL Server Licensing

Feb 16, 2007

I have a three server network. One SQL Server, One Web Server, and a backup.

The web server is ASP.NET, and uses the database. I do not track the number of users hitting the web server.

What type of sql server license is needed? Processor? Device CAL? User CAL? I have read all the white papers and licensing info and can't find an aswer to this question.

Please help

View 5 Replies View Related

Licensing For A Web Server

Jun 20, 2006

What kind of license do I need to run a single web site on a web server that needs SQL server to operate? it's a public site that runs DotNetNuke but it's the only site on that box.

View 5 Replies View Related

SQL Server Licensing

Mar 27, 2007

View 1 Replies View Related

SQL Server Developer Ed Licensing

May 6, 2004

I am a developer in need of setting up a SQL Server test environment for many users.

Can the Dev Edition be used as a back-end to handle this type of testing? Are my limited to one connection from my development machine?

As you can tell, <sarcastic tone>i am having a real fun time with this one</sarcastic tone>. Licensing terms are an area that i tried but sometimes cann't stay out of.

I appreciate your input.

View 1 Replies View Related

SQL Licensing For State Server

Mar 10, 2006

Hello all,
I have a question concerning the ridiculous quagmire of SQL Server licensing…
How is SQL Server licensed when used to store session state information? Is MS claiming that this is an end user use of SQL Server functionality? Or, can we be realistic and say that I need a server license plus a device license for each web server?

Personally, I like everything about SQL Server except the licensing. Management at my company has already said that we’ll most likely be moving to either Firebird or Postgres after they found out how much it would cost to move from SQL 2k to SQL 2005. If MS wants us to buy processor licenses for SQL state servers, I guarantee we’ll be doing something else there as well. I wonder if Microsoft has any clue how much business they’re losing. Not just in SQL Server, but in their OS business as well.

View 1 Replies View Related

SQL Server Licensing (what Version Should I Use?)

May 2, 2006

Hello,
I am very confused about the licensing of SQL Server 2000 and 2005 (various editions), and any light you can shed will be greatly appreciated. I am learning VS2005, and need to build a website.
1. I know what a Client Access License (CAL) is.
2. I know what a processor license is.
My ASP.NET website might have 10 users, 100, or maybe 1,000 (I don't know at this point).They will have anonymous access to a main page from which they will have to log in, and from that point on be using SSL for anything they do.
I am getting conflicting information regarding licensing.
Questions:
1. Can SQL Server 2005 Express support what I need to do? (possibly many users)
2. Other than some of the fancy replication, analysis, etc that Express does not have, is there a good reason not to use Express Edtion?
3. Regarding SQL Server 2000 or 2005 (NOT Express): Does a single web application act as a single user thus the web application requires only one CAL. In other words: I am the only person who has direct access to the database. The ASP.NET web application will also have access to parts of the database. Will this scenario count as 2 "CALs"?

View 1 Replies View Related

Per Seat Vs Per Server Licensing

Oct 26, 2000

In order to use Replication, sql server installation must use per seat licensing. What if I have per server licensing, how can I change the licensing to per seat so I can use replication
Ahmed

View 3 Replies View Related

Sql Server Licensing For Internet

Apr 9, 2001

I am so confused and I am getting no help from the Microsoft, two months and only stammering
from their representatives. I need to set up a Sql Server database that will allow internet access.
This is not an e-commerce situation. At most there will
be 10 known users of this system accessing statistical data. I had priced this system to use Backoffice,
but as I now read this is not legal for internet use. It also appears that a processor license is required for
internet access (not entirely clear on this). Access and MSDE also don't appear to be legal for internet access.
The customer is on a shoe string budget. If I use stand-alone
components the budget only covers an one processor SQL Server 2000 license. I don't like the idea of setting up
a database system with only one processor. Is there another Sql Server based option I am not aware of?
Its looking like a linux/mysql option - Yikes!

View 1 Replies View Related

SQL Server Licensing Mode.

Jun 4, 2004

Is there any way I can see what is the existing license mode and no. of devices/processors allowed for the existing SQL Server setup

Thanks
Babu

View 3 Replies View Related

SQL Server Licensing Question

Jul 20, 2005

How can one identify the current licensing model on an existing(production) SQL Server?

View 8 Replies View Related

SQl Server 2proc Licensing

Feb 6, 2007

Sorry in advance for the potentially boneheaded question: I would like to purchase SQL Svr 2005 Std Edition in a 2 proc licensing config. All my retailer has is 1proc and doesn't have answers for 2proc... Can I buy a 1proc and upgrade thru MSFT? If not, how do I buy a 2proc copy...? Thanks! JohnWoo

View 3 Replies View Related

Verifying SQL Server Licensing

Aug 8, 2006

How do I tell what SQL licensing option (processor, device CALS or user CALS) was taken when the server was installed? I have taken over a SQL 2005 server and I would like to check how many CALS (if any) it is licensed for.

View 2 Replies View Related

SQL Server Licensing Information

Feb 22, 2008

I want to retrieve SQL server licensing information e.g. License type, Count, License Code etc.
Any help?

RK

View 4 Replies View Related

SQL Server 2005 Licensing

Mar 18, 2007

I have a SQL Server 2005 Standard per processor license (My server has a dual core processor). How many client machines can I install the SQL management studio so they can register the SQL Server and query data if need be?

Thanks

View 1 Replies View Related

Licensing Of SQL Server 2005

Dec 5, 2006

what would be the most cost efficient way of acquiring sql server 2005 licenses

for 10000 users that would access 1 web server which access the sql server 2005 .

Hope youcan help me at this one...

Thanks

View 1 Replies View Related

SQL Server Licensing For Businesses

Jul 17, 2007

Hi,

I couldn't decide where in the forums to ask this question.. So I hope there's someone here who can help or you could suggest where I might go.

I have a client with around 5 standard PCs in the office. They want an application to run the business and are trying to decide if SQL Server or Access is the best way to go. My suggestion has been SQL Server, considering the plans they have for the business and the software. But their main issue is the cost.

They don't currently have a Windows Server... Just a bunch of shared drives on win XP which suits them well. Can anyone suggest the database configuration they should be going for? Minimising cost is their main issue and they don't want to go through the trouble of setting up a full windows server.

Are there licensing and legal issues to install one of the workstations with SQL Server Express with a VB.Net application running on potentially 2 machines?

Thanks

View 4 Replies View Related

Licensing Information Of An SQL Server Installation

Sep 13, 2001

How do we findout licening Infromation of an SQL Server Installtion.

Is there any script or stored procedure to find this Information.
What is the difference between Per Server and Per seat Licensing ?

Thanks a lot for your Support.

Regards

Elias

View 1 Replies View Related

Licensing - Per Seat Change To Per Server

Jul 30, 2000

Is this change possible without re-installing SQL 7.0? if so, how?
The install was completed by a network guy who thought he knew enough about SQL and now I have to fix it, but all I know is that we use the per server mode in our company. Help Please!!!

View 5 Replies View Related

Finding The Licensing Mode For The Server?

May 8, 2000

Is there any way in which I can determine the licensing mode (per server/per seat and no. of licenses) for a particular server?

I have been working on this but no clues so far...

Thanks!
- Manoj

View 2 Replies View Related

Licensing Mode In SQL Server 2000

Jan 5, 2005

SQL 200 introduce changes to licensing. There are two licensing modes, Per Seat and Per Processor.

Is there a way to change the licensing mode from Per Seat to Per Processor for a current SQL Installation

View 1 Replies View Related