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

I completely uninstalled 2000 and did a clean install of 2005. I restored m
y
database and users and all seems fine. I am set up with mixed authenticatio
n
(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 40Hi
This sounds like you have orphaned users
121120120" target="_blank">http://support.microsoft.com/defaul...r />
121120120
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 authenticat
ion
> (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
> 20121120120" target="_blank">http://support.microsoft.com/defaul.../>
20121120120
> John
> "SharinDenver" wrote:
>