PANTHEON™ manual

 Categories
[Expand]User Manual for DataLab PANTHEON 5.5
 No formula defined!
[Collapse]Datalab PANTHEON 5.5 Guide
 [Expand]Orders
 [Expand]Settings
 [Expand]Manufacturing
 [Expand]Goods
 [Expand]Service
 [Expand]Financials
 [Expand]Personnel
 [Expand]ZEUS Business Intelligence System
 [Expand]Desktop
  Web Portals
  Extra
 [Collapse]Datalab Software System Environment
  [Expand]Security Policy
  [Collapse]Installation
    Windows Vista
    Windows Terminal Server
    Installing PANTHEON on Linux and Oracle Database
   [Collapse]MS SQL Server
     MS SQL Server Installation
     Changing SQL Sort Order
     SQL Server Agent
    [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
   [Expand]Oracle Database
   [Expand]ODBC
  [Expand]Task Scheduling
  [Expand]PANTHEON System Environment
  [Expand]Datalab Utilities
  [Expand]Database Administration
 [Expand]Messages and Warnings
 [Expand]Additional Programs
 Opening or closing round bracket missing!
 Debugging Formulas
[Expand]Testing and Debugging Formulas
 Opening or closing square bracket missing!
 Conditional statement at position x not enclosed in square brackets!
 Syntax error in conditional statement. Correct syntax is [condition:value]
 Adjacent operators (xx)!
 Last character of the formula is an operator!
 Variable not enclosed in hashes (#)!
 Illegal characters: xyz
 Unknown error!
[Expand]User Manual for Datalab PANTHEON Farming
[Expand]User Site
 Adjacent hashes!
 The line number must be an integer (#xx#)!
 The first character of #xx# must be a transaction type or a column mark!
 The first character of #xx# must be an operation type (R, S, O or A)!
 The second character of #xx# must be a transaction type (D, K, S, P, or O)!
 Variable not defined
[Expand]Kralicek Quicktest Financial Ratios

Load Time: 406.2497 ms
print   |
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!