Post reply

registering local sql server fails

  • July 5, 2004 at 2:27 am

    #161172

    Hi,

    I have installed SQL Server 2000 on my local PC (Windows XP).

    I can connect to a remote sql server but I need to have a local server on my PC also. For this to work I had installed the program twice but I think it should be possible to have only one instance of SQL Server and have local databases ?

    When I try to register my local pc, it's name appears in available servers in the first window of the wizard, but the registration fails saying SQL Server doesn't exist or access denied.

    how come it works with two instances of SQL Server ?

    thanks for your help

  • July 5, 2004 at 5:56 am

    #513276

    Paul,

    When you set-up the instances on your local machine did you set-up using SQL authentication or Windows?

    How are you trying to connect to your local?  If you are attempting SQL authentication did you set a password for sa?  Do you remember it?

    Can you see the instance running from sql manager (should be in systray)

    Thanks,

     

    AJ



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • July 5, 2004 at 6:25 am

    #513279

    Hi

    I use windows authentication

    I am trying to connect by using the registration wizard

    i can't see the sql server icon in systray and in windows services, i only see MSSQLServerOlapService

  • July 8, 2004 at 8:43 am

    #513854

    problem solved :

    the server wasn't started for local server !

Viewing 4 posts - 1 through 3 (of 3 total)

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