SQL Server Clusters On SAN
Mar 17, 2004Is 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
ADVERTISEMENT
Downside Of SQL Server Clusters
Oct 13, 2004Howdy,
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.
Oracle 10G's Real Application Clusters (RAC) Counterpart In SQL Server 2005?
Jul 27, 2007Hello Everyone,
Does SQL Server 2005 has a counterpart to Oracle 10G's Real Application Clusters (RAC)?
http://www.oracle.com/technology/products/database/clustering/index.html
Regards,
Joseph
SQL Server 2005 Counterpart On Oracle 10G's Real Application Clusters (RAC) Counterpart?
Jul 27, 2007
Hello Everyone,
Does SQL Server 2005 has a counterpart to Oracle 10G's Real Application Clusters (RAC)?
http://www.oracle.com/technology/products/database/clustering/index.html
Regards,
Joseph
Clusters
Nov 30, 2007I 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
Clusters
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
Sql 2005 Clusters
Nov 16, 2007I 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.
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?
How To Reading Clusters ?
Sep 20, 2006Hi,
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
Clusters And Log Shipping
Feb 2, 2006Does 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
Using DMX To Rename Clusters
May 26, 2006Hi,
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
Consolidating MS SQL 2000 Clusters
Apr 4, 2007I 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
SQL2000 Clusters + SANS
May 17, 2001Hi.
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
SQL 2012 :: AlwaysOn A/G Across Two Clusters
Oct 22, 2014We 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?
A 3-nodes And 2-clusters Architecture Possible?
Feb 7, 2008To 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.
Clusters With Missing Values
Jan 7, 2007Hello 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.
Data Mining Clusters
Dec 14, 2006In 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.
SQL 2012 :: Creating 2 AlwaysOn Clusters For 1 App
Apr 11, 2014We 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?
SQL 2005 Clusters And Service Accounts
Nov 21, 2007I 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!
Algorithm Used To Determine The Number Of Clusters
Mar 29, 2007Hello.
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.
Add Node To Sql 2005 Failover Clusters Hangs
Feb 2, 2008
Hello,
I wanted to instal sql server 2005 on our sql 2000 failover cluster.
The first thing i did was deinstal sql 2000.
The installation hangs on the dialog screen configuring components and does not present een error.
If i install the cluster with one node there's no problem.
But if i want to add the second node the installion hangs.
When i go to the second node and stop the scheduled task the installations stops.
Do you have any suggestion
Recovery :: Setup AlwaysOn Availability Group Between 2 Separate Clusters
Sep 22, 2015I have an active passive cluster on my primary Data center in NY and have a DR Active / passive SQL Cluster in TX. These are two separate clusters in the same domain using the same SQL server credentials.Both clusters host an active / passive SQL instance. Lets call it SQLNY(Primary) and SQLTX (DR). I want to enable always On Availability group within the two SQL Instances SQLNY and SQLTX. The listener will be SQLAG which will be used by the Application to connect to the SQL instance. Is there a practical way to implement this? This will not only give me instant fail over within the NY (Primary) but also give me the flexibility to fail over to TX. I am using SQL 2014 Enterprise Edition on both clusters.
View 6 Replies View RelatedMemory Configurations For SQL Server 2005 EE X64 With SQL Server 2000 EE X32 On Windows Server EE X64 Server
Apr 20, 2007My server is a dual AMD x64 2.19 GHz with 8 GB RAM running under Windows Server 2003 Enterprise Edition with service pack 1 installed. We have SQL 2000 32-bit Enterprise installed in the default instance. AWE is enabled using Dynamically configured SQL Server memory with 6215 MB minimum memory and 6656 maximum memory settings.
I have now installed, side-by-side, SQL Server 2005 Enterprise Edition in a separate named instance. Everything is running fine but I believe SQL Server2005 could run faster and need to ensure I am giving it plenty of resources. I realize AWE is not needed with SQL Server 2005 and I have seen suggestions to grant the SQL Server account the 'lock pages in memory' rights. This box only runs the SQL 2000 and SQL 2005 server databases and I would like to ensure, if possible, that each is splitting the available memory equally, at least until we can retire SQL Server 2000 next year. Any suggestions?
How To Move Sql Server 2000 Database From One Server Box To Server 2005 On Another Server Box Sql
Aug 10, 2007
Hi,
We have an old machine which holds SQL server 2000 database. We need to migrate a whole database to a new machine which has SQL server 2005.
When we tried to move whole database using Import and Export Wizard, only tables can be selected to import/export. However we want to import/export the whole database, including tables, stored procedure, view, etc. Which tool should we use?
Thanks.
How To Move Sql Server 2000 Database From One Server Box To Server 2005 On Another Server Box Sql?
Aug 10, 2007Hi,
We have an old machine which holds SQL server 2000 database. We need to migrate a whole database to a new machine which has SQL server 2005.
When we tried to move whole database using Import and Export Wizard, only tables can be selected to import/export. However we want to import/export the whole database, including tables, stored procedure, view, etc. Which tool should we use?
Thanks.
Server: MSg 17, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server Does Not Exist Or Access Denied
Jun 6, 2007Hi,
When I am trying to access SQL Server 2000 database from another machine i got this error
Server: MSg 17, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied
but I could access the database on same server and in that server i could access other databases in different server.
SQL Server 2005, SQL Server Mobile, SQL Server Management Studio. Unsupported HTTP Function Call
Sep 5, 2005Hi All,
View 14 Replies View RelatedA Call To SQL Server Reconciler Failed. SQL Server 2005, SQL Server Mobile Merge Replication
Oct 2, 2005Hi,
View 36 Replies View RelatedSQL Server 2000 Databases To SQL Server 2005? Enterprise Manager And Management Stuio At The Same Server?
Feb 13, 2008When I proposed start to use SQL Server 2005 for new VS 2005 web sites, one of my co-workers responded that
we will update the old SQL Server 2000 databases to SQL Server 2005 when we are ready to use 2005 SQL Server.
Questions:
1. Any expected problems to upgrade old 2000 databases to new 2005 SQL Server?
2. I have installed both 2005/Management Studio Express and 2000/Enterprise Manager in my PC. Any expected
problems when running both 2000 and 2005 SQL Server at the same database server?
3. What is the best configuration for running SQL Server 2005 when we have old 2000 databases? Upgade or not upgrade?
TIA,
Jeffrey
Query Analyzer Error Unable To Connect Server Local Msg17, Level 16,state 1/ODBC SQL Server Driver [DBNETLIB]SQL Server Does Not
Oct 20, 2007I am getteing
need help
Query analyzer error Unable to connect server local Msg17, level 16,state 1
ODBC SQL server driver [DBNETLIB]SQL server does not exist
Can't Connect .Net Application From Windows Server 2003 To Database Server (SQL Server 2000)
Apr 3, 2008Hi,
I am having a problem connecting my .net applications from the application server to the database server. When I run the application from my windows xp (sp2) box it works fine. When I try to connect via SQL Management Studio to the database server from the application server I get the same error.
Here is the error:
System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Here is the Environment:
App Server:
Windows Server 2003 Standard Edition
Inside Company's Firewall/ Network
Database Server:
Windows Server 2000 Advanced Edition
SQL Server 2000 SP4
Remote Connections to the Server is checked
Enable Protocols: Named Pipes & TCP/IP
TCP/IP Port: 1402 (I don't know why it isn't the default of 1433)
The db server is sitting out side the Company's firewall (don't ask me why). I can access it fine from inside the firewall on my XP box but not from windows server 2003. There is a web server outside the our network that also connects to the db server with no problem and that is running Windows Server 2003 Web Edition.
I can ping the db server from the app server using the IP address.
I tried using the IP address and the port 1402 in my connection string but that didn't work from any machine (XP and Server).
I imagine the issue is somehow related to the company's firewall but why would it only block Windows Server 2003 and not XP?
What do I tell the network admin to change?
Any help would be appreciated.
Thanks,
Oran
SQL Server 2008 :: Restoring A Database / Server Using A Remote Server As The Service Call?
Jan 4, 2013if you can restore a database to Server B using Server A as the service. Meaning we would issue the command on Server A but somehow point to Server B as where we want the restore to happen.
The backup file would be in a location independent of both servers.
Help! SQL Server Error - [Microsoft][ODBC SQL Server Driver][SQL Server] Invalid Object Name ...
Jul 23, 2005Dear all,On Win2000 server with SP3, I am trying to access a SQL Server 7.0database, "TestDB", from VB6 via a SQL Server ODBC system DSN using ADO2.7. In SQL Server Enterprise Manager, there is a login named "Tester".In its property window, NO "Server Roles" was assigned but its"Database Access" was set to "TestDB". This login was also made as theuser of "TestDB" with "public", "db_datareader" and "db_datawriter"selected as its "Database role membership". All the tables I am tryingto access in "TestDB" were created under "Tester".My code is like:Set conn = New ADODB.Connectionconn.Open "DSN=TestDSN;UID=Tester;PWD=test"Set cmd = New ADODB.Commandcmd.ActiveConnection = conncmd.CommandText = SQLset rs = cmd.Execute()If I set the SQL to something like "SELECT * FROM tbl_test", I alwaysget an error of "-2147217865" saying "[Microsoft][ODBC SQL ServerDriver][SQL Server] Invalid object name tbl_test". If I set the SQL to"SELECT * FROM Tester.tbl_test", everything runs properly. Could anyoneplease kindly advise why the first SQL is not working? Or in otherwords, why must I prefix the table name with its owner while the DBconnection is already made under that owner name? Thanks in advance.Tracy
View 10 Replies View Related