December 16, 2010 at 10:53 am
I’m a newbie DBA. We recently installed 64 bit SQL Server 2008 Express on a machine. For some reason, we had to give a specific instance name. Let’s say its server and instance name is ABC/DEF. I’m trying to set up ODBC connection to the sql server. From the list of the sql servers available, I could see only server name portion (ABC). If I try that one, it got me an error saying there's no such instance. I believe it is because instance name was not provided, it will try to look for the default name which is MSSQLSERVER. I'm not sure whether it is related to 64 bit. Maybe, it's compatibility problem. I have sql serer 2005 client program in my computer. To tell you the truth, I have the exactly same problem when I try to log in to the sql server through my client 2005 program. Give me some light please.
December 16, 2010 at 11:17 am
December 16, 2010 at 11:22 am
Yes I did. It did not work.
December 16, 2010 at 12:32 pm
Connect to that using SSMS and execute select @@servername Enter the same server name in the ODBC connection.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
December 16, 2010 at 12:33 pm
I just checked my local instance of SQL Server Express 2008 R2 and it looks like only Shared Memory Protocol is enabled by default (I dont ever remember changing it).
make sure the TCP/IP protocol is enabled in "SQL Server Configuration Manager" => "SQL Server Network Configuration" => "Protocols for <Instance name>"
December 16, 2010 at 1:34 pm
I found what the problem was. It works good after I change the firewall public profile state to off.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply