On my initial investigation, I created ODBC connection test:
Created empty file udl file on desktop
Put SQL Server’s machine name (or IP) in displayed point 1 and user with his password in point 2
Clicked on “Test Connection” button and test connection seems to be working out.
Secondly I tried to Telnet SQL Server on port 1433 from Application server, but the connection is not able to establish, Please provide your suggestion ?
So, as of now I am suspecting Once the port is enabled, Issue would be resolved.
Anyone please let me know your thought on the issue and potential remediation plan.
The error indicates “login failed, database can’t be opened”. Is the database local or remote to the application server? Windows authentication or SQL Authentication? If Windows authentication, does the user running the service has access to the SQL server and the temadb? If SQL Authentication, does the SQL user defined has access to the temadb?
The error seems to pretty clearly be a logon error for the database account. I would double-check that the credentials you are using match what the data source is using.
If the SQL server was recently changed to require TLS 1.2, there are some additional configuration required for BFI which also might present as a database login failure, but wrong credentials are much more likely.