Posting on behalf of a user.
User has just installed SS 09.00.00.113 on a 64bit OS Windows 2008 SP 1. Getting an error when she tries to configure the database. The specified connection is invalid. She let it create a new database when she installed SS.
This may mean that MS SQL database was for some reason not installed by SelectServer installation. You can use this link communities.bentley.com/.../8069.aspx to install MS SQL manually and this information communities.bentley.com/.../7018.aspx for more details on SelectServer Database Setup configuration.
Answer Verified By: Tyler Q - Bentley
You can also get this if the database does not have TCP/IP enabled.
Depending on what database version you have also check the database configuration.
1. Started Microsoft SQL Server 2005 Configuration Manager.
2. Under SQL Server 2005 Network Configuration > Protocols I enabled TCP/IP Protocal for the database instance.