new SQL Server 2005 install giving login error... HELP!

I completely uninstalled 2000 and did a clean install of 2005. I restored my
database and users and all seems fine. I am set up with mixed authentication
(windows and sql server). My username is in security/logins as well as in
database/security/users with connect and select permissions.
I am getting the following error when trying to submit my asp page:
Microsoft OLE DB Provider for SQL Server error '80004005'
Cannot open database "dbName" requested by the login. The login failed.
/AddressSearch/SearchResults.asp, line 40
Hi
This sounds like you have orphaned users
http://support.microsoft.com/default...21120121120120
John
"SharinDenver" wrote:

> I completely uninstalled 2000 and did a clean install of 2005. I restored my
> database and users and all seems fine. I am set up with mixed authentication
> (windows and sql server). My username is in security/logins as well as in
> database/security/users with connect and select permissions.
> I am getting the following error when trying to submit my asp page:
>
> Microsoft OLE DB Provider for SQL Server error '80004005'
> Cannot open database "dbName" requested by the login. The login failed.
> /AddressSearch/SearchResults.asp, line 40
>
|||You rock! Thank you! Those articles worked perfectly.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> This sounds like you have orphaned users
> http://support.microsoft.com/default...21120121120120
> John
> "SharinDenver" wrote: