Connecting to MSDE2000RelA

I was able to install MSDE into WXP and migrated my Access
databases through Windows Integrated Authentication Method.
But whenever I tried connecting to MSDE by SQL login it
gives me the following error:
Invalid username and/or password, you are using a windows
login that is not your own, or server does not exist.
Please help.
Tnx,
Jess
hi Jess,
jess.tayag@.dhl.com wrote:
> I was able to install MSDE into WXP and migrated my Access
> databases through Windows Integrated Authentication Method.
> But whenever I tried connecting to MSDE by SQL login it
> gives me the following error:
> Invalid username and/or password, you are using a windows
> login that is not your own, or server does not exist.
>
if the raised error is
"Login failed for user 'UserName'. Reason: Not associated with a trusted SQL
Server connection."
the reason is MSDE is only allowing WindowsNT trusted connections and not
SQL Server authenticated connections, and this can be solved as explained in
http://support.microsoft.com/default...b;en-us;285097 in the part
regarding the Windows registry modification, while the
"SQL Server does not exists or access denied"
message is usually related to other kind of troubles, as indicated in
http://support.microsoft.com/default...06&Product=sql
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply