SQL Licencing For Application Software

Jan 30, 2008

Just looking for some clarification. I have written an application that uses SQL Server 2005 to host all the data. The system uses MVC so a data connection is open, data requests are made and then the data connection is closed. All users connect to the database using the same database credentials. If I then want to sell this application and the client has 10 users, do I need a Server licenes + 10 Cals, even though there is in effect only 1 database user? There are only ever likely to be 3 users on the system working at the same time.

Thanks

Colboy

View 1 Replies


ADVERTISEMENT

SQL && Licencing

Sep 29, 2006

I know this is supposed to be a help forum, but the company I work for are looking to produce a DB using Microsoft SQL server, the DB will be accessed by approx 20 / 25 people and we will need one developer licence...and will be held on a dedicated server...

Can some one please help me work out what version of the sortware we need to purchase and what we require in the way of licences....???



Many Thanks

View 4 Replies View Related

SQL Server Licencing

Jul 4, 2001

I want to to purchase SQL Server 7.0 standard Edition. But I am having difficulty sourcing it.

If I purchase SQL Server 2000 standard Edition, am I covered.

Is there an article which covers this topic

View 1 Replies View Related

Licencing Issues

Oct 26, 2000

I have installed SQL Server 7, but in error I set the licencing protocol to 'concurrent users' rather that 'number of seats'. Is there an easy way to change this over? The only option I am aware of is to back-up the DB,re-install SQL Server and then restore the DB.
Is there a better option?

Mike

View 1 Replies View Related

I Don't Understand Licencing

Apr 19, 2007

Hello, i just bought sql server 2005 with 5 cals (previously i was using a shared sql server with my previous host)... I probably should have asked this question before i bought it... i don't understand how the cal licencing works... the sql server is for running our ecommerce site, i just got a dedicated server to put this on... but from reading the licencing does this mean that only 5 internet users can access my website(or the information in the database) at a time???

any help with this would be appreciated

~ Moe

View 4 Replies View Related

Instance Licencing

Nov 11, 2006

Hi,We are have a 5 user licenced microsoft sql server 2000 cd. We need toset this up to run two instances of the server, as we need differentsetups on both databases. Does anyone know if with one cd you can dothis, so that the user licences installed are shared between the twoinstances? Also do you need a aeperate server licence per instance orif using the user license model we can install both instances from thesame cd.Thanks for your help & timeDavid

View 1 Replies View Related

SQL Licencing Problems

Jan 4, 2007

It seems as though our last administrator has installed Enterprise Licenses (SQL 2005) We need these to be Standard, can I down grade some how with minimal to no disruption to our databases?

If so How, if not (which i almost positive that you are going to say NO) then i assume I am going to have to reinstall the SQL server. What is the best way going about this with out having to restore all of the databases? Can i copy all of the MDF and LDF files else where and then once the new installation has completed create the users, then databases and then replace the MDF and LDF?

Is there a better way then this if so it would be a huge help.



Thanks



Brad

View 1 Replies View Related

SQL Server Personal Ed - Licencing?

Feb 27, 2004

I just found that one of the SQL Servers I support shows it is 'SQL Server 2000 Personal Edition'. I've checked and there is a spare SQL Server 2000 Standard Edition' licence in the organisation.

Do I need to re-install SQL Server 2000 with the correct media so that it shows 'Standard Edition' in the SQL Server properties? Or is it ok just to leave Personal Edition on there?

Clive

View 1 Replies View Related

Question Regarding Licencing And Pricing

Jun 1, 2004

Can someone please explain me how much does it cost for Per CPU license and how much /Server for an enterprise edition

Thanks

View 1 Replies View Related

Licencing In Sqlserver Mobile Edition

May 28, 2007

I am working on a Mobile Area project.

The employees go to markets and collect information about the goods.(Collect the datas using pocketpc's) and synchronise the data with SQLSERVER.

At this point how many CAL I need?





View 1 Replies View Related

Installation And Licencing About MSSQL 2005 Standard Edition And Clustering Mode

Feb 8, 2007

Hi,

I have a question about using MSSQL server 2005 standard edition in Clustering mode.
I would like to build a msql cluster with only 2 servers (2 nodes).

I read here -> http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en
page 5 that you can use MSSQL server 2005 standard edition in Clustering mode with 2 nodes.

But my question is :
Can I use windows 2003 standard edition (Clustering mode managed ????) or I only can use windows 2003 enterprise edition ?

J.

View 1 Replies View Related

Distrib.exe Application Error , Application Failed To Initialize Properly(0xx0000142)

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

What I Need To Run Compiled Application On Another Application?

Sep 11, 2007



Hey,
don't know if it's the right place for this question but i hope you help me.
I made an application with VS 2005 that connecting to sql server file db.mdf
Now i want this application work on another user computer, and of course i don't want to install vs 2005 there.
I did install .net framework, but what i need to do to make the database work? do i have to install sql server on his computer? or is there something more simple?
I know that if i was using access file than i need to install nothing else.
please help!
thanx.
max

View 4 Replies View Related

My Asp.net Web Application

Feb 27, 2008

ALTER procedure [dbo].[AHD_EmpID_GET]
as
begin declare @User varchar
declare @empid varchardeclare @Pword varchar
select E.EmpID as Code, E.Empcode as Description
from AHD_glb_Employees E
inner join AHD_users U on E.empid=U.empid
--where E.Empid=@empid
end
i have tried this but it is not getting a unique value...........
can u help me pls??
 
 

View 3 Replies View Related

ASP.NET Application To Use DTS

Aug 3, 2005

I've got an application that needs to:1.  Look on the user's machine and locate a file2.  Pull that file over to DTS3.  Allow DTS to insert this file into a table
I'm sure this can be done....anyone got any article on how to do it?
Thanks!

View 1 Replies View Related

VB Application

Jan 19, 2001

Hi

I have created a Visual Basic application the connects to my SQL database.
The appliction lets a user click on a button, data is retrieved from the database
and then formatted in Excel. Everything works fine on my machine (this is probably
because i have both VB and SQL installed on my machine)
I have created a .exe and deployed the application on some users desktops. The
problem is that when they click on a button - nothing happens. I dont even get any
error messages! Everything else appears to be fine. I have tested the DSNs and
they appear to be fine too.
Does anyone know why this would happen ??

Thanks, Ruaidhri.

View 2 Replies View Related

SQL WITH WEB APPLICATION

Jun 16, 2000

hI,
EVERY ONE.
1)IF I EXECUTE QUERY FROM QUERY ANAL , QUERY & STORE PROC RUN VERY FINE , BUT SAME REPORT IF I DO FROM FRONT END(i.e from web application tool) THEN IT TAKE VERY LONG TIME.WHAT COULD BE THE REASON ?

2) IF I REBOOT MACHINE - SQL SERVER. THEN FROM FRONT END if I RUN ANY REPORT THEN IT WORK FAST BUT NOT same AS OF QUERY ANALY .I DON'T UNDERSTAND THIS .
PLEASE ANY ONE HAS COME ACORSS THIS PROBLEM & HAVE ANY SUGGECTION PLEASE REPLY ME

THANKS
NIRMAL

View 1 Replies View Related

SQL 7.0 And NT Application Log

Apr 12, 1999

Whenever a user logs on to SQL-Server there´s
a message in the application log of windows NT
like
"Login succeeded for user 'Domainusername'. Connection: Trusted."
Since we have lots of users. The application log fills up twice a day.
Is there any way to prevent SQL-Server from doing this ?
(I know that there are settings in the event-viewer which clear events
whenever space is needed).

Thanks.

View 2 Replies View Related

Application Log

Nov 9, 2001

Event Viewer log error "Application log is full". Please any suggestions on how to handle this. THanks

View 1 Replies View Related

Vb.net Application

Jun 26, 2007

i hv developed an application in vb.net, database is in server and more than 50 PCs i have installed my application. Is this the correct procedure, or else i hv to install it on the server and get the shortcut file in all the PCs.because if suppose i want to send a new patch file that time iam going to uninstall my application in all the PCs and installing it again. It takes time.



if i install this in server and create shortcut on every client pc, then how should i management variables value while coding. Please do let me know. thanks for your help

View 1 Replies View Related

Application To SQL Db

Mar 3, 2007

I'm not sure if this is the right section for the question, but here goes...



I have an application that needs to be run in network client mode. This app is supposed to connect to a SQL 2005 db hosted on a server. As I procede through the installation process I get a prompt when i populate the serverdb information.

'The listener port was responsice, but did not return a primary port number for <servername>. Please verify that <servername> is a valid and running database before proceeding.

A little background is in order:

Host:

Server 2003 Standard

SQL Server 2005

Installed instance of said db

Client:

Windows XP Pro sp2

Network config:

We have a domain with about 125 workstationslaptops. Windows firewall is turned off using a group policy (makes it easier to push apps out to clients). For giggles I made exceptions to the 'turned off' firewall policies for the needed ports etc. This was done on both the host server and the client.

Thank you in advance.

View 3 Replies View Related

Call SQL Job In ASP.NET Application

Jun 27, 2006

is it possible to call a SQL job from an ASP.NET application?  if so, how? I'm using VS.net2003 and am programming in C#I've been searching for a while, but haven't found anything.  It doesn't help that one of my keywords when searching is "job(s)."

View 1 Replies View Related

Regarding Update In Asp.net Application

Oct 2, 2006

i created a asp.net application using sql server. it retrieve data from a sql server and shows it in the form. it uses textbox control to show it. i wanna update it or add a new item in database. i wrote the code for it under update and add buttons. when i click on the update button after changing a data in textbox, the page is getting refreshed nad comign back to initial state without getting updated. but when i change the textbox1.text with a string in the code, its getting updated with string without any problem. even same problem for addition too, am using a dataadapeter and dataset for this. when i assign a string to the datset columns, its getting updated well but wheni assign it with textbox.text.tostring, nothing is happenig to database. can anyone help me in this issue, why the data was not sent to the datbase and the page is getting refreshed.. plz need help.. its urgent 

View 1 Replies View Related

SQL Problems With C#.Net Application

Mar 10, 2007

Below is a stored procedure i want to implement. However i am getting errors.
 
Please read and see if u can correct me.
 
Thanks
 
Gareth 
 
 
 
 
 
Create Procedure UpdateFile
 
@Filename         Varchar(255),
@imgContent       Image,
@imgContentType   Varchar(max),
@Description      Varchar(255),
@RtnDate          Datetime,
@UserID           Varchar(50)
 
As
 
Select UserID from Fileshare
If @UserID = UserID
Begin
 
UPDATE Fileshare
 
SET imgContent = @imgContent, imgContentType = @imgContentType, Userid = @UserID, Description = @Description, RtnDate = @RtnDate, FileLock = 0, LockedBy = ''
WHERE Filename = @Filename
 
-- If the parameter and current value dont match, an error
-- Is raised which i will need to deal with in my app.
 
--Error message so (without entering anything for the returned error so far is
--Msg 102, Level 15, State 1, Procedure UpdateFile, Line 19
--Incorrect syntax near '@Filename'.
 

View 5 Replies View Related

One Application With 2 DataBase

Aug 6, 2007

Hai All ,
        Iam having the one Application in DotNet2005.But iam using the two database(SqlServer2005).If user's login the application it will check credentials in first database, if he is not having the login credentials it will cheek the second Database. How can I handle in the configuration file?. How can I change the connection string depending upon the Database in my application for database operation (like insert and update).Any one kindly provide the solution.Thanks and regards,sureshK 
 

View 7 Replies View Related

Application Is Very Slow

Oct 7, 2007

 Dear All,Finally I completed my project. Thanks all you helped me to do it.Now I have the biggest problem. In my application the Data grid is filled with Data from SQL server table which has large number of records. When I run my queries in SS Management Studio it runs very fast. To fill data to datagrid it takes lots of time. How can I reduce this time. How can I increase the performance of my Application.Thanks,Janaka   

View 4 Replies View Related

Im Trying To Run A Application And Getting Following Errors

Nov 17, 2007

Imports System.Data.SqlClientImports System.DataImports Microsoft.SqlServerPartial Class _Default    Inherits System.Web.UI.Page    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click    End Sub    Protected Sub TextBox3_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles TextBox3.TextChanged    End Sub    Protected Sub SqlDataSource1_Selecting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs) Handles SqlDataSource1.Selecting    End Sub    Protected Sub Save_Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Save_Button1.Click        Dim conn As New SqlConnection()        conn.ConnectionString = Data Source=REDSTONE;Persist Security Info=True;User ID=******;Password=******;Unicode=True    End SubEnd Class
 
End of statement expected.    C:Documents and SettingskasireddyMy DocumentsVisual Studio 2005WebSitesBankCustomerInfo.aspx.vb
'System.Data' is a namespace and cannot be used as an expression.    C:Documents and SettingskasireddyMy DocumentsVisual Studio 2005WebSitesBankCustomerInfo.aspx.vb
C:Documents and SettingskasireddyMy DocumentsVisual Studio 2005WebSitesBankCustomerInfo.aspx.vb 

View 1 Replies View Related

Securing Web Application

Dec 11, 2007

Hi, I am using ASP.Net 2005 with C# language and SQL SERVER 2005...
I am developing an web based application and have to deploy it on server.
I need to prevent my site from the SQL Injection and have to use some algorithms.
What is the best technique or method (Algorithm) in .Net ?
Give some measures to prevent from Hackers.

View 3 Replies View Related

Asp.Net Mobile Web Application

Jan 22, 2008

I am geeting following error while trying to acquire db connection. I use sql server ce2.0 with vs2005
Failed to find or load the registered .Net Framework Data Provider

View 3 Replies View Related

Calling The SP From ASP.NET Application

Feb 8, 2008

Hi All,
 
I have problem in calling the SP from ASP.NET application 
 @DefApp nvarchar(255)= '' ,@DefBusFunction nvarchar(255)= '' ,@DefImpact nvarchar(255) = '',AS Begin declare @sql nvarchar(4000)declare @whereClause nvarchar(4000)DECLARE     @return_value intdeclare @sqlWhere nvarchar(4000) select @sql = 'SELECT DefApp, DefBusFunction, DefImpact FROM Def LEFT JOIN ZFunction ON (def.DefApp = ZFunction.App) AND (Def.DefBusFunction = ZFunction.BusFunction)' if @DefImpact <> ''      Set @whereClause = ' where DefImpact '      SET @whereClause = @whereClause + ' = ''' + @DefImpact + '''' set @sqlWhere=@sql + @WhereClauseEXEC @sqlWhereEnd 
and i am calling this SP from my ASP.net application to fill the SSRS report. I have written code in ASP.NET like:
 sqlCmd = new SqlCommand("subbusample", conn);
sqlCmd.CommandType = CommandType.StoredProcedure;sqlCmd.Parameters.Add(new SqlParameter("@DefImpact", SqlDbType.NVarChar, 255, txtValue3.Text.ToString()));
sqlCmd.Parameters.Add(new SqlParameter("@DefBusFunction", SqlDbType.NVarChar, 255, txtValue1.Text.ToString()));
sqlCmd.Parameters.Add(new SqlParameter("@DefApp", SqlDbType.NVarChar, 255, txtValue2.Text.ToString()));
 RptViewer.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
RptViewer.ServerReport.ReportServerUrl = new System.Uri("http://servername/ReportServer");RptViewer.ShowParameterPrompts = false;
RptViewer.ServerReport.ReportPath = "/folder name/Subbu_Sample";
 
when i execute it, i am not able to fill the report with data.
 
Please let me know what i am doing wrong.
 
Thanks,
SR.

View 6 Replies View Related

Using SQL Application Roles From ASP.NET

Nov 1, 2004

Hi there

Can anyone point me to a good tutorial or give me a run down on using Sql Application roles from my asp.net application. Books Online only give a run down on how to set it up - not how to implement or use it from my code. MSDN no help. Google - same thing.

Any help greatly appreciated.

Thanks in advance

View 2 Replies View Related

SQL 2000 In A Web Application

Dec 20, 2004

Is there a way to connect to a sql db and read the databases and write them to a webpage? Then is there a way to view the tables in a selected database on a webpage?

I'm trying to make a web based enterprise manager.

View 2 Replies View Related

I Can't Execute My Asp.net Application With IIS 5.0

Apr 6, 2005

Hi,
please i have a problem, i can't execute my asp.net application with IIS 5.0?
i have a message indicating that MYSERVERASPNET can't connect, and that arrive when trying connect to the database under SQL Server 2000.
you have to know that my application work very well with webserver of WebMatrix.
Web Matrix Project : version 0.6
.Net Framework 1.1
Thank you.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved