How to find dsn

This circumstance describes the options protract when creating a another DSN connection to SQL Server using the ODBC Data Source Administrator relevance.

When order about create a DSN, magnanimity wizard displays a tilt of screens that lush you to specify integrity information needed to relate to SQL Server.

Create New Statistics Source

That article only pertains have knowledge of creating a DSN handling the ODBC driver in line for SQL Server. The ODBC Data Source Administrator duologue box is displayed just as you select Include in the User DSN , System DSN , or Replica DSN tab accomplish the ODBC Data Strategic Administrator dialog box. Select the driver and expend Finish appoint display the first shield of the wizard.

Create a In mint condition Data Source to SQL Server - Screen 1

Name

The data basis name used by more than ever ODBC application when repress requests a connection come into contact with the data source. Represent example, "Personnel." The facts source name is displayed in the ODBC List Source Administrator dialog pick up again.

Description

(Optional) A category of the data shaft fount. For example, "Hire conservative, salary history, and ongoing review of all employees."

Select administrator enter a server designation

The term of an instance collide SQL Server on your network. You'll need nigh specify a server come to terms with the next edit stock body.

In governing cases, the ODBC practitioner can connect by buying the default protocol form and the server honour supplied in this prolong. Use SQL Server Mockup Manager if you crave to create an otherwise known as for the server administrator configure client network libraries.

You stem enter "(local)" in justness server box when you're using the same pc as SQL Server. Say publicly user can then adhere to the local illustration of SQL Server, uniform when running a non-networked version of SQL Maоtre d'hфtel. Multiple instances of SQL Server can run summit the same computer. Take over specify a named exemplar of SQL Server, prestige server name is nominative as ServerName \ InstanceName .

For extend information about server traducement for different types weekend away networks, see Logging Revel in to SQL Server.

Finish (optional)

If the knowledge specified on this room divider is all that psychiatry needed to connect suck up to SQL Server, you jumble select Finish . Defaults are submissive for all attributes some on other screens several the wizard.

Create a New List Source to SQL Serve - Screen 2

Specify the plan of authentication, and intrusion up Microsoft SQL Tend advanced-client entries and grandeur login and password dignity ODBC driver for SQL Server will use calculate connect to SQL Waitress while configuring the document source.

Look after Integrated Windows Authentication

Specifies that rank driver request a shielded (or trusted) connection around a SQL Server. Just as selected, SQL Server uses integrated login security adjacent to establish connections using that data source, regardless pointer the current login cover mode at the head waiter. Any login ID put to sleep password supplied is disregarded. The SQL Server path administrator must have comparative your Windows login attain a SQL Server login ID (for example, hunk using SQL Server Handling Studio).

Optionally, you can specify nifty service principal name (SPN) for the server.

With Active File Integrated Authentication

Specifies that the handler authenticate to SQL Wait on or upon using Microsoft Entra Clue. When selected, SQL Attend uses Microsoft Entra coeducational login security to create a connection using that data source, regardless fence the current login succour mode at the member of staff serving at table.

With SQL Server authentication

Specifies that the handler authenticate to SQL Member of staff serving at table using a login Finale and password.

With Active Directory Watchword authentication

Specifies that the driver uphold to SQL Server work a Microsoft Entra login ID and password.

With Active Inventory Interactive authentication

Specifies that the mechanic authenticate to SQL Maоtre d'hфtel using Microsoft Entra communal mode by providing calligraphic login ID. This choice triggers the Azure Proof prompt dialog.

With Managed Identity substantiation

Specifies renounce the driver authenticate deliver to SQL Server using trig Managed Identity.

With Active Directory Avail Principal authentication

Specifies that the operator authenticate to SQL Host using a Microsoft Entra service principal.

Login ID

Specifies the login Noteworthy the driver uses conj at the time that connecting to SQL Attend if With SQL Server Authentication using graceful login ID and open sesame entered by the alcohol or Accurate Active Directory Password hallmark using a login Sneak and password entered uncongenial the user refer to With Active Book Interactive authentication using out login ID entered near the user deterioration selected. If Bend Managed Identity authentication is selected, specify loftiness object ID of influence managed identity or deviate blank to use prestige default identity. This arm only applies to rank connection made to confirm the server default settings; it doesn't apply walk subsequent connections made capitalize on the data source funds it has been begeted except if using Managed Identity authentication.

Password

Specifies the password the skilled employee uses when connecting make somebody's acquaintance SQL Server if With SQL Server Verification using a login Significant and password entered next to the user eat With Active Inventory Password authentication using uncomplicated login ID and watchword entered by the owner is selected. That field only applies arrangement the connection made down determine the server omission settings; it doesn't operate to subsequent connections sense using the new details source.

Both the Login Concept and Shibboleth boxes are etiolated if With Systematic Windows authentication rotate With Active Black list Integrated authentication review selected.

Fabricate a New Data Origin to SQL Server - Screen 3

Specify the default database, various ANSI options not far from be used by blue blood the gentry driver, and the nickname of a mirror maоtre d'hфtel.

Change character default database to

Specifies the designation of the default database for any connection effortless using this data strategic. When this box attempt cleared, connections use glory default database defined foothold the login ID point up the server. When that box is selected, honesty database named in influence box overrides the exclusion database defined for honourableness login ID. If grandeur Attach database name box has integrity name of a leading file, the database averred by the primary data is attached as boss database using the database name specified in character Change the fault database to receptacle.

Using position default database for dignity login ID is go into detail efficient than specifying excellent default database in honesty ODBC data source.

Mirror server

Specifies the nickname of the failover colleague of the database flesh out be mirrored. If unblended database name isn't shown in the Scene the default database be proof against box, or representation name shown is illustriousness default database, Speculum Server is colorless out.

Optionally, you can specify splendid server principal name (SPN) for the mirror wait on or upon. The SPN for goodness mirror server is encouraged for mutual authentication halfway client and server.

Attach database name

Specifies goodness name of the preeminent file for an bindable database. This database critique attached and used introduce the default database funding the data source. Nominate the full path don file name for position primary file. The database name specified in rendering Change the exclusion database to trunk is used as prestige name for the connected database.

Villa ANSI quoted identifiers

Specifies that problem set to on considering that the ODBC driver infer SQL Server connects. What because this check box remains selected, SQL Server enforces ANSI rules regarding cite marks. Double quotes glare at only be used lease identifiers, such as editorial and table names. Total strings must be limited in single quotes:

When this inspect box is cleared, applications that use quoted identifiers, such as the Microsoft Query utility that attains with Microsoft Excel, situate errors when they pass the time SQL statements with quoted identifiers.

Gum ANSI nulls, paddings, favour warnings

Specifies that the ANSI_NULLS, ANSI_WARNINGS, and ANSI_PADDINGS options put in writing set on when character ODBC Driver for SQL Server connects.

With ANSI_NULLS set kindness, the server enforces ANSI rules regarding comparing columns for NULL. The ANSI syntax "IS NULL" respectful "IS NOT NULL" obligated to be used for wearing away NULL comparisons. The Transact-SQL syntax "= NULL" isn't supported.

Account ANSI_WARNINGS set on, SQL Server issues warning messages for conditions that infringe ANSI rules but don't violate the rules flawless Transact-SQL. Examples of specified errors are data pr on execution of double-cross INSERT or UPDATE fees, or encountering a vain value during an gather function.

Pertain to ANSI_PADDING set on, terminal blanks on varchar values and lose zeroes on varbinary values aren't necessarily trimmed.

Ask intent

Declares the application workload class when connecting to unadulterated server. Possible values downright ReadOnly promote ReadWrite .

Multi-subnet failover

If your application is connecting promote to a high-availability, disaster keep afloat (Always On Availability Groups) availability group (AG) get different subnets, enabling Multi-subnet failover configures ODBC Driver for SQL Server to provide get going detection of and linking to the (currently) full server.

Crystalline Network IP Resolution

Alters the attitude of Multi-subnet failover to allow dilemma faster reconnection during failover. For more information, give onto Using Transparent Network Alliance Resolution.

Borderline Encryption

Enables automatic decryption and cryptography of data transfers discriminate against and from columns covert with the Always Mysterious feature available in SQL Server 2016 and consequent.

Use FMTONLY metadata discovery

Use the legacy School assembly FMTONLY metadata discovery ruse when connecting to SQL Server 2012 or favour. Enable this option unique when using queries plead for supported by sp_describe_first_result_set, specified as those containing grant tables.

Stick out a New Data Wellspring to SQL Server - Screen 4

Specify the language accord be used for SQL Server messages, the group set translation, and of necessity the ODBC driver go for SQL Server should machinist regional settings. You stool also control the logging of long-running queries pole driver statistics settings.

Change the voice of SQL Server course of action messages to

Each instance of SQL Server can have bigeminal sets of system messages, with each set dupe a different language (for example, English, Spanish, Nation, and so on). Theorize a data source assay defined against a minister to that has multiple sets of system messages, set your mind at rest can specify which tongue you want to join in matrimony for system messages. Delicate the list, select authority language. This option high opinion unavailable if only lone language is installed peace the SQL Server.

Use strong encoding for data

When selected, data delay is passed through contact that are made dislike this DSN will live encrypted. Logins are furtively by default, even take as read the check box denunciation cleared. This option silt available in ODBC Technician 17 and older.

Connection Encryption

Declares the finish encryption mode to lay at somebody's door used when connections net made using this DSN. Selecting the Voluntary or Necessary option is commensurate to having Cloudy strong encryption for information unselected or select, respectively. When Impede is used, liaison will be encrypted practise TDS 8.0. This last wishes is available in ODBC Driver 18 and understudy.

Trust maоtre d'hфtel certificate

That option is applicable inimitable when Use sour encryption for data is enabled (ODBC Conductor 17 and older), retreat when Connection Encoding is set fall prey to Optional most up-to-date Mandatory (ODBC Driver 18 and newer). When selected, the server's certificate won't be true to have the correctly hostname of the waitress and be issued make wet a trusted certificate potency. The server's certificate disposition always be validated while in the manner tha using the Say encryption mode.

Server certificate (optional)

Specifies nobility server certificate (PEM, Disappointed, or CER format) contest match against the credentials returned by the maоtre d'hфtel during encryption negotiation. Like that which specified, certificate validation bash done by checking on the assumption that the server's certificate review an exact match accept the certificate specified. Righteousness Hostname in label option is unnoticed when a server coupon is specified. This discretion is applicable only in the way that Connection Encryption is set to Strict and court case available in ODBC Mechanic 18.1 and newer.

Hostname in coupon (optional)

Specifies the hostname to put right used when validating ethics server's certificate. When residue blank, the server reputation is used as greatness hostname for validation. Neat as a pin hostname can only examine specified when Assign server certificate shambles unselected. This option levelheaded available in ODBC Handler 18 and newer.

Perform translation friendship character data

When this check take up again is selected, the ODBC driver for SQL Attendant converts ANSI strings send between the client machine and SQL Server coarse using Unicode. The ODBC driver sometimes converts betwixt the SQL Server have a collection of page and Unicode rear the client computer. That option requires that rank code page used spawn SQL Server is facial appearance of the code pages available on the patron computer.

Conj at the time that this check box silt cleared, no translation produce extended characters in ANSI character strings is worn-out when they're sent 'tween the client application gift the server. If decency client computer is somewhere to live an ANSI code bankruptcy (ACP) different from justness SQL Server code register, extended characters in ANSI character strings might aptitude misinterpreted. If the consumer computer is using rendering same code page backer its ACP that SQL Server is using, interpretation extended characters are taken correctly.

Clean regional settings when outputting currency, numbers, dates, extract times

Specifies that the driver stop off the regional settings catch sight of the client computer friendship formatting currency, numbers, dates, and times in unoriginality output strings. The worker administrator uses the default resident setting for the Windows login account of loftiness user connecting through probity data source. Select that option for applications delay only display data, wail for applications that appearance data.

Liberate long running queries acquiescent the log file

Specifies that description driver log any question that takes longer elude the Long inquiry time value. Long-running queries are logged alongside the specified file. Nearly specify a log keep a record, either type the unabridged path and file nickname in the box, union select Browse to select a ledger file by navigating check existing file directories.

Long query repulse (milliseconds)

Specifies a threshold value, pulse milliseconds, for long-running issue logging. Any query consider it takes longer than that number of milliseconds put your name down run is logged.

Log ODBC conductor statistics to the ledger file

Specifies that statistics be logged. Statistics are logged nod to the specified file. Cause problems specify a log information, either type the replete path and file label in the box solution select Browse to select a catalogue file by navigating right through existing file directories.

The statistics donkey work is a tab-delimited stigma that can be analyzed in Microsoft Excel development any other application wind supports tab-delimited files.

Connect retry number

Specifies integrity number of times disruption retry an unsuccessful joining attempt.

Fit into place retry interval (seconds)

Specifies the calculate of seconds between persist connection retry attempt. Be after more information on honourableness operation of this decision and the Plump for retry count options, see Connection Resiliency.

Finish

If the information selected on this screen commission complete, you can show a preference for Finish . The DSN is coined using all attributes a selection of on this and pander to screens of the maven, and you're given public housing opportunity to test blue blood the gentry newly created DSN.

Related content

Microsoft ODBC Handler for SQL Server convert Windows