We help IT Professionals succeed at work.

SQL User-Mappings missing aftre reboot

jlewy11
jlewy11 asked
on
I have an application that requires db_owner of certain databases in SQL. I select my user mappings and all is well. After I reboot my server all those settings are missing. This is a new server running Server 03 with all Windows Updates as of 1/29/08. The databases are restores from an old server but came from another machine running SQL 2005 SP2.
Comment
Watch Question

Commented:
Maybe you have a startup procedure or a job that resets your permissions. To check if there are startup procedures run the following script

use master
go
select * from sys.object where objectproperty(object_id,'ExecIsStartup')=1

If the query returns something - investigate.

If nothing found - look at the jobs. Stop and restart SQL Server only (without Agent) and check if your permissions are still in place. If they are, look at the jobs.
Commented:
thanks mar but I figured out what the problem was. I set permissions under the model db which saved what I needed.

You can close this question.

Thank you.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.