Difference between revisions of "SQL Server ODBC Driver Configuration"

From RadiWiki
Jump to: navigation, search
Line 10: Line 10:
  
 
[[File:SQL_Server_ODBC_Driver2.png]]
 
[[File:SQL_Server_ODBC_Driver2.png]]
 +
 +
{{ScreenElementDescription|Windows NT Authentication|Select this option to use the credential of the logged in user to connect to the MSSQL server.}}
 +
{{ScreenElementDescription|SQL Server Authentication|Select this option to use a SQL Server specific username and password to connect to the MSSQL server.}}
 +
{{ScreenElementDescription|Client Configuration...|Will show additional configuration details for the MSSQL connection. Your MSSQL database administrator can help you with setting this details.}}
 +
{{ScreenElementDescription|Login ID|The name of the MSSQL user that should be used to connect to the MSSQL Server}}
 +
{{ScreenElementDescription|Password|The password of the MSSQL user that should be used to connect to the MSSQL Server}}
 +
 +
When the {{ScreenElement|Next >}} button is pressed, a third configuration dialog is shown.
 +
 +
[[File:SQL_Server_ODBC_Driver3.png]]
 +
 +
{{ScreenElementDescription|Windows NT Authentication|Select this option to use the credential of the logged in user to connect to the MSSQL server.}}
 +
{{ScreenElementDescription|SQL Server Authentication|Select this option to use a SQL Server specific username and password to connect to the MSSQL server.}}
 +
{{ScreenElementDescription|Client Configuration...|Will show additional configuration details for the MSSQL connection. Your MSSQL database administrator can help you with setting this details.}}
 +
{{ScreenElementDescription|Login ID|The name of the MSSQL user that should be used to connect to the MSSQL Server}}
 +
{{ScreenElementDescription|Password|The password of the MSSQL user that should be used to connect to the MSSQL Server}}
 +
 +
When the {{ScreenElement|Next >}} button is pressed, a fourth configuration dialog is shown.
 +
 +
[[File:SQL_Server_ODBC_Driver4.png]]
 +
 +
{{ScreenElementDescription|Windows NT Authentication|Select this option to use the credential of the logged in user to connect to the MSSQL server.}}
 +
{{ScreenElementDescription|SQL Server Authentication|Select this option to use a SQL Server specific username and password to connect to the MSSQL server.}}
 +
{{ScreenElementDescription|Client Configuration...|Will show additional configuration details for the MSSQL connection. Your MSSQL database administrator can help you with setting this details.}}
 +
{{ScreenElementDescription|Login ID|The name of the MSSQL user that should be used to connect to the MSSQL Server}}
 +
{{ScreenElementDescription|Password|The password of the MSSQL user that should be used to connect to the MSSQL Server}}
 +
 +
When the {{ScreenElement|Finish}} button is pressed, a final configuration dialog is shown.
 +
 +
[[File:SQL_Server_ODBC_Driver5.png]]
  
 
{{ScreenElementDescription|Windows NT Authentication|Select this option to use the credential of the logged in user to connect to the MSSQL server.}}
 
{{ScreenElementDescription|Windows NT Authentication|Select this option to use the credential of the logged in user to connect to the MSSQL server.}}

Revision as of 13:25, 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.

SQL Server ODBC Driver1.png

ScreenElementDescription.png Name An unique name that uniquely identifies the Data Source from the other available Data Sources.
ScreenElementDescription.png Description Any additional information regarding the Data Source
ScreenElementDescription.png 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.

SQL Server ODBC Driver2.png

ScreenElementDescription.png Windows NT Authentication Select this option to use the credential of the logged in user to connect to the MSSQL server.
ScreenElementDescription.png SQL Server Authentication Select this option to use a SQL Server specific username and password to connect to the MSSQL server.
ScreenElementDescription.png Client Configuration... Will show additional configuration details for the MSSQL connection. Your MSSQL database administrator can help you with setting this details.
ScreenElementDescription.png Login ID The name of the MSSQL user that should be used to connect to the MSSQL Server
ScreenElementDescription.png 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.

SQL Server ODBC Driver3.png

ScreenElementDescription.png Windows NT Authentication Select this option to use the credential of the logged in user to connect to the MSSQL server.
ScreenElementDescription.png SQL Server Authentication Select this option to use a SQL Server specific username and password to connect to the MSSQL server.
ScreenElementDescription.png Client Configuration... Will show additional configuration details for the MSSQL connection. Your MSSQL database administrator can help you with setting this details.
ScreenElementDescription.png Login ID The name of the MSSQL user that should be used to connect to the MSSQL Server
ScreenElementDescription.png Password The password of the MSSQL user that should be used to connect to the MSSQL Server

When the Next > button is pressed, a fourth configuration dialog is shown.

SQL Server ODBC Driver4.png

ScreenElementDescription.png Windows NT Authentication Select this option to use the credential of the logged in user to connect to the MSSQL server.
ScreenElementDescription.png SQL Server Authentication Select this option to use a SQL Server specific username and password to connect to the MSSQL server.
ScreenElementDescription.png Client Configuration... Will show additional configuration details for the MSSQL connection. Your MSSQL database administrator can help you with setting this details.
ScreenElementDescription.png Login ID The name of the MSSQL user that should be used to connect to the MSSQL Server
ScreenElementDescription.png Password The password of the MSSQL user that should be used to connect to the MSSQL Server

When the Finish button is pressed, a final configuration dialog is shown.

SQL Server ODBC Driver5.png

ScreenElementDescription.png Windows NT Authentication Select this option to use the credential of the logged in user to connect to the MSSQL server.
ScreenElementDescription.png SQL Server Authentication Select this option to use a SQL Server specific username and password to connect to the MSSQL server.
ScreenElementDescription.png Client Configuration... Will show additional configuration details for the MSSQL connection. Your MSSQL database administrator can help you with setting this details.
ScreenElementDescription.png Login ID The name of the MSSQL user that should be used to connect to the MSSQL Server
ScreenElementDescription.png Password The password of the MSSQL user that should be used to connect to the MSSQL Server

Once the MSSQL ODBC Data Source connection is correctly configured, the configuration of the customer database in RadiMation® can be performed.

Retrieved from "https://wiki.radimation.com/wiki/index.php?title=SQL_Server_ODBC_Driver_Configuration&oldid=11201"