Correct "DATABASE" is an obfuscated value for the true user database name.

As this is an SSIS package which runs via an agent, the connection manager is setting the initial catalog...

I didn't think so either...

...unless the first 10 second was trying...

You could build logic into the script, but theres no way to get a user to press a key to continue unless you wrote it in some sort of application.

Something...

Nope not checked the DNS client as of yet.

Guessing it has something to do with the mirroring connection timeout being set to 10, but the connection string is 30, so...

Depending what the value is in config manager depends on what your URL is.

If the URL is reports_dmb the URL would be dmb_reportserver\reports_dmb

There wouldn't be a dmb_reportserver\reports which is why...

It's completely random to which app/job/package and what time is also random.

Today's example was a job which runs every 30 minutes, 10:00 Success, 10:30 failed, 11:00 Success and...

So you want to change the SSRS database name from ReportServer at migration phase also?

If so you will need to do some SOAP API calls to the 2008 SSRS box...

Anyone ever encountered this problem I'm seeing on a clients system?

http://www.sqlservercentral.com/Forums/Topic1727739-391-1.aspx

Can't figure out whats going on.

Last time I used FogLight, I had to get someone from Quest to install it as the installer and configuration was so complex and buggy the engineers did all the...

Bit of further reading up on mirroring, if using the Native Client and not specifying the failover partner property on the connection string (which isn't happening here) the native client...

Stingray

Aqua

This link should detail everything you need https://msdn.microsoft.com/en-us/library/ms143747(v=sql.120).aspx

http://blogs.msdn.com/b/sqlexpress/archive/2005/05/05/415084.aspx

https://msdn.microsoft.com/en-us/library/aa337562(v=sql.100).aspx

elmnas (10/14/2015)

I have...