That article makes sense, thank you 🙂

Kwisatz78 (2/18/2013)

---

I just did a quick read of this:

http://msdn.microsoft.com/en-gb/library/hh213080.aspx#CreateAddiitListener

However if using 2 static IPs of different subnets and you use the listener name in your connection string, then...

I never knew what those icons meant before! Thanks for your help.

Its the 2 computers with the script.

I think I know what you're going to say next - group policy is preventing a change?

I actually started with transactional but then I got worried about identity ranges so I switched to merge instead to utilize the automatic identity range management. Log shipping is more...

Chris,

Some great info there, thank you. The 20k deletes was just to remove the test data, its not something that would occur regularly in the live environment. The normal workload...

Chris,

Thanks for the reply. I can do what you suggest and everything will work fine. My problem is I deleted over 20,000 records from two tables in the publisher....

I've had enough with this issue now, I've decided that I will just enable the http URL when I need to manage this server. That will have to do.

I've got this warning message in the Application Log:

The value for UrlRoot in RSReportServer.config is not valid. The default value will be used instead.

There is nothing significant in the log...

I just tried with the URL, still no luck 🙁

EDIT: My configuration had a https URL only. I added a http URL to the configuration and now I can...

No better place to start 😀

The service is definitely started, I can connect through the browser and run reports no problem.

That looks like it would fit the bill perfectly. I'll be checking it out later on.

Thank you yann_nguyen 😀

Has anybody any thoughts on this at all?

I find it very surprising that 1) SCD does not cover records that have been deleted at the source and 2)there does not...

Ok I was thinking about this in the wrong way. All I had to do was create a variable for my folder name, then use this variable in an expression...

Thanks Samuel. I purchased Professional SQL Server 2005 Integration Services by Brian Knight at the weekend and I've gone through the first few chapters today. I will take a look...