Fix for Error: SQL Server does not exist or access denied

[eUK-Martin]

Hello,

Here are the steps on how to fix MSSQL error:

"SQL Server does not exist or access denied"

-- Check if SQL server is running and accepting connections.

-- Make sure that the user and password in the connection string is correct.

-- if you do not remember them and then delete the DB user from Plesk (just resetting the password will not help) and re-add them with the details in the connection string.

-- If you do not have Plesk control panel then make sure that the server is mapped to the database with the appropriate permissions.

-- To verify the mapping, connect the server with Management Studio, expand Security >> Login. Double click on the user and select “User Mapping”. Make sure that the user at least has read permission on the database