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
     Dictionary of terms
     First steps with PANTHEON
    [Expand]Using PANTHEON at Tecta, a fictional company
    [Expand]Instructions for Ensuring Compliance of PANTHEON with SAS
    [Expand]PANTHEON Installation
    [Collapse]PANTHEON System
     [Expand]PANTHEON System data
     [Collapse]MS SQL Server
       Download and install MS SQL Server
       Upgrading MS SQL Server to 2019 or 2022
       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
       Nastavitve MS SQL strežnika za večja Pantheon™ oko
       Changing SQL Sort Order
      [Collapse]MS SQL Server Security
        Creating Server Logins
        SQL Server Service Settings
        Fixed Server Role
        Fixed Database Role
        Windows Authentication
        SQL Server Authentication
        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 Basics
    [Expand]PANTHEON Help
    [Expand]Materials and Goods Movements
    [Expand]Assigning Identifiers
    [Expand]Frequently asked questions about Pantheon (F.A.Q.)
    [Expand]Archive
   [Expand]User Manual for eBusiness
   [Expand]Settings
   [Expand]Orders
   [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
  [Expand]Old products Archive
 [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
  [Expand]Old products Archive
[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]Archive
[Expand]User Site

Load Time: 437.5163 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!