Hi Chris,

I think you'll find this is a pretty common issue that is thankfully easy to resolve.

SQL Server has a set of logins for the whole database management system and then another set of users for each database. When you look at the "Security" folder and then "logins" in SQL Server you'll see the "privuser" and "pubuser" logins sitting there. Then when you open up the "Database" folder followed by your database ("PMDB") and then "Security" and finally "Users" underneath, you'll see "privuser" and "pubuser" there. So you're probably thinking why won't it work.

Despite the Logins and Users having the same name there is no connection between them because you brought the database in from elsewhere. The login called "privuser" is not associated with the User called "privuser" and so you can't access the database.

Here's what you do.

1. Login to SQL Express as something with high privileges.
2. Open up a SQL Query window.
3. Change to your PMDB database
3. Run the following statement to link the login "privuser" to the database user "privuser"
EXEC sp_change_users_login 'Update_One','privuser','privuser'
4. Run the following statement to link the login "pubuser" to the database user "pubuser"
EXEC sp_change_users_login 'Update_One','pubuser','pubuser'


Quite possibly one of the most compelling reasons to use Oracle database instead of SQL Server :-)

I hope that helps you.

Barrie
http://www.kinleyconsulting.com