kb20152309-1 Troubleshoot SQL Server Connections in Cayosoft Administrator

Published: Sept 23, 2015
Applies to: Cayosoft Administrator 3.x, 4.x
Available with: Enterprise and Data Access Licenseing

Network/Security considerations

• Firewall must allow access to SQL server
• IE Enhanced Security Must also be set to allow access

Required SQL Services

• Microsoft SQL Server (SQL Express is OK)
• Microsoft SQL Server Browser must be running

Account used for connection

• Authentication must be in mixed mode - Windows and SQL
• SQL Account should be sysadmin and public role holder

Specifying server name

• Use the default instance, provide only server name
• Use SERVER/INSTANCE naming format
  (Server/Instance name should be in all capital letters)
• SERVER/SQLEXPRESS

Specify table or view names in rules

• Table name must not contain special characters like "-"
• Do not prefix table names with dbo.