I have am in the process of trying to learn how to convert Access 2003 tables to SQL Server 2005 and link the tables to my Access frontend. I am new to SQL Server 2005.
I have SQL server set up using Windows Authentication mode. I have a database called db7 that I converted from Access 2003. I created a Login in Sql server called domain\username. However under Login properties Security->Logins->User Mapping, I cannot select my database db7. When I select it, there are no error messages but when I open that page up again, it is no longer selected.
I can successfully select other databases.
Under db7->Security->Users, I have created a user with the same name domain\username and it is pointing to the correct database db7 (Extended Properties).
When I look at the properties for that database db7 (right click properties), when I go to Permissions, I cannot add the user either. Again it appears I'm adding it successfully (no error messages) but when I go back in, the user is no longer there.