SQL License Required For Logging Application
Nov 20, 2007
I understand the general SQL no-multiplexing-to-reduce-CALs idea. I have a semi-edge case: Does this apply to applications like IIS when using SQL to log access? IIS allows you to log web hits to an ODBC database -- so for a typical web app, that would mean getting a CPU license for SQL server. Is that correct?
What about a network monitoring app that sniffs packets and records network statistics? If there's only a 2 network devices (but potentially packets from millions of users), what does licensing look like then?
When does the "manual step" allowance kick in? For instance, if a user generates a report from SQL server and it's automatically saved as an HTML file to a webserver thats accessed publicly -- what's licensing for that?
Is a CPU license needed in all these cases?
-Michael
View 4 Replies
ADVERTISEMENT
Apr 22, 2007
Hi Everyone, I m using ASP.NET 2005 with C# and SQL SERVER 2005. I m using stored procedure and sql datasource control to retrieve the data. I want to use the trigger alongwith storedprocedure. I have created the following trigger on emp_table. CREATE TRIGGER Employeee on emp_tableAFTER DELETE ASDECLARE @empid int SELECT @empid=empid from emp_table where locationid=(SELECT locationid from deleted)IF @@ROWCOUNT=0 DELETE FROM location_table where locationid=(SELECT locationid from deleted)What i wanted to know is how can i use it with asp.net and sql server 2005 when any update,delete or insert query is executed thru the stoed procedure...What code is required to use the trigger with the application of .NET thanxs.....
View 2 Replies
View Related
Oct 6, 2006
We are starting to work with SSIS in our production environment & due to support issues; we are trying to get rid of the "Package xxx started" log entries inside of the Windows Application Event Log...
So far, I have tried many different things, including setting the LoggingMode to "Disabled", as well as adding a new logging reference with a different destination... All of which still do not get rid of the extra log entries...
how to get this done?
View 7 Replies
View Related
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
Nov 28, 2006
Hi,
I am developing an application that uses Access database (mdb file) to store the user data. The user of this application is not interested in the database file (to view in MS Access Environment). Does the user machine requires MS Access installation to run my application or just some couple of dlls (OleDB driver, Access DB Engine,..) should be enough to run my application?
Thanks,
Rao
View 3 Replies
View Related
Jun 18, 2007
Greetings,
I am developing a package on my local workstation. I have defined two logging service providers. One is for SQL Server and the other is for the Windows Event Log. I am using the Dts.Log method in a script task to write log entries.
Logging is working properly with the SQL Server provider and rows are being inserted into the sysdtslog90 table. However, the only events that are being logged in the Windows Event Log are the package start and end events which I believe SSIS is doing automatically anyway.
Is there something I need to do to enable WIndows Event Log logging other than defining a log provider and making sure it is checked active? Won't SSIS write to two different logs with one Dts.Log call? Any ideas on what might be going wrong with my approach?
Thanks,
BCB
View 3 Replies
View Related
Oct 17, 2007
Hi,
I decided to use the SQL Server log provider to store logging data of all my Integration Services packages. I also created some reports about this data for operating purposes.
I have a problem occurs the name of the executing package is not always written to the log,but the name of the single task which failed. But that is not very useful information for operating, because I do not see any chance to get the name of the package by the information which is logged in the sysdtslog90 table in the database which I defined for SSIS Logging.
How do I configure the package to always log the package information into the table, too?
Best regards,
Stefoon
View 5 Replies
View Related
Sep 12, 2005
I recently read the project real ETL design best practices whitepaper. I too, want to do custom logging as I do today, and also use SSIS logging. The paper recommended using the variable system::PackageExecutionId to tie the 2 logging methods together.
View 4 Replies
View Related
Apr 13, 2008
have SQL Server 2005 std edition SP1 installed on Windows 2003 Std edition .Configured Transactional (single Publisher and no clustered environment.)
Replication past two months working fine, Now
1.Distrib.exe application err is coming.
Due to which my job is failing (Distributor to Subscriber).
Iam attaching thw file.
Thanks
Sandeep
View 1 Replies
View Related
May 10, 2000
To all,
Can anyone give me the answer?
I want to use DTS to import some data from remote server to my local server.
Every time I get following error message "The license for the installation of Microsoft SQL Server on your source and destination connections does not permit the use DTS to transfer data".
Both my servers are on SP2. Why I have such error? What should I do?
Thanks.
View 1 Replies
View Related
Nov 2, 2000
Hello all,
I need to pick up a SQL Server 7 license, but I am a little confused as to what I need.
I'll be running SQL Server 7 on a web server. I'll be the only one logging to maintain SQL Server. There will be three different apps the run on the server that each will have one to ten databases.
So, what's the minimum license I need? Will the developer's license work?
Any one out there have a license they want to sell - cheap? :)
Thanks....
Michael
jns-michael@home.com
View 1 Replies
View Related
Jun 29, 1999
How do you increase the number of license? With 6.5 we were able to do this through the setup on the CD but it will not let me do this with 7.0? The specific error is SQL Server Error 18460. Logon Failed. The maximum simultaneous user count of 5 license s for this Standard Edition server has been exceeded. I have upgraded the licenses in the License manager for Windows NT but SQL 7.0 does not seem to recognize it.
View 2 Replies
View Related
Dec 31, 2004
Hi,
My company is developing their site with MS SQL which will then be transfered onto another server hosted by our ISP, do I need to purchase a SQL license for that machine - exactly what do I need to purchase.
Any help appreciated!
Thanks,
Sanjay
View 2 Replies
View Related
Oct 9, 2007
New challenge!!!!
I have already installed a SQL Server 2005 cluster with several instances and I want to change the license key to another one.
How can I do this with out having to re-install?
seethem.
View 20 Replies
View Related
Sep 21, 2007
i want to check the price of sql server 2005 in my country as a consideration to take when deciding on wich db to build.i dont understand the licensing method. what 5 clt stands for ? whats the basic 64 bit 1 processor dual core license i need for a commercial website ? thanx,
View 1 Replies
View Related
Jan 24, 2005
Hello,
Anyone aware of any license requirment for selling any application developed in ASP.NET (C#) using MSDE as backend?
Any response will be highly appreciated.
Thanks
View 5 Replies
View Related
May 29, 2001
If I just need a desktop version of SQL 7.0 installed for local development. (Not being used as a server) Do I just need a CAL license?
Thanks!
View 3 Replies
View Related
Jul 12, 2000
Hi ,
I have two servers, One is with per seat mode
another with per license mode.
when i am registering one server which is having per seat mode at one of
my client machine , it is giving u dont have license permission.
Can anyone suggest me regarding license modes if u have two servers.
thanku
rk
View 2 Replies
View Related
Dec 13, 2000
Hi all,
I want to know how I can do to change my SQL server licence mode (from per-ser to per-seat) without reinstall SQL Server.
Thanks in advance.
View 3 Replies
View Related
Jan 17, 2001
Hi all,
There is a guy in my company install a sql server himself, but he picked the per seat license rather then the per server (we got the per server license), is there a way to change it without re-install the whole sql server? or need to reinstall from start?
Thanks,
Westley
View 1 Replies
View Related
Mar 8, 2001
I can't find anything written about licensing for OLAP anywhere. Do I presume correctly that it doesn't require one of its own?
Thanks for any info.
Simon
View 3 Replies
View Related
Jun 5, 2002
Is there a way to change the license key after installation of SQL7.0?
View 1 Replies
View Related
Mar 18, 2004
Is there a way to check if a sql 2000 server was installed on the license of "per server" or "per # concurrent users"?
Can't find from server property.
thanks
-D
View 1 Replies
View Related
Nov 8, 2004
Does it mean "per hard drive" or "per CPU"(Pentium III, Pentium IV, etc.)? I'm a bit confused about it after reading a lot of books and article talking about processor license. Thanks in advance....
View 4 Replies
View Related
Jun 22, 2006
Hi,
I have to audit a number of servers and tally with source installation CDs. How can I tell which CD license key has been used on a server , i.e. where (I assume in registry) is the license key held ??
Many thanks.
View 1 Replies
View Related
Oct 20, 2006
Hey Gang,
I was wondering if there was an alternative to using SQL SERVER and not having to spend all that money on a license?
View 5 Replies
View Related
Jan 17, 2007
I run w2003 standard and SQL 2K on my development machines.
I have installed this environment several times with no problems.
Now I am setting up a new machine, an AMD dual core.
Right after installing and validating w2003 I tried to install SQL 2K developer edition and after the first few dialogs it brings up a license key dialog with an already filled in key and it will not let me continue.
This product doesn't require a key, and no keys are given for it in my MSDN subscription. I just tried this CD in an XP machine and it installs without asking for a key. It never asked for a key when I installed on previous w2003 std. machines either.
Why I sit asking for a key now? Why will it not install on this particular machine?
Thanks.
View 2 Replies
View Related
Aug 28, 2006
Hello,
I have a question concerning the license requirements for SQL Server Express Edition. I read from a previous MSDN license agreement for MSDE the following non-competition section:
"7.6 If you choose to redistribute MSDE, you also agree: (i) that your application shall not substantially duplicate the capabilities of Microsoft Access or, in the reasonable opinion of Microsoft, complete with same; and (ii) that unless your application requires your customers to license Microsoft Access in order to operate, you shall not reproduce or use MSDE for commercial distribution in conjunction with a general purpose word processing, spreadsheet or database management software product, or an integrated work or product suite whose components include a general purpose word processing, spreadsheet, or database management software product except for the exclusive use of importing data to the various formats supported by Microsoft Access."
I can't find this section or similar verbiage in the SQL Server Express Edition redistribution EULA or in the newest MSDN license agreement. My company has a database product that provides other functionalities besides just being a database. However we didn't use MSDE due to the section quoted above. I am wondering whether SQL Server Express Edition's license model has changed?
Any help is greatly appreciated.
Thanks,
-Jason-
View 1 Replies
View Related
Oct 3, 2007
Hi, I'm not sure if this is the correct forum to ask about this, but here it goes.
I was planning to aquire the SQL Workgroup (2 processors, bla bla bla). But I realized it is not as simple as that.
Then I was looking at the different licenses and I'm not sure where I stand. The 2 processors, reporting services and
unlimited Database size is what I need. I currently use the Express Edition so I cant schedule backups within the
SQL Server and also when the database reaches 4GB will have to buy another version of SQL Server.
But which license should I have? I am a developer so all I need is an instance of the SQL Server running, nothing else.
My application will connect to it and do its job from different PCs in the netowork. I dont need any SQL Client application
running and my application uses a single user (sa) to access the SQL Server simultaniously from several PCs on the
network.
So that is why I think this is a maze to me, I don't know where to proceed. Does anyone know which license or whatever
SQL Server 2005 Workgroup version should I use?
Thanks,
Fábio
View 17 Replies
View Related
Dec 19, 2007
I installed sql server 2005 standard edition a few months ago and while installing i realized that it was the 5 CAL version. I need the per processor license. so we order the per processor license standard edition. i go to install it and it tells me to run setup with the SKUUPGRADE option. i try that and it doesn't work. so then, i go to control panel and hit change/remove and it installs some stuff. i install some hotfixes to get it up to build 9.0.3159 like the rest of my servers. however, i can't find any way to tell what kind of license it's using. this is one of my production servers so i can't have any restrictions or reduced performance if it still thinks it's running a 5 CAL version. how do i tell what kind of license it's using?
i was originally going to uninstall sql server 2005 and reinstall it using the new media, but this server is also one of my production sql server 2000 servers and if it messed up my sql server 2000 installation i would be in huge trouble.
View 2 Replies
View Related
Mar 6, 2008
Does anybody know if sqlserverce's license is freeware or shareware??
thanks a lot!
View 1 Replies
View Related
Mar 10, 2008
Dear All,
I have different application installed on a server all of them are interface to SQL Server databases.
I want to know if I have 5 user license to one application, 10 user license to other application, 3 user license to third application. So, I have as an example 18 application license.
My question is: What does affect the access of these application to their databases? - Number of application user license or something else.
Thanks n advance.
View 1 Replies
View Related
Oct 8, 2006
Hello Everyone,I have been searching hard to get an answer on this question, I hope someone here can help me!Here is my situation:I am planning to build a website for them, that would be used for some event registration (by people outside my company). I also plan to use SQL Express Edition as the database backend for the site. Now this is where I have a question, can I use SQL Express and pay nothing? (It is free right?) There would be a maximum of 600 registrations over a period of 1 month. I don't expect more than 50 concurrent users. The administration side of the application would be used by internal employees (So, the application would be used by internal employees and external people). Where can I find more information about the license?I would be very thankful if someone can guide me on this.ASP_Newbie
View 3 Replies
View Related
