Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chulheekim
Starting Member
46 Posts |
 Posted - 2010-12-16 : 14:24:01
|
| 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 from my computer 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 since 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 error message when I try to log in to the sql server through my client 2005 program. Any thought? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-16 : 14:31:16
|
| Just type in the server\instance name. Don't bother looking for it in the dropdown list. |
 |
|
|
chulheekim
Starting Member
46 Posts |
Posted - 2010-12-16 : 15:35:13
|
| I found what the problem was. It works good after I change the firewall public profile state to off. |
|
|
|
|
|
|
ODBC from my computer to 64 bit SQL 2008 Express