Install reconfiguration/setup wizard cannot connect to local or remote MSSQL database
- Login failed
- Failed to connect to server
Common causes include: - Service not started or has not been restarted after install. - Incorrect port configuration. - MSSQL incorrectly configured. -Client tools not installed.
Has the SQL Server services been restarted since install?
Checking MSSQL service:
Check MSSQL port configuration:
Check network connection to MSSQL server?
Check is MSSQL port is open on SQL server:
Is MSSQL Client Tools installed?
If SEPM is installing to a remote MSSQL database the SEPM server will need client tools installed
Installing MSSQL Client tools:
To install client tools only for SQL Server 2005
To install client tools only for SQL Server 2000
Verify MSSQL user account authenticate to the MSSQL server database instance:
To Verify the account that SEPM uses to access the SEPM database perform the following
Note: If the above osql commands failed with "Login Failed for user 'sem5'" the password enter maybe incorrect and may require reset.
How to reset MSSQL user account password: