Hi All

Im have an existing SRS Instance (SQL 2012 version) on one of my SQL cluster nodes, but as a standalone install, and this works fine (used by SCOM 2012).  Im now trying to install a second SRS Instance on the same server node (to be used by SCSM 2012).  The install works fine, but when I go to SQL Reporting Services Configuration Manager, and go to the Database pane to create the neccessary two reporting databases.  On running through the database creation wizard it attempts to create the databases, it completes the first 4 steps but fails on the "Applying connection rights".  Checking the databases I can see that they have been created, but the process has not worked since I am not able to exit the wizard ("Finish" is greyed out).

Any thoughts very much appreciated!?

System.Data.SqlClient.SqlException: Windows NT user or group '(null)' not found. Check the name again.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(SqlConnection conn, String script, ICommandWrapperFactory commandWrapper)
   at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script)
   at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script)

Resolved this by changing the Service Account to be 'Network Service', prior to running the database creation wizard.

Cheers

Andrew

• Proposed as answer by Charlie LiaoMicrosoft contingent staff, Moderator Tuesday, October 16, 2012 1:21 AM
• Marked as answer by Charlie LiaoMicrosoft contingent staff, Moderator Monday, October 22, 2012 10:30 AM

Hi Andrew,

I am glad to hear that your issue has been solved. Thank you for your sharing.

Regards,
Charlie Liao

thanks resolved