Problem with SQLServer 2000

i installed the Visual Studio 2004+ Framework.NET 2

and SQLserver 2005

after those

i installed SQLserver 2000

and i got this :

http://img240.imageshack.us/img240/7392/sql2fk.jpg

thank you

This is the wrong forum. From your screenshot it looks like you should be checking the Express forum: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=385&SiteID=1

In the meantime, have you checked in the Services panel that SQL Server is running?

Have you enabled remote conenctions using the Surface Area configuraiton tool?

-Jamie

|||what should i change here?

http://img86.imageshack.us/img86/746/remote6np.jpg

thank you|||

From the screenshot http://img240.imageshack.us/img240/7392/sql2fk.jpg - it looks like you are trying to access SQL Server 2005 Express Edition from SQL Server Enterprise Manager.

Try accessing SQL Server 2005 express edition from SQL Server Management Studio (which is equivalent of SQL Server 2000 Enterprise manager for SQL Server 2005.)

Thanks,
Loonysan

|||i dont know what do u mean...

i even dont need SQL server 2005 i need only the 2000...

but i have heard that removing SQL server 2005 from my computer wont work...

can someone give me step by step what to do to solve the problem...

thank you :D|||

deViance wrote:

i dont know what do u mean...
i even dont need SQL server 2005 i need only the 2000...
but i have heard that removing SQL server 2005 from my computer wont work...
can someone give me step by step what to do to solve the problem...

thank you :D

For a starter, you are in the wrong place.

If you don't need SQL2005 why did you install it? What exactly are you trying to do?

-Jamie

problem with restore

hi,
i am trying to resore a database on sql --the back up of
which was taken in sql 2000
and i am getting the following error
[SQL-DMO] must be a part of sa, sysadmin or.......group
to complete this operation
i have given the server nt authentication and i am logged
in to the account with sys admin privalges ...
i am running a service pack 4 alredy
can someone help me on this one
You need to be sa to restore the db and it sounds like the account EM is
registered under for that server is not. Try using QA and the RESTORE
command with a proper login and see what happens.
Andrew J. Kelly SQL MVP
"ggupta" <ggupta@.cs.odu.edu> wrote in message
news:124801c4a331$d22dd300$a501280a@.phx.gbl...
> hi,
> i am trying to resore a database on sql --the back up of
> which was taken in sql 2000
> and i am getting the following error
> [SQL-DMO] must be a part of sa, sysadmin or.......group
> to complete this operation
> i have given the server nt authentication and i am logged
> in to the account with sys admin privalges ...
> i am running a service pack 4 alredy
> can someone help me on this one