Post reply

sql sever does not exist or access denied

  • October 31, 2006 at 7:37 am

    #116165

    I have installed sql server 2000 personal edition on my machine and I have started the service in services but when I try to connect to the instance from the enterprise manager it says sql sever does not exist or access denied.Connection open(connect().

     

    But I have started the sqlserver with my windows authentication and trying to connect from enterprise manager with the same authentication.

     

    what should be the pbm. How can I connect ?

     

    Thanks.

  • October 31, 2006 at 7:53 am

    #668969

    When i see my hardware profiles it has undocked profile(currrent) and docked profile in the AS available hardware profiles.

     

    does this effect?

  • October 31, 2006 at 7:56 am

    #668970

    How do you name the server when you're trying to connect?

    Try using a . (period) as servername and see if it works.

    (this is assuming you're sitting at the same console where the server is running)

    /Kenneth

  • October 31, 2006 at 8:06 am

    #668974

    my server name is newdb and the service is mssql$newdb and I am trying to add the new instance as newdb in my enterprise manager.

    Thanks for ur help.

  • October 31, 2006 at 8:15 am

    #668980

    even if i try with . ( a period) i am getting the same error.

     

    Thanks.

  • November 1, 2006 at 3:17 am

    #669160

    How about trying to connect with Query Analyzer..?

    Enter your servername 'newdb'  ..(?) is that the name of your computer?

    ..and try connecting with  - windows authentication

    (requires you're logged on with a local admin account, assuming you haven't added your 'normal windows account' to a login)

    .. or log on as 'sa' and provide the password you entered when you installed SQL Server.

    /Kenneth

Viewing 6 posts - 1 through 5 (of 5 total)

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