SSRS 2008 DB Script Create New DB

Question

Need to know how to manually create SSRS 2008 DB.  The tool doesn't allow you to generate a script as in 2005.  Our DB team manages all DB's. They create the blank DB and we have to provide the creation script to them.  I also need to know all permissions that are required for the connection account to the DB.  Thanks!

 

Answer 1

Need to know how to manually create SSRS 2008 DB.  The tool doesn't allow you to generate a script as in 2005.  Our DB team manages all DB's. 

Can you please be specific? I am not sure if I understand you. Can't you just use SQL Server Management Studio to create a database and instead of hitting "ok", script the database out and sen tit to your team?

Answer 2

Do you want SSRS runs script to create a database/db objects? I have doubts that is the purpose of SSRS at all.

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/