Service Desk 7 Install error
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.
Comments
If the SQL Server is not on
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.
- Bruce
*** If a forum post solves your problem, please flag it as a solution. If you like an article or forum post, vote it up. ***
Thanks, but it is
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.
John Atkins
Advanced Client Services Engineer
LifeWay Christian Resources
http://www.lifeway.com
TN User Group Membership Director
i've exactly the same error.
i've exactly the same error. SQL off the box.
The SQL on administrators group and the same error.
solved changing the user that
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 this error install Workflow 7 with SQL off box too
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.
Please "Mark as Solution" those posts which resolve your problem - its a free way to give something back to those who contribute their time and knowledge to these forums.
Would you like to reply?
Login or Register to post your comment.