domain or local the account should be low permission. Setup will assign the correct permissions for the account when installing the system or when setting through SQL configuration manager

domain account...

what version\edition of VMWare are we talking?

if its VMWare server forget it for a production system. The point of clustering is to remove the hardware failure factor (not load balancing)....

database role best ways to go 😉

that's RTM not SP2, apply the service pack again and you should be golden

check the onepoint database recovery model as suggested already

your welcome Jason

as we have stressed already, just make sure resource is i the same place as master.mdf otherwise when you come to upgrade you could\will hit problems

IIRC the only time you get problems with upgrades after moving the master database is if the resource database is in a different location. That is why they need to...

its in BOL but here goes

open sql configuration manager and modify the startup parameters for that sql instance. The paramaters will look something like this

-dC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL...

up to you entirely really, tempdb is the one you should ideally relocate. Bear in mind if you do move master, where ever you put master.mdf the mssqlsystemresource.mdf and ldf...

dude i dont know what you're smoking but i'd sure like some LOL

dude madhu

BOL makes some assumptions here. Generally rebuild is used for corrupt installations of sql server and the restore of the system databases is standard routine, even then you may...

the following can be used to generate the scripts to grant execute on all SP's in a database if required

select 'grant execute on ' + s.name + '.' + o.name...

am i right in thinking you have rebuilt the system databases to a different collation but then trying to restore the original databases with the original collation?

madhu

what is the geographical location of your sql server?

feel the force Luke LOL