I have noticed one other problem as well, running on SQLTEST02.

After switching Reporting Services to run on SQLTest02 and connecting to it using one of my DNS entries:

- sqltestrs/reports

...

Hi Brian.

I've checked both servers are using configured for Kerberos, both SQLTest01 and SQLTest02 return the following NTAuthenticationProviders:

I have some more...

Hi Brian,

Great article - Thanks.

I'm having a few issue getting this working however (although I had it working earlier this morning, I've now broken it - not sure how). ...

Thanks Vishal.

I've been working on it for the last few days, and my it working, by using the impersonate windows account, having set up the required Service Principle Names against...

What does the SPN do?

(i'm seeing alot of SPN and Kerberos related articles on the web) I'm not a network guy - so I'm not quite sure why this...

Hi

Just tagging on to this thread, I'm having an issue with reporting services.

I have a data source which I want referencing via a DNS Entry as the database is...

For those of you interested, I've submitted an article about this (more of a how to guide really), which focusses around SQL Server Standard edition. It will be...

that sounds like it's not picking up your passed servername variable or it can't find the server

First off, if you haven't already done it, create another package with a...

Hi

Looking at your error, I say it's either your variable is defined or your server connection string blank - possibly as a result of the variable not being mapped...

Ok. So is this just a bug then - as I can't view the copy only backups when selecting a backup device?

YES!!

I confessed it crossed my mind whilest working on something else, but I dismissed it, as I didn't think that it would discriminate COPY_ONLY backups (I couldn't think of...

thanks I'll check it out

Couple of things in reply to the posts above

1. I've tried googling the problem and can't seem to find any relevant results (maybe it's the search string I'm using),...

ain't that the truth! 😀

Thanks again for your help.

It's a package that evolved, which is where I think i managed to mix up the variables a little.

I can't understand how it worked for...