We have a MSSQL with per seat license of 20. The MSSQL is sitting in the same machine as the asp.net.
Does that mean that the the no. of connections and Max Pool Size are limited up to 20 only?
Thanks,
Ben
We have an active database that sits on SQL Server 2000 that currently has per seat license...but now want to switch to per processor.
If I go to ControlSQL Server 2000 License Set up...it doe not give me the option to choose per processor.
Do I need to un-install/re-install SQL Server 2000 and choose the per processor choice and then re-attach our database ?
It seems like a lot of work..please advise.
Thank you
Hi,
I have a SQL server installed in per server license mode... I am getting some error saying
"THE MAXIMUM SIMULTANEIOUS USER COUNT OF 1 LICENSE FOR THIS STANDARD EDITION SERVER HAS BEEN EXCEEDED. ADDITIONAL LICENSE SHOULD BE OBTAINED AND INSTALLED OR YOU SHOULD UPGRADE TO A FULL VERSION""
can someone tell me how to go from per server to per seat....
Thanks
I can't find the answer...it just talk about the CPU / ram /database limit. thanks for you help!
View 1 Replies View RelatedI 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"
Per-seat? problem
I have installed SQL7 standard edition on a server and the desktop version on an NT workstation PC. When I try to DTS between them, I get an error with regard to needing per seat licenses. I installed SQL7 from ‘BackOffice Test Platform’ CD (we are a MS Solution Provider), but there was no option for ‘seats’. What am I missing? Is there another SQL7 CD?
Thanks,
Judith
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
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!!!
Hi there,
Here we have got a
asp.net application that was developed when database was
sitting on SQL server 6.5. Now client has moved all of their databases
to SQL server 2000. When the database was on 6.5 the previous
development team has used oledb connections all over. As the databases
have been moved to SQL server 2000 now i am in process of changing the
database connection part. As part of the process i have a login
authorization code.
Private Function Authenticate(ByVal username As String, ByVal password As String, ByRef results As NorisSetupLib.AuthorizationResult) As Boolean
Dim conn As IDbConnection = GetConnection()
Try
Dim cmd As IDbCommand = conn.CreateCommand()
Dim sql As String = "EDSConfirmUpdate" '"EDSConfirmUpdate""PswdConfirmation"
'Dim cmd As SqlCommand = New SqlCommand("sql", conn)
cmd.CommandText = sql
cmd.CommandType = CommandType.StoredProcedure
NorisHelpers.DBHelpers.AddParam(cmd, "@logon", username)
NorisHelpers.DBHelpers.AddParam(cmd, "@password", password)
conn.Open()
'Get string for return values
Dim ReturnValue As String = cmd.ExecuteScalar.ToString
'Split string into array
Dim Values() As String = ReturnValue.Split(";~".ToCharArray)
'If the return code is CONTINUE, all is well. Otherwise, collect the
'reason why the result failed and let the user know
If Values(0) = "CONTINUE" Then
Return True
Else
results.Result = Values(0)
'Make sure there is a message being returned
If Values.Length > 1 Then
results.Message = Values(2)
End If
Return False
End If
Catch ex As Exception
Throw ex
Finally
If (Not conn Is Nothing AndAlso conn.State = ConnectionState.Open) Then
conn.Close()
End If
End Try
End Function
''' -----------------------------------------------------------------------------
''' <summary>
''' Getting the Connection from the config file
''' </summary>
''' <returns>A connection object</returns>
''' <remarks>
''' This is the same for all of the data classes.
''' Reads a specific
connection string from the web.config file for the service, creates a
connection object and returns it as an IDbConnection.
''' </remarks>
''' -----------------------------------------------------------------------------
Private Function GetConnection() As IDbConnection
'Dim conn As IDbConnection = New System.Data.OleDb.OleDbConnection
Dim conn As IDbConnection = New System.Data.SqlClient.SqlConnection
conn.ConnectionString = NorisHelpers.DBHelpers.GetConnectionString(NorisHelpers.DBHelpers.COMMON)
Return conn
End Function
in the above GetConnection() method i
have commented out the .net dataprovider for oledb and changed it to
.net dataprovider for SQLconnection. this function works fine. But in
the authenticate method above at the line
Dim ReturnValue As String = cmd.ExecuteScalar.ToString
for some reason its throwing the below error.
Run-time exception thrown : System.Data.SqlClient.SqlException - @password is not a parameter for procedure EDSConfirmUpdate.
If i comment out the
Dim conn As IDbConnection = New System.Data.SqlClient.SqlConnection
and uncomment the .net oledb provider,
Dim conn As IDbConnection = New System.Data.OleDb.OleDbConnection
then it works fine.
I also have changed the webconfig file as below.
<!--<add
key="Common" value='User ID=**secret**;pwd=**secret**;Data
Source="ESMALLDB2K";Initial Catalog=cj_common;Auto
Translate=True;Persist Security Info=False;Provider="SQLOLEDB.1";'
/>-->
<add key="Common" value='User ID=**secret**;pwd=**secret**;Data Source="ESMALLDB2K";Initial Catalog=cj_common;' />
Please help. Thanks in advance.
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.
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
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 RelatedHi,
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
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.
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 RelatedHello,
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
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!
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
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.
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
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
Is there a way to change the license key after installation of SQL7.0?
View 1 Replies View RelatedIs 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
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 RelatedHi,
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.
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?
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.
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-
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
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.
Does anybody know if sqlserverce's license is freeware or shareware??
thanks a lot!
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.
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