Cannot open database requested in login 'databaseName'. Login fails

it happened to me with sql server 2000 and 2005, after restoring the database i couldn't login from asp or asp.net script.
this solution is for sql 2000 but i think it will work also with 2005.
i noticed that after the restore the user that i'm tring to loggin with appears on the logins of the specifice database but the culomn of Login Name is empty. i looked at the same place in the original database and i saw something there... it was lost with the restore! i don't know if it's a bug or what, but i lost few days of fighting with it!
anyway, you need to put the the user name... it's not so easy, i didn't find the way to do it, i had to delete it and add it again.. that also not so simple! so you can delete the login it shouldn;t own nothing... so i had to change all the objects that were owned by this login and then could do it!!
i hope you found this blog before losing too much time on this!! the time that i spent is enough :)
if that helped you so write a commemnt
have a nice programming!!

Discuss Post

message could not be dilevered to all servers

this error recieved when the email address of the reciever is not legal email address, for example starting with number, or like this format xx@hot..com, or start or have an illegal character like ' ! ?

Publishing .net WebApplicatuib

if you are tring to publish a .net webApplication, it doesn't matter if it's c# or VB.net you should do the following steps :
1. copy the files tin your projects
you don't need to copy them all, only the aspx, and the congidurations files and very important is to copy the bin directory other wise you'll get theis error message:
Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately. Parser Error Message: Could not load type 'AppName.Global'.

2.Create Virtual Directory
this is a very important step, alot of people loose aloth of time untill they knwo they should do it (at least i did :)
go to the iis, stand on the default webSite (in the websites) and right click and the new virtual director.
if you don;t do this step so you will get the following error message:
An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.