Resetting User Password

From: Jeremy Pond (jpond_at_railcu.org.au)
Date: 07/21/04 

Date: Tue, 20 Jul 2004 18:34:26 -0700

Hi,

I've created a user which is attached to a database. This
user exists only in SQL 2000. (no NT login in domain or
on the local box).

This user owns this database and i can't remember the
password. Therefore i'm unable to connect to it through
another computer using the ODBC connection.

I've looked everywhere to see where i can reset the
password. But i can't find it. I'm guessin that using the
T-SQL command prompt stuff is my best bet. But i've also
had problems with this SQL box and i can't connect to it.

Please let me know if there's anyway i can reset the
password. I've tried creating another user and giving it
full access to the db. As a custom application runs ontop
of the SQL database it needs specific permissions which
are builtin to that user

Thanks

Relevant Pages

  • Fixed
    ... I also found this article that gives the proper way to move system dbs in sql 2008: ... The model exists where the master states it exists. ... This is the error log prior to detaching the model database. ...
    (microsoft.public.sqlserver.server)
  • Re: CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to
    ... Go to the Database tab and click on the browse button next to the connection string. ... In the New Database Reference dialog, enter the details for the database where you want to deploy the assembly and create the user defined aggregate. ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to meth
    ... Now register the assembly and the aggregate in the SQL Server database you want ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • Re: Logging in irrespective of database access
    ... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
    (microsoft.public.sqlserver.server)
  • Re: Logging in irrespective of database access
    ... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
    (microsoft.public.sqlserver.server)