One more thought that I had Alicia.

If your Active Directory is being backed up, depending on the backup software you are using, it may be possible to perform a single...

Do the login(s) which you are using to connect your linked server have permissions for the new database?

Hi Alicia,

By default the BUILTIN\Administrator group (which maps to the local Windows Administrator group on the server running Reporting Services) has Content Manager rights on the Report Server from the...

I feel that this is highly unlikely.

Log Shipping is an established and mature technology which people like for its simplicity and effectiveness.

It works well, people use it and it probably...

Hi Mark,

Try taking a look on the report server at the data source which the reports are using.

Are the credentials stored there ok or does the password need to be...

By default remote connections should be enabled anyway on everything except Developer Edition, so it is surprising that you needed to configure that.

That should be all you need to do...

So if the full name of the clustered instance is MYSERVER\INST1, then the name that you have to feed the configuration tool is MYSERVER (in other words the name of...

Hi Premkuttan,

Whether a standalone instance or a clustered instance, in SQL Server 2005 remote connections are enabled \ disabled through the Surface Area Configuration tool, under the Surface Area Configuration...

I agree with Gail.

I believe that in SQL Server 2000 it was necessary to be a member of the sysadmin role in order to use Profiler.

In SQL Server 2005 onwards,...

Hi James,

Forgive if I am stating something which you have already considered, but I would say that an important point here is licensing.

If you have all components installed on one...

Hi,

I think that you should be able to run Profiler if you are just given the "Alter Trace" permission.

You do not need to be a SysAdmin.

Hope that helps.

Hi,

Are you using SQL Server Developer edition by any chance?

Have you confirmed that the SQL Server Browser service is running?

The SQL Server log should give you some clues, take a...

Hi John,

Welcome to the forums.

If you have separate servers running SQL Server Reporting Services then yes, these will need to have SP3 installed on them too.

Not sure if you will...

How about installing Microsoft Virtual PC?

That way you can keep Vista on your laptop and install Windows Server and SQL Server into a virtual machine.

Hi Dana,

I think the best time to set the max memory would be between step 1 and 2.

Then as the instance is failing over to node 1, the updated configuration...