SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Completely new to SQL Server 2000
 New Topic  Reply to Topic
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

RichardBone
Starting Member

29 Posts

Posted - 10/16/2006 :  20:09:41  Show Profile  Reply with Quote
Hello, I have installed Enterprise edition. I used Client Network Utility to create a server. I went into Enterprise manager and tried to register this server I created and I got the following error:
Specified SQL Server not found

What should I do?

khtan
In (Som, Ni, Yak)

Singapore
17642 Posts

Posted - 10/16/2006 :  21:20:42  Show Profile  Reply with Quote
"I used Client Network Utility to create a server."
What do you mean ?

You don't have to do anything in the client network util. Once the server is installed (make sure it is running), just run Enterprise Manager to register it (either using computername\instancename or IPAddress,portno or let it auto detect)



KH

Go to Top of Page

RichardBone
Starting Member

29 Posts

Posted - 10/16/2006 :  21:42:49  Show Profile  Reply with Quote
I have one called SQLExpress, I get this error when I connect:
You must Use SQL Server 2005 management tools to connect to this server.

So I can't do anything with this in SQL Server 2000?

Edited by - RichardBone on 10/16/2006 21:43:19
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
17642 Posts

Posted - 10/16/2006 :  21:45:23  Show Profile  Reply with Quote
Looks like SQLExpress is the SQL Server Express Edition (2005). You can't use Enterprise Manager (2000) to manage a 2005 server.

" I have installed Enterprise edition"
You have installed SQL Server 2000 Enterprise Edition or 2005 ?


KH

Go to Top of Page

RichardBone
Starting Member

29 Posts

Posted - 10/16/2006 :  22:08:01  Show Profile  Reply with Quote
I installed SQL 2000 EE, SQL Server 2005 was installed automatically when I installed ASP.NET 2.0. Should I uninstall SQL Server 2005?

Edited by - RichardBone on 10/16/2006 22:19:05
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
17642 Posts

Posted - 10/16/2006 :  22:17:59  Show Profile  Reply with Quote
You don't have to unless you want to. SQL 2000 and 2005 can co-exists in the same machine (There might be some minor issue or things to be aware, do a search in this forum for details). It just that you can't use Enterprise Manager to manage a 2005 but you can use SQL Server Management Studio to manage both 2000 & 2005 SQL Server.


KH

Go to Top of Page

RichardBone
Starting Member

29 Posts

Posted - 10/16/2006 :  22:20:36  Show Profile  Reply with Quote
So, how do I create a server to use with 2000? Thanks for all the help.
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
17642 Posts

Posted - 10/16/2006 :  22:22:42  Show Profile  Reply with Quote
Once you installed SQL Server 2000 Enterprise Edition you have a SQL Server for your use. Next you will need to create database. Goto Enterprise Manager and right click on the Database and select New.


KH

Go to Top of Page

RichardBone
Starting Member

29 Posts

Posted - 10/16/2006 :  22:26:00  Show Profile  Reply with Quote
My database option is disabled. I thought you were suppose to connect to a server and create databases there. And I don't have a server to connect to. The only server listed is the 2005 one, which I can't use in 2000.

Edited by - RichardBone on 10/16/2006 22:32:01
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
17642 Posts

Posted - 10/16/2006 :  22:32:18  Show Profile  Reply with Quote
Run Enterprise Manage and register the SQL Server 2000.
Make sure your SQL Server is running (Control Panel - Admin Tools - Services)
Click on SQL Server Group and right click to New Server Registration.


KH

Go to Top of Page

RichardBone
Starting Member

29 Posts

Posted - 10/16/2006 :  22:38:01  Show Profile  Reply with Quote
Only one SQL Server is running which is named in the services:
SQL Server (SQL Express)

How do I start up the SQL Server for 2000?

Edited by - RichardBone on 10/16/2006 22:39:04
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
17642 Posts

Posted - 10/16/2006 :  22:40:47  Show Profile  Reply with Quote
Look for MSSQLSERVER and right click to start it


KH

Go to Top of Page

RichardBone
Starting Member

29 Posts

Posted - 10/16/2006 :  22:44:00  Show Profile  Reply with Quote
I don't have that, what should I do?
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
17642 Posts

Posted - 10/16/2006 :  22:50:18  Show Profile  Reply with Quote
or if you named the SQL Server instance, it will appear as

MSSQL$InstanceName

If still not there, Did you really installed SQL Server 2000 ?


KH

Go to Top of Page

RichardBone
Starting Member

29 Posts

Posted - 10/16/2006 :  22:55:11  Show Profile  Reply with Quote
Oh god it's not there. I always get the most messed up problems. Maybe I should try to reinstall it. (It is SQL Server 2000 EE, by the way).
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
17642 Posts

Posted - 10/16/2006 :  23:11:57  Show Profile  Reply with Quote
Yes. Try to re-install it. Take note of any error occurred during installation


KH

Go to Top of Page

RichardBone
Starting Member

29 Posts

Posted - 10/16/2006 :  23:19:38  Show Profile  Reply with Quote
Wow, I got an error first time I installed it. I just said ok without reading it and installed it through. Now that I'm reinstalling, that error came up again. It says "The server component is not supported on this operating system, only client components will be installed"

I'm using WinXP. Is there a way to work around this?
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
17642 Posts

Posted - 10/16/2006 :  23:27:40  Show Profile  Reply with Quote
Afraid not.

If not mistaken, you can't install Enterprise Edition on WinXP only Windows Server 2000 / 2003. For WinXP, you have to use
Developer Edition


KH

Go to Top of Page

RichardBone
Starting Member

29 Posts

Posted - 10/16/2006 :  23:29:51  Show Profile  Reply with Quote
Thanks again for all your help.
Go to Top of Page

Kristen
Test

United Kingdom
22415 Posts

Posted - 10/17/2006 :  13:27:25  Show Profile  Reply with Quote
I have a feeling the Developer Edition (or perhaps MSDE which would also do) comes on the same CD as Enterprise Edition

Kristen
Go to Top of Page

jpotucek
Constraint Violating Yak Guru

USA
273 Posts

Posted - 10/17/2006 :  14:26:25  Show Profile  Send jpotucek an AOL message  Reply with Quote

There are actually Three main Editions of SQL Server 2000
Personal, Standard, Enterprise. There are also Developer Edition, Desktop Engine, SQL Server CE and Evaluation Edition.

http://www.mssqlcity.com/Articles/Adm/SQL2000Inst.htm

I have SQL Server 2000 Personal Edition running at home on my XP Professioal machine.. I just can't rememember where I got the Personal Edition from ... I'll poke around and see if I can find it for you
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.56 seconds. Powered By: Snitz Forums 2000