April 23, 2012 at 8:58 am
Hope someone can help with this one, I've installed SQL Server 2008 r2 developer edition onto the same pc as a default instance of 2005.
however when I try and connect via SSMS 2008 to the 2008 instance its reporting it's unable to connect, however the service is running and i'm able to stop and start the sql server as well via services.
Any ideas.
April 23, 2012 at 9:36 am
RedLegSQL (4/23/2012)
Hope someone can help with this one, I've installed SQL Server 2008 r2 developer edition onto the same pc as a default instance of 2005.however when I try and connect via SSMS 2008 to the 2008 instance its reporting it's unable to connect, however the service is running and i'm able to stop and start the sql server as well via services.
Any ideas.
And how are you connecting? SERVERNAME\NAMEDINSTANCE?
Jared
CE - Microsoft
April 23, 2012 at 11:31 pm
Did you add yourself as one of the admins during the set-up?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 24, 2012 at 12:14 am
RedLegSQL (4/23/2012)
.. its reporting it's unable to connect, however the service is running...
1) Please post the error message.
2) Make sure that SQL Server Browser service running.
April 24, 2012 at 12:58 am
April 25, 2012 at 5:49 am
Dooooohhhh sorry guys it was a long day and I forget to put the default instance name first !!!!
cheers for the reponses
April 25, 2012 at 6:20 am
April 26, 2012 at 9:15 am
I am not trying to hijack this thread; I am just making this information available to any interested parties.
We have this same structure except that the 2005 named instance is on a separate server. The issue we are having is that performance from 2008 R2 to a named instance of 2005 is horrid. There is a known issue and various bug reports on it available online. It appears the issue is Microsoft's driver(s) for linked server activity.
We are currently working with Microsoft's Tier 2 support to resolve the issue. We have tried Data Direct's SQL Server driver and throughput is marvelous, but they want 40+k for a driver that would require code changes on our part to use.
If anyone, has a solution to this or a work-around I would love to hear about it.
Bestest!
John
April 26, 2012 at 10:18 pm
jmiceli (4/26/2012)
I am not trying to hijack this thread; I am just making this information available to any interested parties.We have this same structure except that the 2005 named instance is on a separate server. The issue we are having is that performance from 2008 R2 to a named instance of 2005 is horrid. There is a known issue and various bug reports on it available online. It appears the issue is Microsoft's driver(s) for linked server activity.
We are currently working with Microsoft's Tier 2 support to resolve the issue. We have tried Data Direct's SQL Server driver and throughput is marvelous, but they want 40+k for a driver that would require code changes on our part to use.
If anyone, has a solution to this or a work-around I would love to hear about it.
Bestest!
John
Just for my information.....How does Data Direct's SQL Server driver increase the throughput?....What is it supposed to do??..
April 27, 2012 at 8:23 am
In all honesty, Vinu, I have no idea why their driver works faster. I figure since their business is providing finely tuned drivers for various database engines, they have simply invested the resources to build a market.
I almost wonder if Microsoft's unwillingness to fix the issue is not a planned lack of effort to force upgrades to the newer versions of SQL Server. The support we have paid for thus far and been completely dissatisfied with has led us to to give up on them. We are simply upgrading our boxes completely and making everything 2008 R2.
Bestest,
John
April 27, 2012 at 10:56 pm
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply