Hi all, I'm running into an issue where the Cireson Setup application can't create the SQL DB. Here is what the logs say:
8/12/2020 7:21:51 AM Attempting to create ServiceManagement Database Logins
8/12/2020 7:21:51 AM Failed to create management database logins SCSMDevServiceManagement on SQLServerFQDN\Instance : A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)
8/12/2020 7:21:51 AM Failed to create management database logins SCSMDevServiceManagement on SQLServerFQDN\Instance : A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)
8/12/2020 7:21:51 AM Set recovery to simple. ManagementDBName:SCSMDevServiceManagement SQLServer:SQLServerFQDN\Instance
I've tried:
- Making sure both my account and the account used for application pool user are dbcreators on the SQL box (even sysadmin for testing purposes)
- Testing with both accounts being Domain Admins, just to eliminate permissions issues
- Verified successful pings to and from the SCSM server and the SQL server, as well as testing TCP over the SQL port
The fun part is, I have already done this in my Proof-Of-Concept environment, and I don't remember having as issue. I looked at that server just to make sure I was replicating those general settings (different DBs though of course). If anyone can think of anything I'm missing or haven't tried yet, that'd be awesome. Thanks!