Please bore patience I am trying my best to understand.

initially I was confuse with the difference between a username and a loginname thought they were the same.

Trying to understand I...

I have two databases one with the users and the other with the data

After the user login

if the user is james it say

Cannot open database "Database" requested by the login....

ALTER USER UserName WITH LOGIN = LoginName

I am sorry I could not get it to work.

A little more explanation please.

thanks

both databases has the same name

the users are in the configuration file on the network website

<add name="DefaultConnection" connectionString="Data Source=xxxx;Initial Catalog=aspnet-cxcDB-20130627224632.mdf;User ID=xxxx;Password=xxxxx" providerName="System.Data.SqlClient" />

<add name="CXCDBConnectionString1" connectionString="Data...