Author |
Topic |
RichardBone
Starting Member
29 Posts |
Posted - 2006-10-16 : 20:09:41
|
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 foundWhat should I do? |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-10-16 : 21:20:42
|
"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 |
|
|
RichardBone
Starting Member
29 Posts |
Posted - 2006-10-16 : 21:42:49
|
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? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-10-16 : 21:45:23
|
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 |
|
|
RichardBone
Starting Member
29 Posts |
Posted - 2006-10-16 : 22:08:01
|
I installed SQL 2000 EE, SQL Server 2005 was installed automatically when I installed ASP.NET 2.0. Should I uninstall SQL Server 2005? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-10-16 : 22:17:59
|
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 |
|
|
RichardBone
Starting Member
29 Posts |
Posted - 2006-10-16 : 22:20:36
|
So, how do I create a server to use with 2000? Thanks for all the help. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-10-16 : 22:22:42
|
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 |
|
|
RichardBone
Starting Member
29 Posts |
Posted - 2006-10-16 : 22:26:00
|
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. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-10-16 : 22:32:18
|
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 |
|
|
RichardBone
Starting Member
29 Posts |
Posted - 2006-10-16 : 22:38:01
|
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? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-10-16 : 22:40:47
|
Look for MSSQLSERVER and right click to start it KH |
|
|
RichardBone
Starting Member
29 Posts |
Posted - 2006-10-16 : 22:44:00
|
I don't have that, what should I do? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-10-16 : 22:50:18
|
or if you named the SQL Server instance, it will appear asMSSQL$InstanceNameIf still not there, Did you really installed SQL Server 2000 ? KH |
|
|
RichardBone
Starting Member
29 Posts |
Posted - 2006-10-16 : 22:55:11
|
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). |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-10-16 : 23:11:57
|
Yes. Try to re-install it. Take note of any error occurred during installation KH |
|
|
RichardBone
Starting Member
29 Posts |
Posted - 2006-10-16 : 23:19:38
|
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? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-10-16 : 23:27:40
|
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 |
|
|
RichardBone
Starting Member
29 Posts |
Posted - 2006-10-16 : 23:29:51
|
Thanks again for all your help. |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-10-17 : 13:27:25
|
I have a feeling the Developer Edition (or perhaps MSDE which would also do) comes on the same CD as Enterprise EditionKristen |
|
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
Posted - 2006-10-17 : 14:26:25
|
There are actually Three main Editions of SQL Server 2000Personal, Standard, Enterprise. There are also Developer Edition, Desktop Engine, SQL Server CE and Evaluation Edition.http://www.mssqlcity.com/Articles/Adm/SQL2000Inst.htmI 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 |
|
|
Previous Page&nsp;
Next Page
|