The AutoSperm system has been discontinued. These pages are for documentation only.

Connect to SQL server

Command

Admin
Connect to SQL server

Description

Use this dialog to view or specify options when connecting to the Microsoft SQL Server.

Required input

  • Driver: select SQL Native Client or SQL Server.
  • Server: select the server to connect to. When SQL Server 2005 Express Edition is installed on your local PC, enter .\sqlexpress. If you are connecting to SQL Server 2005 Express Edition on a remote computer, use the computer name followed by \sqlexpress.
  • Authentication: two authentication modes are available:
    • Windows Authentication: allows to connect through a Windows user account.
    • SQL Server Authentication: when a user connects with a specified login name and password from a non-trusted connection, SQL Server performs the authentication itself by checking to see if a SQL Server login account has been set up and if the specified password matches the one previously recorded. If SQL Server does not have a login account set, authentication fails, and the user receives an error message.
  • User name: enter the user name to connect with. This option is only available if you have selected to connect using SQL Server Authentication.
  • Password: enter the password for the login. This option is only available if you have selected to connect using SQL Server Authentication.

Click OK to connect to the selected server.

Privacy policy Contact Site map