MSDE installation

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 didnt 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
|||The problem was in another thing.
The space isn't important.
Best regards,
Jakub Cermak
ICQ 159971304
http://cermi.wz.cz
Jens Smeyer napsal(a):
> Hope you didnt 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...
>
>