locked
SSRS 2008 DB Script Create New DB RRS feed

  • 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!

     



    • Moved by Sean Jenkin Friday, May 27, 2011 4:20 PM (From:MSDN, TechNet, and Expression Profile and Recognition System Discussions)
    Friday, May 27, 2011 4:00 PM

Answers

  • 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/
    • Marked as answer by Challen Fu Friday, June 3, 2011 8:20 AM
    Sunday, May 29, 2011 6:56 AM

All replies

  • 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?
    Saturday, May 28, 2011 12:52 PM
  • 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/
    • Marked as answer by Challen Fu Friday, June 3, 2011 8:20 AM
    Sunday, May 29, 2011 6:56 AM