SQL Logins and DB User associations

Discussion in 'Databases' started by TechPG, Jun 11, 2010.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. I created a SQL Login named "abcd" and my restored db has a user called "abcd". Normally once I do a restore from an external source, i have to run the following SQL to tie the SQL Login to the DB user.

    sp_change_users_login 'Update_one', 'abdc', 'abcd'

    I ran the query, but am getting a SQL message that "permission was denied" on the first select to the db. In the web.config file, the user and password are encrypted and work in other environments.
     
  2. I solved it by just getting the encryped username and password for the default login user and put that in the web config file and didn't use the one that I had.
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page