SQL Server Performance

can't open SQL server 2005

Discussion in 'Getting Started' started by johnson alonso, Apr 23, 2007.

  1. johnson alonso New Member

    Dear All Experts,
    I am a newbie in this forum (SQL 2005). I am confusing with the current problem I am facing now. I have installed both SQL 2005 and 2000 developer edition. Today, I can't open SQL 2005 using SQL server management studio both using windows or SQL authentication in my notebook. I try to open it in the PC that located in the same workgroup with my notebook, it is successfully opened. I also have tried to open it in the notebook of my friend, it is also successful. I really don't understand why I could not open it in my notebook. I appreciate your answer. TIA.



    Rgds,
    Johnson
  2. satya Moderator

    You have to be clear about what error you are getting when trying to connect to SQL Server 2005 instance?
    Ensure the login you are using has relevant privilges or access rights to do so, also check whether SQL 2005 services have been started successfully.

    KBAhttp://support.microsoft.com/kb/328306
    http://support.microsoft.com/kb/265808
    ...should help you to go from here.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  3. MohammedU New Member

    Make sure SQL services are running and check the application log for any errors related to this...

    And post the error what you are getting.

    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  4. johnson alonso New Member

    Tks for your reply.

    quote: Make sure SQL services are running and check the application log for any errors related to this And post the error what you are getting.

    and


    quote: You have to be clear about what error you are getting when trying to connect to SQL Server 2005 instance?
    Ensure the login you are using has relevant privilges or access rights to do so, also check whether SQL 2005 services have been started successfully.


    After I check, the service is running and I can't find application log. Because I could not open SQL server 2005 yet. Do I have to check it using microsoft SQL server management studio installed in another PC ? I login with right access, there is no mistaken in password and instance or server name. I waited 1/2 hours but the error message never appears. I can send a webex file or screen shot for you if you are agree. Pls let me know your e-mail. I have no idea no more about this. Tks.


    Rgds,




  5. satya Moderator

    Have you check the both KBA articles above that will show how to connect and check few things, send the file to satyaskj-at-yahoodotcodotuk.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  6. Akthar New Member

    Is the SQL instances installed on a Server OR ON YOUR NOTEBOOK.?

    1. try re-installig client connectivity library on your Laptop





    AKTHAR

Share This Page