ReInstall Sql Server

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!!!!!!!!!
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:

---

> 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

---

|||You have a couple of possible solutions.
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]
>
>.
>

---

Registration access denied

Am I able to register SQL2005 server in Enterprise Manager of SQL2000, or SQL2000 server in SQL Server Management Studio?

You can use enterprise manager from sql 2005 to administer both sql 2000 and sql 2005 databases.

I doubt that the enterprise manager from sql 2000 would work with a sql 2005 database.

|||How should I use enterprise manager in SQL2005?|||

Its Management Studio.

From Management Studio, you can connect to both sql 2000 and sql 2005 databases.

http://www.aspfaq.com/sql2005/show.asp?id=3

|||this SQL Express, is there any stest I can use for SQL 2000?|||

Hi

Below is from previous link:

As for connecting to Express from application code, this should not be any different from connecting to a named instance of SQL Server 2000. Your connection string should look like this, assuming local machine and an instance name of SQLEXPRESS (you might need a different instance name, and you may have to use a machine name, rather than "." (which means local)).

Registration access denied

Am I able to register SQL2005 server in Enterprise Manager of SQL2000, or SQL2000 server in SQL Server Management Studio?

you can't use it even if it registers.

here's a story:

i have bothe Enterprise manager and management studio on the same box

what ever i register on the management studio gets registered to EM.

but the problem is i cant open version 9 Db on EM even it i see it on the list of server

Registering Error

I am trying to register the SQL server 6.5 in SQL server 2000 I am getting
error
"SLQ Server does exist or access denied(ConnectionOpern(connect))
where is the problem its urgent can any body help me
Yousuf Khan
Programmer
I assume that you want to manage 6.5 from Enterprise Manager 2000? If so, can't be done. You need to
use EM 6.5 to manage 6.5.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Yousuf" <yousuf.yk@.gmail.com> wrote in message
news:82FCC446-36CC-423C-BF4F-EF60039BC984@.microsoft.com...
>I am trying to register the SQL server 6.5 in SQL server 2000 I am getting
> error
> "SLQ Server does exist or access denied(ConnectionOpern(connect))
> where is the problem its urgent can any body help me
> --
> Yousuf Khan
> Programmer
|||i wanted to import the databeses of 6.5 into 2000 thats y i wanted to
registers it first
Yousuf Khan
Programmer
"Tibor Karaszi" wrote:

> I assume that you want to manage 6.5 from Enterprise Manager 2000? If so, can't be done. You need to
> use EM 6.5 to manage 6.5.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Yousuf" <yousuf.yk@.gmail.com> wrote in message
> news:82FCC446-36CC-423C-BF4F-EF60039BC984@.microsoft.com...
>
>
|||Such an "import" is performed using the SQL Server 2000 Upgrade Wizard (found in the "Microsoft SQL
server - Switch" program group).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Yousuf" <yousuf.yk@.gmail.com> wrote in message
news:DE8EB7CB-A9A2-4D0F-8E07-CD9E93D554D4@.microsoft.com...[vbcol=seagreen]
>i wanted to import the databeses of 6.5 into 2000 thats y i wanted to
> registers it first
> --
> Yousuf Khan
> Programmer
>
> "Tibor Karaszi" wrote:

Registering Error

I am trying to register the SQL server 6.5 in SQL server 2000 I am getting
error
"SLQ Server does exist or access denied(ConnectionOpern(connect))
where is the problem its urgent can any body help me
Yousuf Khan
ProgrammerI assume that you want to manage 6.5 from Enterprise Manager 2000? If so, ca
n't be done. You need to
use EM 6.5 to manage 6.5.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Yousuf" <yousuf.yk@.gmail.com> wrote in message
news:82FCC446-36CC-423C-BF4F-EF60039BC984@.microsoft.com...
>I am trying to register the SQL server 6.5 in SQL server 2000 I am getting
> error
> "SLQ Server does exist or access denied(ConnectionOpern(connect))
> where is the problem its urgent can any body help me
> --
> Yousuf Khan
> Programmer|||i wanted to import the databeses of 6.5 into 2000 thats y i wanted to
registers it first
Yousuf Khan
Programmer
"Tibor Karaszi" wrote:

> I assume that you want to manage 6.5 from Enterprise Manager 2000? If so,
can't be done. You need to
> use EM 6.5 to manage 6.5.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Yousuf" <yousuf.yk@.gmail.com> wrote in message
> news:82FCC446-36CC-423C-BF4F-EF60039BC984@.microsoft.com...
>
>|||Such an "import" is performed using the SQL Server 2000 Upgrade Wizard (foun
d in the "Microsoft SQL
server - Switch" program group).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Yousuf" <yousuf.yk@.gmail.com> wrote in message
news:DE8EB7CB-A9A2-4D0F-8E07-CD9E93D554D4@.microsoft.com...[vbcol=seagreen]
>i wanted to import the databeses of 6.5 into 2000 thats y i wanted to
> registers it first
> --
> Yousuf Khan
> Programmer
>
> "Tibor Karaszi" wrote:
>

Registering Error

I am trying to register the SQL server 6.5 in SQL server 2000 I am getting
error
"SLQ Server does exist or access denied(ConnectionOpern(connect))
where is the problem its urgent can any body help me
--
Yousuf Khan
ProgrammerI assume that you want to manage 6.5 from Enterprise Manager 2000? If so, can't be done. You need to
use EM 6.5 to manage 6.5.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Yousuf" <yousuf.yk@.gmail.com> wrote in message
news:82FCC446-36CC-423C-BF4F-EF60039BC984@.microsoft.com...
>I am trying to register the SQL server 6.5 in SQL server 2000 I am getting
> error
> "SLQ Server does exist or access denied(ConnectionOpern(connect))
> where is the problem its urgent can any body help me
> --
> Yousuf Khan
> Programmer|||i wanted to import the databeses of 6.5 into 2000 thats y i wanted to
registers it first
--
Yousuf Khan
Programmer
"Tibor Karaszi" wrote:
> I assume that you want to manage 6.5 from Enterprise Manager 2000? If so, can't be done. You need to
> use EM 6.5 to manage 6.5.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Yousuf" <yousuf.yk@.gmail.com> wrote in message
> news:82FCC446-36CC-423C-BF4F-EF60039BC984@.microsoft.com...
> >I am trying to register the SQL server 6.5 in SQL server 2000 I am getting
> > error
> > "SLQ Server does exist or access denied(ConnectionOpern(connect))
> > where is the problem its urgent can any body help me
> >
> > --
> > Yousuf Khan
> > Programmer
>
>|||Such an "import" is performed using the SQL Server 2000 Upgrade Wizard (found in the "Microsoft SQL
server - Switch" program group).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Yousuf" <yousuf.yk@.gmail.com> wrote in message
news:DE8EB7CB-A9A2-4D0F-8E07-CD9E93D554D4@.microsoft.com...
>i wanted to import the databeses of 6.5 into 2000 thats y i wanted to
> registers it first
> --
> Yousuf Khan
> Programmer
>
> "Tibor Karaszi" wrote:
>> I assume that you want to manage 6.5 from Enterprise Manager 2000? If so, can't be done. You need
>> to
>> use EM 6.5 to manage 6.5.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Yousuf" <yousuf.yk@.gmail.com> wrote in message
>> news:82FCC446-36CC-423C-BF4F-EF60039BC984@.microsoft.com...
>> >I am trying to register the SQL server 6.5 in SQL server 2000 I am getting
>> > error
>> > "SLQ Server does exist or access denied(ConnectionOpern(connect))
>> > where is the problem its urgent can any body help me
>> >
>> > --
>> > Yousuf Khan
>> > Programmer
>>