Answer: Access creates DB in MSDE in SQL Server Authentication mod
Date: Tue, 27 Jul 2004 22:09:02 -0700
I've confirmed that MS Access will create an ADP project in MSDE only if the server is set to Mixed (SQL Server and Windows) authentication mode. Trials in Windows Authentication mode failed. This is still hard to believe, I know, but its a reality.
To all those who tried to help, my sincere thanks.
--
Lou Arnold
Ottawa, Canada
Relevant Pages
- Getting to the bottom of MSDE network connection problems ...
... but other than that it is MSDE 2000 with sp3a already applied. ... I've finally figured out the connection problems associated with this, ... and it seems the problems are due to Windows XP and not MSDE. ... the enterprise/standard versions of SQL server won't install ...
(microsoft.public.sqlserver.msde) - RE: Getting to the bottom of MSDE network connection problems ...
... the way using the same installation scenario on Win2K works with no problem. ... > various versions of MSDE and Windows XP ... > and it seems the problems are due to Windows XP and not MSDE. ... > on a desktop OS like XP (meaning that, you can not compare SQL Server ...
(microsoft.public.sqlserver.msde) - Re: Need help & support regarding MBSA 2.1 beta 2
... Issue: Local Account Password Test ... Check is skipped on Windows XP Home Edition computers. ... SQL Server and/or MSDE authentication mode is set to Windows ...
(microsoft.public.security) - Re: ADO.NET 2.0 & MSDE & Win98
... Does SQL Server Express run just fine on Windows 98? ... At this point in time you should be using SQL Server Express, ... not MSDE. ... DISABLENETWORKPROTOCOLS ...
(microsoft.public.dotnet.framework.adonet) - Need help & support regarding MBSA 2.1 beta 2
... Issue: Local Account Password Test ... Check is skipped on Windows XP Home Edition computers. ... SQL Server and/or MSDE authentication mode is set to Windows Only. ...
(microsoft.public.security) |
|
