[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 153
  • Last Modified:

SQL User-Mappings missing aftre reboot

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.
0
jlewy11
Asked:
jlewy11
1 Solution
 
maradamCommented:
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.
0
 
jlewy11Author 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.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now