yeah.. I just deleted them and added back to the DNS...now when i do an nslookup from each server to a different one I see both the IP addresses for...

I am using the same names. The only difference is I added a new nic card to each server.

For my testing I have destroyed my entire cluster that I built and I am rebuilding the 3 node clustering with two network cards and when I am trying to...

But if they dont match does it mean the connections are still open by the end of my trace? The question came up because the dev team wanted to identify...

I think I figured out the issue..I had the perfmon running while the service account was being changed...I will restart the sql server service and check if that fixes the...

That query returns me zero records...I wonder the zeros got anything to do with the permissions of new SQLServer Service account that has been put in place of local system..please...

SQLRNNR I have just run the command as an administrator but I still see the zeroes for all the above perfmon counters. But I dont see any issues as of...

Thanks for the reply SQLRNNR..but would this require any service or server reboot? or would it affect any apps connected to the sql server right now if i execute the...

I am using SQL Server 2008 R2 X64 SE on Windows Server 2008 R2 EE.

one last thing is on my test environment I have the sqlserver services running under local system account (unlike our production env where I changed it to run under a...

Thanks for the info guys. Yes, I knew about the instant file initialization and I have already scheduled to implement it.

I never use percentage for autogrow. I only use whole numbers. Most of the times I use something between 200MB and 500MB, depending on what I think will be enough....

One last thing is.. is it mandatory to have 2 nic cards for each individual node when implementing sql clustering in sql server 2008 R2 EE X64bit on windows server...

I figured out the issue...Node C was newly built and the firewall was enabled...I disabled the firewall and am able to connect now from my laptop to sql instances after...

Ok, as I read that you have a default instance and a named instance. And that looks fine to me. I have two as well but am only showing one.

I'd...