ServiceDesk

I have tried several times to get SD 7 installed and continue to get this error.  I have listed the details below.  The errors are in bold.   Any help would be appreciated.


Installation started...

Installing Workflow Server..
Checking Server Extensions service running
Default server is not local
Process timeouts and escalations
Copying Workflow Server installer for using later in designer
Workflow Server role installed.
Installing ServiceDesk ITIL Core..
Checking Server Extensions service running
ProcessManager portal role added to default server
ServiceDesk ITIL Core role installed.
Preparing SQL scripts to execute..
Installing ServiceDesk Portal Core..
Checking Server Extensions service running
Writing MSSQL connection instance to web configuration file..
Writing Replication file location to web configuration file..
ServiceDesk Portal Core role installed.
Checking Server Extensions service running
Notification Server credentials saved.
Executing database integration strategy..
Checking if database Ensemble already exists..
Database integration strategy failed due to an error: System.Data.SqlClient.SqlException: Invalid object name 'dbo.sysdatabases'.
   at System.Data.SqlClient.SqlConnection.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.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteScalar()
   at Installer.Core.MSSQL.MSSQLDataProvider.ExecuteScalar(String sql, Boolean onDatabase)
   at Installer.Core.MSSQL.MSSQLDataProvider.CheckDatabaseExists()
   at Installer.Core.MSSQL.MSSQLDatabaseStrategy.Execute()
Database Configuration could not be installed correct. Installation cannot be continued
Installation Failed.

If the SQL Server is not on the same computer as your ServiceDesk Server, make sure the Computer Name of your ServiceDesk Server computer is in the Administrators Group on your SQL Server computer. See page 49 of the ServiceDesk Implementation Guide for more details.

You are right in that my SQL server is off box, but I do have the ServiceDesk server set as an admin on my SQL server according to the Implementation Guide.

i've exactly the same error. SQL off the box.
The SQL on administrators group and the same error.

solved changing the user that connect with the SQL.
using SA instead of the user created for AltirisSD it worked.
Seems a permission problem (it was SQL admin) ....  what are the minimum permission needed for a SQL user for installing the SD?

Thankx

I had the same error for Workflow 7 (which SD7 is based on) and with my SQL db off-box. 

My solution was restarting the "LogicBase 2006 Server Extensions" service after I resolved the SQL permissions.  It appears that this service is installed before the error occurs and (I presume) holds onto some of the connection information.  So anyone who doesn't get the permissions right first install might see a problem like this, even though they've actually fixed the permissions issue.

My fix to SQL permissions was to add my Workflow computer account to the Administrators group on the SQL server as per above.   This seems to be needed so that the Workflow install can create the db.

KB44116 might be of help too - this gives instructions on how to manually create the db and I presume this will work for SD7 too.