is "Denied" before I have a login for a standart user but
I can't use it I get connection fail all the time. I want
to reinstall Sql Server am i going to lose the databases?
Is there any hope for this situation?
Please Help!!!!!!!!!
ShalomHello,
it depends on your NT-Account. If you have still access to the
server console you can login, shutdown the sql-services and
copy the database files to a secure place.
You can than use the rebuildm.exe tool to create new system-db's.
Reattach the user-db's and all is fine.
That would be my suggestion...but maybe some have a better one.
cu
p.s:
But how you have lost the rights?
You have made backups of your system and user databases?
"Shalom" <Telaviv7777777@.aol.com> wrote in message
news:009f01c3cbda$9c3c1c40$a301280a@.phx.gbl...
quote:|||You have a couple of possible solutions.
> I lost access to sql server, "sa" is "Denied" "builtin"
> is "Denied" before I have a login for a standart user but
> I can't use it I get connection fail all the time. I want
> to reinstall Sql Server am i going to lose the databases?
> Is there any hope for this situation?
> Please Help!!!!!!!!!
> Shalom
1. Restore master from a backup
2. Rebuild master then re-attach the user databases.
3. Attempt a Windows NT Athenticated connection with the NT admin account
on the server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Hi Christian,
Thank You for trying to help.
1) I selected security from the console root I epanded the
server than selected security clcked on login than
selected "sa" than selected "denied" for "sa" user.
2)I did not make a backup.
Shalom
quote:
>--Original Message--
>Hello,
>
>it depends on your NT-Account. If you have still access
to the
quote:
>server console you can login, shutdown the sql-services
and
quote:
>copy the database files to a secure place.
>You can than use the rebuildm.exe tool to create new
system-db's.
quote:
>Reattach the user-db's and all is fine.
>That would be my suggestion...but maybe some have a
better one.
quote:
>cu
>p.s:
>But how you have lost the rights?
>You have made backups of your system and user databases?
>
>"Shalom" <Telaviv7777777@.aol.com> wrote in message
>news:009f01c3cbda$9c3c1c40$a301280a@.phx.gbl...
but[QUOTE]
want[QUOTE]
databases?[QUOTE]
>
>.
>
No comments:
Post a Comment