active/passive cluster with san drive

is there anywhere i can get a step by step order for
installing an active/passive sql2000 cluster on a win2k3
platform that shares an attached san drive. i have not
performed this before and am not sure about how to set up
the san drive. do i set up the disks on one or both
systems. or do i set up the disks on one and run the mscs
setup? any info would be appreciated. thanks.
jay
Strangely enough, BOL (Books On-Line) has a very good set of instructions on
setting up a failover cluster. You start with a working MSCS cluster
(Windows 2003 help files will get you started there).
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"jay mack" <jmack@.thecreek.com> wrote in message
news:00ba01c49c16$eb424960$a501280a@.phx.gbl...
> is there anywhere i can get a step by step order for
> installing an active/passive sql2000 cluster on a win2k3
> platform that shares an attached san drive. i have not
> performed this before and am not sure about how to set up
> the san drive. do i set up the disks on one or both
> systems. or do i set up the disks on one and run the mscs
> setup? any info would be appreciated. thanks.
> jay
|||Hello Jay,
You may find this whitepaper helpful for setting up windows 2003 cluster
Step-by-step instructions for creating and configuring a typical single quorum device multi-node server cluster using a shared disk on servers running the Microsoft Windows Server 2003 Enterprise Edition and
Windows Server 2003 Datacenter Edition operating systems.
http://www.microsoft.com/downloads/d...displaylang=en
For SQL Server 2000 clustering, the following Microsoft Whitepaper is good
http://www.microsoft.com/technet/pro.../failclus.mspx
This whitepaper was released before Win2K3 and does not discuss about it. Although most of the things are same for SQL 2K Failover cluster on Win2K3, here are some things that are different/unsupported:
Installation of a Named Instance of SQL Server 2000 Virtual Server on a Windows 2003-Based Cluster Fails
http://support.microssoft.com/?id=815431
SQL Server 2000 Cluster Does Not Install on Windows Server 2003-Based Computers Where Terminal Services Is Installed
http://support.microsoft.com/?id=301520
SQL Server 2000 Is Not Supported on Windows Server 2003 Terminal Server Application Server
http://support.microsoft.com/?id=327270
Virtual SQL Server 2000 Installation Fails on Cluster That Has Eight Nodes
http://support.microsoft.com/?id=811054
SQL Server 2000 support for mounted volumes
http://support.microsoft.com/?id=819546
HTH,
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

Active Directory and SQL 2000 clustering on W2003

Is this true that Active Directory is needed in order to cluster the SQL2000.
I have 2 Dell 6000 series with a shared Dell RAID...
Any articles or links to see how can I set this up correctly?
You need a domain, NT 4.0, 2000 or 2003. AD is not needed.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
"Eugene Borukhovich" <macroscape@.yahoo.com> wrote in message
news:41df378d.0408191658.1d36e56d@.posting.google.c om...
> Is this true that Active Directory is needed in order to cluster the
> SQL2000.
> I have 2 Dell 6000 series with a shared Dell RAID...
> Any articles or links to see how can I set this up correctly?
|||You do not need active directory for SQL Server 2000 Clustering on W2K3. You do need the nodes of the cluster to be members of the same domain.
Here are some links that you may find useful. These will help with the requirements of Windows and SQL Clsutering, step by step installation, what it can do and what it cannot do, troubleshooting etc.
Step-by-step instructions for creating and configuring a typical single quorum device multi-node server cluster using a shared disk on servers running the Microsoft Windows Server 2003 Enterprise Edition and
Windows Server 2003 Datacenter Edition operating systems.
http://www.microsoft.com/downloads/d...displaylang=en
SQL Server 2000 Failover Clustering
http://www.microsoft.com/technet/pro.../failclus.mspx
There are few things different for clustering SQL Server 2000 on Win2K3 and the foll. KBs are useful
Installation of a Named Instance of SQL Server 2000 Virtual Server on a Windows 2003-Based Cluster Fails
http://support.microssoft.com/?id=815431
SQL Server 2000 Cluster Does Not Install on Windows Server 2003-Based Computers Where Terminal Services Is Installed (Has better info than 327270)
http://support.microsoft.com/?id=301520
SQL Server 2000 Is Not Supported on Windows Server 2003 Terminal Server Application Server
http://support.microsoft.com/?id=327270
Virtual SQL Server 2000 Installation Fails on Cluster That Has Eight Nodes
http://support.microsoft.com/?id=811054
SQL Server 2000 support for mounted volumes
http://support.microsoft.com/?id=819546
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||So w/o actually reading through all the links yet and to confirm that
there is no dependencies on the AD at all. When you say "domain" - can
it be a workgroup?
this will be in a highly secure environment, so i dont want any AD nor
these SQL servers even joining the AD.
Thanks, Eugene B
|||Clustered SQL Servers must have a common security context. This means they
must be member servers of an NT4 or AD domain. A common workgroup will not
work.
I am concerned that you see AD as a security problem rather than a solution.
Perhaps your system administrators do not fully understand how to implement
AD in a highly secure environment.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Eugene Borukhovich" <macroscape@.yahoo.com> wrote in message
news:41df378d.0408250542.71ac947e@.posting.google.c om...
> So w/o actually reading through all the links yet and to confirm that
> there is no dependencies on the AD at all. When you say "domain" - can
> it be a workgroup?
> this will be in a highly secure environment, so i dont want any AD nor
> these SQL servers even joining the AD.
> Thanks, Eugene B
|||You can't have it on a workgroup. It must be on a domain - AD or NT. If
you really want security, then you'll have to put it within its own forest
and set up a one-way trust.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Eugene Borukhovich" <macroscape@.yahoo.com> wrote in message
news:41df378d.0408250542.71ac947e@.posting.google.c om...
So w/o actually reading through all the links yet and to confirm that
there is no dependencies on the AD at all. When you say "domain" - can
it be a workgroup?
this will be in a highly secure environment, so i dont want any AD nor
these SQL servers even joining the AD.
Thanks, Eugene B
|||Hi ,
I am trying to install cluster SQL2000 on a WIN2003MSCS. Are there any
links to step by step procedure. Install on a WIN 2000 is quite
different.WIN 2003 cluster service is setup and running. Any
documentations on a SQL virtual server setup will be much appreciated.
Thank you
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||There are few things different for clustering SQL Server 2000 on Win2K3 and the foll. KBs are useful
Installation of a Named Instance of SQL Server 2000 Virtual Server on a Windows 2003-Based Cluster Fails
http://support.microssoft.com/?id=815431
SQL Server 2000 Cluster Does Not Install on Windows Server 2003-Based Computers Where Terminal Services Is Installed (Has better info than 327270)
http://support.microsoft.com/?id=301520
SQL Server 2000 Is Not Supported on Windows Server 2003 Terminal Server Application Server
http://support.microsoft.com/?id=327270
Virtual SQL Server 2000 Installation Fails on Cluster That Has Eight Nodes
http://support.microsoft.com/?id=811054
SQL Server 2000 support for mounted volumes
http://support.microsoft.com/?id=819546
How to Configure Microsoft Distributed Transaction Coordinator on a Windows Server 2003 Cluster
http://support.microsoft.com/?id=301600
How to enable Network DTC access in Windows Server 2003
http://support.microsoft.com/?kbid=817064
HTH,
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

Active directory

Hie,
Someone can tell me haw can i do in order to migrate my server sql to active directory.
What is the stepThere really isn't a "one size fits all" process. Check the Microsoft documentation on Active Directory migration. There is a whole chapter on migrating SQL Servers to Active Directory, but keep in mind that you probably only have to do a small part of everything listed there.

-PatP

Active /Pasive vs Active/Active

Hi,
we have 2 node Active/pasive cluster system, and thinking to convert it to
active/active. In order to determine all pros/Cons I'm trying to find out all
comparison issues.
Any article,comment on this, will be appreciated.
Thanks
Banu
With instances in SQL Server 2000, come two new concepts for failover clustering:
* Single instance cluster: replaces an active/passive cluster. A single instance cluster means there is one SQL Server 2000 virtual server installed.
* Multiple instance cluster: replaces an active/active cluster. A multiple instance cluster is one in which there is more than one SQL Server 2000 virtual server installed. Because of the way the implementation of
clustering is different with SQL Server 2000, using the active/active terminology does not really apply.
Here is some info that you may find helpful
Single-Instance Cluster
A single-instance cluster has only one active instance of SQL Server owned by a single server node, and all other nodes of the cluster are in a wait state. Another node is enabled in the event of a failure on the active
node, or during a manual failover for maintenance.
Multiple-Instance Cluster
A multiple-instance cluster has up to four server nodes and supports up to 16 instances (1 default, 15 named or 16 named). Each SQL Server 2000 virtual server requires its own disk resources that cannot be used by
other instances. These disk resources are the logical drive names (for example, drive F:\) used by SQL Server on which to store data and log files. Separate physical disk sets are needed to make up the logical
drive, unless your disk subsystem supports multiple logical drives on one physical drive set. SQL Server in a clustered environment also behaves differently from a stand-alone named instance in relation to IP ports.
During the installation process, a dynamic port that may be something other than 1433 is configured, and that port number is reserved for the instance.
For additional information, refer to
Microsoft Whitepaper - SQL Server 2000 Failover Clustering
http://www.microsoft.com/technet/pro.../failclus.mspx
Specifically read the following sections in the whitepaper
* Memory Configuration
-This section presents considerations for memory usage in a SQL Server 2000 failover cluster.
* Processor Capacity
* Using More Than Two Nodes
HTH,
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

Accessing to another server

Hello there
I have two databases, on two diffrent servers, connected to the same
network.
In order to use them both I:
1. create registry to both servers on the same enterprize manater
2. Set them as remote server on two sides.
Now when i'm trying to access to one server when connecting to other server,
it being connected as Guest. And i would like to access to another server as
Admin, or other user.
How can i do that?Roy
Have you read about Linked Servers?
"roy goldhammer" <roy@.hotmail.com> wrote in message
news:eOinwRG%23FHA.740@.TK2MSFTNGP11.phx.gbl...
> Hello there
> I have two databases, on two diffrent servers, connected to the same
> network.
> In order to use them both I:
> 1. create registry to both servers on the same enterprize manater
> 2. Set them as remote server on two sides.
> Now when i'm trying to access to one server when connecting to other
> server, it being connected as Guest. And i would like to access to another
> server as Admin, or other user.
> How can i do that?
>|||Is there diffrenct between linked server and remote server?
' 03-5611606
' 050-7709399
: roy@.atidsm.co.il
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OFMRt3J%23FHA.1032@.TK2MSFTNGP11.phx.gbl...
> Roy
> Have you read about Linked Servers?
>
> "roy goldhammer" <roy@.hotmail.com> wrote in message
> news:eOinwRG%23FHA.740@.TK2MSFTNGP11.phx.gbl...
>|||Roy
By creating Linked Server you will be able to query this (remote)
server like SELECT <> FROM Servername.DataBase.dbo.Table WHERE...
By registering a remote server via EM you can olny view a data if you have
an appropriate permissions
One thing I'd like to mention is you can use OPENROWSET command to query
remote server without creating linked server on it.
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:eri9hfL%23FHA.160@.TK2MSFTNGP12.phx.gbl...
> Is there diffrenct between linked server and remote server?
> --
>
>
> ' 03-5611606
> ' 050-7709399
> : roy@.atidsm.co.il
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OFMRt3J%23FHA.1032@.TK2MSFTNGP11.phx.gbl...
>

Accessing sys.syslockinfo from an application role

In SQL Server 2005, you must have the VIEW SERVER STATE permission in order to access sys.syslockinfo (http://msdn2.microsoft.com/en-us/library/ms189497).

It seems that the VIEW SERVER STATE permission can only be granted to users.

Once you execute sp_setapprole, the connection loses the permissions of the user and assumes the permissions of the application role (http://msdn2.microsoft.com/en-us/library/ms190998).
So, how can I access the sys.syslockinfo view while using an application role?
Note: I have to maintain compatibility with SQL Server 2000

Here are two ways to allow an application role access to syslockinfo:

a) Create a signed stored procedure that exposes syslockinfo and grant execute on it to the application role. An example of procedure signing has been presented in the following post:

controlling security through stored procedures -- 2005 behaviour

b) Grant VIEW SERVER STATE to public.

Thanks
Laurentiu|||

Thanks for your help. I see that they just added this knowledge base article: http://support.microsoft.com/kb/906549, which has another example. Did you write the kb article?

|||Thanks for posting the KB link, this is recent indeed. No, I didn't write that article but I see it's a complete description of the solution I mentioned as (a). Let us know if you have any trouble with that solution.

Thanks
Laurentiu|||Their example works great for syslogins and sysprocesses. However, it doesn't work for syslockinfo.

This is the error message:
The user does not have permission to perform this action.|||Nevermind, I think there was just something wrong with my install. I reinstalled, and now it is working. Thanks again for your help.