You must Sign In to post a response.
  • Category: SQL Server

    Error in connecting sql server

    Sir i had installed visual studio and sql server 2008r2. Now i want to establesh a connection with it and to create a database but i just got an error that i have attached in zip. Please have a look on it.
  • #764112


    Delete Attachment

  • #764116
    Hi sachin,

    1) Check whether Microsoft SQL service is started?

    Start->Programs->Microsoft SQL Server->Configuration Tools->SQL Server Configuration Manager.
    From the configuration manager assure that the SQL Service is started.

    2) Make sure you are entering correct Server Name.

    Hope this will help you.

    Shashikant Gurav

  • #764123
    Sir i had started SQL service properly and entered server name properly but the problem is being continue.

  • #764126
    Hai Sachin,
    While installing the Sql Server, you need to choose the Default instance and keep it in Windows Authentication. Once you do that during the installation, a default instance of the Sql Server will be installed in your machine and then you can access it. There should not be any issue when using the Windows Authentication. Once it is successful, you can create the users and then you can make the sql server authentication to access it
    Hope ti will be helpful to you.

    Pawan Awasthi(DNS MVM)
    +91 8123489140 (whatsApp), +60 14365 1476(Malaysia)

  • #764139
    Hi Sachin.

    Your first error message clearly says that you have opened it using the design i.e., through user interface. Try to close it and once restart the sql server in the services by typing services.msc in run command.
    Where as your second error of verify instance is due to incorrect server type and server name.
    If you have installed in default instance mode then your server name will be MSSQLSERVER else the server name will be your PC name.
    Go to properties of mycomputer and check the name of PC.
    Give the PC name as server name.
    For example my pc name is sri the the server name will be sri.
    Then connect with windows authentication mode.

    Sridhar Thota.
    Editor: DNS Forum.

Sign In to post your comments