I have installed Blue Prism 6.2.1. on an application server and I'm trying to configure it for the first time.
Chose SQL Server (SQL Authentication)
Database Server: DatabaseServer
Database Name: BPSandbox
User ID: DatabaseServer\sa_user
Password: sa_user password.
I keep getting this error however - Unable to determine whether database exists - Login failed for user 'DatabaseServer\sa_user'.
Troubleshooting:
1. Checked the spelling, case etc of both sa_user and password. It's definitely correct as I use the same credentials to log into the app server and my database server.
2. I can ping the database server from the app server and vice versa.
3. I have enabled TCP/IP on the SQL server instance.
4. My sa_user is a sysadmin on the SQL server instance.
Is there anything else I should try?
