SQL Server connection problems |
You may encounter problems when entering the database connection details in the first step of database setup:
Error 1: Establishing connection to the server
Error message:
Troubleshooting:
Error 2: Login failed for user 'xy' Error message:
Troubleshooting for SQL Server account
If you're using SQL Server account with password, make sure you are using a valid user name and password. The login must be created on the server, it must be enabled and granted with permission to connect to the server. You can check the user account in Enterprise Manager/SQL Server Management Studio -> Server -> Security -> Logins:
Also, check the Server Properties -> Security dialog in Enterprise Manager/SQL Server Management Studio and make sure your server supports SQL Server and Windows Authentication mode:
Troubleshooting for Windows Authentication account
If you're using Windows Authentication account, the situation may be a little more complex and may require you to contact your network administrator. The ASP.NET applications run under some particular local or domain account. This current account is displayed on the screen:
This account must have its own login with Windows authentication in the SQL Server. You can create the login in Enterprise Manager\SQL Server Management Studio -> Security -> Logins and grant it with appropriate permissions on the server. If you SQL Server is located on a different machine than your web server, you may need to configure your web application so that it runs under some domain account, rather than local account so that you can the login in the remote SQL Server.
If you do not succeed to configure Windows authentication, you may want to enable Windows and SQL Server Authentication on your SQL Server and use SQL Server account instead. You can learn more about SQL Server authentication in the Troubleshooting for SQL Server account section earlier in this chapter.
|