when you install SQL Server 2005 it creates a series of groups on the windows server, these groups are provisioned into the SQL Server instance. Add your windows account to...

Why have you added these options?

/execute /nopae...

This is nothing to do with AD. Check your DNS server and more specifically, your reverse lookup zone for that subnet, it'll probably be in there!!

Hi

sorry, my bad. I had posted the same link twice but have corrected that now. Right click the link and download the file before trying to open!!

Sorry,...

That would be something wouldn't it.

SQL Server is managed in the same way you would manage a normal instance of SQL Server, what changes is the complexity of the...

This is a misconception, a cluster is either Active\Active or Active\Passive!

Chris Kitchen (11/4/2010)

---

The bit where I am confused is running setup.exe to "Add Node".

1.

Can...

K. Brian Kelley (11/4/2010)

---

Likely that user is a member of a group that is either a member of the Administrators or Power Users group on the system where SQL Server...

Have you tried a recompile of the procedure on the server where it takes time to execute, could be a bad cached plan.

Ahh, OK. Definitely check the network response and stability between the VM and the physical node too if you can.

Do you have access to the VI client? You can create rules regarding VM movement when DRS is enabled on the ESX cluster

Hi

What makes you think it's VMotion, do you supsect manual or automatic VM movement?

One thing to check would be the network stack between the physical and virtual networks, any issues...

Public is already an inherited role for all users. Try the following

exec sp_msforeachdb 'use [?];

create user [domain\user];

exec sp_addrolemember ''db_backupoperator'', ''domain\user'';

exec sp_addrolemember ''db_denydatareader'', ''domain\user'';'

Ignore output messages indicating the database user...

yes!

add them to the model database on that instance