MS SQL Server and the web application are both on the same machine.
web.config, I have:
connectionString=" Server=COMPUTER_NAME\MSSQLSERVER; Database=MyDatabase; Integrated Security=true" name="ApplicationServices" providerName="System.Data.SqlClient"
I created a new Windows user account named
MyWebsite. This account is assigned to application pool and my web application is using it.
In SQL Server Management Studio:
- MyWebsite account is added in Security -> Logins
- MyWebsite account is added in MyDatabse -> Security -> Users.
- db_owner option is checked
In SQL Server Security Manager, all protocols are allowed.
I'm still getting the following error message:
A network-related or instance-specific error occurred while establishing a connection to SQL Server' Error 26 - Error Locating Server/Instance Specified
Am I missing something?