No, the server is not rebooting. The SQLAgent shows the below message and when we see this message, at that time the application is unable to connect sql server and...

But BOL says that you can configure the directory for Shared features for the first installation of SQL Server 2008 and you can not change it for the 2nd instance...

What are the steps to perform before disjoin the passive node from cluster?

Could you plz advice me. Thanks

Hi,

I went through the below link to add the newly build passive node and I want to have the steps to add the new node 2 the existing active node....

Could you plz advice me. Thanks

Yes, I can get the full path from the project solution. But I want to get latest rds file (data source) from Report Manager .i.e the way we can get...

Thank you Perry & Waynes,

I glance through the document, SQL Server 2008 Upgrade Technical Reference Guide, to see whether we can keep the same Virtual server name and SQL Server...

It wouldn't be possible to maintain your passive node as a passive node during the upgrade, I agree.

However, one idea might be to drop the passive node out of the...

Thank you,

The link helped and I'm able to get the rdl file from report manager.

Thank you very much!(':-)');

This is Share point content database and it MUST have only one file group (multiple file groups are NOT supported for Share point content database)

In this case, how can I...

Sqlbuddy,

The Procedure discussed here is emptying the file but where the data is going to?

I need to move the data from Secondary data file to Primary data file..and then delete...

Could you please advice!!

Thanks

Thanks Seth,

TCP Port 1433 is Open...

please...

On SQL Server 200 box, Is the remote connections need to enable on MSDTC? (Go to Start->All Programs->Component Services->Computers->My Computer->Right Click->MSDTC->Security Configuration)

In which case, we need to enable Network DTC...