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 |
|
noopy
Starting Member
5 Posts |
 Posted - 2008-08-29 : 06:06:25
|
While creating an ODBC connection for SQL Server 2005 when I try to select the server name from the drop down it is empty. It is not showing the server nameAny Idea why is this happening?? |
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-08-29 : 06:29:02
|
| Are you on a different machine to where SQL Server is installed, aiming to access it over a LAN/internet? |
 |
|
|
noopy
Starting Member
5 Posts |
Posted - 2008-08-29 : 06:32:37
|
| yes, over LAN...infact these are two different domains connected with P2P connectivity......all the clients can ping the server machine. |
|
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-08-29 : 06:44:21
|
| Are you going Start -> Control Panel -> Administrative tools -> Data Sources(ODBC)? What are your driver options & which one did you select? |
|
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-08-29 : 06:45:24
|
| It could be a firewall blocking it. If you have one, try disabling it to see if thatt's the problem |
|
|
|
noopy
Starting Member
5 Posts |
Posted - 2008-08-29 : 06:59:43
|
quote:
Originally posted by dexter.knudson
Are you going Start -> Control Panel -> Administrative tools -> Data Sources(ODBC)? What are your driver options & which one did you select?
I am creating System DSN and selecting "SQL Server" as a driver name. |
|
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-08-29 : 07:21:07
|
| Firewall? And the SQL Server services are definately running? |
|
|
|
|
|
|
ODBC with SQL 2005