>I installed MSDE 2000 with parameters SAPWD='ahoj' SECURITYMODE=SQL
> Installation was OK, I enabled all networks protocols in SVRNETCN.exe and
> restared server.
> osql.exe -L found 1 server: (local);
> But if I try to start osql.exe -U sa and write a password, osql says
> 'Login
> failed for user sa'.
> Where is the mistake?
> The password is OK.
> --
> Best regards,
>
> Jakub Cermak
> ICQ 159971304
> http://cermi.wz.cz

> Hope you didn´t mess up with the syntax, in your case it would be:
>
> OSQL -Usa -Pahoj
>
> Did you tried it with those space between -P and -U ? Most be used with no
> spaces between paramters...
>
> HTH, Jens Suessmeyer
>
> ---
> http://www.sqlserver2005.de
> ---
>
> "Jakub Cermak (news)" <ja.cermi@centrum.cz> schrieb im Newsbeitrag
> news:uaZulUpQFHA.3384@TK2MSFTNGP10.phx.gbl...
>
>>I installed MSDE 2000 with parameters SAPWD='ahoj' SECURITYMODE=SQL
>>Installation was OK, I enabled all networks protocols in SVRNETCN.exe and
>>restared server.
>>osql.exe -L found 1 server: (local);
>>But if I try to start osql.exe -U sa and write a password, osql says
>>'Login
>>failed for user sa'.
>>Where is the mistake?
>>The password is OK.
>>--
>>Best regards,
>>
>>Jakub Cermak
>>ICQ 159971304
>>http://cermi.wz.cz
>
>