SQL Server 2005 Licensing Concern.

Mar 5, 2008

Hello,

Our company has developed several Access applications for our clients
and we wish to expand to use a database server. We wish to use Access
as the front end application and SQL Server 2005 as the back end
Databes Server. Making a Server-Client application database.

I'm very new to SQL Server so my concern is how the licensing works
for a developer like us. I am aware that we can purchase the Developer
edition for $49 USD. Our clients will then have to purchase a their
respective licensing option.

We do not have an issue with this, but i would like a better
understanding of how this works.

1) The developer edition (DE) is the same as the Enterprise edition.
Would our clients have to buy the Enterprise edition ($24,999) if we
develop the SQL server in the DE? Or can they purchase the Standard
or Workgroup edition if the workload allows it?

2) If the client already has the Enterprise Edition on the Server we
wish to use, will they have to buy the license again if we create the
Database? Can they import our Database to thier SQL Server, and our
application connects to thiers?

3) Is there other options that would require a cheaper option for our
clients?

4) With just the DE, can we develope applications and use the
appropriate edition for our clients whatever it is?

5) To test our products we thought of using the Trial version to
simulate a multi-user test environment? Since thats just a 180 day
trial, perhaps the Worgroup Edition or the Light weight Edition might
work. But these editions might not be compatible with our clients'
requirements. The DE doesn't seem to handle multi-user environments,
so we cant effectively test how the application will perform in the
"real world". Any advices here?

Our clients range from small bussiness to nation-wide to multi-
national companies.

Thanks,

- GL

View 14 Replies


ADVERTISEMENT

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

Licensing CALs Sql Server 2005

Mar 26, 2007

Hello

Is there a way to put my new User CAL's into an existing SQL Server 2005 ?

In SQL 2000 we got SQL Server 2000 Licensing Setup in Control Panel

Thanks

View 1 Replies View Related

SQL Server Mobile 2005 - Licensing

Jul 10, 2007

Hi,

Could someone pl explain how is SQL Server mobile 2005 licensed. Do we need to buy license for each device ? or CAL?

In my app, I need a database which is accessed by .net compact framework app. synchronization is also done by our own app, no direct communication from sql server mobile to sql server db. we have a server side .net app which talks to the sql server and a windows mobile app which talks to the sql mobile db, these two .net apps talk to each other like:

sql server mobile db <--->.net compact framework app <--->.net desktop app <-->sql server 2005

Needless to say, there would be multiple devices having the above setup. However only one desktop side app and database. In this scenario, how would licensing be calculated?

regards,
D2

View 1 Replies View Related

SQL Server 2005 Standard Edition Licensing

May 1, 2008

I'm getting some conflicting information , regarding sql 2005 Standard Edition licensing for multi instancing.

If you have multiple instances of SQL 2005 Standard Edition on one Server, do you need to pay a server license for every Instance or just the one Server license?

Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com

View 4 Replies View Related

What Licensing Is Needed To Mirror A SQL 2005 Server?

May 7, 2008



Hello,

I hope this is in the right forum, I'm new to MSDN. I'm also not an expert in SQL, so please bear with me as I was unable to find an answer by searching the archives.

We have a single SQL 2005 Standard installation with 30 user CALs on a Server2003R2 box. We have another Server 2003 box in a remote but connected location that we previously used for backup replication. What we'd like to do is use some of the replication features in SQL 2005 to replicate the data over every night to the other box, onto which we would install another copy of SQL 2005. This would not be a server accessed by clients, but simply a "live backup", that in the event of a catastrophic failure, could be manually set up to operate as a SQL server in place of the failed primary server. I don't need any kind of automatic "failover", just the ability to replicate the data over to the other system so I have two SQL Servers that synchronize from one to the other overnight.

I was told that I wouldn't need to buy the user CALs again, that the 30 user cals would translate over if the primary server fails and has to be replaced by the cloned server. But what do I buy for the SQL server itself? A boxed version is a bit pricy and comes with 5 CALs which apparently I wouldn't need. Then I noticed that on softwaremedia.com the open license version, which can be bought a la carte, lists a requirement of buying at least 5 cals or a processor license. What exactly do I need to do this, and how can I get it for the least amount of further spending?

Thanks!

View 3 Replies View Related

SQL Server Management Studio 2005 Licensing

Apr 27, 2006

I handle all licensing for our companies. I am trying to completely understand the licensing and want to insure if I approve the installation of Mgmt Studio 2005, that it is covered by SQL Developer licenses?

THANK YOU!

View 1 Replies View Related

Installation Of SQL Server 2005 Standard Edition With CAL Licensing

Jan 9, 2008



Hi Experts,
Can you tell me the procedure how to install SQL Server 2005 Standard Edition with CAL licensing?
This is very very urgent,
Your help would be appreciated..

View 1 Replies View Related

Developer Edition Licensing SQL Server 2000/2005

Nov 26, 2007

Hello,

I have two question with respect to the developer edition licensing in SQL Server 2000 and 2005:

Question 1
I wanted to install a developer edition on a Development/Test Server. The server needs to be accessed by our development and Testing team of a team of 20 from their workstations. Is that possible?

Question 2
And if so what are the different licensing options that I can choose from considering that I don't want to install a developer edition of sql server on each workstation? The developer edition will be installed on the Dev/Test Server and the workstations will connect to the server using NT or Standard authentication.

Looking forward for any advice and suggestions.

Thanks!

View 1 Replies View Related

SQL 2005 Standard Edition - Licensing Question For Web Server

Apr 11, 2008

I have one server hosting an ASP.NET application. It will be running 2005 Standard Edition.

I don't really understand which licensing model I need. Obviously processor licensing would work, but at a hefty price!

The web application and SQL Server are on the same machine, and no other machines will be querying the database. The only 'users' are the people who visit the website (both internal and external users).

Can someone help me properly determine the most cost efficient licening model to use?

Thanks

View 1 Replies View Related

SQL Server 2005 Standard Licensing &&amp; Free Ready To Launch CAL

Jul 6, 2007

Hi folks



I attended one of the SQL Server 2005 "Ready to Launch" parties a couple of years ago and was given a complimentary SQL Server Standard Edition CAL along with a copy of the SQL Server 2005 Standard setup DVD.



As there's no mention in the "Ready to Launch" pack of an included Server license I was wondering whether it is possible to install a copy of SQL Server 2005 on a standalone server and use the single CAL in a Production environment without having to purchase a Server license? The pack does include a Product Key - is this the Server license?



Thanks

Chris

View 1 Replies View Related

SQL Server 2005 Workgroup Edition Licensing (How To Install Without A License, Then Require License On First Run)

Oct 13, 2006

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"

View 1 Replies View Related

Of Any Concern????

Jul 24, 2007

This is a reoccurring error in one of our Domain Controllers event logs…

Event Type: Error
Event Source: KDC
Event Category: None
Event ID: 11
Date: 7/24/2007
Time: 6:23:05 AM
User: N/A
Computer: DC2
Description:
There are multiple accounts with name MSSQLSvc/dbsrvr-02.olntv.local:1433 of type DS_SERVICE_PRINCIPAL_NAME.

the Server dbsrvr-02 (sql server 2000 standard edition sp3a) has a default instance and it looksl ike 2 named instances installed that we are not using. Ive searched this error and cannot find a thing.. should this concern me??? anyone ???

View 1 Replies View Related

SQL 2005 RS Licensing!

Mar 7, 2007

ok here we go...

Currently Project managing deployment of a lightwieght asp.net web app, and have a web server in a dmz and a database app server behind corporate firewall. The app is to be used by external internet users and is accessed through the web apps authentication. Currently have sql 2005 standard processor licence on the db server.

At present RS is deployed on the main db app server however it is not accessible to the external world as corporate IT advise this is a security risk. Fair enough. They advise I need ot install RS and sql licence on web server to get this to work.

However will I now need to buy a processor licence to enable RS to run on the web server? there was an interesting thread posted below on the deployment of RS. I think if you install Report Manager on separate server (the dmz web server) then you do not need to purchase more SQL licenses? the EULA indicated this but its not crystal clear.

The report manager is a asp.net web app just 'ike the main application. Is it not feasible to install report manager on the web app and then have this talk back to the report server on the main db application?

is Report Server installed with Report Manager regardless, and even if you deploy it separately you still have to pay!

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=978665&SiteID=1

hope makes some sense

many thanks!

SJ





View 10 Replies View Related

SQL 2005 Licensing

Aug 13, 2007

I have a rather complicated SQL Licensing question which i am looking for a simplified answer to. My current production environment consists of a dual CPU W2K3 SQL 2000 ent. as the primary transactional server and a quad itanium W2K3 running 64bit SQL 2000 ent as a backup reporting server. I am currently working on a project that will expose these servers to users outside of our firewall (read only non-transactional) and our desire is not to upgrade to SQL 2005 at this time. In additon, the primary server will be accessed from 7am to 9pm and then a switch over to the backup from 9pm to 11pm as the primary will be unavilable due to maintenance. If I interpret SQL 2005 Licensing correctly we would need a per-processor liscense, either standard or enterprise depending on the features utilized. Since we are only doing log shipping from the primary to secondary server my assumption is to purchase SQL 2005 Standard per-processor licensing for both servers?

View 1 Replies View Related

SQL 2005 (standard) Licensing

Nov 7, 2007

Hello all,
Never had to set up a server before and am bewildered by the licensing speak.
I'm going to have 1 small server (probably with 1 quad core processor) with 1 instance of SQL server running on it. The same server will host an intranet site through which all users will access the data.
What kind of licensing set up is required for this?

Thanks

Elliott

View 1 Replies View Related

SQL 2005 Licensing Question

Feb 25, 2007

We have installed SQL Server 2005 Standard Edition 64-bit on our Windows 2003 server. Now we have the server and CAL license in hand and want to add those licenses to SQL 2005. Tried using Control Panel License but SQL 2005 is not there. Can someone help us, how we can add the SQL Server and xx number of CAL licenses to SQL 2005. Thanks.

View 8 Replies View Related

SQL 2005/2000 Licensing

Oct 18, 2007

Hi,

I have a client that has a licensed SQL 2005 environment running on a commercial site. I need to install SQL 2000 as well to support a piece of software that does not run on SQL 2005. The client believes that their license covers them to run both versions of the software - is this correct?

If so, they no longer have the install set for SQL 2000 so is there somewhere I can get this from? I work for a Microsoft partner so we have our MSDN version of SQL 2000 but I suspect that would not work with the clients key?


Unfortunately the client is in a different country so it's not easy to just try it and see.

Any help would be gratefully received.

Rob

View 1 Replies View Related

Concern About Attach After Upgrade

Dec 24, 2007

I need to upgrade the currect db to sqlserver2005, and the current db used multiple filegroup and file
I first detach the db, and I want to make sure if I need to attach each db file after upgrade to sqlserver2005
Thanks

View 1 Replies View Related

Log File Growth Concern

May 18, 2007

I am getting a bit concerned with the size of my log file and my understanding of backups and how the log file should be getting reduced in size. I have a production database that is 12 GB and the log file is 275 GB. The database file is set to autogrow at 1 MB and unrestricted file growth. The log file is set to 10% file growth and restricted to 2,097,152 MB file growth. I perform a full database backup each night. I had thought that all transactions in the log file would be rolled into the database file and then the log file auto-truncated in size during the backup process. I have never seen a log file stay larger than the database file. Please advise how I may keep the log file size (growth) down. Thanks!

View 10 Replies View Related

Microsoft SQL 2005 Licensing && ASP.NET Applications

Jul 3, 2006

I am having a nightmare getting an answer about what type of licensing I will need for the standard addition of SQL Server 2005 for my asp.net application and wonder if anyone has any advice.
As I see it its very simple, I have a web app that makes a connection to SQL via a connection string using a single username and password, no impersonation just straight SQL authentication.
For this simple scenario I figured I would need to get a SQL 2005 license and then 1 Client access license (CAL), this being a nice affordable way of doing things BUT I am being told by different sources, that I may need to license on a per processor basis as any user of my web application, anonymous or otherwise needs a client access license and given that I don’t know how many users are going to access my website I would need to go for the larger outlay and purchase two standard processor license (my sql server is a dual processor machine).
Can anyone tell me if this is the case, is a connection from a ASP.Net website to a SQL server for my website visitors regarded as a new client and therefore needs a client access license or the large investment of a per processor license?
I would stick with SQL Express but at 4gigs max it won’t do the job.
Thanks in advance.

View 17 Replies View Related

Concern On Auto Update Statistics

Dec 7, 2007

Hi all,

We are using SQL Server 2005. The auto update statistics and auto create statistics for a database is set to ON. This database has a very heavy work load. When I checked the individual statitics , still the last updated statistics is in a old date value (few months ago).

Is it necessary to manually update the statistics for the same database? Or can we rely upon "auto update statistics" itself ?

Usually in what frequency the manual UPDATE STATISTICS should be run on production system which has heavy transactions ?

Thanks & Regards,

Hariarul

View 1 Replies View Related

Writing C# Stored Procs, Is SQL Injection A Concern?

Oct 31, 2006

I just started looking into writing queries/SPs in C#. A simple SP looks like this.

public class ContactCode
{
[SqlProcedure]
public static void GetContactNames(string lastName)
{
SqlCommand cmd = €¦€¦. €¦€¦
cmd.CommandText = "SELECT * FROM Person.Contact WHERE LastName = " + lastName;
SqlDataReader rdr = cmd.ExecuteReader();
SqlPipe sp = €¦€¦€¦€¦..;
sp.Send(rdr);
}
}

Since it's concatenating a dynamic SQL in the code, is SQL injection a concern or the CLR integration knows to take care of the input sanity? I know good programming practice is to validate input before it gets to this but it's necessary for CLR SPs to have the same robustness as normal T-SQL SPs when it comes to input parameter handling.

View 6 Replies View Related

Security Concern - How To Avoid Hardcoding Passwords In Batch?

Feb 24, 2003

I would like to eliminate all hardcoded login ids and passwords and would like to know what other companies are doing to address this issue. I know a job scheduling software package is the ideal solution, but until dollars become available I need a short-term solution. We've tossed around the idea of using system variables.

Any recommendations?

Thanks, Dave

View 3 Replies View Related

Public Role And Guest Security Concern In SQL 2000 SP4

Sep 8, 2006

Hi all,

I have setup a new SQL 2000 SP4 and internal auditor query about revoke permission from Public role and remove guest from all databases.

1. Can I revoke all default permissions (select on system tables in all DBs) from "Public" role? I am concern any error after such action.

2. I found that guest account in DB -- master, tempdb and msdb. According to Microsoft documents. The account should not remove and can't from master and tempdb. How about msdb?

Thanks,

Regards,

Edwin

View 7 Replies View Related

Licensing Of Data Mining Tools With SQL 2005 Analysis Services

Oct 25, 2006

A rather dumb question but I've installed an evaluation copy of SQL 2005 on my machine and a colleague would like the Analysis Services Data Mining capability on his machine (without the eval SQL Server).

Is there a license associated with such an installation when we buy 2005 or does it fall under client components which can be installed on any number of users machines?

Matt

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







Copyrights 2005-15 www.BigResource.com, All rights reserved