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

Microsoft Visual Sutdio For Applications Has Lost The Link To .

Jul 23, 2007

Hello,

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.

Any ideas?

View 10 Replies View Related

Microsoft.AnalysisServices.Viewers.DLL Microsoft SQL Server 2005 Datamining Viewer Controls

Jun 21, 2007

Hi

I am trying to use Association Viewer Control in

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

thanks from now.

Cem Üney

View 9 Replies View Related

Using SQL Server 2005 CE Embedded In Desktop Applications

Jan 3, 2007

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?

Thanks,

IonWarp

View 7 Replies View Related

SQL Server 2005 For Two Applications With Different Collation Setting On Same Platform?

Nov 13, 2007

Hi ,

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?

Thanks and regards,

Quinh

View 5 Replies View Related

How Can I Connect To Microsoft SQL Server 2005 CTP With Microsoft SQL Server 2005 Express Manager?

Aug 9, 2005

I installed Microsoft SQL Server 2005 Express Manager and connect to SQL 2000 normally

View 10 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?