You get this error because sql server do not support backward compatibility, which means 2008/2008R2 Management Studio cannot connect to a higher version of SQL Server, it will be the...

Thanks Ron,

Yes i certainly have 4 SQL Server environments running right at my home on VMs, i feel it was enough to configure Clustering or such. I will follow up...

It would have been best if you posted the entire error message but by speculating what could be happening is that your SA account is usually in denied mode since...

You should not create a database and then try to restore, instead you should directly restore the database with NORECOVERY mode and finish restoring differentials and the last backup you...

I have seen this kind of behavior when i detach as someone and try to attach as someone else, also permission would be to a machine\user and machine name could...

I have run into this problem when the users had changed date/time while testing application and started getting "Cannot Generate SSPI context" using AD account, would this be the same...

Hi,

Preferably use domain service account on all 3 servers.

Hi,

I don't think there is a concept of database level clustering in sql server, clustering has always been on windows as parent and it has to be instance level clustering....

Hi,

This could have more than few speculations, usually it is necessary to have sql browser service to be running if you're using named instance if you hadn't uninstalled previous default...

Looks to be fine to me.

Make sure the mirroring is in "High Safety" - Synchronous mode, usually it is just in seconds the data is transferred from and to mirror so there is almost no...

Hello Everyone!,

I resolved this issue myself.

Whenever the server tried to make contact with exchange it was expecting the remote server to have host name instead of IP, something just barged...

any body has come across with this problem?

Thanks.