GenerateDatabaseCreationScript Method (WMI MSReportServer_ConfigurationSetting)

Generates a SQL Script that can be used to create a report server database.


Public Sub GenerateDatabaseCreationScript(ByVal DatabaseName As String, _
    ByVal Lcid As Int32, ByVal IsSharePointMode As Boolean, ByRef Script As String, _
    ByRef HRESULT As Int32)
public void GenerateDatabaseCreationScript(string DatabaseName, Int32 Lcid, 
    Boolean IsSharePointMode, out string Script, out Int32 HRESULT);


  • Databasename
    A string containing the name of the report server database to create.

  • Lcid
    Value used for localization of role names.

  • IsSharePointMode
    Indicates whether to create database in native mode or SharePoint mode.

    False to create database in native mode; true to create database in SharePoint integrated mode.

  • Script
    [out] A string containing the generated SQL script.

    [out] Value indicating whether the call succeeded or failed.

Return Value

Returns an HRESULT indicating success or failure of the method call. A value of 0 indicates that the method call was successful. A non-zero value indicates that an error has occurred.


This method generates an SQL script that creates report server databases for the version of the report server currently connected to.

The value supplied in the DatabaseName parameter must conform to SQL Server database naming conventions.

The method does not check the existence of the database when generating the script.

This method does not check for the existence of the report server database when generating the script.

The generated script supports SQL Server 2000, SQL Server 2005, and SQL Server 2008.


Namespace: root\Microsoft\SqlServer\ReportServer\RS_<EncodedInstanceName>\v10\Admin

Platform: Windows Server 2003, Datacenter Edition; Windows Server 2003, Enterprise Edition; Windows Server 2003, Standard Edition; Windows Vista; Windows XP Professional with Service Pack 2 (SP2) or Service Pack 1 (SP1); or Windows 2000 (all versions)