Microsoft SQL Server Native Client install

  • X86 Package (sqlncli.msi) - 3516 KB

    X64 Package (sqlncli_x64.msi) - 6403 KB

    Should i install 32 bit or 64 bit Microsoft SQL Server Native on application server? THe backend database server for this application is sql server 2005 sp2 64 bit.

  • Why do you want to install SS native client on App server? I am just curious.

  • It was the requirement for the application.

  • FYI, application will even uses analysis services. May be for analysis services. It need sql server backward compability apart from native client. I even have question should i install 32 bit or 64 bit on 32 app server to connect to 64 bit sql server?

  • I don't think you have to install anything even if you have MDAC application.

    The Windows already has MDAC components including SQL Sever native client, you just may want to check it version.

  • NAtive client is application's requirement.but don't know why they need that. HOw can we say MDAC is installed ?

  • NAtive client is application's requirement.

    Yes, I understand. I am just think it is already installed with MDAC.

    There are two different ways to check which version of Microsoft Data Access Components (MDAC) is installed on a system:

    -Use the Component Checker tool.

    -Check the version information that is stored in the registry.

  • I even can't find out if MDAC is installed or not. HOw i can find that? I will worry about version later once i know MDAC is installed.

  • It is not about version. The only way to find MDAC is verify the version. If you see the version, something like 2.0, that means you have it installed.

    This is link, and I would recommend the second way there:

    http://support.microsoft.com/kb/301202

  • Here is how to check it through Registries:

    The version information is found in the following key:

    HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess\FullInstallVer

    To check the registry, follow these steps:

    On the Start menu, click Run.

    In the Open text box, type regedit and then click OK; this starts Registry Editor.

    In the Navigation pane, drill-down to the following path:

    HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess

    In the Details pane, look in the Name column for FullInstallVer and Version. Each of these keys will have corresponding version information in the Data column.

    When finished, click Exit on the Registry menu to close Registry Editor.

  • Thank you for the information. Ya it is installed.

    However i found the answer for my problem. I think i have install 32 bit sql server combatibility components in app server becasue 64 bit can't be installed on 32 bit OS.

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply