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

accing to shered volumes

Roy Goldhammer wrote:
> Hello there
> I have local hard drive, which i can easy run xp_cmdshell 'dir c:'
> On the same computer i have shered Z: volume which is hard drive on anothe
r
> server
> How can i get list of all files on z by using xp_cmdshell 'dir z:' ?
>
xp_cmdshell '\\servername\sharename'
The mapping to drive Z: only exists under your login, not under the
login that the SQL Server service runs under. You also need to make
sure that the SQL Server service account has access to the share.Hello there
I have local hard drive, which i can easy run xp_cmdshell 'dir c:\'
On the same computer i have shered Z: volume which is hard drive on another
server
How can i get list of all files on z by using xp_cmdshell 'dir z:' ?|||Roy Goldhammer wrote:
> Hello there
> I have local hard drive, which i can easy run xp_cmdshell 'dir c:'
> On the same computer i have shered Z: volume which is hard drive on anothe
r
> server
> How can i get list of all files on z by using xp_cmdshell 'dir z:' ?
>
xp_cmdshell '\\servername\sharename'
The mapping to drive Z: only exists under your login, not under the
login that the SQL Server service runs under. You also need to make
sure that the SQL Server service account has access to the share.

accing to shered volumes

Hello there
I have local hard drive, which i can easy run xp_cmdshell 'dir c:\'
On the same computer i have shered Z: volume which is hard drive on another
server
How can i get list of all files on z by using xp_cmdshell 'dir z:' ?Roy Goldhammer wrote:
> Hello there
> I have local hard drive, which i can easy run xp_cmdshell 'dir c:\'
> On the same computer i have shered Z: volume which is hard drive on another
> server
> How can i get list of all files on z by using xp_cmdshell 'dir z:' ?
>
xp_cmdshell '\\servername\sharename'
The mapping to drive Z: only exists under your login, not under the
login that the SQL Server service runs under. You also need to make
sure that the SQL Server service account has access to the share.

accing shered volume

Hello there
I have local hard drive, which i can easy run xp_cmdshell 'dir c:\'
On the same computer i have shered Z: volume which is hard drive on another
server
How can i get list of all files on z by using xp_cmdshell 'dir z:' ?What account is SQL Server running as? It must have permissions to the Z:\
(typically this means you must set up SQLServer to run as a Domain\User as
opposed to a local user or built-in account).
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:eXbwFn7kGHA.3816@.TK2MSFTNGP02.phx.gbl...
> Hello there
> I have local hard drive, which i can easy run xp_cmdshell 'dir c:'
> On the same computer i have shered Z: volume which is hard drive on
> another
> server
> How can i get list of all files on z by using xp_cmdshell 'dir z:' ?
>
>

Accessing network drive from SQL Analyzer

Not sure if this posted or not before, so just in case, I'm doing it again.
I have SQL2000 on a Win2000 server. Using windows explorer, I have mapped a
network drive to letter "F"
While in SQL Analyzer, I'm trying to access "F" but I can't. I can access C
and D which are local drives, but not F.
If you are curious, I'm trying to access it by simply doing xp_cmdshell 'dir
f:'
Once this works, I'm planning to use a restore operation which we will read
from that drive.
Does anyone know how to access a mapped network drive from SQL Analyzer? It
will greatly appreciated.
thanks,
PPHi
Did you log onto the SQL Server using the SQL Server service account, map
the drive and then log off again?
If not, that is the way you should do it.
Generally, it is best to use UNC naming (\\machinename\sharename\) when
accessing resources over the network.
Backup and restores have to be done via UNC paths as mapped drives are not
supported for those operations.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"PP" <PP@.discussions.microsoft.com> wrote in message
news:422C6736-9887-450A-B83D-3F7A9B30799B@.microsoft.com...
> Not sure if this posted or not before, so just in case, I'm doing it
> again.
> I have SQL2000 on a Win2000 server. Using windows explorer, I have mapped
> a
> network drive to letter "F"
> While in SQL Analyzer, I'm trying to access "F" but I can't. I can access
> C
> and D which are local drives, but not F.
> If you are curious, I'm trying to access it by simply doing xp_cmdshell
> 'dir
> f:'
> Once this works, I'm planning to use a restore operation which we will
> read
> from that drive.
> Does anyone know how to access a mapped network drive from SQL Analyzer?
> It
> will greatly appreciated.
> thanks,
> PP

accessing mapped drive via xp_cmdshell

Hello,
I'm having problems accessing a mapped network drive. Basically, I
need to be able to access the g:\ drive from SQL Server (i.e.
master..xp_cmdshell 'dir g:\')
I created a share on my server (\\MyServer\ShareName) and mapped the
network drive G to this. So, from my machine I can do a "start, run",
and type in g:\, and get what I want to see.
However, when I run:
master..xp_cmdshell 'dir g:\
I get a message "The system cannot find the path specified."
I have the MSSQLSERVER account on this server setup to login as me.
Shouldn't this take care of any issues?
I would like to use a UNC share, but unfortunately I can't do that at
this time.
Much appreciate any ideas!
Sylvia
Try specifying the UNC path instead of a mapped drive:
EXEC master..xp_cmdshell 'DIR \\MyServer\ShareName'
Hope this helps.
Dan Guzman
SQL Server MVP
"Sylvia" <sylvia@.vasilik.com> wrote in message
news:1133830852.921653.231970@.g49g2000cwa.googlegr oups.com...
> Hello,
> I'm having problems accessing a mapped network drive. Basically, I
> need to be able to access the g:\ drive from SQL Server (i.e.
> master..xp_cmdshell 'dir g:\')
> I created a share on my server (\\MyServer\ShareName) and mapped the
> network drive G to this. So, from my machine I can do a "start, run",
> and type in g:\, and get what I want to see.
> However, when I run:
> master..xp_cmdshell 'dir g:\
> I get a message "The system cannot find the path specified."
> I have the MSSQLSERVER account on this server setup to login as me.
> Shouldn't this take care of any issues?
> I would like to use a UNC share, but unfortunately I can't do that at
> this time.
> Much appreciate any ideas!
> Sylvia
>
|||Thanks for the reply. Unfortunately using a UNC path is not an option
at this point, as I mentioned above (some hard-coded stuff already
written, can't change right now).
Any other options? Does a network share mapped to a drive just not
work?
Thanks,
Sylvia
|||> Thanks for the reply. Unfortunately using a UNC path is not an option
> at this point, as I mentioned above (some hard-coded stuff already
> written, can't change right now).
Sorry, I didn't understand that from your original post.

> Any other options? Does a network share mapped to a drive just not
> work?
A mapped drive can work but it is a kludge. One thing you might try is
establishing a persistent mapped drive. I expect you'll only need to do
this once, unless you change the SQL Server service account or unmap the
drive for that user.
EXEC master..xp_cmdshell 'NET USE L: \\MyServer\ShareName /PERSISTENT:YES'
Hope this helps.
Dan Guzman
SQL Server MVP
"Sylvia" <sylvia@.vasilik.com> wrote in message
news:1133845592.917117.66320@.g43g2000cwa.googlegro ups.com...
> Thanks for the reply. Unfortunately using a UNC path is not an option
> at this point, as I mentioned above (some hard-coded stuff already
> written, can't change right now).
> Any other options? Does a network share mapped to a drive just not
> work?
> Thanks,
> Sylvia
>
|||That did it! Thanks much - it's just the kludge I needed to get past
this.

accessing mapped drive via xp_cmdshell

Hello,
I'm having problems accessing a mapped network drive. Basically, I
need to be able to access the g:\ drive from SQL Server (i.e.
master..xp_cmdshell 'dir g:\')
I created a share on my server (\\MyServer\ShareName) and mapped the
network drive G to this. So, from my machine I can do a "start, run",
and type in g:\, and get what I want to see.
However, when I run:
master..xp_cmdshell 'dir g:\
I get a message "The system cannot find the path specified."
I have the MSSQLSERVER account on this server setup to login as me.
Shouldn't this take care of any issues?
I would like to use a UNC share, but unfortunately I can't do that at
this time.
Much appreciate any ideas!
SylviaTry specifying the UNC path instead of a mapped drive:
EXEC master..xp_cmdshell 'DIR \\MyServer\ShareName'
Hope this helps.
Dan Guzman
SQL Server MVP
"Sylvia" <sylvia@.vasilik.com> wrote in message
news:1133830852.921653.231970@.g49g2000cwa.googlegroups.com...
> Hello,
> I'm having problems accessing a mapped network drive. Basically, I
> need to be able to access the g:\ drive from SQL Server (i.e.
> master..xp_cmdshell 'dir g:')
> I created a share on my server (\\MyServer\ShareName) and mapped the
> network drive G to this. So, from my machine I can do a "start, run",
> and type in g:\, and get what I want to see.
> However, when I run:
> master..xp_cmdshell 'dir g:\
> I get a message "The system cannot find the path specified."
> I have the MSSQLSERVER account on this server setup to login as me.
> Shouldn't this take care of any issues?
> I would like to use a UNC share, but unfortunately I can't do that at
> this time.
> Much appreciate any ideas!
> Sylvia
>|||Thanks for the reply. Unfortunately using a UNC path is not an option
at this point, as I mentioned above (some hard-coded stuff already
written, can't change right now).
Any other options? Does a network share mapped to a drive just not
work?
Thanks,
Sylvia|||> Thanks for the reply. Unfortunately using a UNC path is not an option
> at this point, as I mentioned above (some hard-coded stuff already
> written, can't change right now).
Sorry, I didn't understand that from your original post.

> Any other options? Does a network share mapped to a drive just not
> work?
A mapped drive can work but it is a kludge. One thing you might try is
establishing a persistent mapped drive. I expect you'll only need to do
this once, unless you change the SQL Server service account or unmap the
drive for that user.
EXEC master..xp_cmdshell 'NET USE L: \\MyServer\ShareName /PERSISTENT:YES'
Hope this helps.
Dan Guzman
SQL Server MVP
"Sylvia" <sylvia@.vasilik.com> wrote in message
news:1133845592.917117.66320@.g43g2000cwa.googlegroups.com...
> Thanks for the reply. Unfortunately using a UNC path is not an option
> at this point, as I mentioned above (some hard-coded stuff already
> written, can't change right now).
> Any other options? Does a network share mapped to a drive just not
> work?
> Thanks,
> Sylvia
>|||That did it! Thanks much - it's just the kludge I needed to get past
this.