Well not really, I was just using it as a way to join the tables.

Regards,

D.

Hello, yes I need both windows and sql logins, I have found the sys.database_principles.

Regards,

D.

Hello,

Thanks for getting back, I understand that there is a duplicate key and it needs removing, the problem is I am not sure how to do that, or where to...

Thanks, that's a really good post.

Regards,

Paul.

Thank you, Gail.

I will read the link right away, thank you for that. In regards to...

That's a problem right there. That needs to be set on 64-bit, doubly so if...

Firstly, a big thank you to everyone that has replied. I have 3 64bit servers, two of those servers have a 2 to 3 instances on them and are maxed...

Hello, thanks for getting back. Well I had looked through the script, but your comment made me look again and I noticed this time (after a nights sleep) that the...

Have you tried applying the new SQL 2008 R2 Service Pack, I think its still at the beta stage at the moment, but ready for download.

Regards,

D.

I didnt, in the end we didnt go for a cluster, so it didnt matter in the end.

Regards,

D.

Hello,

Probably a silly question, but whereabouts do I run that command?

Regards,

D.

Hello,

Yes, I'm going to do that, I thought I would wait and see if anything came back from my other reply just a precaution.

Thanks,

D.

Hello, thanks for getting back.

Its pointing to

D:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\ReportingServicesService.exe"

Dont understand why (or how) its starts. I hope it does not interfere with the new default install of RS....

Nice, thanks Gail. Have good weekends everyone!

Kind Regards,

D.

Thanks for replying Guys, the only thing I changed was the page verify from Torn, to checksum, but changed it back to torn again. Does that make a difference? I...

Thank you for the replies. The users all have their own workstations so I dont think I need to worry about the machine licence. Thanks again!

Regards,

D.