Does anyone have any information on the trace flag 1903? I have been instructed to add it as a startup parameter and cannot find any information...
Thanks for all the replies... After much knashing of teeth I was able to figure it out. It turns out that a Local Domain Group can only assign...
A local domain group was created and added to an SQL 2005 instance. It was then given permissions to a DB. Users in this group cannot connect to the...
I heard a rumor the Mainstream support for SLQ 2000 was going to be extended beyond 4/2008. Has anyone else heard this? Can someone direct me to a...
Yes, all the instances do not have a min/max set. What would be the best way to handle?
Thanks, I used Perfmon to look at the memory usage and one instance is using most of the RAM. Can someone give me some insite on how I should...
I hve 4 instances running on one node of a two node cluster. When I look at task manager on the active node I see that one instance is using 5gb (of...
In the instructions to install SSIS on a cluster MS mentions creating an IP resource. http://technet.microsoft.com/en-us/library/ms345193.aspx "Add...
Thanks for the input. I need to move the System databases to another drive and per MS KB article I have to put the instance in single user mode in...
I have a named instance running on a cluster. The cluster service uses one account and the SQL service uses another. When I put the instance into...
Can I change the Private IP in the Cluster manager? Thanks
quote:1. added it to domain group that originally was used as group to set up cluster 2. added to local admin 3. added to sql as user ; make account...
The cluster service account does not need SA rights. It must have an account on ALL the instances in order to perform an ISALIVE check. Ref: MS KB
There is 4gb RAM and 2 processors. THe OS is Win 2003 server SP1. THanks
I have a cluster with 15 instances. None have had the min/max memory set. Should it? I was watching the memory usage and saw where one very active...
Thanks for the info, I'll have to see if I can find more in the book you mentioned....JC III
I am trying to find out information about the Extended stored procedure: XP_EXEC. I've just learned a vendor is calling it and I am concerned about...
I was doing some testing on the impact of the cluster account and removed it from an instance. Now the instance is offline and I cannot get it back...
I will be changing the private IP on a SQL 2000 clustered instance. I would prefer not to take the instance down if it is not necessary. I read...
I read the cluster service account needs to be in the public role at a minimum in a cluster environment. I removed the account from the instance...
Separate names with a comma.
