Sybase on NT "sa" password problem

Martin V.

unread,

Mar 16, 1999, 3:00:00 AM3/16/99

to

Hello,

I recently installed Sybase ASE 11.5.1 on an NT box in our development environment.

Today, I upped the "total memory" parameter to 48 Mb (out of 96Mb), stopped and restarted the server. It seemed to start up OK.

Now I can't connect to it with the "sa" account. It keeps returning a login failure. I hadn't gotten around to changing the "sa" password from the default (null) yet and nobody else is using this server so I KNOW I've got the right password.

Anybody know what's going on?

- Martin Virta

burha...@yahoo.com

unread,

Mar 16, 1999, 3:00:00 AM3/16/99

to

Use the -psa option in the database server startup script. This will generate
a new password for sa. Don't forget to clear the option after you've
finished.

Burhanettin MASAK
Demirbank T.A.S.

In article <1%iH2.2616$mH2....@news21.bellglobal.com>,
"Martin V." <mjlvan...@sympatico.ca> wrote:
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_010F_01BE6F26.8EB94720
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> Hello,
>
> I recently installed Sybase ASE 11.5.1 on an NT box in our development =
> environment.
>
> Today, I upped the "total memory" parameter to 48 Mb (out of 96Mb), =

> stopped and restarted the server. It seemed to start up OK.
>

> Now I can't connect to it with the "sa" account. It keeps returning a =
> login failure. I hadn't gotten around to changing the "sa" password from =
> the default (null) yet and nobody else is using this server so I KNOW =

> I've got the right password.
>
> Anybody know what's going on?
>
> - Martin Virta
>

> ------=_NextPart_000_010F_01BE6F26.8EB94720
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
> <HTML>
> <HEAD>
>
> <META content=3Dtext/html;charset=3Diso-8859-1 =
> http-equiv=3DContent-Type>
> <META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV><FONT color=3D#000000 size=3D2>Hello,</FONT></DIV>
> <DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
> <DIV><FONT size=3D2>I recently installed Sybase ASE 11.5.1 on an NT box =
> in our=20
> development environment.</FONT></DIV>
> <DIV><FONT size=3D2></FONT> </DIV>
> <DIV><FONT size=3D2>Today, I upped the "total memory" =
> parameter to 48 Mb=20
> (out of 96Mb), stopped and restarted the server. </FONT><FONT =
> color=3D#000000=20
> size=3D2>It seemed to start up OK.</FONT></DIV>
> <DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
> <DIV><FONT color=3D#000000 size=3D2>Now I can't connect to it with the=20
> "sa" account. It keeps returning a login failure. I hadn't =
> gotten=20
> around to changing the "sa" password from the default (null) =
> yet and=20
> nobody else is using this server so I KNOW I've got the right=20
> password.</FONT></DIV>
> <DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
> <DIV><FONT color=3D#000000 size=3D2>Anybody know what's going =
> on?</FONT></DIV>
> <DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
> <DIV><FONT color=3D#000000 size=3D2>- Martin =
> Virta<BR></FONT></DIV></BODY></HTML>
>
> ------=_NextPart_000_010F_01BE6F26.8EB94720--
>
>

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Alexy Timonin

unread,

Mar 16, 1999, 3:00:00 AM3/16/99

to

What tool do you use for connecting to ASE? Have you tried isql -S<SERVERNAME> -Usa -P ? If that doesn't work, then you have real problem with your password. In this case you should use -p option of sqlsrv. The -p option generates a new password for a System Security Officer's account. Look at http://sybooks.sybase.com/onlinebooks/group-as/asp1150e/nt_util/@Generic__BookView for more information.

With best regards

Alexy

Martin V. ïèøåò â ñîîáùåíèè <1%iH2.2616$mH2....@news21.bellglobal.com> ...

Hello,

I recently installed Sybase ASE 11.5.1 on an NT box in our development environment.

Today, I upped the "total memory" parameter to 48 Mb (out of 96Mb), stopped and restarted the server. It seemed to start up OK.

Now I can't connect to it with the "sa" account. It keeps returning a login failure. I hadn't gotten around to changing the "sa" password from the default (null) yet and nobody else is using this server so I KNOW I've got the right password.

Ken Ho

unread,

Mar 16, 1999, 3:00:00 AM3/16/99

to

"Martin V." wrote:

Hello, I recently installed Sybase ASE 11.5.1 on an NT box in our development environment. Today, I upped the "total memory" parameter to 48 Mb (out of 96Mb), stopped and restarted the server. It seemed to start up OK. Now I can't connect to it with the "sa" account. It keeps returning a login failure. I hadn't gotten around to changing the "sa" password from the default (null) yet and nobody else is using this server so I KNOW I've got the right password. Anybody know what's going on?

Can you connect to the SQL server using other account?? Are you using NT 4 SP 4??

Ken

weed...@my-dejanews.com

unread,

Mar 16, 1999, 3:00:00 AM3/16/99

to

> Today, I upped the "total memory" parameter to 48 Mb (out of 96Mb), =

> stopped and restarted the server. It seemed to start up OK.
>

> Now I can't connect to it with the "sa" account. It keeps returning a =
> login failure. I hadn't gotten around to changing the "sa" password from =
> the default (null) yet and nobody else is using this server so I KNOW =

> I've got the right password.
>
> Anybody know what's going on?
>

I am prepared to bet a pound of Stan Viger's best sausages (and to me they are
worth more than gold :-) that the server hasn't really started. Increasing
total memory is one of *the* classic ways of preventing Sybase from starting.

Try downing the server, resetting total memory to the value that was there
when you were last able to connect. Restart the server and try connecting
again.

dowen

David Owen 7, Stradbrooke Rise SW, Calgary, AB, Canada
dowen@<spam-me-not>cadvision.com
You needn't be well to wealthy, but you gotta be whole to be holy.
Greg Lake, Works Vol 1