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:
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=10.10.10.100\INSTANCENAME;Initial File Name="";Server SPN=""
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.