will do. thanks.

absolutely. This is one possible scenario, but for me, the most appropriate.

Worth saying as well, that we use dns entries in our connection strings to the active report server...

Article is now published for anyone interested:

http://www.sqlservercentral.com/links/488664/150471

😀

Hi Vinesh,

yes I think I did.

Apologies, I thought I had actually posted a reply, but apparantly not 🙂

I found that if you are trying to connect to...

Hi Vinesh,

I have test the connection for connections that do not use Windows Authentication and found 2 things:

1. Despite that fact that you are specifying the servername in the...

Not sure if your familiar with it, but Microsoft have a best practice example for data warehouse / ETL called Project Real.

Worth a read.

Hi Vinesh,

I can't seem to open the bitmap image. Could you try to PM it me. thanks.

Also, is the user account you refer to a windows domain account?

or...

hi Vinesh

First off I'll clarify the bug: if you try to set the ServerName property, using an expression it doesn't work. (this is what I initially tried, but...

I believe it is.

I was directly updating the field enabled in the table msdb.dbo.sysjobs, setting it to 1 or 0, depending on whether I wanted to enable it or not....

excellent 😀

that'll take the guess work out of it.

So it is a case of randomly coming up with a port number then.

Apart from the odd bit of software, like SQL default and http services, I not sure what...

Thanks,

but I need to what port numbers I can use.

I've now resolved the issue.

For anyone else who has issues configuring Kerberos authentication, take a look at this white paper, which helped me to get to the bottom of my...

Hi brigitte,

It sounds like you are going along the right lines, but I think you may be missing the step of deleting the report server instances in the report...

I hope so, I recently got a status update, saying that it had been accepted, but not yet scheduled for publication.