Re: database owner

Are there any necessary steps I should take or correct this setup? (I hope this explanation was understandable)

Having the backupexec account probably won't do any harm as long as the Windows account exists. To ensure a database owner is never orphaned, I use 'sa' as the database owner unless I have a reason to do otherwise. You can use sp_changedbowner to specify the desired owner. For example:

USE MyRestoredDatabase
EXEC sp_changedbowner 'sa'
GO

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Andy.I" <Andy.I@xxxxxxxxxxxxxxxx> wrote in message news:5B2D9624-7F22-4AA4-AB1B-F48C01F180DC@xxxxxxxxxxxxxxxx
Hi

I have recently migrated several databases between 2 SQL server 2K servers, and used backupexec in this process.
Backup from old server, and db restore to new server. Migrated all logins with a stored procedure I found in MS's knowledgebase.
Now on the new server the backupexec user account is database owner on all the migrated databases. I do not have a dedicated login for this user on the server, but this account is member of a administrators group in the sql server and this group is dedicated at dbo on all databases and belongs to the sysadmin servers role. So this way all rights are inherited from the group membership.
My question is, will this create any issues? The way I see it, the sid of the database owner, doesn't exist in the syslogins table in the master DB, and it doesn't exist as an own login in sysusers on the database in question, even if it is a member of the administrators group on the database.
I use SQL Server 2000 Sp4 with mixed security.

Are there any necessary steps I should take or correct this setup? (I hope this explanation was understandable)

/A

.

Relevant Pages

  • Re: ADP/SQL Server 2000 Security Problem
    ... The server is running Windows 2003. ... I'll also test using a SQL Server account and see what happens. ... it worked in MSDE 2000. ... I have not created any new accounts for the production database. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Help with WSS 3.0 Server Farm Config - Backend SQL 2005
    ... I had to use only "sharepoint" to get the ... What interest me though is that the database get created but fails after ... Virtual Server with DBSVR ... an account local to the WEBSVR) to create and access the SQL server, ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Restored Server but SharePoint refusing admin access
    ... > SID/BID or remove the user from the database and add it again. ... >, In SQL Configuration Manager go to SQL> Server ... > you had) you cannot access the database from that account. ... > newly added administrator account (for me, since I added a new admin ...
    (microsoft.public.windows.server.sbs)
  • Re: Keep getting this error when trying to use Web Parts in VS2005 Beta 2. Why?
    ... > setup another database. ... >> operation or the server is not responding. ... This is necessary because the web server account will ... >> This is necessary because the web server account will attempt to ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Single Sign On Database Connection Issues
    ... SSOSrv, I'm having difficulty on the "Manage Server Settings for Single ... to define the necessary database. ... So after assigning the appropriate security to the user account, ...
    (microsoft.public.sharepoint.portalserver)