PANTHEON™ Help

 Toc
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Expand]Guide for PANTHEON
  [Expand]Guide for PANTHEON Retail
  [Expand]Guide for PANTHEON Vet
  [Expand]Guide for PANTHEON Farming
 [Collapse]User Manuals for PANTHEON
  [Collapse]User Manual for PANTHEON
   [Collapse]Getting Started
     First steps with PANTHEON
    [Expand]PANTHEON Installation
    [Expand]PANTHEON Basics
    [Collapse]PANTHEON System data
     [Expand]PANTHEON System data
     [Collapse]MS SQL Server
       Download and install MS SQL Server
       Upgrading the SQL Server to the newer version
       MS Management Studio - Download and install
       Restoring database onto SQL server
       Adding users to server level (AddUser_PAX)
       Installing SQL for external access
       Installing PANTHEON clients
      [Collapse]MS SQL Server Security
        Windows Authentication
        SQL Server Authentication
        Creating Server Logins
        Fixed Server Role
        Fixed Database Role
        SQL Server Service Settings
        Encrypting SQL Server Connections
      [Expand]Useful SQL Queries
       SQLExecute
      [Expand]SQL Server Jobs
     [Expand]Microsoft Windows Utilities
     [Expand]Security Policy
     [Expand]Database Administration
    [Expand]PANTHEON Security
    [Expand]Using PANTHEON at Tecta, a fictional company
    [Expand]Frequently asked questions about Pantheon (F.A.Q.)
   [Expand]User Manual for eBusiness
   [Expand]Settings
   [Expand]Orders
    Creating new invoice
   [Expand]Goods
   [Expand]Manufacturing
   [Expand]Service
   [Expand]Help
   [Expand]Personnel
   [Expand]Financials
   [Expand]Analytics
  [Expand]User Manual for PANTHEON Retail
  [Expand]User manual for PANTHEON Vet
  [Expand]User Manual for PANTHEON Farming
[Collapse]PANTHEON Web
 [Collapse]Guides for PANTHEON Web
  [Expand]Guide for PANTHEON Web Light
  [Expand]Guide for PANTHEON Web Terminal
  [Expand]Guide for PANTHEON Web Legal
 [Collapse]User Manuals for PANTHEON Web
  [Expand]Getting started PANTHEON Web
  [Expand]User Manual for PANTHEON Web Light
  [Expand]User Manual for PANTHEON Web Terminal
  [Expand]User Manual for PANTHEON Web Legal
[Collapse]PANTHEON Granules
 [Collapse]Guides for PANTHEON Granules
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]Dashboard Granule
  [Expand]B2B Orders Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
 [Collapse]User Manuals for PANTHEON Granules
  [Expand]Getting started
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]B2B Orders Granule
  [Expand]Dashboard Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
[Expand]User Site

Load Time: 1546.901 ms
"
   2014 | 2564 | 336924 | Updated
Label

SQL Server Service Settings

SQL Server Service Settings

SQL Server Service Settings

SQL Server by default installs iteself so that is uses the system account for logon. You have to change this, because the system account does not allow access to network resources. This may also be the cause of errors when a backup cannot be made because a network location is unavailable:

\\Server\Backup\BkpDataLab19991109160205.dat'. Device error or device off-line.
See the SQL Server error log for more details.

 

You have to change the SQL Service to log on using a domain account. Go to Control Panel | Administrative Tools | Services, find MSSQLSERVER, right click and select Properties. Go to the Log On tab.

Select the option This Account and enter a domain user and the associated password that should be used by SQL Server to access network resources.

004029.gif

The specified domain user must have access to all objects required by SQL Server and read/write permission for the folder where backups are stored. Because of that, a user with administration privileges is often used.

The logon account can also be specified in SQL Server Enterprise Manager.

If you use the Full-Text Search service, you have specify the logon account with it, otherwise the synchornization between SQL Server and Full-Text Search won't work.

004030.gif

046374.gif If you change the account's password or delete the account, make sure to make the same changes for the SQL Server instance.
 

Rate this topic
Was this topic usefull?
Comments
Comment will also bo visible in forum!