%META:TOPICPARENT{name="ConfigureTroubleshootDBMSsForDataAccess"}% =Pre-Requisites for Connections to Microsoft SQL Server= ==Basic DBMS & DBMS Version Support== * [[DoOpenLinkDriversConnectToMSSQLServer|Do OpenLink drivers connect to Microsoft SQL Server?]] * [[WhichVersionsOfMSSQLServerAreSupportedByOpenLinkDrivers|Microsoft SQL Server version support]] * [[HowCanIDetectMyMSSQLServerDBMSVersion|Detecting the Microsoft SQL Server DBMS version]] ==Database Native Client Requirements== * [[WhatIsTheMSSQLServerNativeClient|Understanding the Microsoft SQL Server native client]] * [[WhenDoINeedTheMSSQLServerNativeClient|When do I need the Microsoft SQL Server native client?]] * [[WherecanIgettheMSSQLServernativeclient|Obtain the Microsoft SQL Server native client (a.k.a "NetLib")]] * [[HowDoIConfigureTheMSSQLServerNativeClient|Configure the Microsoft SQL Server native client]] ==Key Database Native Variables (Set Before OpenLink Install)== * [[WhatValueDoesTheDSQUERYEnvironmentVariablePass|DSQUERY]] * [[WhatValueDoesTheTDSHOSTEnvironmentVariablePass|TDSHOST]] * [[WhatValueDoesTheTDSPORTEnvironmentVariablePass|TDSPORT]] * [[WhatValueDoesTheTDSVEREnvironmentVariablePass|TDSVER]] ==Database Native Settings You Need to Know== * [[HowDoIFindMySQLServerInstanceName|Identify the Microsoft SQL Server Instance Name]] * [[HowDoIFindMySQLServerListenPort|Identify the Microsoft SQL Server Listen Port]] ==Database Configuration for Unicode== * [[SQLServerUnicodeConfig|Unicode Configuration]] ==Database Configuration for XA Support== * [[SQLConfigXASupport|XA Configuration]]