Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jharwood

    Attaching DB and Mapping Users

    I had just relized what I has did I was still logged into the master db and not the db that TestUser was in. Thanks for the help.
  2. jharwood

    Attaching DB and Mapping Users

    I added: EXEC sp_change_users_login @Action = 'Update_One', @UserNamePattern = 'TestUser', @LoginName = 'TestUser', @Password = 'user';" But now I get: System.Data.SqlClient.SqlException: An invalid parameter or option was specified for procedure 'sys.sp_change_users_login'.
  3. jharwood

    Attaching DB and Mapping Users

    If I look under Security --> Users under the database the user it there. When I check the properties of the user under General --> Role Members db_datareader and db_datawriter are checked. But If I check the users Properties under Security --> Logins --> User Mapping Nothing is checked.
  4. jharwood

    Attaching DB and Mapping Users

    Maybe I am not going about this the right way. What I am trying to do is; I have detached a DB that was created in SQL Server 2005 and copied the the .mdf and .ldf files. I renamed them and put them into a foder. When the user enters information into a web form the mdf and ldf files are copied...

Part and Inventory Search

Back
Top