MSDE Security. Oxymoron?

We have a commercial application that uses a number of Access DBs. For security reasons we have to encrypt all the data. It's not personal data or anything, just proprietary information.

I've been thinking about MSDE instead of Access so I could stop encrypting. Since the user will only get MSDE they won't be able to get the data without our application since they won't know the user or pwd. Unless...

If they already have the full SQL Server on some other system, couldn't they just copy the MDF file from our application to that server, attach it as a new DB and have full access to it (using the admin account on the full system?)

I guess it comes down to can an MSDE database be read on a full SQL Server instance elsewhere?The scenario you describe is correct. The users would have to stop the SQL Services (no big challenge for most folks), in order to ensure they get a nice clean copy. They can even probably access the data with the SQL tools if they are a local admin on the MSDE machine (unless you removed the BUILTIN\ADMINISTRATORS group).

You may just want to go for the full fledged version of SQL Server, and put the server in a locked server room, with no user permissions on the data and backup directories.

MSDE Release A max number of concurrent queries

Hi All. A friend of mine mentioned that Release A actually has the max number
of concurrent queries to be 25 instead of 7 as MSDE. Is this true? Thank you
hi Andrew,
Andrew @. Abaki wrote:
> Hi All. A friend of mine mentioned that Release A actually has the
> max number of concurrent queries to be 25 instead of 7 as MSDE. Is
> this true? Thank you
false.. MSDE (and there's only one of it, only different packages with
different eulas) allows up to 8 concurrent (of the ones included in the
count of the Governor it self) batches before the Governor Workload kicking
in ...
http://msdn.microsoft.com/library/?u...asp?frame=true
25 is a "magic number" guessed by Microsoft,
http://www.microsoft.com/sql/msde/ho.../msdeuse.mspx, at the question
Q. Can I use MSDE as a database for Web applications?
A. Yes, MSDE is an ideal solution for basic Web applications with up to 25
concurrent users.
this number obviously depends on the application code quality, access type,
data nature and design, activities on it, ...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||The confusion comes from "concurrent queries" versus "concurrent users".
The workload governor operates off the former while users are typically
looking to configure based on the latter.
The workload governor allows essentially 480 (sub-second) database queries
or other (e.g., update) operations per minute without degradation. You can
ballpark what this means in terms of transactions. Assume a simple
transaction has perhaps 5 queries. A mid-level has perhaps 20, and a
complex transaction has about 40. So you can support between 10 and 100
transactions per minute with MSDE with no degradation. OLTP leans towards
the simple side (volume-wise you might have 70-80% of your transactions in
the simple category) so lets assume 75 transactions per minute.
The real question for MSDE thus is, how many users does it take to generate
75 transactions in a minute. If your users submit one transaction per
minute then you could support 75 users. If your users submit 2-3
transactions per minute then you get to the 25 users that Microsoft targets
as a maximum. If your workload leans towards the more complex transactions
then the numbers you support go down. If users do very infrequent
transactions then the numbers go up.
Microsoft's real target for MSDE was for apps that support 10 users or less.
There is a lot of history there in terms of the business target and the
technical requirements. One part of the requirements analysis dictated that
hard concurrent user limits cause major customer dissatisfaction. So MSDE
was not given a hard concurrent user limit nor was the governor set to make
performance fall off a cliff after 10 users. The result is that for many
applications MSDE supports far larger numbers of users than the technical
specs might indicate.
Hal Berenson, President
PredictableIT, LLC
www.predictableit.com
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3sbpn3Fn11hqU1@.individual.net...
> hi Andrew,
> Andrew @. Abaki wrote:
> false.. MSDE (and there's only one of it, only different packages with
> different eulas) allows up to 8 concurrent (of the ones included in the
> count of the Governor it self) batches before the Governor Workload
> kicking in ...
> http://msdn.microsoft.com/library/?u...asp?frame=true
> 25 is a "magic number" guessed by Microsoft,
> http://www.microsoft.com/sql/msde/ho.../msdeuse.mspx, at the question
> Q. Can I use MSDE as a database for Web applications?
> A. Yes, MSDE is an ideal solution for basic Web applications with up to 25
> concurrent users.
> this number obviously depends on the application code quality, access
> type, data nature and design, activities on it, ...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||And, BTW, this is an oversimplification. Most queries take a tiny fraction
of a second. So you could really support quite a bit more than I show. But
my example allows for some decent conservative planning.
Hal Berenson, President
PredictableIT, LLC
www.predictableit.com
"Hal Berenson" <hberenson@.predictableit.com> wrote in message
news:u9qGL4x2FHA.632@.TK2MSFTNGP10.phx.gbl...
> The confusion comes from "concurrent queries" versus "concurrent users".
> The workload governor operates off the former while users are typically
> looking to configure based on the latter.
> The workload governor allows essentially 480 (sub-second) database queries
> or other (e.g., update) operations per minute without degradation. You
> can ballpark what this means in terms of transactions. Assume a simple
> transaction has perhaps 5 queries. A mid-level has perhaps 20, and a
> complex transaction has about 40. So you can support between 10 and 100
> transactions per minute with MSDE with no degradation. OLTP leans towards
> the simple side (volume-wise you might have 70-80% of your transactions in
> the simple category) so lets assume 75 transactions per minute.
> The real question for MSDE thus is, how many users does it take to
> generate 75 transactions in a minute. If your users submit one
> transaction per minute then you could support 75 users. If your users
> submit 2-3 transactions per minute then you get to the 25 users that
> Microsoft targets as a maximum. If your workload leans towards the more
> complex transactions then the numbers you support go down. If users do
> very infrequent transactions then the numbers go up.
> Microsoft's real target for MSDE was for apps that support 10 users or
> less. There is a lot of history there in terms of the business target and
> the technical requirements. One part of the requirements analysis
> dictated that hard concurrent user limits cause major customer
> dissatisfaction. So MSDE was not given a hard concurrent user limit nor
> was the governor set to make performance fall off a cliff after 10 users.
> The result is that for many applications MSDE supports far larger numbers
> of users than the technical specs might indicate.
> Hal Berenson, President
> PredictableIT, LLC
> www.predictableit.com
>
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
> news:3sbpn3Fn11hqU1@.individual.net...
>

MSDE Performance Governor - knowing when its kicked in

I'm working on a VB.NET project where we are intending to use MSDE as our
back-end database. The actual number of users is expected to be low and I
don't have any concerns as to whether MSDE will be up to the job (most of
the time). I'm aware that if we end up with lots of users connecting to our
site at once (which may happen as certain times in the year when people need
information for deadlines) then the performance governor in MSDE will kick
in and slow everything down.

What I don't know is how do I find out whether the performance governor has
kicked in?

I would like to know how to monitor this so we can make an educated decision
as to when we need to migrate to a full version of SQL Server (if at all).

Can anyone point me in the right direction for finding this out?

thanks,

Brian Cryer."Brian Cryer" <brianc@.127.0.0.1.activesol.co.uk> wrote in message
news:1106559318.8377.0@.damia.uk.clara.net...
> I'm working on a VB.NET project where we are intending to use MSDE as our
> back-end database. The actual number of users is expected to be low and I
> don't have any concerns as to whether MSDE will be up to the job (most of
> the time). I'm aware that if we end up with lots of users connecting to
> our
> site at once (which may happen as certain times in the year when people
> need
> information for deadlines) then the performance governor in MSDE will kick
> in and slow everything down.
> What I don't know is how do I find out whether the performance governor
> has
> kicked in?
> I would like to know how to monitor this so we can make an educated
> decision
> as to when we need to migrate to a full version of SQL Server (if at all).
> Can anyone point me in the right direction for finding this out?
> thanks,
> Brian Cryer.

Check out DBCC CONCURRENCYVIOLATION in Books Online. If you don't already
have the latest version of BOL, then you should download it, as it has more
detailed information about MSDE and the workload governor that wasn't in
previous versions.

Simon|||"Simon Hayes" <sql@.hayes.ch> wrote in message
news:41f4c703$1_1@.news.bluewin.ch...
> "Brian Cryer" <brianc@.127.0.0.1.activesol.co.uk> wrote in message
> news:1106559318.8377.0@.damia.uk.clara.net...
> > I'm working on a VB.NET project where we are intending to use MSDE as
our
> > back-end database. The actual number of users is expected to be low and
I
> > don't have any concerns as to whether MSDE will be up to the job (most
of
> > the time). I'm aware that if we end up with lots of users connecting to
> > our
> > site at once (which may happen as certain times in the year when people
> > need
> > information for deadlines) then the performance governor in MSDE will
kick
> > in and slow everything down.
> > What I don't know is how do I find out whether the performance governor
> > has
> > kicked in?
> > I would like to know how to monitor this so we can make an educated
> > decision
> > as to when we need to migrate to a full version of SQL Server (if at
all).
> > Can anyone point me in the right direction for finding this out?
> > thanks,
> > Brian Cryer.
> Check out DBCC CONCURRENCYVIOLATION in Books Online. If you don't already
> have the latest version of BOL, then you should download it, as it has
more
> detailed information about MSDE and the workload governor that wasn't in
> previous versions.
> Simon

Excellent Simon. Just what I was after.

Many Thanks.

Brian.

MSDE Max Connections?

Hi, can anyone tell me whats the maximum number of connections you can have to MSDE? Eg, is it enough to host an intranet site for a relativly small business?There is no practical maximum. There is a throttle, however, when there are more than five concurrent sessions that are processing data. I've seen apps with many dozens of users use MSDE without the throttle kick in, when their data usage was relatively light.

There are lots of subtleties, but it's a good chance that it'll work for you.

Don|||Thanks Don :)

MSDE Limits

I know from experience that when the number of concurrent users on an MSDE
database exceeds the limit, an error is logged and the workload govenor
kicks in. Does something similar occur when the 2 GB limit is exceeded? I
had the experience yesterday where an application stopped responding for no
apparent reason. It's MSDE database was near 2 GB and the only thing we
could figure was that MSDE was trying to extend the database past 2GB.
Unfortunately there was no error logged, either from MSDE or from my
application.
MSDE will not allow you to extend the size of the database beyond 2GB. There
is no limit on the size of the log file, but there will be an inherent limit
on insert transactions due to the limit on the database size. If your
database has reached 2GB you should still be able to query data or perform
deletes or updates (as long as the update don't tigger an extent). If MSDE
failed to create an extent then there should be an log entry created in the
SQL Server log.
Jim
"Andy Walldorff" <andyw@.REMOVEsuperior.net> wrote in message
news:OfI6oIJHEHA.3288@.TK2MSFTNGP12.phx.gbl...
> I know from experience that when the number of concurrent users on an MSDE
> database exceeds the limit, an error is logged and the workload govenor
> kicks in. Does something similar occur when the 2 GB limit is exceeded?
I
> had the experience yesterday where an application stopped responding for
no
> apparent reason. It's MSDE database was near 2 GB and the only thing we
> could figure was that MSDE was trying to extend the database past 2GB.
> Unfortunately there was no error logged, either from MSDE or from my
> application.
>
|||Thanks
"Jim Young" <thorium48@.hotmail.com> wrote in message
news:uxhZEINHEHA.4092@.TK2MSFTNGP11.phx.gbl...
> MSDE will not allow you to extend the size of the database beyond 2GB.
There
> is no limit on the size of the log file, but there will be an inherent
limit
> on insert transactions due to the limit on the database size. If your
> database has reached 2GB you should still be able to query data or perform
> deletes or updates (as long as the update don't tigger an extent). If MSDE
> failed to create an extent then there should be an log entry created in
the
> SQL Server log.
> Jim
> "Andy Walldorff" <andyw@.REMOVEsuperior.net> wrote in message
> news:OfI6oIJHEHA.3288@.TK2MSFTNGP12.phx.gbl...
MSDE
> I
> no
>

MSDE liciense

was that MSDE is a free distribute software and have not
access limitation for the number of the user?
where i can find the more license infor for MSDE
thanks in advance
Try http://www.microsoft.com/sql/msde/default.asp and
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
Regards,
John
"How" <how_world@.hotmail.com> wrote in message
news:914401c4334f$ee4f8bc0$a501280a@.phx.gbl...
> was that MSDE is a free distribute software and have not
> access limitation for the number of the user?
> where i can find the more license infor for MSDE
> thanks in advance

MSDE Installation

When I install MSDE (MSDERelA) it installs fine, but it doesn't start the
service.
I am deploying this to a large number of computers and I don't want to have
to require them to reboot or go into the component services console in order
to use the database.
It there a why to start the service as soon as it installs without user
having to go into the services console or reboot?
Hi Lance,
From your descriptions, I understood that you MSDE instance will not be
launched unless you reboot your box or go into the services console. Have I
understood you? If there is anything I misunderstood, please feel free to
let me know
Based on my scope, after the installation, the service is started by
default. Look in Task Manager and you should see the service running. You
can use any application that connects to the service or you can issue osql
commands to work with the service.
Are there any error log shown during the setup? If you are installing the
MSDE stand-alone, will the service be started?
Anyway, if the service is not started by default, you could try to start it
with a DOS command "net start <Service Name>" in your application.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

MSDE Installation

When I install MSDE (MSDERelA) it installs fine, but it doesn't start the
service.
I am deploying this to a large number of computers and I don't want to have
to require them to reboot or go into the component services console in order
to use the database.
It there a why to start the service as soon as it installs without user
having to go into the services console or reboot?Hi Lance,
From your descriptions, I understood that you MSDE instance will not be
launched unless you reboot your box or go into the services console. Have I
understood you? If there is anything I misunderstood, please feel free to
let me know
Based on my scope, after the installation, the service is started by
default. Look in Task Manager and you should see the service running. You
can use any application that connects to the service or you can issue osql
commands to work with the service.
Are there any error log shown during the setup? If you are installing the
MSDE stand-alone, will the service be started?
Anyway, if the service is not started by default, you could try to start it
with a DOS command "net start <Service Name>" in your application.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

MSDE Installation

When I install MSDE (MSDERelA) it installs fine, but it doesn't start the
service.
I am deploying this to a large number of computers and I don't want to have
to require them to reboot or go into the component services console in order
to use the database.
It there a why to start the service as soon as it installs without user
having to go into the services console or reboot?Hi Lance,
From your descriptions, I understood that you MSDE instance will not be
launched unless you reboot your box or go into the services console. Have I
understood you? If there is anything I misunderstood, please feel free to
let me know:)
Based on my scope, after the installation, the service is started by
default. Look in Task Manager and you should see the service running. You
can use any application that connects to the service or you can issue osql
commands to work with the service.
Are there any error log shown during the setup? If you are installing the
MSDE stand-alone, will the service be started?
Anyway, if the service is not started by default, you could try to start it
with a DOS command "net start <Service Name>" in your application.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

MSDE in Enterprise manager: strange number with managed tasks...

Without having read the manual (just assuming it should work), I have a
problem with MSDE and using the Enterprise Manager to create a database
maintenance plan.
I have a desktop machine with SQL2K(sp3) and a portable with MSDE
(msderela.exe). I am testing (developing) an application that should
bee able to pull a subscription-db (portable in this case) from the
main-server (desktop in this case). I've setup all directories needed
(repldata) and the installation-log for MSDE (installed with /L*v)
didn't gave me any error... I've attached a DB (for testing purposes)
and (using the Enterprise manager) it seems to return everything I want
it to return (data that is).
But, when I was trying to setup a maintenance plan on the laptop (so
that user has a backup in case he's traveling and would like to revert
to a backup-file), I run into some very strange errors. Although I can
create a plan (either using the wizard or 'plain'), certain values are,
well, let's say damaged...
For example, the "complete backup" tab. On the right side of the
checkbox "Remove files older then" you have a combo with 'days',
'weeks', etc. For some reason, this combo is empty.
Having skipped this functionality completely, I've setup a complete
plan and saved it. Backup every 1 days at 18:00 (there's more, but for
the example's sake I don't include all settings).
Now, when I open that plan again, I see that the every 1 days is
changed to 366 days (not only for this one, but for all where I've set
it to every 1 day). I can't save the plan anymore (errors complaining
about having the wrong value-types). When I change it back to 1 day,
save it and re-open it, it comes back with the 366 days again...
Any ideas on what's going on here?
Thx,
GB
Dit is een automatische handtekening van MesNews.
Site : http://www.mesnews.net
Are you sure you're properly licensed to manage MSDE with Enterprise
Manager?
http://www.aspfaq.com/
(Reverse address to reply.)
"Gijs Beukenoot" <gijs.beukenoot@.wanadoo.nl> wrote in message
news:mn.8c937d4b9fda54cf.22563@.wanadoo.nl...
> Without having read the manual (just assuming it should work), I have a
> problem with MSDE and using the Enterprise Manager to create a database
> maintenance plan.
> I have a desktop machine with SQL2K(sp3) and a portable with MSDE
> (msderela.exe). I am testing (developing) an application that should
> bee able to pull a subscription-db (portable in this case) from the
> main-server (desktop in this case). I've setup all directories needed
> (repldata) and the installation-log for MSDE (installed with /L*v)
> didn't gave me any error... I've attached a DB (for testing purposes)
> and (using the Enterprise manager) it seems to return everything I want
> it to return (data that is).
> But, when I was trying to setup a maintenance plan on the laptop (so
> that user has a backup in case he's traveling and would like to revert
> to a backup-file), I run into some very strange errors. Although I can
> create a plan (either using the wizard or 'plain'), certain values are,
> well, let's say damaged...
> For example, the "complete backup" tab. On the right side of the
> checkbox "Remove files older then" you have a combo with 'days',
> 'weeks', etc. For some reason, this combo is empty.
> Having skipped this functionality completely, I've setup a complete
> plan and saved it. Backup every 1 days at 18:00 (there's more, but for
> the example's sake I don't include all settings).
> Now, when I open that plan again, I see that the every 1 days is
> changed to 366 days (not only for this one, but for all where I've set
> it to every 1 day). I can't save the plan anymore (errors complaining
> about having the wrong value-types). When I change it back to 1 day,
> save it and re-open it, it comes back with the 366 days again...
> Any ideas on what's going on here?
> Thx,
> GB
> --
> Dit is een automatische handtekening van MesNews.
> Site : http://www.mesnews.net
>
|||Aaron [SQL Server MVP] drukte met precisie uit :
> Are you sure you're properly licensed to manage MSDE with Enterprise
> Manager?
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
I fail to see what the licensing has to do with this problem...
But anyway, I have at least three developer licenses (7 and 2x2K); two
standard licenses (7 and 2K) and one Enterprise license (2K) (all
processor); I also have one dev lic with with Office-xp-dev and I have
an MSDN universal... But from memory (I used to have @.microsoft.com
behind my (not-mentioned-here-due-to-spam)-address although that is a
few years ago), having just one valid SQL license is enough to do what
I want to do.
Dit is een automatische handtekening van MesNews.
Site : http://www.mesnews.net
|||> I fail to see what the licensing has to do with this problem...
Maybe trying to push you to create jobs legally using the stored procedures
in MSDB, instead of Enterprise Manager, which (a) you are having problems
with, and (b) is not likely abiding by licensing agreements.

> But anyway, I have at least three developer licenses (7 and 2x2K); two
> standard licenses (7 and 2K) and one Enterprise license (2K) (all
> processor); I also have one dev lic with with Office-xp-dev and I have
> an MSDN universal... But from memory (I used to have @.microsoft.com
> behind my (not-mentioned-here-due-to-spam)-address although that is a
> few years ago), having just one valid SQL license is enough to do what
> I want to do.
I would consult with a Microsoft licensing rep before having confidence in
such a statement. MSDE has very strict limitations on how you can use SQL
Server tools for management, regardless of how many licenses you have for
other editions. And there are very few cases that I've heard of where it's
legal to manage MSDE with Enterprise Manager, sorry.
|||Aaron [SQL Server MVP] drukte met precisie uit :

> I would consult with a Microsoft licensing rep before having confidence in
> such a statement. MSDE has very strict limitations on how you can use SQL
> Server tools for management, regardless of how many licenses you have for
> other editions. And there are very few cases that I've heard of where it's
> legal to manage MSDE with Enterprise Manager, sorry.
Aaron,
Can I point you to the website?
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
To be precise :
<cut>
Q. Can I use SQL Server tools and services in conjunction with MSDE?
A. You can only use SQL Server tools and services in conjunction with
MSDE if you acquired MSDE through SQL Server 2000 (Developer Edition,
Standard Edition, or Enterprise Edition), and if you are using MSDE in
conjunction with a properly licensed copy of SQL Server 2000. Visit the
How to Buy page for information on obtaining a valid SQL Server
license.
Note: The tools and services included with SQL Server Developer Edition
may not be used to manage production server environments.
<paste>
And this is exactly what I'm doing...
Sent me a private message if you're still think I am doing something
wrong.
Dit is een automatische handtekening van MesNews.
Site : http://www.mesnews.net
|||> And this is exactly what I'm doing...
I thought the same thing too, but apparently there's much more to it than
that single paragraph, and relying on that paragraph has proved detrimental
in the past.

> Sent me a private message if you're still think I am doing something
> wrong.
Not really my job to prove to you that you are doing something wrong; you
might not be, I don't know because I am neither a lawyer nor a Microsoft
licensing rep. Just reminding you that the onus is on YOU to be sure YOU
are abiding by the licensing agreement(s).
|||Aaron [SQL Server MVP] gebruikte zijn klavier om te schrijven :
> I thought the same thing too, but apparently there's much more to it than
> that single paragraph, and relying on that paragraph has proved detrimental
> in the past.
>
> Not really my job to prove to you that you are doing something wrong; you
> might not be, I don't know because I am neither a lawyer nor a Microsoft
> licensing rep. Just reminding you that the onus is on YOU to be sure YOU
> are abiding by the licensing agreement(s).
Good. Can we go back to the original question then?
Anybody any ideas why the before mentioned method is giving me these
strange numbers?
Dit is een automatische handtekening van MesNews.
Site : http://www.mesnews.net

MSDE Error on attempting to create new Access 2000 project

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
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" <laurencetruman@.yahoo.com> wrote in message
news:c8e229b3.0406090533.5ecefd75@.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
|||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" <laurencetruman@.yahoo.com> wrote in message
news:c8e229b3.0406090533.5ecefd75@.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