Connection Error using SQL Server ODBC   

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!!

date: Wed, 12 Dec 2007 11:42:03 -0800   author:   KRISTEN

Re: Connection Error using SQL Server ODBC   

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"  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!!

date: Wed, 12 Dec 2007 16:01:27 -0800   author:   Warren Brunk

Re: Connection Error using SQL Server ODBC   

do you also encountered this error: 
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default 
driver specified

please help me...



"Warren Brunk" wrote:

> 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"  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!! 
>

date: Thu, 14 Feb 2008 23:11:00 -0800   author:   marieyah