Question regarding configuration of an Active/Active cluster

Hey. I've a Active\Active with SQL 2000 on the nodes right now. I've to migrate to SQL 2005 and needed some help regarding using accounts.

Should I use the same account for the cluster service and the SQL Server/Agent service? If not what are the permissions I've to give to the cluster service account in SQL? I've a cluster with 2 nodes. What permissions should the SQL account be given on the box? Should it be a local admin or when installing, I give it the account and let SQL worry about giving permissions to the box? Thank you.

Tej,

According to MS:

- You should have different accounts for the cluster and SQl. Reason for this is that if the cluster account password changes, it does not affect SQL.

- You should create these account as normal domain user accoounts , but give them admin privileges on the SQL servers. When installing/configuring SQl and cluster services, these accounts will be given the correct permissions.

Check out this document

www.windowscluster.com/msdocs/confclus.doc

Question regarding configuration of an Active/Active cluster

Hey. I've a Active\Active with SQL 2000 on the nodes right now. I've to migrate to SQL 2005 and needed some help regarding using accounts.

Should I use the same account for the cluster service and the SQL Server/Agent service? If not what are the permissions I've to give to the cluster service account in SQL? I've a cluster with 2 nodes. What permissions should the SQL account be given on the box? Should it be a local admin or when installing, I give it the account and let SQL worry about giving permissions to the box? Thank you.

Tej,

According to MS:

- You should have different accounts for the cluster and SQl. Reason for this is that if the cluster account password changes, it does not affect SQL.

- You should create these account as normal domain user accoounts , but give them admin privileges on the SQL servers. When installing/configuring SQl and cluster services, these accounts will be given the correct permissions.

Check out this document

www.windowscluster.com/msdocs/confclus.doc

Question re: SSIS "Script Task" + VB.NET keyboard configuration

I was pretty excited when my first script ran in this type of task. But I soon noticed that I couldn't find the "watch" or "immediate" windows I was used to in standard VB.NET. Did I miss them or are they simply not available in the Script Task editor?

TIA,

barker

P.S. Also under the VB.NET environment, I can Import the VB.NET default keyboard settings (e.g. Step Into is F8; Step Over is Shift+F8) into the IDE. Is the same option available for the Script task editor?

They are just not visible by default. After you hit the breakpoint you can go to the menu "Debug>>>Windows>>Locals" for example.

The script task editor is just VS wired up for VSA and VB.net. So you should be able to accomplish this though I admit I have not explored that. I know I have re-assigned my own hot keys to things via "tools>>options>>keyboard"

sql