How to create DSN for DATABASE ON SQL SERVER on Windows 8

What is DSN ?

A data source name (DSN) is a data structure that contains the information about a specific database that an Open Database Connectivity ( ODBC ) driver needs in order to connect to it.

What is SQL Server?

SQL Server is a relational database management system (RDBMS) from Microsoft that's designed for the enterprise environment.

How to create DSN for SQL server on Windows 8?

1. Open the ODBC Data Source Administrator as described in the topic, How to: Open the ODBC Data Source Administrator.

2. On the User DSN tab or the System DSN tab, click Add to add a user data source or a system data source.

3. Click SQL Native Client or SQL Server Native Client 10.0 to select the driver, and then click Finish.

4. Follow the instructions in the Wizard.

• #science_technology
• #create
• #server
• #windows
• #windows_8_operating_system
• #microsoft_sql_server_database_management_system
• #microsoft_windows_operating_system
• #sql_programming_language
• #dsn
• #how_to_crete_dsn
• #dsn_stands_for_data_source_name
• #introduction_to_dsn
• #introducton_to_odbc_drivers
• #dsn_data_structure
• #sql_server_management_studio