Login problem after restoring DB

Dear Masters;

I have a classical aspnetdb Login DB; When I backup the DB and make some changes and then restore again; users can't login anymore...

I can see this is good for security but what should I do to do it in a propar way?

Thanks...

Hi Kaan,

In the SQL Server, the logins are not contained in the database. So when you backup the DB, you just backup the users.

However the mapping from a login to user is lost. This is by design. In this case, you have to re-map the logins and users after restoring.

HTH. If this does not answer your question, please feel free to mark the post as Not Answered and we will look into it again. Thanks!

|||

Hi Kevin,

Thank you very much this is actually the answer:) but also a trigger of another question:) How can I re-map the logins?

Thanks...

|||

Hi Kaan,

Here are the steps for User Mapping.

1. In the Management Studio, Open Security/Logins and double click on a login to open the Login Properties dialog box.
2. Select User Mapping from the left tree, and you will see mapping on the right.

|||

Hi Kevin,

Thank you very much... Sorry I'm too lamer

I've seen that my database's mapping check box was unchecked; so re-mapping should be simply checking it:)

I think it'll work or at least I'll dicover..

Thanks a lot again.

|||

Q: "I have a classical aspnetdb Login DB; When I backup the DB and make some changes and then restore again; users can't login anymore..."

A: "In the SQL Server, the logins are not contained in the database. So when you backup the DB, you just backup the users.

However the mapping from a login to user is lost. This is by design. In this case, you have to re-map the logins and users after restoring.

Here are the steps for User Mapping.

1. In the Management Studio, Open Security/Logins and double click on a login to open the Login Properties dialog box.
2. Select User Mapping from the left tree, and you will see mapping on the right." (Kevin Yu)

Login not working anymore

I am running an Express 2005 server, using the Management software included. I was attempting to view server settings when it locked me out. I could not access the properties of the server, and after that, anything. I tried logging out, but it would not let me log back in. It said that the server may not allow remote connections, but this was the same login that I had been using previously with Windows authentication without a problem.

So, now I'm locked out of my database with no way to access anything. Does anyone know how I can get around this or make the login work again?
Hi,

is the service started properly ? Perhaps you switch the RemoteConnections Setting for some reason ? http://www.sqlserver2005.de/SharedFiles/RemoteConnection.jpg

Or you have a different port than the default one associated with the Service and the SQL Browser which does the dynamic directing doesnt work anymore ? In this case start the SQL Browser or use the direct syntax to contact your SQL Server : machineName\InstanceName,Portnumber . There could be various issues why you can′t connect anymore, try to find out if something changed on the system first by looking in the event logs.

One possible reason *could* be that you assigned the service a specific account and changed the password for that account, but this could be clearly seen in the event log.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de