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.
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!
Ok, simple question:
We have 10 developers. All 10 use ONE server to do development work (design, coding, testing ONLY!). We have a Developer Edition licence for EACH developer. Is this OK? We have 10GB plus in test data and do not want to replicate that to each desktop.
According to the Developer Edition EULA, I would say NO. It looks like you can only have one developer (and a few testers, I forget the number) per server. It says NOTHING about having more than one developer access the same server under this license. The Developer Edition EULA appears to be designed around installing a database on a desktop just for that developer, not installing a central database that all developers use.
There are conflicting postings everywhere about this. I built a small site using VWD and SQL Server Express, but need to convert to Sql Server 2005 Developer because the DB will exceed 4Gb. Tried to install and could not connect or use from VWD. Tried to uninstall, got into large mess with the byzantine uninstall process, and have now started with a clean machine.
I installed SQL Server 2005 Developer first, then installed VWD Express 2008 without installing SQL Server Express. VWD won't let me connect to an existing database, won't let me add a new database and doesn't even show the Database Tools option under the Tools menu.
Is there someone with specific knowledge that can provide any enlightenment? Would be much appreciated.
I tried to install this on the same box and I'm not sure how to reply to setup questions since I want to keep my SQL Server 2000 intact.
View 5 Replies View RelatedCan someone here confirm or deny that Visual Web Developer 2005 Express Edition doesn't work with SQL Server Developer Edition 2005?
I
was about to order SQL Server Developer Edition 2005 on Amazon, to use
with Visual Web Developer 2005 Express, when I read a user comment that
the two are incompatible with each other. Does anyone know for sure if
that is true?
What I'm wanting to do is develop an ASP.NET web
application on a web host using a SQL Server database. I use VS2003 and SQL
Server Enterprise 2000 at work, but I'd like to learn the 2005 editions
for this side project. I don't own any of the developer tools/IDEs
personally, so I'm trying to find the most affordable way to do this
for my home business.
Thanks for any advice,
Keith
Hello all. I'm giving serious thought on changing gears withing the IT world. For several years I have been a software developer who has been fortunate enough to have been involved in the needed databases. From just sketching out tables for the DBA to doing the database from the ground up and maintaining it during production. Along the way I've known that I didn't do as quality of a job as a knowledgeable DBA would do but given the situations I made do just fine.
I am considering switching gears to the database side only, coding as secondary. Since I am basically familier with most aspects of SQL Server in a general way, I am looking to take that knowledge and become a "Professional". What I am looking for is a few books to help out. Maybe a "Become a DBA for Software Developers" or something. I know that mining these and other forums are very valuble but I'd like some other training materials as well.
Have I been clear enough on what I am looking for? I don't quite feel like I have.
Basically, what would you recommend for a good software developer who is looking on switching to becoming a good database person?
I'd like to stay in SQL Server for now, since that is what they use here and it would give me an opportunity to practice.
Also, do you see value in the studying process for certifications in this area?
I can't tell if the SQL Developer install upgraded the service, but left the SqlExpress version information, or if I'm still really only using SqlExpress.
Also, my intended target is SQL Enterprise, so if I am using SQL Express am I asking for trouble when I go to move the database over? Are the database formats compatible?
I've poked around trying to search for this answer for a while and haven't turned anything up. Maybe I'm searching on the wrong terms...
Thanks,
Geoff
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
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
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 RelatedI 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?
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
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 RelatedI 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
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 RelatedEnv.: 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?
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.
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"?
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
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!
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
How can one identify the current licensing model on an existing(production) SQL Server?
View 8 Replies View RelatedSorry 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 RelatedHow 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
I want to retrieve SQL server licensing information e.g. License type, Count, License Code etc.
Any help?
RK
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
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
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
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.
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
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!!!
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