Hi! I'm using Sql server 2005 Express, and now i have a login problem. I want to create a user for my database in Sql Server Authentication mode, that when others that they don't know sa password and login in windows authentication mode can't see or can't access my database. I did these steps :
1. I loged in to sql server in 'sql server authentication' mode and with strong sa password
2. I went Security \ Logins and created new login with password
3. I went to my database security \ users and created new user and for login name i choosed previous login i created in step 2
4. Then i closed sql server and when i restarted it and loged in to sql server in 'Windows Authentication' mode i could see and open database.
Problem : in step 4 i wanted that i couldn't open my database.
Please help what should i did that i forgot to do !!
Sql Server Express Database login problem
relax_ant
if you have no GUI to configure your server you can use this statement here to remove the administrators role form the sysadmin group:
sp_dropsrvrolemember
'BUILTIN\Administrators', 'sysadminHTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---
Stefano Triulzi
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---
swapnareddy
hello
So thanks for your advice, and so sorry that i can't check my mail for answers about my problem.
Dear Jens, Also i have same problem, i couldn't find local admin group to remove it!
What should i do I searched roles but i saw no local admin group.
Please help me again.
Thank you.
padlewski
Hello again dear Jens
You solved my last required problem in sql server 2005, Somebody adviced me to back to sql server 2000 until solving these security problems.
I opend sql server express and went to security then logins and removed 'BUILTIN\Administrators' and this was my answer.