quorum is a separate resource to the SQL Server instance group and wont necessarily fail over with the SQL Instance unless the active node dies.

not with virtual machines 😉

hamidi 97216 (5/8/2010)

---

now i could succeed to pass the check and u caused it. i'm really grateful.

now i think i don't need StarWind at all. i may uninstall it as...

Clustered!!

This is a Windows 2003 cluster and so will support ESX shared HDD's \SCSI bus!

The OP barely has the skills to add a shared virtual HDD let alone deploy a...

The virtual disk you are sharing needs to be attached to both VM's. Create a single HDD on each VM and use SCSI 0 as the controller, this will be...

then add the shared HDD to both VM's and share the SCSI bus on each VM accordingly

bad idea, consult your domain administrator and see if they are able to help you

😉

Are both VM's on the same host?

Bryan

the script that George mentions is probably the best way to generate create login scripts.

Your script has NULLs because the script is pulling Windows logins (which have no password)...

under what context does your sql server service run user account or local system?

hey, you're welcome!

to rename a files logical name you need to use the following

Get the logical names for your chosen database using

select f.name from sys.databases d

inner join sys.master_files f on d.database_id...

ColeTrain (5/1/2010)

---

Hello, I'm having issues creating two stored procs. I would like to create one that creates and resets the password for a defined type of user on the system....