sa account password

[Steve Schwandt]

Well, I inherited a SQL Server ....sob story.........installer won`t call back.....sob story.....buying books like mad......sob story. Geez, this was a *great* job when I interviewed.....

Regardless, I do not know the password for the sa account on a SQL 6.5 server running on NT4SP3. We are using standard securtiy. Do I have any options?

Hopefully, the technical discussion doesn`t reference rubber garden watering implements. :{)

Thanks,
steve

[Asfen Tantono]

Steve,

Is the Server registered in the Enterprise Manager?

If it is, it`s most probably registered using `sa` login and password, that would allow you to modify the password (under `Logins`).

Cheers,
Asfen

On 8/10/98 3:51:46 PM, Steve Schwandt wrote:
> Well, I inherited a SQL Server ....sob story.........installer won`t call
> back.....sob story.....buying books like mad......sob story. Geez, this was
> a *great* job when I interviewed.....

Regardless, I do not know the
> password for the sa account on a SQL 6.5 server running on NT4SP3. We are
> using standard securtiy. Do I have any options?

Hopefully, the technical
> discussion doesn`t reference rubber garden watering implements.
> :{)

Thanks,
steve

[Steve Schwandt]

I am unable to get the servers registered on EM.



On 8/10/98 4:45:37 PM, Asfen Tantono wrote:
On
> 8/10/98 3:51:46 PM, Steve Schwandt wrote:
> Well, I inherited a SQL
> Server ....sob story.........installer won`t call
> back.....sob
> story.....buying books like mad......sob story. Geez, this was
> a
> *great* job when I interviewed.....

Regardless, I do not know the
> Steve,

Is the Server registered in the Enterprise Manager?

If it is,
> it`s most probably registered using `sa` login and password, that would
> allow you to modify the password (under `Logins`).

Cheers,
Asfen

>
> password for the sa account on a SQL 6.5 server running on NT4SP3. We are
>
> using standard securtiy. Do I have any options?

Hopefully, the
> technical
> discussion doesn`t reference rubber garden watering
> implements.
> :{)

Thanks,
steve

[Chuck Lucking]

Steve,
What I think Asfen is suggesting is......
The previous owner of this database may have registered under SA on his computer with EM. If this is so, you will need to access that computer. Also I believe SQL writes the registration user/password to the registry in plain text. You may want to explore that if you find the machine.
Chuck

On 8/10/98 5:07:46 PM, Steve Schwandt wrote:
> I am unable to get the servers registered on EM.

[Jasper]

There is a Security loop-hole on SQL Server which may be useful if you are an administrator on the NT Server, that SQL is on.

This method will automatically mapped you as `SA` on SQL. To access as `SA` on SQL Server, you should be able to set the Security Options of SQL Server, to Mixed Security, using SQL Server Setup.

Regards
Jasper

[VK]

Going to the Windows NT registry is the best solution in this case.
I already used this `method` by myself. If any of the servers have
already been registered in EM under `sa` account you can find
sa-password in registry in PLAIN text.

VK.