SQL Server ODBC Driver Configuration: Difference between revisions
No edit summary |
No edit summary |
||
| Line 21: | Line 21: | ||
[[File:SQL_Server_ODBC_Driver3.png]] | [[File:SQL_Server_ODBC_Driver3.png]] | ||
{{ScreenElementDescription|Change default database| | {{ScreenElementDescription|Change default database|Enable the option, and specify or select the name of the database on the MSSQL Server that should be used.}} | ||
All other parameters should be left on their default value, or they should be set accoording to the instructions of your MSSQL database administrator. | All other parameters should be left on their default value, or they should be set accoording to the instructions of your MSSQL database administrator. | ||
| Line 29: | Line 29: | ||
[[File:SQL_Server_ODBC_Driver4.png]] | [[File:SQL_Server_ODBC_Driver4.png]] | ||
All | All arameters should be left on their default value, or they should be set accoording to the instructions of your MSSQL database administrator. | ||
When the {{ScreenElement|Finish}} button is pressed, a final configuration dialog is shown. | When the {{ScreenElement|Finish}} button is pressed, a final configuration dialog is shown. | ||
Latest revision as of 13:32, 9 February 2011
The SQL Server ODBC Driver Configuration dialog allows you to configure the details of an ODBC connection to a MSSQL database. This dialog is not part of RadiMation®, but it is provided by Microsoft.
 Name
|
An unique name that uniquely identifies the Data Source from the other available Data Sources. |
| Description
|
Any additional information regarding the Data Source |
| Server
|
The name (or IP address) of the MSSQL server, to which a connection should be made |
When the Next > button is pressed, a second configuration dialog is shown.
| Windows NT Authentication
|
Select this option to use the credential of the logged in user to connect to the MSSQL server. |
| SQL Server Authentication
|
Select this option to use a SQL Server specific username and password to connect to the MSSQL server. |
| Client Configuration...
|
Will show additional configuration details for the MSSQL connection. Your MSSQL database administrator can help you with setting this details. |
| Login ID
|
The name of the MSSQL user that should be used to connect to the MSSQL Server |
| Password
|
The password of the MSSQL user that should be used to connect to the MSSQL Server |
When the Next > button is pressed, a third configuration dialog is shown.
| Change default database
|
Enable the option, and specify or select the name of the database on the MSSQL Server that should be used. |
All other parameters should be left on their default value, or they should be set accoording to the instructions of your MSSQL database administrator.
When the Next > button is pressed, a fourth configuration dialog is shown.
All arameters should be left on their default value, or they should be set accoording to the instructions of your MSSQL database administrator.
When the Finish button is pressed, a final configuration dialog is shown.
| Test Data Source...
|
Will perform a connection test, to determine if a connection with the MSSQL server can be established, using the configured parameters. A confirmation or error dialog with some additional information will be shown. |
| Ok
|
Stores the configured ODBC connection. |
| Cancel
|
Closes the dialogs without creating an ODBC connection. |
Once the MSSQL ODBC Data Source connection is correctly configured, the configuration of the customer database in RadiMation® can be performed.