By using this web site, you agree to all terms and conditions for acceptable use.

ServiceLedger KnowledgeBase Knowledgebase Home Page > ServiceLedger > Technical | Contact Us

Search the Knowledge Base Browse by Category

ServiceLedger provides this content as-is for self help support purposes. ServiceLedger assumes no liability for any steps you take based on the directions in our knowledge base, and assumes that you have the knowledge to determine whether a given step is appropriate for your situation. Certain solutions can affect third-party software that ServiceLedger relies on or integrates with; it is your responsibility to consult with the documentation or publishers of such third-party software to understand whether any changes suggested here will have negative effects on other applications.


(T0070) How do I ensure all database objects are owned by the dbo role in SQL Server, I am receiving errors about missing objects?

Would you like to...

Print this page
Email this to a friend

SQL Server may create objects under different user accounts if you have a non-standard security policy defined.  The symptoms that this step may need to be performed are:

  1. You have a non MSDE installation of ServiceLedger
  2. You use SQL or NT accounts other than sa for the operation of ServiceLedger
  3. The updater is not allowed to use sa SQL account for its update procedure
  4. You are seeing errors in the application about missing objects, procedures, tables or views. 

ServiceLedger requires all objects to be owned by the dbo account.  ServiceLedger provides a facility to ensure this with these steps (you must have 5.5.0.37 or later to perform):

  1. Log into your server as an administrator
  2. Go to Start->Run and type (It is recommend you copy & paste this as it must be exact)
    osql -E -d ServiceLedger -Q "exec dbo.sp_FixTableOwners"
  3. Click run or ok, you may see a flash, then proceed
  4. Go to Start->Run and type (It is recommend you copy & paste this as it must be exact)
    osql -E -d ServiceLedger -Q "exec rebuildsltables"
  5. Click run or ok, you may see a flash, test to see if your error has cleared.  If not, contact support@serviceledger.com if you have a support plan.

Related Questions:

Attachments:

No attachments were found.


ServiceLedger KnowledgeBase Copyright © 2019 support.serviceledger.com
Powered by AcitveKB Knowledgebase Software