Video Screencast Help
Endpoint Management Community Blog

SIM fails to log into SQL Server at the database creation phase

Created: 20 Mar 2014
SK's picture
0 0 Votes
Login to vote

Hello all,

Today I ran into the above mentioned problem whilst trying to perform a clean install of ITMS 7.5, so I thought I would share what worked and what didn't.

Windows 2008 SP1 R2 with SQL 2012 SP1.

SQL was initially configured for Windows Authentication.  When SIM failed, I manually created the database to no avail.

I then changed to mixed authentication and changed the SA account (as I obviously didn't know what the original one was) via the UI.  Unfortuantely, the SA account had the same problem.

 

What worked was running the following query:

USE master
GO
ALTER LOGIN [sa] WITH PASSWORD=N'NewSAPassword', CHECK_POLICY = OFF
GO
ALTER LOGIN [sa] ENABLE
GO

 

This allowed SIM to create the database and begin the installation phase.  Once ITMS 7.5 was installed, and the 9 hotfixes (required a rebot beforehand), I opened the Database Settings page and switched to the AppId so that Windows Authentication could be used again (I did the same for the reports too).