Setting Up a SQL Anywhere Database Connection
Full control permissions are required for directories containing
databases that you need to access from your .NET Web Service
applications.
Before the .NET Web Service connects to a SQL Anywhere database, you
must either start the database manually or grant the IIS_IUSRS (IIS 7.5 or later) default permissions for the
AppeonShared and SAP SQL Anywhere directories, making sure to replace
permissions of all child objects in those directories.
Note
If your database configuration uses a server name, you must
provide the database server name in the start-up options when you start
the database manually, in addition to the name of the database file you
are accessing.
If you do not grant the appropriate user permissions for Appeon
directories and your database configuration is set to start the database
automatically, your application will fail to connect to the database. SQL
Anywhere cannot access files unless the IIS_IUSRS user group
has the right to access them.
-
In Windows Explorer, right-click the Appeon, AppeonShared or
SAP SQL Anywhere directory and select Properties from the context
menu. -
Select the Security tab of the Properties dialog box for the
directory and click Add. On Windows 7 and later, click Edit and then Add.Note
To show the Security tab of the Select Users,
Computers, or Groups dialog box, you might need to modify a
setting on the View tab of the Folder Options dialog box for your
current directory. You open the Folder Options dialog box by
selecting the Tools > Folder Options menu item from Windows
Explorer. To display the Security tab, you must clear the check
box labeled “Use simple file sharing (Recommended)” -
Click Locations, choose the server computer name from the
Locations dialog box, and click OK. -
Type IIS_IUSRS (IIS 7.5 or later) in the list
box labeled “Enter the object names to select” and click OK.If valid
for your server, the account name you entered is added to the Security
tab for the current directory. You can check the validity of a group
or user name by clicking Check Names before you click OK. -
Select the new account in the top list box on the Security tab,
then select the check boxes for the access permissions you need under
the Allow column in the bottom list box.You must select the Full
Control check box for a directory containing a database that you
connect to from your application. -
Click Advanced.
-
Select the check box labeled “Replace permission entries on all
child objects with entries shown here that apply to child objects” and
click OK.A Security dialog box appears, and warns you that it will
remove current permissions on child objects and propagate inheritable
permissions to those objects, and prompts you to respond. -
Click Yes at the Security dialog box prompt, then click OK to
close the Properties dialog box for the current directory.The
pbtrace.log file is created in the
applicationName_root directory. This file records
all runtime exceptions thrown by the application and can be used to
troubleshoot the application.