Connection Error using SQL Server ODBC

Hi, I'm trying to connect to an SQL Server using an ODBC driver, typed in th
e
Machine name, but it won't let me connect.
Where the wizard asks me what the server name is that I want to connect to,
the drop down is empty. I thought it should show me a list of servers to
choose from?
Also, if I try to type in the machine name, and connect, it gives me an
error that it either could not connect or I am unauthorized even though I
know I'm using the administrators login and password.
I'm sooooooo confused. Am I even using the right ODBC driver? It's [SQ
L
Server], and they tell me the database is SQL Servcer v.8...
Any ideas?
THANKS!!In the ODBC set up there are several ways to connect...
When setting it up you need to make sure that you click on client
configuraiton and choose a connection that your SQL Server allows. TCP/IP is
pretty typical on port 1433. Then you must make sure that your SQL server
allows connections using TCP/IP using your client configuration tools.
You also want to check simple things like making sure you can ping the
server (if your firewall allows it) to make sure that you can resolve your
server using DNS...
/*
Warren Brunk - MCITP,MCTS,MCDBA
www.techintsolutions.com
*/
"KRISTEN" <KRISTEN@.discussions.microsoft.com> wrote in message
news:B76386D1-75FB-4673-AC9B-FF501DB58D87@.microsoft.com...
> Hi, I'm trying to connect to an SQL Server using an ODBC driver, typed in
> the
> Machine name, but it won't let me connect.
> Where the wizard asks me what the server name is that I want to connect
> to,
> the drop down is empty. I thought it should show me a list of servers to
> choose from?
> Also, if I try to type in the machine name, and connect, it gives me an
> error that it either could not connect or I am unauthorized even though I
> know I'm using the administrators login and password.
> I'm sooooooo confused. Am I even using the right ODBC driver? It's [
SQL
> Server], and they tell me the database is SQL Servcer v.8...
> Any ideas?
> THANKS!!