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.
I am struggling with a really ugly problem in SSIS.
I am designing SSIS package where I have a couple of Script tasks. Let's call them Script Task 1 and Script Task 2. Everything was working fine until this morning I added another Script taks (Script Task 3), which was trying to do some rudementary file manipulation. At that point I started getting this message:
"Microsoft Visual Sutdio for Applications has lost the link to .
Your work will be exported to c:documents and settings".
This is it! "lost a link to "dot". After this, the VS environment continues to run in debug mode, so it doesn't even crash stirctly speaking. I can stop debugging and continue developing, but nothing would run anymore and I would keep getting the same error. Moreover, after removing Script Task 3 (which seems to be the culprit), I would still keep getting the same error! Only removing all the script tasks completely and then adding them back gets the package to run again.
Microsoft.AnalysisServices.Viewers.DLL dll in VS 2005 but sometimes it gives an error.
"Code generatio for property 'ConnecitonManager'" failed. Error was:'Property accesor 'ConnectionManager' on object 'AssosiactionViewer1' threw the following exception:'Object referance not set to instance of an object"
Is there anyone here who use "Microsoft SQL Server 2005 Datamining Viewer Controls" in SQLServer2005 FeaturePack ? http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17&DisplayLang=en
i am using VS2005 Version 8.0.50727.762 (SP.050727-7600) and SQL Server 2005 SP2
Is it ok to use SQL Server 2005 CE as an embedded DBMS inside a desktop (Windows XP / w2k3 / Vista) application?
The whitepaper available here: http://download.microsoft.com/download/A/4/7/A47B7B0E-976D-4F49-B15D-F02ADE638EBE/Compact_Express_Comparison.doc describes this as one of the primary usages of the product. However, I've seen information elsewhere on this forum that seems to imply that SQL Server 2005 CE is not allowed in desktop applications.
Can you please clarify this, and specify any limitations of this usage?
Also, the whitepaper refers to an online redistribution agreement that needs to be signed in order to freely redistribute SQL Server 2005 CE inside a commercial application. Can you please point to this agreement?
We want to install 2 applications that run on SQL server 2005 but the requirement of database installation are different Collation setting ( One require Dictionary order, case-insensitive, for use with 1252 Character Set and other require Dictionary order, case-sensitive, for use with the 437 (US English) Character set). So the question here could I install both two applications successfully on same platform ? and if yes how?
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!
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?
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?
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.
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?
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.
Hello,Our company has developed several Access applications for our clientsand we wish to expand to use a database server. We wish to use Accessas the front end application and SQL Server 2005 as the back endDatabes Server. Making a Server-Client application database.I'm very new to SQL Server so my concern is how the licensing worksfor a developer like us. I am aware that we can purchase the Developeredition for $49 USD. Our clients will then have to purchase a theirrespective licensing option.We do not have an issue with this, but i would like a betterunderstanding 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 wedevelop the SQL server in the DE? Or can they purchase the Standardor Workgroup edition if the workload allows it?2) If the client already has the Enterprise Edition on the Server wewish to use, will they have to buy the license again if we create theDatabase? Can they import our Database to thier SQL Server, and ourapplication connects to thiers?3) Is there other options that would require a cheaper option for ourclients?4) With just the DE, can we develope applications and use theappropriate edition for our clients whatever it is?5) To test our products we thought of using the Trial version tosimulate a multi-user test environment? Since thats just a 180 daytrial, perhaps the Worgroup Edition or the Light weight Edition mightwork. 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
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?
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
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?
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?
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..
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.
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?
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?
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?
I am update/inserting records threw a web form in vb.net. I need to insert 'NULL' into my microsoft sql server database. I am not talking about the below line of code where website is the name of my paramater. If i do that it will just place a blank into that field in the database. If i dont enter anything into that textbox I want it to to say NULL in that field. So if I go into the actual table in the SQL Server Management Studio and look at the website field of the recored I just added or updated and did not type anything into the web site textbox it needs to say NULL. I also tried the second line of code but that places a single quote in front and behind NULL. So the field will have the value 'NULL'. website.value = txtwebsite.text.tostirng if txtwebsite.text ="" then website.value ="NULL" end if The reason why I need the NULL there is because I bind the website filed to a hyperlink template in a gridview. The actual text of the hyperlink is bound to PAYER which is a name of a insurance payer but the navigateto is bound to the website field. If i do not enter any data into the website field and it stays as NULL, then when my gridview is loaded, payers that dont have a website will not be underlined and user wont have the option to click on them since there is no value for the navigateto. But if i use my form to update/add a payer and leave the website textbox blank in puts a blank into that field in my database and when it loads that new row into the gridview the PAYER is underlined and u can click on it but it will just take u to the web site is unavailable page. So is there anyway to actaull have NULL placed into a filed and not just blank space
Hello, How are you? I have a problem when I try to create a new connection with Microsoft SQL Server 2005 Compact Edition from Visual Studio 2005 IDE. When I€™m going to choose the data source, the SQL Server 2005 Compact Edition provider doesn€™t appear in the list. I installed the SQL Server 2005 Compact Edition from this page http://www.microsoft.com/downloads/details.aspx?FamilyId=%2085E0C3CE-3FA1-453A-8CE9-AF6CA20946C3&displaylang=en. In the additional information says by installing SQLServerCE31-EN.msi installs the provider (System.Data.SqlServerCe.dll) in the GAC (global assembly cache) and registers the OLEDB provider (sqlceoledb30.dll). So, I don€™t understand why couldn€™t I create a new connection with Microsoft SQL Server 2005 Compact Edition from Visual Studio 2005 IDE?
I am having a problem with connecting to SQL Server 2005 database from Office Business Scorecard Manager 2005 (the connection string i am using is: provider=SQLOLEDB;Data source=server_name; Initial catalog=database_name). But the connection failed. Would please any experts here shed me any light on what is the problem and how to fix it then? As there is no any forum for Office Business Scrorecard manager 2005. Therefore I post my thread here as it is related to the connection to SQL Server 2005 database engine, thought here is the best place for this question.
Thank you very in advance for your kind advices and help. And I am looking forward to hearing from you soon.
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.
Hi Fellas, I would really appreciate if you could help me out with the following two questions? 1) Can 2005 server files be converted to 6.5? and how? 2) How easy it to upgrade from 6.5 to 2005? and how?
