Download Scribe 2000 User Guide

Transcript
56
Scribe Accounts 2015
Firewall appears to be interfering with connection
The application connects to the SQL Server database running on the server. If the installation appears
successful but the connection cannot be made at the Create Council stage, you should check whether a
firewall is preventing access by turning firewalls off temporarily and trying again. If this proves to be the
case you will allow access for the application through the firewall. An incorrect firewall setting can even
interfere with an installation on a single PC.
SQL Server generally listens on TCP port 1433. The article at http://support.microsoft.com/kb/287932
describes the firewall settings needed to be done to be able to connect to the SQL.
Normal Login/Connection Stops Working - SQL Server Services have been turned
off
Check that the SQL Server services are running. It is possible a third party change to the PC such as an
automatic Windows Update impacted on this.
Go to Control Panel | Administrative Tools | Services and look down the list for SQL Server (SQL
EXPRESS). In Windows 10 you can also get to this via Settings | System | About | Additional
Administrative Tools | Services.
In Windows 7 you can also get to this from the Windows Start button - under All Programs look for
Microsoft SQL Server 2012 and SQL Server Configuration Manager. In Windows 8 and 10 you can view
services directly from Control Panel | Administrative Tools | Services. (The Configuration Manager does
exist but the Search box will not locate it for you.)
In the list of services the SQL Server and the SQL Server Browser must have both a Status of 'Started' or
‘Running’ and a Startup Type set to 'Automatic'.
You can right click and select Properties to view or to change these settings, eg to restart the service if
it has been stopped. This should also then start automatically at next reboot. (The service called SQL
Server Agent is not relevant)
Error: Access Denied - You do not have admin privileges and hence cannot create
council to run the application.
The Scribe program will give this message after checking if the user has sufficient Windows write
permissions on the machine. Being a Windows Administrator should be sufficient, but if the error
appears, you can recheck this by manually opening the ‘Scribe.exe.config’ file in Wordpad and attempt
to save it without making any changes. If you have Admin rights then you should be able to save it
otherwise it will give the ‘Access denied’ message. The file will be placed in the ‘C:\Users\All Users
\Scribe_2000_Ltd’ folder.
If this is not the issue, recheck any Domain policies which may be reducing permissions (see below).
SQL Server Express installation in a Windows Domain environment
Issues that can come up while installing on a domain environment are most likely related to security
access permissions so please check these. Provided the user has administrative rights on the machines
on which you are installing the program, this should generally be sufficient.
As a general rule, always install SQL Server Express on the domain server so that it is always
Copyright Scribe 2000 Ltd