Q. I have my own full version of SQL Server and would like to use that instead of MSDE or SQL Express to run Agvance. Are there any special instructions?
A. There are a few things to keep in mind:
- You will need to set an SA password (it doesn't have to be ssi). It should not be a blank password. If you will be converting data, you will use your own SA password, not the ones from the conversion instructions.
- The authentication mode for SQL server defaults to Windows. The other two options are SQL Server or Both. The authentication mode needs to be set either to SQL Server or Both.
- Once the password is set and the authentication mode is changed, SQL Server is ready to work with Agvance. The services must be running in order for the user to access the data.
