Activity overview
Latest activity by williamholding
In Sql Server, user accounts and credentials are set at the server level, not at the database level. When you deploy an SQL database, only the database info moves over. You need to connect to the Database Server in your deployed environment , set up the username and password you want to use, and give the account appropriate permissions into the database. Login failed for User is a general sql error message and may have several causes. So, first you have to make sure that the user exist on SQL Server , that the user is enabled, and has access (mapped) to the correct database. In most cases, just set "Integrated Security=False" and it will work. Make sure that you have the Mixed-Mode authentication enabled and here is how to enable it. Also, either one of three things you will need to do to correct this issue:
Add the user used by the worker process to the SQL database and assign the appropriate permissions. Change the Connection String to use a predefined user name and password. Change the Anonymous authentication credentials or the credentials used by the worker process. / comments
In Sql Server, user accounts and credentials are set at the server level, not at the database level. When you deploy an SQL database, only the database info moves over. You need to connect to the D...