Can't connect to SQL 2005

Hi,
I just installed MSDE 2005 (or, rather, whatever it's called now) on my
machine. I'm trying to connect to it using Enterprise Manager, but I
keep getting Unable to connect/connection refused messages.
I've tried giving it my machine name, the word (local), localhost,
127.0.0.1, my machine's IP... nothing. I've also tried all those
permutations using cliconfg.exe, with the same results.
I ran the SQL Manager plug-in, and it shows that SQL Server is indeed
running. Also I tried doing an ODBCPING against it, with the following
errors:
SQLState: 08001 Native Error: 17
Info. Message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server
does not exist or access denied.
SQLState: 01000 Native Error: 1326
Info. Message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]
ConnectionOpen (Connect()).
Any recommendations on a next step to try?
If you're trying to run the EM for 2000, it won't work. Not supported.
"Scott McNair" <scott.mcnair@.sfmco.takethispartout.com> wrote in message
news:Xns95D7AB2AE2D3Bsfmco@.207.46.248.16...
> Hi,
> I just installed MSDE 2005 (or, rather, whatever it's called now) on my
> machine. I'm trying to connect to it using Enterprise Manager, but I
> keep getting Unable to connect/connection refused messages.
> I've tried giving it my machine name, the word (local), localhost,
> 127.0.0.1, my machine's IP... nothing. I've also tried all those
> permutations using cliconfg.exe, with the same results.
> I ran the SQL Manager plug-in, and it shows that SQL Server is indeed
> running. Also I tried doing an ODBCPING against it, with the following
> errors:
> SQLState: 08001 Native Error: 17
> Info. Message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server
> does not exist or access denied.
> SQLState: 01000 Native Error: 1326
> Info. Message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]
> ConnectionOpen (Connect()).
> Any recommendations on a next step to try?
|||Derrick Leggett wrote:
> If you're trying to run the EM for 2000, it won't work. Not supported.
>
> "Scott McNair" <scott.mcnair@.sfmco.takethispartout.com> wrote in message
> news:Xns95D7AB2AE2D3Bsfmco@.207.46.248.16...
>
>
What about setting up an ODBC System DSN? Shouldn't this be supported
through the SQL Native Client? I get pretty much the same errors when
trying to do that.