Have not gotten a direct answer to this yet, but it did not seem to cause any issues.

Since we do not have a SQL Cluster, and are just...

Hello,

I believe, if I understand your setup correctly, that parameter wouldn't be needed.

If you had two different locations, site A and site B, the listener would have an IP address...

Thank you all for the replies.

The applications connect to a middle man home grown application that then sends the T-sql queries to production... so 85% of the queries all come...

Hi,

I'm actually the DBA, only been with the company for a few months and they've never had a DBA before so it's a lot of politics.

As I said, I'm trying...

Hello,

As Suresh pointed out, this role is in the MSDB database.

You don't assign it from each specific database, you just assign it from the MSDB database, so you...

Thank you for the reply.

We do have that enabled for our backups, I wasn't sure if this restore labelonly was related to the backups.

Currently that restore labelonly is running, as...

The Network admin updated some software and firmware on the server and everything is working now.

Thank you for all the replies!

Thank you both.

Our network/System Engineer is looking into both the network and will double check the permissions.

I recently had some issues with this and had to also download the 2007 Office System Driver: Data Connectivity Components .

Not sure if this will fix your issue but thought...

Thank you!

I just wanted to double check since you know what they say about assuming.

Finally got this all fixed.

Some of the reports had been built and setup to utilize SharePoint (on a server with Native Report Server)

Then someone changed the execution account password within...

Thank you again for your replies to this!

I believe I have convinced them that the most logical way of moving forward will be to utilize the existing Report Server database...

Call me puzzled but I ask myself the same question. The original request was just to upgrade from 2008 to 2008 R2 and add the SharePoint integration.

I...

Thank you so much for your reply.

I actually didn't need to uninstall the inactive SQL Server 2008 R2 instance. It turns out that during the failed upgrade the web...