Can't connect to MS SQL server from a 32 bit client

Posted on 2014-08-28
Last Modified: 2014-08-28
We have a lot of MS SQL 2008 R2 servers in different locations, and there were not problem to use them from a 32bit application. Today we were going to setup another MS SQL server (v10.50.4000, a second SQL instance) and the application server, but somehow I can not connect from a 32 bit application, but 64 bit client connects just fine.
To test a connection from a 32bit application I run the following command from 32bit cmd.exe:
\Windows\SysWOW64\Rundll32.exe "%CommonProgramFiles%\System\OLE DB\oledb32.dll",OpenDSLFile connect.udl
where connect.udl contains the connection string:
; Everything after this line is an OLE DB initstring
Provider=SQLNCLI10.1;Integrated Security="";Persist Security Info=False;User ID=username;Initial Catalog=DBname;Data Source=\INSTANCENAME;Initial File Name="";Server SPN=""

Open in new window

What I have tried: Reinstall the SQL native client to SP2. Checked the server's configuration manager (32bit client protocol is enabled).
Also tried to make a test connection from the server machine itself and from some other machine, works both 64bit and 32bit.
Also works from the problem application server to the main instance of the SQL server.
Question by:zc2
    1 Comment
    LVL 18

    Accepted Solution

    Found a solution.
    In the server configuration manager the second instance had defined alias with non standard TCP port.
    The port has to be specified in the connection  string, like:,1435\INSTANCENAME

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Suggested Solutions

    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now