troubleshooting Question
Problems with 32bit and 64bit SQL Server 2008 instances on the same server
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.
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.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.