HELP URGENT!

Hi,
I can access my database. I get the message ......cant access...in single
user mode. How can I reset this?
Thanks
The first thing I would try is from EM, right-click on the
database>properties>Options tab, uncheck Restrict Access if it's checked.
"Chris" wrote:

> Hi,
> I can access my database. I get the message ......cant access...in single
> user mode. How can I reset this?
> Thanks
|||Thanks!
"Jack" wrote:
[vbcol=seagreen]
> The first thing I would try is from EM, right-click on the
> database>properties>Options tab, uncheck Restrict Access if it's checked.
> "Chris" wrote:

HELP URGENT!

Hi,
I can access my database. I get the message ......cant access...in single
user mode. How can I reset this?
ThanksThe first thing I would try is from EM, right-click on the
database>properties>Options tab, uncheck Restrict Access if it's checked.
"Chris" wrote:

> Hi,
> I can access my database. I get the message ......cant access...in sing
le
> user mode. How can I reset this?
> Thanks|||Thanks!
"Jack" wrote:
[vbcol=seagreen]
> The first thing I would try is from EM, right-click on the
> database>properties>Options tab, uncheck Restrict Access if it's checked.
> "Chris" wrote:
>

HELP URGENT!

Hi,
I can access my database. I get the message ......cant access...in single
user mode. How can I reset this?
ThanksThe first thing I would try is from EM, right-click on the
database>properties>Options tab, uncheck Restrict Access if it's checked.
"Chris" wrote:
> Hi,
> I can access my database. I get the message ......cant access...in single
> user mode. How can I reset this?
> Thanks|||Thanks!
"Jack" wrote:
> The first thing I would try is from EM, right-click on the
> database>properties>Options tab, uncheck Restrict Access if it's checked.
> "Chris" wrote:
> > Hi,
> > I can access my database. I get the message ......cant access...in single
> > user mode. How can I reset this?
> >
> > Thanks

help Sa password lost ?

One of our guy as left our company, and he has configured SQL server 2000
with sa password that he and I caanot remember.
Is there a way to reset sa passord on SQL server 2000 in order to set an
other one?
thnaks for your help
regards
serge
Hi
Login with windows authentication and at QA perform
A. Change the password of a login without the former password
This example changes the password for the login Victoria to ok.
EXEC sp_password NULL, 'ok', 'Victoria'
B. Change a password
This example changes the password for the login Victoria from ok to coffee.
EXEC sp_password 'ok', 'coffee'
"serge calderara" <sergecalderara@.discussions.microsoft.com> wrote in
message news:14A10F77-EB04-46C1-AA05-366315B17921@.microsoft.com...
> One of our guy as left our company, and he has configured SQL server 2000
> with sa password that he and I caanot remember.
> Is there a way to reset sa passord on SQL server 2000 in order to set an
> other one?
> thnaks for your help
> regards
> serge
|||See if this helps: http://vyaskn.tripod.com/administration_faq.htm#q9
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"serge calderara" <sergecalderara@.discussions.microsoft.com> wrote in
message news:14A10F77-EB04-46C1-AA05-366315B17921@.microsoft.com...
One of our guy as left our company, and he has configured SQL server 2000
with sa password that he and I caanot remember.
Is there a way to reset sa passord on SQL server 2000 in order to set an
other one?
thnaks for your help
regards
serge
|||Hi,
U can change the sa password by executing
sp_password.
u can have more information from bol.
hope this help
from
Doller

help Sa password lost ?

One of our guy as left our company, and he has configured SQL server 2000
with sa password that he and I caanot remember.
Is there a way to reset sa passord on SQL server 2000 in order to set an
other one?
thnaks for your help
regards
sergeHi
Login with windows authentication and at QA perform
A. Change the password of a login without the former password
This example changes the password for the login Victoria to ok.
EXEC sp_password NULL, 'ok', 'Victoria'
B. Change a password
This example changes the password for the login Victoria from ok to coffee.
EXEC sp_password 'ok', 'coffee'
"serge calderara" <sergecalderara@.discussions.microsoft.com> wrote in
message news:14A10F77-EB04-46C1-AA05-366315B17921@.microsoft.com...
> One of our guy as left our company, and he has configured SQL server 2000
> with sa password that he and I caanot remember.
> Is there a way to reset sa passord on SQL server 2000 in order to set an
> other one?
> thnaks for your help
> regards
> serge|||See if this helps: http://vyaskn.tripod.com/administration_faq.htm#q9
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"serge calderara" <sergecalderara@.discussions.microsoft.com> wrote in
message news:14A10F77-EB04-46C1-AA05-366315B17921@.microsoft.com...
One of our guy as left our company, and he has configured SQL server 2000
with sa password that he and I caanot remember.
Is there a way to reset sa passord on SQL server 2000 in order to set an
other one?
thnaks for your help
regards
serge|||Hi,
U can change the sa password by executing
sp_password.
u can have more information from bol.
hope this help
from
Doller

help Sa password lost ?

One of our guy as left our company, and he has configured SQL server 2000
with sa password that he and I caanot remember.
Is there a way to reset sa passord on SQL server 2000 in order to set an
other one?
thnaks for your help
regards
sergeHi
Login with windows authentication and at QA perform
A. Change the password of a login without the former password
This example changes the password for the login Victoria to ok.
EXEC sp_password NULL, 'ok', 'Victoria'
B. Change a password
This example changes the password for the login Victoria from ok to coffee.
EXEC sp_password 'ok', 'coffee'
"serge calderara" <sergecalderara@.discussions.microsoft.com> wrote in
message news:14A10F77-EB04-46C1-AA05-366315B17921@.microsoft.com...
> One of our guy as left our company, and he has configured SQL server 2000
> with sa password that he and I caanot remember.
> Is there a way to reset sa passord on SQL server 2000 in order to set an
> other one?
> thnaks for your help
> regards
> serge|||See if this helps: http://vyaskn.tripod.com/administration_faq.htm#q9
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"serge calderara" <sergecalderara@.discussions.microsoft.com> wrote in
message news:14A10F77-EB04-46C1-AA05-366315B17921@.microsoft.com...
One of our guy as left our company, and he has configured SQL server 2000
with sa password that he and I caanot remember.
Is there a way to reset sa passord on SQL server 2000 in order to set an
other one?
thnaks for your help
regards
serge|||Hi,
U can change the sa password by executing
sp_password.
u can have more information from bol.
hope this help
from
Doller