Thanks Steve.

Will try your suggestion.

Regards

Rajan

Hi All,

Our company procured MS SQL Server 2008 R2 with 5 CAL. I installed MS SQL Server 2008 R2. How to ensure that only 5 CALs are used....

Thanks Perrry. Infact thats what my understanding after this incident. It might have been costlier though.

Regards

Govind

Hi Perry,

if you are saying the public network will initiate a failover of the instance, will it shut down the cluster itself ? or will it failover to the available...

Hi All,

Thanks for your reply.

Even i have the same understanding that the sql server should not go down due to network issues whether it is private or public....

Hi Anthony,

Thanks for your reply.

I found that it was virus. One of the users laptop was constantly probing all sql servers with sa login. I removed it from...

Hi,

I am also getting this error Error: 18456, Severity: 14, State: 8. + Login failed for user 'sa'. [CLIENT: 192.168.4.52], but the user is not accessing SQL Server directly. ...

Thanks anthony.

Regards

Govind

Thanks Gail for this article.

Since this db size is around 575 gb now, i need to know how long the Full backup should take in general? Currently it is...

Hi Jeff,

Thanks for your reply.

Yes. I am learning a lot after this issue. Infact my db was having FULL recovery model. I advised my boss to go...

Hi Friends,

I am facing an issue on reclaiming space from transaction log with my sql server 2008 with sp2. It grew up to 200 GB and running out of...

Hi Folks,

In cluster properties, it is showing "Kerberos Status: Access denied." it is throwing the below error :

Event id : 1207 - Network Name resource error

Cluster network name resource...

Hi All,

Thanks. I am able to connect from Client with CLUSTERNAME\instance_name.

Regards

Govind

Hi,

it is using dynamic port. Yes. I am not able to connect thru SSMS from client. I am entering servernameamedinstance for connection. The SQL browser is running...

Hi, Installed a sql server 2008 cluster. Could not connect from client machine to this named instance. It is listening to port no. 52096. Verified in the...