| Author |
Topic |
|
kendo666
Starting Member
12 Posts |
 Posted - 2005-05-16 : 05:59:39
|
| Hi,I'm trying to install two sql server 2000s on a XP Pro machine to simulate a network env with multi sql servers, one default, one named. I install the default correctly and can see it in my sql server group through ent mgr. I install the second with the same settings (except with an instance name). I then go into ent mgr and try to add the new instance to the group via New Sql Server Registration but it says it doesn't exist.So i tried to install the new instance again but the install fails saying it already exists.Any idea on why it can't be seen in Ent Mgr?ThanksKen |
|
|
gyan78
Starting Member
4 Posts |
Posted - 2005-05-16 : 06:10:14
|
| May be i think if u connect diff IP(Network card or create two IPs) for it. |
 |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-05-16 : 06:23:48
|
| What's your instance called? What are you putting in the EM box asking for the server name?-------Moo. :) |
|
|
|
kendo666
Starting Member
12 Posts |
Posted - 2005-05-16 : 08:45:04
|
| I've called the instance ALT and when I goto the sql server reg wizard its got listed my machine name (i assume local) and no ALT aso i type ALT myself and add it but get the message:Sql Server does not exist or access denied (even if i try windows auth or sql server auth to get in)ThanksKen |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-05-16 : 08:48:07
|
Go to the server network utility and verify that you have a protocol enabled. WHY did you name something ALT???  You really should have picked another name. I wonder if that's some kind of reserved name. It's kind of funny actually. I should setup one of those on all my servers and have the same data in reverse.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
kendo666
Starting Member
12 Posts |
Posted - 2005-05-16 : 08:54:04
|
| However,I can't get into it via Query Analyzer as well saying it does exist but i can see the services running as MSSQL$ALT and SQLAgent$ALT.and if i try to re-install it says it exists. Hmmm, is this me, XP and instances, a full moon? How do i un-install an instance?cheersKen |
|
|
|
dragan
Starting Member
17 Posts |
Posted - 2005-05-16 : 08:59:58
|
| Make sure that you reboot after installing the second instance.After rebooting you should see the second instance listed under Available Servers in the Register SQL Server Wizard. If you don't see the second instance try typing in your computer name followed by a backslash. eg: draganpc\instance2Typing in local\instance2 won't work. It has to be the name of your pc.Later |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-05-16 : 09:07:41
|
| Yup. You can't just type "alt" as the name into the registration box, you have to typeyourservername\theinstancename-------Moo. :) |
|
|
|
kendo666
Starting Member
12 Posts |
Posted - 2005-05-16 : 09:26:23
|
| Thanks Guys,It was the machine name issue.CheersKen |
|
|
|
|
Can't see Named Instance in Group