By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,470 Members | 1,426 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,470 IT Pros & Developers. It's quick & easy.

MSDE Error on attempting to create new Access 2000 project

P: n/a
Hi folks
I've just installed MSDE on my Win 2k machine and have attempted to
create a new Access 2000 project. When I do (and using a number of
different Login ID/Password combinations), I get this:

Connection failed:
SQLState: '01000'
SQL Server Error: 123
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen
(CreateFile()).
Connection failed:
SQLState: '08001'
SQL Server Error: 123
[Microsoft][ODBC SQL Server Driver]Client unable to establish
connection

can anyone tell me what this means and what I should do. Any help much
appreciated.

thanks

Laurence
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Laurence,

See: http://support.microsoft.com/default...b;en-us;233312

It looks like you do not have named pipes installed with your MSDE, but you
are using it from your client.

Russell Fields
"Laurence" <la************@yahoo.com> wrote in message
news:c8**************************@posting.google.c om...
Hi folks
I've just installed MSDE on my Win 2k machine and have attempted to
create a new Access 2000 project. When I do (and using a number of
different Login ID/Password combinations), I get this:

Connection failed:
SQLState: '01000'
SQL Server Error: 123
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen
(CreateFile()).
Connection failed:
SQLState: '08001'
SQL Server Error: 123
[Microsoft][ODBC SQL Server Driver]Client unable to establish
connection

can anyone tell me what this means and what I should do. Any help much
appreciated.

thanks

Laurence

Nov 13 '05 #2

P: n/a
Laurence,

Actually, you might find this more helpful (since my first post was to an
old version of MSDE)

ACC2002: "Configuring SQL Server 2000 Desktop Engine" White Paper Available
in Download Center
http://support.microsoft.com/default...b;en-us;301413

Russell Fields
"Laurence" <la************@yahoo.com> wrote in message
news:c8**************************@posting.google.c om...
Hi folks
I've just installed MSDE on my Win 2k machine and have attempted to
create a new Access 2000 project. When I do (and using a number of
different Login ID/Password combinations), I get this:

Connection failed:
SQLState: '01000'
SQL Server Error: 123
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen
(CreateFile()).
Connection failed:
SQLState: '08001'
SQL Server Error: 123
[Microsoft][ODBC SQL Server Driver]Client unable to establish
connection

can anyone tell me what this means and what I should do. Any help much
appreciated.

thanks

Laurence

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.