[RESOLVED] Need some good advice on Windows application & SQL SERVER database Security

[angelica]

I dont have User Mappings. Guess as you said its not included in the Express Edition.

About my attaching the DB I had done it through the normal way, DB > Attach normally and it shows the path to the Db. Then a friend suggested that I type in the name of the DB instead of the path and it worked. Then I got blocked as you said with the Default, but managed to fix that somehow. This was before I got your post and then I confirm it true.

What's the user mapping for? And what if I dont set it off?

[szlamany]

The user mapping is just a way to associate a username with a DB - which seems to be your issue.

I've got zero experience with EXPRESS - I've got SQL 2005 EXPRESS installed on some machines I've got but not the SSMS EXPRESS tool...

At any rate - now that the DB is attached (and we are going to leave it attached like this!) can you open it in the object explorer and see a branch for SECURITY - and then USERS?

Under that USERS branch you can right-click and add a user. There should be two spots - username and login name - the login name has a button with "..." on it - if you click that it should let you browse around and find the xxxxxx\Angelica login. I guess you put Angelica in the username spot - that's free text I believe (I never really put users in this way - unless I'm creating SQL AUTHENTICATION USERS).

[angelica]

ok, that is all done using the last method. Guess that's there is to it then.

Thanks a lot Szlamany.

Now I set up 2 new Logins were, one for the user to login the database through the system and the other for a sysadmin.
However when I try to seet X.XXXXX\USER as a sysadmin I am getting this error and dont know what it is exactly.

[angelica]

Hi help,


Im completely blocked out of the database and the Server. I get this error on clicking the properties of the Server and Database.

Anythng I can do pls?

[szlamany]

I told you not to change the default database...

http://forums.microsoft.com/MSDN/Sho...67068&SiteID=1

Google also found lots of other sites - but I think this one clearly tells you how to change the default database back to something more reasonable.

[angelica]

I had done two horrible mistakes, one I locked out XXXXX\user by trying to mess with the dbright and deleted owner by mistake and I also changed the default. The last one I knew how to fix but the other completely shut me out. Good thing I had another admin user account and logged int he database through that one.

I better leave experimenting for after my project! Thanks Szl, am saving some points for rating your help!