MSDE questions for SharePoint and Project Server

Hi:
Appreciate if anyone can help me on the following questions:
(1) Is MSDE necessary if we wish to install Windows SharePoint Team service
and/or MS Project Server?
(2) MSDE installation problems -- please read below.
Followed article
http://msdn.microsoft.com/library/de...stsql_84xl.asp
for many many times and never succeeded -- maybe just because I am new to
this.
Using example of the article - setup SAPWD="AStrongSAPwd"
What exactly show we put inside " "? A real strong password, or as
literally the same as in the example -- AStrongSAPwd?
Do we include " " or not?
I tried once with the exact thing as - setup SAPWD="AStrongSAPwd", word by
word, and the best thing that I could get from testing (based on
http://support.microsoft.com/default...36&Product=sql )
is to have the following result: 1>
And there is no instructions for what to do next in the article. I pressed
Enter, it will become 2> and go on. I typed something else, no response at
all.
Other times, it will become as the following - which i changed to the mixed
mode but still failed.
The following error message indicates that the computer that is running SQL
Server is set to Windows Authentication only:
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server
connection.
I also tried the section -
How to Change Your SA Password
Still wont work.
So your advise is deeply appreciated.
Thanks in advance.
hi,
"xfile" <cou-cou@.remove.nospam.com> ha scritto nel messaggio
news:%23JlIhmdsEHA.2720@.TK2MSFTNGP12.phx.gbl
> Hi:
> Appreciate if anyone can help me on the following questions:
> (1) Is MSDE necessary if we wish to install Windows SharePoint Team
> service and/or MS Project Server?
yes... I do think SharePoint installs it' own instance of a modified MSDE
release...

> (2) MSDE installation problems -- please read below.
> Followed article
>
http://msdn.microsoft.com/library/de...stsql_84xl.asp
> for many many times and never succeeded -- maybe just because I am
> new to this.
> Using example of the article - setup SAPWD="AStrongSAPwd"
> What exactly show we put inside " "? A real strong password, or as
> literally the same as in the example -- AStrongSAPwd?
your own strong password for the special SQL Server account known as "sa",
an administrative account that can not be dropped...

> Do we include " " or not?
yes

> I tried once with the exact thing as - setup SAPWD="AStrongSAPwd",
> word by word, and the best thing that I could get from testing (based
> on
> http://support.microsoft.com/default...36&Product=sql
> ) is to have the following result: 1>
>
:-|
if you resulted in oSql.exe output
1>
that means you do not have a password for "sa" Login
else you'd would have been pompted for a password like
c:\>osql -Usa
Password: [here caret blinks]

> And there is no instructions for what to do next in the article. I
> pressed Enter, it will become 2> and go on. I typed something else,
> no response at all.
if you want to (and should) set a strong password for your "sa" login,
please repeat the described steps as above..
then at the 1> prompt, type
1>sp_password @.old = NULL , @.new = 'yourStrongPassword' , @.loginame =
'sa' --hit return
2>GO -- hit return
GO is a special word that will execute all the statements preceding it as a
single batch...
obviously change
'yourStrongPassword'
with your own password...

> Other times, it will become as the following - which i changed to the
> mixed mode but still failed.
> --
> The following error message indicates that the computer that is
> running SQL Server is set to Windows Authentication only:
> Login failed for user 'sa'. Reason: Not associated with a trusted SQL
> Server connection.
> --
this must be managed via Windows registry modification, as described in
http://support.microsoft.com/default...us;Q285097...
stop and restart the MSDE instance service
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi:
Thanks for your kind response and I just installed another time before
reading your message, for which the installation appears to be successful.
I use the utility - DbaMGR2k and set it to use "Trusted NT connection" and I
can see all things are there. But I still could not figure out if the
password is correct or not.
I guess what I will try to do is to install again with the "mix mode" and
leave the password blank during installation.
Then I would follow your instructions to check again if the password is
blank, if so, using the following to set a password -
1>sp_password @.old = NULL , @.new = 'yourStrongPassword' , @.loginame =
> 'sa' --hit return
> 2>GO -- hit return
One more question about the strong password. Do we have to strictly follow
the strong password rules for choosing the password, or could we just use
some combinations of characters and numbers?
Thanks so much.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it>
??:2t75bqF1s1tkjU1@.uni-berlin.de...
> hi,
> "xfile" <cou-cou@.remove.nospam.com> ha scritto nel messaggio
> news:%23JlIhmdsEHA.2720@.TK2MSFTNGP12.phx.gbl
> yes... I do think SharePoint installs it' own instance of a modified MSDE
> release...
> http://msdn.microsoft.com/library/de...stsql_84xl.asp
> your own strong password for the special SQL Server account known as "sa",
> an administrative account that can not be dropped...
>
> yes
>
> :-|
> if you resulted in oSql.exe output
> 1>
> that means you do not have a password for "sa" Login
> else you'd would have been pompted for a password like
> c:\>osql -Usa
> Password: [here caret blinks]
>
> if you want to (and should) set a strong password for your "sa" login,
> please repeat the described steps as above..
> then at the 1> prompt, type
> 1>sp_password @.old = NULL , @.new = 'yourStrongPassword' , @.loginame =
> 'sa' --hit return
> 2>GO -- hit return
> GO is a special word that will execute all the statements preceding it as
> a
> single batch...
> obviously change
> 'yourStrongPassword'
> with your own password...
>
> this must be managed via Windows registry modification, as described in
> http://support.microsoft.com/default...us;Q285097...
> stop and restart the MSDE instance service
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Hi:
This is an update status -- it is done.
Use mixed mode and the following instructions for changing password, I am
able to reset the password to the one I wanted,
Thanks for the kind help
"xfile" <cou-cou@.remove.nospam.com>
??:uXSTNsesEHA.2664@.TK2MSFTNGP12.phx.gbl...
> Hi:
> Thanks for your kind response and I just installed another time before
> reading your message, for which the installation appears to be successful.
> I use the utility - DbaMGR2k and set it to use "Trusted NT connection" and
> I can see all things are there. But I still could not figure out if the
> password is correct or not.
> I guess what I will try to do is to install again with the "mix mode" and
> leave the password blank during installation.
> Then I would follow your instructions to check again if the password is
> blank, if so, using the following to set a password -
> 1>sp_password @.old = NULL , @.new = 'yourStrongPassword' , @.loginame =
> One more question about the strong password. Do we have to strictly
> follow the strong password rules for choosing the password, or could we
> just use some combinations of characters and numbers?
> Thanks so much.
>
>
>
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it>
> ??:2t75bqF1s1tkjU1@.uni-berlin.de...
>
|||hi,
"xfile" <cou-cou@.remove.nospam.com> ha scritto nel messaggio
news:uXSTNsesEHA.2664@.TK2MSFTNGP12.phx.gbl
>....
> One more question about the strong password. Do we have to strictly
> follow the strong password rules for choosing the password, or could
> we just use some combinations of characters and numbers?
>
you should use a combination of chars and digits... this will improve the
security of your pwd... and wathc about the lenght... not just a 4 or 5
chars lenght...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql

MSDE Question

Sorry if this is basic stuff but I'm new to MSDE and SQL.

I am running MSDE as the server.

I created a Microsoft Access Project and connected to the MSDE. Security is
set to Integrated Security.

When I try to open the database from an application I am writing I get a
login error stating the user doesn't have rights to the database. I am
logged in to the computer with administrator privledges but get the error.

I know that I have to tell the server that users have access to the database
but how do I do that if I can't gain access to the database?

Thanks,

EricI have hit this problem with sql server as well. I fixed it by
creating a server based login. that is one that requires a user name
and password. That way in the program all you need for permission is
those to fields in teh Connection String. Of course you still need to
grant that login access to the relevent dbs

MSDE prototyping

I haven't used MSDE yet. Does it run with an Enterprise Manager & Sql analyser interface?
I'm working on an asp.net vb project using sql2000. Users request me to create a protype for their review and training use. Can I deploy my project with only dlls forthe front end and an MSDE backend created from a script of the original Sql2000 database? Is there any potential discrepacy or problem with my prototyping plan? How can I copy my original database from sql2000 to msde?

Thanks for any help.Yes, Enterprise Manager and Query Analyzer can be interfaces to MSDE.

Yes, you can use MSDE as the back end for development but deploy to a SQL Server 2000 database.

When I mean "can" I mean "technically possible". I am not 100% sure of "legally possible". The licensing information for MSDE is fairly confusion, IMO.

The SQL Server 2000 Developer's edition is made specifically for situations like yours. It is $49.95 US and would give you the EM and QA tools plus the database. SeeDevelopment Edition Licensing.

I think the best way to transfer the data and schema would be to restore a backup.

Terri

MSDE problems

Hi!

I'm working on a website that will be a webshop in the end. I chosed MSDE as database for the project. Now I have a problem. When i want to have a counter (for the cusomers number for exampel) i can't turn autoincresement on. Well I can, but I can't save it. If i try I get an errormessage.
Why is it so and how will i get it to work?
I'm running the newest version...
Thanks for any help!What is the error message you are receiving?

In order to make a column an Identity column the data type must be integer and it may not allow nulls.

Terri|||I have translated the errormessage from swedish to english. I don't think it's absolutley correkt translated but i hope you will understand it anyway:
(And yes i have the column as Int and not allow nulls)

There was an error saving the design of this table. No changes were made.

[Microsoft][ODBC SQL server driver][SQL server] Unable to create standardvalue on colums with IDENTITY-attribut. Tabel 'tbkunder', column 'kundnummer.
[Microsoft][ODBC SQL server driver][SQL server] Unable to create restriction. Watch previous errormessage.|||This is very difficult with the language difference.

It sounds to me like you are trying to set the IDENTITY property on a column that has a Default Value set, which can't be done.

Terri

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 over firewall

Succesfully created a MSDE 2000 rel A backend on 2003
server. I can connect a MS Access project frontend to it
from an XP client on the same LAN segment. I can connect
the same frontend over the internet to this server when
set out in the firewall's DMZ.
And now for my next trick! When I tuck the MSDE server
back behind the firewall and open up TCP and UDP ports at
1433 and 1434 for both incoming and outgoing traffic, I
cannot connect. I include a filtered log showing traffic
between the Access client on the Internet and the firewall
for detail. It appears that the Netgear firewall passes
packets to the server but it times out in a little less
than a minute... I am looking forward to any ideas that
may move this project forward!
TimeProtocolSrcDstApplication
Message
13:58:28UDP645521434ms-sql-m
[Service access request successful]
13:58:28TCP645532418cas[Access
Policy not found, dropping packet]
13:58:31TCP645532418cas[Access
Policy not found, dropping packet]
13:58:37TCP645532418cas[Access
Policy not found, dropping packet]
13:58:51TCP645582418cas[Access
Policy not found, dropping packet]
13:58:54TCP645582418cas[Access
Policy not found, dropping packet]
13:59:00TCP645582418cas[Access
Policy not found, dropping packet]
13:59:14TCP64564445ms-ds[Access
Policy not found, dropping packet]
13:59:14TCP64565139netbios-ssn
[Access Policy not found, dropping packet]
13:59:17TCP64565139netbios-ssn
[Access Policy not found, dropping packet]
13:59:17TCP64564445ms-ds[Access
Policy not found, dropping packet]
13:59:20UDP645521434ms-sql-m
[Connection timed out.Bytes transferred : 137]
13:59:23TCP64565139netbios-ssn
[Access Policy not found, dropping packet]
13:59:23TCP64564445ms-ds[Access
Policy not found, dropping packet]
From your trace it appears that many more IP ports (than 1433 & 1434) are
being attempted to be used.
I suspect it's failing because of the attempt to do name resolution.
Steve
"Ed Morra" <ed@.orl-inc.com> wrote in message
news:36f801c4297b$6a642240$a601280a@.phx.gbl...
> Succesfully created a MSDE 2000 rel A backend on 2003
> server. I can connect a MS Access project frontend to it
> from an XP client on the same LAN segment. I can connect
> the same frontend over the internet to this server when
> set out in the firewall's DMZ.
> And now for my next trick! When I tuck the MSDE server
> back behind the firewall and open up TCP and UDP ports at
> 1433 and 1434 for both incoming and outgoing traffic, I
> cannot connect. I include a filtered log showing traffic
> between the Access client on the Internet and the firewall
> for detail. It appears that the Netgear firewall passes
> packets to the server but it times out in a little less
> than a minute... I am looking forward to any ideas that
> may move this project forward!
> Time Protocol Src Dst Application
> Message
> 13:58:28 UDP 64552 1434 ms-sql-m
> [Service access request successful]
> 13:58:28 TCP 64553 2418 cas [Access
> Policy not found, dropping packet]
> 13:58:31 TCP 64553 2418 cas [Access
> Policy not found, dropping packet]
> 13:58:37 TCP 64553 2418 cas [Access
> Policy not found, dropping packet]
> 13:58:51 TCP 64558 2418 cas [Access
> Policy not found, dropping packet]
> 13:58:54 TCP 64558 2418 cas [Access
> Policy not found, dropping packet]
> 13:59:00 TCP 64558 2418 cas [Access
> Policy not found, dropping packet]
> 13:59:14 TCP 64564 445 ms-ds [Access
> Policy not found, dropping packet]
> 13:59:14 TCP 64565 139 netbios-ssn
> [Access Policy not found, dropping packet]
> 13:59:17 TCP 64565 139 netbios-ssn
> [Access Policy not found, dropping packet]
> 13:59:17 TCP 64564 445 ms-ds [Access
> Policy not found, dropping packet]
> 13:59:20 UDP 64552 1434 ms-sql-m
> [Connection timed out.Bytes transferred : 137]
> 13:59:23 TCP 64565 139 netbios-ssn
> [Access Policy not found, dropping packet]
> 13:59:23 TCP 64564 445 ms-ds [Access
> Policy not found, dropping packet]
>

MSDE over firewall

Succesfully created a MSDE 2000 rel A backend on 2003
server. I can connect a MS Access project frontend to it
from an XP client on the same LAN segment. I can connect
the same frontend over the internet to this server when
set out in the firewall's DMZ.
And now for my next trick! When I tuck the MSDE server
back behind the firewall and open up TCP and UDP ports at
1433 and 1434 for both incoming and outgoing traffic, I
cannot connect. I include a filtered log showing traffic
between the Access client on the Internet and the firewall
for detail. It appears that the Netgear firewall passes
packets to the server but it times out in a little less
than a minute... I am looking forward to any ideas that
may move this project forward!
Time Protocol Src Dst Application
Message
13:58:28 UDP 64552 1434 ms-sql-m
[Service access request successful]
13:58:28 TCP 64553 2418 cas [Access
Policy not found, dropping packet]
13:58:31 TCP 64553 2418 cas [Access
Policy not found, dropping packet]
13:58:37 TCP 64553 2418 cas [Access
Policy not found, dropping packet]
13:58:51 TCP 64558 2418 cas [Access
Policy not found, dropping packet]
13:58:54 TCP 64558 2418 cas [Access
Policy not found, dropping packet]
13:59:00 TCP 64558 2418 cas [Access
Policy not found, dropping packet]
13:59:14 TCP 64564 445 ms-ds [Access
Policy not found, dropping packet]
13:59:14 TCP 64565 139 netbios-ssn
[Access Policy not found, dropping packet]
13:59:17 TCP 64565 139 netbios-ssn
[Access Policy not found, dropping packet]
13:59:17 TCP 64564 445 ms-ds [Access
Policy not found, dropping packet]
13:59:20 UDP 64552 1434 ms-sql-m
[Connection timed out.Bytes transferred : 137]
13:59:23 TCP 64565 139 netbios-ssn
[Access Policy not found, dropping packet]
13:59:23 TCP 64564 445 ms-ds [Access
Policy not found, dropping packet]From your trace it appears that many more IP ports (than 1433 & 1434) are
being attempted to be used.
I suspect it's failing because of the attempt to do name resolution.
Steve
"Ed Morra" <ed@.orl-inc.com> wrote in message
news:36f801c4297b$6a642240$a601280a@.phx.gbl...
> Succesfully created a MSDE 2000 rel A backend on 2003
> server. I can connect a MS Access project frontend to it
> from an XP client on the same LAN segment. I can connect
> the same frontend over the internet to this server when
> set out in the firewall's DMZ.
> And now for my next trick! When I tuck the MSDE server
> back behind the firewall and open up TCP and UDP ports at
> 1433 and 1434 for both incoming and outgoing traffic, I
> cannot connect. I include a filtered log showing traffic
> between the Access client on the Internet and the firewall
> for detail. It appears that the Netgear firewall passes
> packets to the server but it times out in a little less
> than a minute... I am looking forward to any ideas that
> may move this project forward!
> Time Protocol Src Dst Application
> Message
> 13:58:28 UDP 64552 1434 ms-sql-m
> [Service access request successful]
> 13:58:28 TCP 64553 2418 cas [Access
> Policy not found, dropping packet]
> 13:58:31 TCP 64553 2418 cas [Access
> Policy not found, dropping packet]
> 13:58:37 TCP 64553 2418 cas [Access
> Policy not found, dropping packet]
> 13:58:51 TCP 64558 2418 cas [Access
> Policy not found, dropping packet]
> 13:58:54 TCP 64558 2418 cas [Access
> Policy not found, dropping packet]
> 13:59:00 TCP 64558 2418 cas [Access
> Policy not found, dropping packet]
> 13:59:14 TCP 64564 445 ms-ds [Access
> Policy not found, dropping packet]
> 13:59:14 TCP 64565 139 netbios-ssn
> [Access Policy not found, dropping packet]
> 13:59:17 TCP 64565 139 netbios-ssn
> [Access Policy not found, dropping packet]
> 13:59:17 TCP 64564 445 ms-ds [Access
> Policy not found, dropping packet]
> 13:59:20 UDP 64552 1434 ms-sql-m
> [Connection timed out.Bytes transferred : 137]
> 13:59:23 TCP 64565 139 netbios-ssn
> [Access Policy not found, dropping packet]
> 13:59:23 TCP 64564 445 ms-ds [Access
> Policy not found, dropping packet]
>

MSDE on a 2k Domain Controller

I have asked this before, but it was a while back and then the project got
put on hold, and I can't find the replies - sorry.
Is there any problems (operationally wise, or conflict wise) with putting
MSDE 2000 A on a Windows 2000 Server which is a domain controller (the
server also has Exchange 2000 and ISA 2000 installed on it)?
I can obviously restrict the memory it can use so that's not a problem, but
I wondered if it would create problems or serious performance issues for the
DC.
Also, if it is OK to install on a DC, is the installation straightforward or
are there any special switches or settings I should use? Or do I just do a
plain install as I would on any machine?
Thanks
Keith
Anyone?
"Keith" <@..> wrote in message news:ehizqISKEHA.3436@.tk2msftngp13.phx.gbl...
> I have asked this before, but it was a while back and then the project got
> put on hold, and I can't find the replies - sorry.
> Is there any problems (operationally wise, or conflict wise) with putting
> MSDE 2000 A on a Windows 2000 Server which is a domain controller (the
> server also has Exchange 2000 and ISA 2000 installed on it)?
> I can obviously restrict the memory it can use so that's not a problem,
but
> I wondered if it would create problems or serious performance issues for
the
> DC.
> Also, if it is OK to install on a DC, is the installation straightforward
or
> are there any special switches or settings I should use? Or do I just do
a
> plain install as I would on any machine?
> Thanks
> Keith
>
|||A no-one responded yet...
Yes, you should be fine. One thing to consider is that your service account is now a domain account. I.e., a
potential security issue. (This is because a DC doesn't have any local accounts.)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Keith" <@..> wrote in message news:e2TJLgDLEHA.3704@.TK2MSFTNGP11.phx.gbl...
> Anyone?
>
> "Keith" <@..> wrote in message news:ehizqISKEHA.3436@.tk2msftngp13.phx.gbl...
> but
> the
> or
> a
>
sql

MSDE for large volume and high no. of users?

Hi,
We need to use a free database for a project because of tight budget.
Is MSDE ok for handling large volume of data and 70 - 80 users?
My understanding is that MSDE is optimized for 5 concurrent users.
Is MySQL better than MSDE?
Thanks,
BenA web app with 70-80 concurrent users (if it's well built) shouldn't beto busy for MSDE to handle. The high volume of data is the biggerissue, since MSDE databases are limited to 2GB maximum. Yes, fora large application, I'd look elsewhere simply becuase of that, andMySQL is one option. PostgreSQL is another.

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