Hi all,
I have a Windows 2008 x64 server (MINERVA) set up with two SQL Server 2008 instances: a default instance called MSSQLSERVER which was installed as x64 and a second named instance, SQL32, installed as x86.
The default instance is the primary server. The other 32bit instance is solely intended to connect to a 32bit ODBC legacy data source (our accounting system).
I installed the default instance first, then the SQL32 instance. Both are patched to SP1, and report a version of 10.0.2531. Both have TCPIP and Shared memory protocols enabled and named pipes and "VIA" disabled.
Now the problem is that strange things happen connecting to the SQL32 instance...
On the server (MINERVA), connecting to MINERVA (the default instance) connects me to the default instance...OK
On the server (MINERVA), connecting to MINERVA\SQL32 connects me to SQL32...OK
On the server (MINERVA), connecting to MINERVA\SQL32,1433 .... connects me to the DEFAULT INSTANCE, *NOT* SQL32.
On a workstation, connecting to MINERVA (the default instance) connects me to the default instance...OK
On a workstation, connecting to MINERVA\SQL32 times out.
On a workstation, connecting to MINERVA\SQL32,1433 .... connects me to the DEFAULT INSTANCE, *NOT* SQL32.
Any ideas how I can access SQL32 from a workstation?
Thanks,
Ben.
Our community of experts have been thoroughly vetted for their expertise and industry experience.