SQL ExpresS OR Additional Licenses??????
Jul 31, 2006
We are
looking for a solution for a client that we will make software for. We are a ISV. After
completion of the software, our client then wants to sell this software to their
partners, people in that business, etc. We do not want to add any additional cost, by means of them(client(s)) purchasing
a server, server software or licensing. Is there any solution
that will make this work? A runtime or embedded database solution? If there is a
license we need to purchase, what would that be? SQL Express Edition work?
View 4 Replies
ADVERTISEMENT
May 4, 2007
we have a sql express - that comes standard with servers.I just wanted to know.....Is there any addition Client access licenses needed for this sql express or not.
View 1 Replies
View Related
Aug 1, 2000
hello!
i am getting the following error in the windows NT event viewer daily atleast twice or thrice...
"The product Microsoft SQL Server 7.0 is out of licenses. Use License Manager from the Administrative Tools folder for more information on which users are out of compliance and how many licenses should be purchased. "
we have recently got an open license agreement also for sql server from microsoft.till now we were using a temporary license.how to apply the details in the certificate so that i don't get the error?
View 3 Replies
View Related
May 16, 2006
Dear All
I have developed a system which has SQL server as a backend... Reading Microsofts Licensing required i m a bit puzzled if a CAL license is required for each user that is created on my system. i.e. If my system has 5 users, do i need 5 CAL licences.. however, in order to present the required data to these users i log to SQL server with the same single account.
Regards
View 6 Replies
View Related
Jul 20, 2005
Can you change your license setup if it was initially done by seat andyou want to change it to by processor? The server is already up andrunning in a production environment. If so how?
View 2 Replies
View Related
Oct 17, 2007
As I understand it, if I have a 4 CPU box and I buy 4 processor licenses for SQL Server 2005 Standard, I can run 16 instances of SQL Server on that box.
Now given a cluster set up for active/passive I understand that if I license the same way I can have 16 instances on one of the nodes of the cluster. In the event of a failure, the instances can fail over to the "passive" node and the licenses move with them.
So heres the question. Given my two node cluster, each node has 4 CPUs, if I have some of the resources on node 1, and others on node 2, so instances are running on node 1 and node 2, am I on the hook for 8 processor licenses?
View 4 Replies
View Related
Mar 20, 2007
I've just installed Workgroup Edition for the first time. I have copies on each of two servers, each ordered with five CALs.
My problem is that I don't know how to assign the licenses. I can't find anything in the documentation about it, nothing in the tools menus, and no reference to SQL Server in the Licensing application. The latter really looks like the right place, so if I had to guess, I'd think I've installed something incorrectly. Shouldn't SQL Server appear there as a product?
Of course, I'd also think this would be documented somewhere, but then it's probably one of those things that any idiot would know, so there's no need to explain it.
Once I get past that problem, I'll be setting up eight workstations. I understand from Microsoft Sales that since I've purchased a total of ten CALs, then all eight workstations will be able to access either server. Do I have to do anything special to make that work? Currently, there's no domain. The servers are just members of a workgroup.
Thanks,
Dick
View 1 Replies
View Related
May 22, 2007
Hi all,
I hope I am on a suitable thread. Sorry if I'm not. I just need to know if I need a license in order to write a commercial application using Visual Studio 2005. And, if so, is this license necessary to me as a developer or to my customer that will purchase the application at the end?
And something more. ASP.NET runs on IIS, which is shipped with Windows Server, correct? So, once my customer purchases Windows, he doesn't anything more in order to run a ASP.NET application (which will finally access the SQL Server DBMS). Is this correct?
Thanks in advance
Lambros
View 1 Replies
View Related
Mar 8, 2000
I need to install some SQL Licenses but the Control Panel applet is non-functional (It states that I have an NFR version of NT). Is there another way to activate licenses?
View 2 Replies
View Related
Apr 19, 2000
I would like to know does it exist a relation between number of licenses (per server) entered when installing SQL Server and the maximum of connections obtained by @@MAX_CONNECTIONS ? how can i get the information about the number of licenses after the installation ? Thanks.
View 1 Replies
View Related
Apr 19, 2000
I was told that there is no relationship between max_connections and number of licences. So how can i know when the number of user connections exceeds the number of licenses per server (with the error 18458 - the maximum simultaneous user count of %d licenses for this server has been exceeded)? Because I did some tests by openning a number of connections greater than my number of licenses and i didn't get any error.
View 1 Replies
View Related
Jul 20, 2005
How do you find the number of licenses that are installed on a SQL Server2000?
View 2 Replies
View Related
Mar 14, 2008
I've purchased and installed SQL Server 2005 along with some licenses and I now have a 'Microsoft Open License Confirmation Letter' in my inbox.
How do I add these licenses to SQL Server and get them active?
How do I check to see how many licenses SQL Server contains?
View 10 Replies
View Related
Jan 6, 2004
My company uses a quad processor server connected to a SAN to load and summarize detail sales information from 2000 stores on a nightly basis. We poll and load around 5,000,000 rows of data each night. THis information is summarized up to various levels, then replicated to one or more secondary datamart servers for end user access via web reporting, BI tools like Proclarity/Analysis Services etc...
The initial data polling server is only touched by the development staff supporting the process (1-5 programmers) and is licensed for SQL server Enterprise using a CAL model. Each datamart server is licensed with MS SQL server processor licenses.
The question: We were told that the quad processor polling machine, which has no end user access allowed, must be licensed with processor licenses since it touchs the data ultimately consumed by end users. This makes no sense to me.
The Microsoft white papers discussing multi_tier environments don't seem to address this type of issue. They focus on applications that ultimately pass thru a data request to the SQL server machine. In this situation, user requests are handled by the datamart servers, which are licensed with processor SQL licenses.
Can anyone clarify?
Thanks, Mike
View 1 Replies
View Related
Jul 20, 2005
Hello everybodyI've got a small system (~20 client machines) connected to one SQL Server2000. Two of these machines refuse to connect to the database. As I don'tknow how the license system is supposed to work, I haven't investigatedtoo much yet.My question is therefore:Will SQL Server 2000 Enterprise Edition refuse to accept any newconnections when all licenses are used?Is such case, what tool do I use to add more licenses?thanks in advance--Johnny Ljunggren
View 3 Replies
View Related
Jul 23, 2006
hi all,
our company is using SQL Server 2000 Standard Edition as a backend for inventory and sales data storage.
The top management of our company has decided to web enable all the data for sales and inventory so that any authorized user can have access to the data from anywhere in the world.
now my question is that how many SQL Server licenses will we require if we are going to use it for the web?
We currently hold 20 licenses.
Thanx in advance.
View 4 Replies
View Related
Oct 19, 2007
I have got a licensed copy of MS SQL Server 2005 Standard Edition. I am wondering how I can go about telling how many Processore Liscenses or Client Licenses I have with it. I have just the disk set and product key, no box. Any clues?
View 1 Replies
View Related
Sep 17, 2007
Hello our organization has never had any problems getting users to connect to our SQL servers but we have grown a lot over the past year or two. Does SQL Server actually block connections if they go over the license limit? I don't have access to the servers to see the model used but I have been asked to look into this. I couldn't find any information on this so I decided to ask you guys. Thanks in advance.
View 4 Replies
View Related
May 9, 2006
I have been testing and developing with Sql 2005 enterprise eval. Now ready to deploy, and we have purchased a "device" and 5 "cal" licenses for each box. What is the recommended procedure for applying Sql 2005 "standard" licenses to existing boxes having 2005 enterprise eval. installed? I do not want to delete and re-install sql server if at all possible!
Thanks!
Ken Ambrose
View 2 Replies
View Related
Oct 21, 2002
Currently both of our servers have 1 gig of RAM. We are adding and additional 1gig of RAM to our local server but none to the remote server. Transactional replication is performed between both servers in both directions. SQL Server is configured to dynamically configure memory on both servers.
Are there any issues or concerns that I should be aware of?
Thanks
View 1 Replies
View Related
Jul 6, 2005
I have code on a website that does a search to an Access database based on what the person enters as the search criteria. My SQL code uses a like % statement for all the fields in the search criteria. The problem is that the first and third search fields do no return the search criteria that is asked for.....The 2nd search field (Description) returns whatever is asked for..... I did read up and found that the data must be character for the like statement. Anyone have any other clues or where I can read up on this???????HTML SEARCH CODE: <table ALIGN="CENTER" width="408" bgcolor="#FFFFFF" cellspacing="0" cellpadding="5"> <tr> <td width="400" bgcolor="#3366cc" colspan="2"> <form method="post" name="DaForm" action="Makeit.asp" align="center"> <div align="center"><center><table border="1" width="350" cellpadding="3" bgcolor="#3366cc"> <tr> <td align="left" width="189"><select name="TypeSearch" size="1"> <option selected value="PartNumber">Part Number</option> <option value="Description">Description </option> <option value="Mfg">Manufacturer</option> </select></td> <td width="310" align="right"><input type="text" size="30" name="DaInBox"></td> </tr> <tr> <td colspan="3" align="center" width="507"><div align="left"><p><input type="submit" name="B1" value="Search!"><input type="reset" name="B2" value="Clear"> </td> </tr> </table> </center></div> </form> </td> </tr></table>Makeit ASP COde:
<%@ LANGUAGE="VBSCRIPT" %>
<html>
<head>
<title>Your Search Results!</title>
<meta name="Microsoft Border" content="lb, default">
</head>
<body>
<%
Dim MySql
Set cn = Server.CreateObject("ADODB.Connection")
cn.Open("parts")
MySql = "SELECT * FROM parts"
If Request.Form("TypeSearch") = "Part Number" Then
MySql = MySql & " WHERE PartNumber LIKE '%" &_
Request.Form("DaInBox") & "%'"
End If
If Request.Form("TypeSearch") = "Description" Then
MySql = MySql & " WHERE Description LIKE '%" & _
Request.Form("DaInBox") & "%'"
End If
Dim rs
Set rs = new Server.CreateObject("ADODB.Recordset")
rs.Open MySql, cn, 0,1
%>
<% If rs.BOF and rs.EOF Then%>
<h2 align="center">We did not find a match!</h2>
<%Else%>
<%If Not rs.BOF Then%>
<h2>Here are the results of your search:</h2>
<table BORDER="0" width="100%" cellpadding="3">
<tr>
<th bgcolor="#0366cc"><font face="Arial" color="#000000">Part Number </font></th>
<th bgcolor="#3366cc"><font face="Arial" color="#000000">Description </font></th>
<th bgcolor="#3366cc"><font face="Arial" color="#000000">Manufacturer </font></th>
<th bgcolor="#3366cc"><font face="Arial" color="#000000">Qty </font></th>
<th bgcolor="#3366cc"><font face="Arial" color="#000000">Condition </font></th>
</tr>
<%
Do While Not rs.EOF
%>
<tr>
<td><%=rs("PartNumber")%>
<%=rs("Description")%>
</td>
</tr>
<% rs.MoveNext
Loop
%>
</table>
<%End If%>
<%End If%>
<%
rs.Close
cn.Close
Set rs = Nothing
Set cn = Nothing
%>
<p> </p>
</body>
View 1 Replies
View Related
Feb 28, 2001
Hi,
What are all the performance parameters to be analyzed, in an existing production server, to accommodate an additional database.
Regards
Kalyan
View 1 Replies
View Related
Feb 12, 2014
I have two tables that I am pulling data from to insert into a third table.
Table 1:
Organization Address Date
Name 404 St. 12/31/1999
Table 2:
Organization Software Type Quantity
Name SW1 5
Name SW2 6
Name SW3 7
Name SW4 8
My query looks something like this:
INSERT INTO Organization SW Reqs (Name, Address, Date, SW1 Quantity, SW2 Quantity, SW3 Quantity)
SELECT Table 1.Name, Table 1.Address, Table 1.Date,
(Select Table 2.Quantity Where Table 2.Software Type = 'SW1'),
(Select Table 2.Quantity Where Table 2.Software Type = 'SW2'),
(Select Table 2.Quantity Where Table 2.Software Type = 'SW3')
FROM Table 1, Table 2
WHERE Table 1.Organization = Table 2. Organization
Sadly, this query gives me four rows, one for each Software Type. I have tried putting DISTINCT after my SELECT, but that narrows it down to two rows only. I would really like to have just a one row result per organization.
View 2 Replies
View Related
Mar 10, 2006
Part of the code as follows:
SELECT
ARDoc."Cpnyid", ARDoc."Custid", ARDoc."CuryOrigDocAmt", ARDoc."DocBal", ARDoc."DocDate", ARDoc."Doctype", ARDoc."slsperid", ARDoc."Territory", ARDoc."RecordType", ARDoc."user7",
ARTran."CmmnPct", ARTran."CuryTranAmt", ARTran."DrCr", ARTran."ExtCost", ARTran."InvtId", ARTran."JrnlType", ARTran."Qty", ARTran."RefNbr", ARTran."Rlsed", ARTran."S4Future04", ARTran."S4Future05", ARTran."TranAmt", ARTran."TranClass", ARTran."TranDate", ARTran."TranType", ARTran."UnitDesc", ARTran."UnitPrice",
RptCompany."CpnyName", RptCompany."RI_ID",
Customer."Name",
Salesperson."CmmnPct", Salesperson."Name", Salesperson."SlsperId"
FROM
{ oj ((("SOLUSBS02APP"."dbo"."zARDoc_Comm" ARDoc INNER JOIN "SOLUSBS02APP"."dbo"."RptCompany" RptCompany ON
ARDoc."Cpnyid" = RptCompany."CpnyID")
INNER JOIN "SOLUSBS02APP"."dbo"."Customer" Customer ON
ARDoc."Custid" = Customer."CustId")
LEFT OUTER JOIN "SOLUSBS02APP"."dbo"."Salesperson" Salesperson ON
ARDoc."slsperid" = Salesperson."SlsperId")
LEFT OUTER JOIN "SOLUSBS02APP"."dbo"."ARTran" ARTran ON
ARDoc."Custid" = ARTran."CustId" AND
ARDoc."Refnbr" = ARTran."RefNbr" AND
ARDoc."Doctype" = ARTran."TranType"}
Currently, if a new rep takes over for an old ones invoices and accounts...he will also get credit on the report which this query is for. Instead I need to use a table SOShipHeader to be 'date sensitive'. SOShipHeader will have the correct 'SlsperID', but will still need to pull the name from Salesperson."Name"
My guess, would be that I need to wedge the SOShipHeader table between the ARDoc and Salesperson tables?
View 5 Replies
View Related
Apr 11, 2006
I have the following fields in table A:
GL_ID|GL_Name_VC| Amount |Period_TI|Year_SI|
===================================================
1000| Sales_HW| -20,000.00 | 01 | 2005
===================================================
1000| Sales_SW| -10,000.00 | 01 | 2005
===================================================
1001| Cost_HW | 5,000.00 | 01 | 2005
===================================================
1001| Cost_SW | 5,000.00 | 01 | 2005
the fields above have the following datatype:
Fields | Datatype
===================================
GL_ID | Integer
GL_Name_VC | Variable Character
Amount | Integer
Period_TI | TinyInteger
Year_SI | SmallInteger
The above database is running on Microsoft SQL Server 2000 and i would like to query
for a report that looks something as below:
Sales Category | Sales | Cost | Profit
=================================================
HW |-20,000.00 |5,000.00| -15,000.00
SW |-10,000.00 |5,000.00| -5,000.00
=================================================
Total |-30,000.00 |10,000.00|-20,000.00
The above report have 4 columns, with last column being a calculated field (Sales-Cost)
Guys, hope someone out there can help me with the sql command for the above report?
View 2 Replies
View Related
Feb 20, 2007
How do I create additional instances of any MSSQL 2005 service(specifically database and analysis) given that a default instance is present?
View 4 Replies
View Related
Jul 6, 2006
Hi
I have a column in the db with serial number data, on a export that I am doing the data has to be 10 digits long the problem is not all of them are eg
12234
122334343
1234234567
how can i get it to look like this adding an 0 to the front to make the row 10 digits
0000012234
0122334343
1234234567
Thanks
View 6 Replies
View Related
Feb 29, 2008
Hi All,
I have developed a report using report viewer in asp.net web form. The report is generated based on the selection of Department. User have an option to multi select the departments so the department column grows. Lets say user select Business category first and generate the report then user decides to add another department say Engineering. No the report column headers will have addional column "Engineering". I have used the Matrix since I had to group by Name and dates. Everything is good so far.
Now I have to add an additional column "Notes" at the end of all the columns. If there is ony department is chosen then Notes column appears after that and if mulitple departments are chosen the Notes column should also appear after all the department column (at the very end).
I am really having hard time to accomplish this. Is there any suggestion or solution to finish this? I really appreciate your responses.
Thank you.
View 1 Replies
View Related
Dec 28, 2006
I am attempting to add additional fields and data to the default users database that is created as a result of enabling roles on my website. Is it possible to add additional data fields to this file? Where can I find the commands to do this?
View 2 Replies
View Related
Jul 23, 2007
Hi, I use the FOR XML AUTO to retrive native XML from a database with:
SELECT [xml] FROM myxml WHERE id = 81 FOR XML AUTO, elements, root('ROOT')"
However it returns the database name and table name as parent elements. How can I return just my raw XML data without additional elements:
XML is Stored:
<ROOT>
<CHAPTER>
<TITLE>This is a test</TITLE> </CHAPTER>
</ROOT>
Returns:
<databasename>
<tablename>
<ROOT>
<CHAPTER>
<TITLE>This is a test</TITLE> </CHAPTER>
</ROOT>
</tablename>
</databasename>
View 1 Replies
View Related
Jan 18, 2008
I have a stored procedure which is used to search records in the database based on the data sent from the web page. There are several search fields and all of them are in one table (Table1) except the "CallerName" field which is in a different table (Table2). Since I had to show CallerName also in the gridview apart from other columns, I did a LEFT JOIN (using field CallerNumber) to show all the required fields from Table1 and CallerName from Table2.
Now heres the problem. Since CallerName is a search criteria, its supposed to be in the WHERE clause after the JOIN or in the JOIN clause itself. The problem is, if I put it in WHERE clause, the result set doesn't show records from Table1 which do not have a matching CallerNumber in Table2. SELECT T1.CallerNumber, T1.DateCalled, T2.CallerName
FROM Table1 T1
LEFT JOIN Table2 T2 on
T1.CallerNumber = T2.CallerNumber
WHERE T1.CallerNumber = 'some number' AND T2.CallerName = 'some name' If I put it in the JOIN condition, it works just like a LEFT JOIN is supposed to work, showing all the records in Table1 and also those which had CallerName in Table2. SELECT T1.CallerNumber, T1.DateCalled, T2.CallerName
FROM Table1 T1
LEFT JOIN Table2 T2 on
T1.CallerNumber = T2.CallerNumber AND T2.CallerName = 'some name'
WHERE T1.CallerNumber = 'some number'
1st SQL won't work for me because it doesn't show all the records in Table1, even when no search criteria is specified.2nd SQL won't work for me because it shows more than required when just CallerName is sent from the web page as search criteria. It will show all the records where CallerName is "some name" and also all the additional records (since it is a left join).
Can I get the goodness of both in one or do I have to create two separate Stored Procedures?
Thanks all,Bullpit
View 11 Replies
View Related
Feb 27, 2008
I added one crummy column to my table. I updated the stored procedure and added the thing to the aspx page which is my form for adding an article. I have a strong feeling that something is foul over here...Why is it that Visual Studio will not allow me to capitalize the word get and when I delete the () after ShortDesc they immediatlye reappear and the get statement is set to get. Every other one of them, and there are 9 others use GET and there is no () after the public property variable name. Does anyone know the reason for this?
Public Property Author As System.String
GETReturn _Author
End Get Set(ByVal Value As System.String)
_Author= ValueEnd Set
End PropertyPublic Property ShortDesc() As System.String
GetReturn _ShortDesc
End GetSet(ByVal value As System.String)
End Set
End Property
View 1 Replies
View Related
Dec 18, 2003
I have a DataGrid, it will return a table in SQL2000 server.
the problem is:
no data in the datagird, only a record "null" in all field.
I find a sample is add a "sqlDataAdapter1.Fill".
but if I add the code:
sqlDataAdapter1.Fill(dataSet21);
I got the error:
---------------
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll
Additional information: System error.
-------------
I have search this problem fix many many time, many people has this problem, looks like no result I can find.
Please help, thanks very very much.
Thanks.
View 2 Replies
View Related
