Post reply

create an instance of enterprise manager in my computer

  • May 1, 2006 at 7:50 am

    #112877

    hi, as of now to connect to my sql server 2000  i have to connect remotly by using remote connection, but I have seen there is a way to create an instance so then I just have to go to programs and then see enterprise manager from my computer. How do I do this, I have adminstrator rights to the sql server.

    Any help will be apreciate it!

    Jessica

     

  • May 1, 2006 at 8:52 am

    #635131

    What you want to do is to install only the client tools on your computer.  If you follow through the install process you will see this option.  Once you have done this yuou can open up the Enterprise Manager and register servers using SQL Server or NT Authentication.  This will then allow you to access any of the registered servers.

  • May 1, 2006 at 8:58 am

    #635134

    thank you, and i will find the client tools in the sql server cd?

  • May 1, 2006 at 12:32 pm

    #635192

    Yep, youwill see an option for install client tools only.

  • May 1, 2006 at 12:34 pm

    #635193

    thank you!!!!

  • May 3, 2006 at 8:05 am

    #635625

    I put the sql server standard edition cd and tried to install it and got an error message saying: "Microsoft SQL SErver 2000 Standard Edition server component is not supported on this operating system. Only client components will be availabe for installation"

     

    Help please....

  • May 3, 2006 at 8:06 am

    #635627

    hi,

    that's fine, so say OK, and the install will continue, allowing you to install the client tools .

    hope this helps

    Paul

  • May 3, 2006 at 9:17 am

    #635676

    thank you!!!!  :-), that is what i did and now it is successfully installed in my computer. Now from here how do I add my existing sql server connection?, is it adding a new group?

  • May 3, 2006 at 9:23 am

    #635678

    try add a new group, then highlight the group name, right click and select "New SQL Server Registration" and then you're away

    hope this helps

    Paul

  • May 3, 2006 at 9:24 am

    #635680

    also see "registering servers" In Books Online, and check out "How to register a server (Enterprise Manager)

  • May 3, 2006 at 9:25 am

    #635681

    awesome, mission accomplished than you so  much!!

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply