Clusters And Licenses
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
ADVERTISEMENT
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
Nov 30, 2007
I need to install sql server 2005 server and foglight on 2 node active/passive cluster.
do i need to install on both nodes ?
after install how can i find which is active node?
how can i findout the virtual name/IP ?
do i need to create DBMP's on both the nodes ?
how can i do cluster failover?
I am completely new SQL server, please let me know
laddu
View 2 Replies
View Related
Nov 30, 2007
I need to install sql server 2005 server and foglight on 2 node active/passive cluster.
do i need to install on both nodes ?
after install how can i find which is active node?
how can i findout the virtual name/IP ?
do i need to create DBMP's on both the nodes ?
how can i do cluster failover?
I am completely new SQL server, please let me know
laddu
View 4 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
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 17, 2004
Is anyone running SQL Server 2000 clusters on an IBM SAN (FAStT or ESS800)? Could you shed some light and provide links if any to IBM and/or Microsoft sites on this issues
View 2 Replies
View Related
Nov 16, 2007
I am supporting 2 node cluster sql 2005 servers (Windows 2003 computers). Active and passive cluster.
Right now sql services are running under local system account , as per standard should be run on sql service account.
So please let me know how to change, with out impacting the application
Can i directly change sql services to service account on passive node ?
Please help me anyone on this task.
View 3 Replies
View Related
Sep 20, 2006
Hi,
For our trainign data clustering models show the maximum accuracy.
We want to preset the results to our client. In order to do that we want to present what are the properties of each cluster.
For example for my predictable attribute if Cluster 9 is showing maximum population then I want to show what conditions of attributes make cluster 9 .
What is the way of doing this ?
Thanks,
Vkas
View 3 Replies
View Related
Feb 2, 2006
Does anyone know of any issues with using Active/Passive or Active/Active clusters and log shipping. Will log shipping still work if a failover occurs?
Thanks
View 3 Replies
View Related
May 26, 2006
Hi,
I have a MS Clustering model based on knowledge-area and I want to rename each cluster to the name of the knowledge area. What would be the DMX to rename the cluster?
I have been trying to do something like -
UPDATE [Knowledge Base].Content
SET Node_Caption = [Knowledge Base].[Field]
(Field is the column in the mining structure [Knowledge Base] with the values to be assigned to the Node_Caption)
But this does not work. The DMX query editor on parsing the query says that it reached the end of input.
Can someone help me out?
~ Sanchet
View 6 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
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
View Related
Apr 4, 2007
I am about to move 8 SQL 2000 clusters instances residing on 2 seperate MCS clusters (4 instances each with 2 nodes each active/passive) to one single MCS cluster (2 nodes active/passive). The SQL Cluster VMs will have the same DNS names and IPs, however the MCS VM and nodes will have different names.
The planned method for moving the DBs is just to stop all SQL services copy the system and user MDF and LDF files and then restart SQL. From everything I have read this should be fine. However here are my concerns on a cluster platform:
Will the change in node names on the target cluster be a problem when moving the master DBs over from source SQL VMs? Are the cluster nodes listed somewhere in the Master DB?
A couple of the SQL instance VMs are invovled in transactional replication. If all of the SQL files are copied over and the target VM has the same DNS and IP name, will there be a problem with the transactional replication when SQL is restarted?
Thanks,
Chris
View 1 Replies
View Related
May 17, 2001
Hi.
I am working on a project and we are starting to spec out our back end database systems. I wish to have multiple SQL Servers in a cluster PLUS failover running fiber against SANS storage arrays to partition the databases.
Has anyone seen any articles on this or know of any sources for support etc. ?
Our volume is sporatic but during enrollment phases (2 week long periods) we can have as many as 100,000 visitors registering (small datasets, large volume of logic) Thanks,
Craig Somberg csomberg@stageone.com
View 1 Replies
View Related
Oct 13, 2004
Howdy,
We're interested in putting a SQL 2000 cluster together and want to hear from people who have run SQL Server clusters :
(1) Just how reliable are they in the real world?
(2) Which bits break ( i.e. hardware or OS or SQL Server )
(3) What configuration would you suggest and why?
Any help much appreciated
SG.
View 9 Replies
View Related
Oct 22, 2014
We are looking to setup an AlwaysOn A/G between two SQL instances across two SQL clusters - one cluster has two nodes the other has three nodes.
Is this possible using WSFC? Does the A/G wizard just handle this?
View 3 Replies
View Related
Feb 7, 2008
To all the SQL H/A experts, we were wondering if we could have 3 physical nodes and 2 active/passive clusters architecture setup on a SAN as seen in the image below? http://www.geocities.com/juanlieu/CP_Arch.JPGIn case you cannot see the diagram, it would looks something like this:
active/passive Cluster A ---> physical server A (Win2003/SQL2005) ---> HP EVA SAN ---> physical server B (Win2003/SQL2005) ---> HP EVA SANactive/passive Cluster B ---> physical server B (Win2003/SQL2005) ---> HP EVA SAN ---> physical server C (Win2003/SQL2005) ---> HP EVA SAN
In this setup, I understand that Server B cannot be called upon as the active server at the SAME time by both clusters. question: what would happens if it does, would Server B reject the last cluster that calls it?Appreciated in advance.
View 3 Replies
View Related
Jan 7, 2007
Hello all and a happy new year!
I used Microsoft clustering for grouping my data. Even though i already cleaned the data and have no null values i get one cluster with missing values in every attribute. (i set CLUSTER_COUNT=3 and i'm using Scalable k-means algorithm)
Does "missing" mean that the algorithm cannot group that particular tuple in another group so it consider it as missing?
Thank you in advance.
View 4 Replies
View Related
Dec 14, 2006
In a response posted Nov 21 (Clustering Dimension), Jamie wrote...
"The only option of using a table-based model as a dimension is to write out the cluster labels and simply make the cluster label as a dimension attribute. You could even append the cluster label to the source data (e.g. the customer table) and not have a seperate dimension, simply a browseable attribute on the dimension of interest"
Jamie, can you provide more information on how to do this? We'd like to have a series of clusters in an existing household dimension. That is, we need multiple occurences of cluster model results over time browsable in the source cube. I've looked at the data source, dimension, and cube created by the data mining model, but I don't see where the case ID (Household Key) and the cluster name could be extracted to update the existing dimension. We're using the cube for the data mining source.
This would also help to fix a recurring problem we have with keeping the linked cube and the source cube metadata in sync. If I make a change to the source cube, say by adding a new measure, the metadata for the linked cube gets out of sync. I've been deleting the data mining dimension, cube, and dsv and them adding them back in using the data mining menu in the model.
View 5 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
Apr 11, 2014
We have 2 SQL 2012 servers. Our application has 2 databases. We are creating an AlwaysOn cluster. Is it good to create 2 AlwaysOn clusters to have 1 database primary on one of the servers and the other database primary on the other server?
I have been asked if it is possible to have one database running on one server and the other database on the other server. Is this possible without creating 2 separate AlwaysOn clusters?
View 4 Replies
View Related
Nov 21, 2007
I have been reading through many postings here, through the MS SQL Server Unleashed book by SAMS, the MS SQL Tech article "Failover clustering for Microsoft SQL Server 2005 and SQL Server 2005 Analysis Services" for installing a brand new SQL 2005 2 node cluster.
So far I have not found the definitive answer that I am looking for and that is, what rights does the SQL service account need to work properly? One article states that it needs both Domain Admin permissions and local admin permissions (and this is a domain account by the way) and then another article states that it only needs domain users group permissions and the least amount of privledges possible.
Can anyone please tell me what is correct for installation and running the server? The more I read about this the more confused I get.
Please be patient as I am brand new to SQL.
Thank you very much!
View 3 Replies
View Related
Mar 29, 2007
Hello.
What kind of criterion is used by MS clustering algorithm to determine the number of clusters when 0 is specified in the algorithm parameters?
The problem is that I find automatically defined cluster number somehow strange, especially when expactation maximization algorithm is used. I tried to "manually" calculate optimal cluster numbers in my models using bayesian information criterion and the one by Akaike and received more understandable results.
Thank you very much in advance.
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
