We only have one SQL Server instance on this cluster. My research suggests that 40-60% of resources should be left out for windows. However in this case its 25%.

well I am using windows 2003 server enterprise edition and sql server 2000 enterprise edition.

By the way I am now confused since John is suggesting i dont need to...

Ok here is my list of steps ... Please let me know what you think. Once we change the boot.ini file following steps would be taken

1 -...

What you just said makes sense. However my question was along the lines of what steps do I need to take to set AWE enabled in SQL Server.

After we...

Makes sense. Now we are planning to change the boot.ini file so we SQL Server can use upto 3 GB of memory.

I was wondering if there is anything I...

this is what I get when I run sp_configure 'max server memory (MB)'

name minimum     maximum     config_value run_value  

max server memory (MB)              4           2147483647  2147483647   2147483647

what does run value mean in this...

Paul

were you able to find a solution for this problem- "Cannot connect to the repository

" ? I am having exactly the same problem but having no luck with...

is the only way to give access to analysis service is to make the user part of olap admin group?

well not having luck with logging dts package. even though i enable it per following link http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_dts_pkgmng_6vqr.asp  . however per this link I should do the following

On the Package...

There is ample disk space available.

well I used the following and it works really well. All you have to do is replace the value in third line with what you are looking for... cheers

SET NOCOUNT...

that worked. interestingly i didnt see this command in the article I used to do point in time recovery.

is there good source with scenarios that I can refer to?

thanks

Eddie.. thanks for your input. Will let you know how I did.

Shahab

you happen to have notes or or if you would like to share your thoughts about the MCTS exam? thanks

Issue was that one the second node domain account under which sql server service runs was not part of the local admin group.