locked
Error getting while connecting to SQL Server RRS feed

  • Question

  • Hi Friends,
     I am Ali, i am using sql srver 2008 R2, visual studio 2008, sharepoint 2010. When i am opening Sql Server Database Engine in Windows authentication getting this error..

    "Cannot connect to AVSDT03
    A network-related or instance-specific error occurred while establishing a connection to SQL Server, The Server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.(Provider: Named Pipes Provider, error:40-Could not open a connection to SQL Server) (Microsoft SQL Server , Error:2)"

    i checked in Configration tools-->sql server config manager-->sql server services-->sql server browser is in running state  |  Automatic    |     NT AUTHORITY\Local service.
    and sql server Network configratino--> Protocols MSSQLSERVER--> shared memory - Enabled,Named pips-Disabled, TCP/IP-Enabled.

    and sql server services-->sql server(MSSWL SERVER) state is stopped, when i am going to start this service getting this error
    " The request failed or the service did not respond in timely fashion. Consult the event log or other applicable error logs for details."

    Please help me anybody

    Thanks & Regards

    Ali.

     


    MD.Liakath ali
    Monday, January 24, 2011 11:14 AM

Answers

  • Hi Liakath,

     

    For the first error message, it is likely caused by the SQL Server is not running from your description.

     

    For the second error message, I would like to suggest you try to change the service account to a domain account or other built-in service account and then give a try to start.

     

    If there are any progress, please feel free to let me know.                                          

     

    Thanks,
    Weilin Qiao


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
    • Marked as answer by Liakath Friday, January 28, 2011 9:07 AM
    Wednesday, January 26, 2011 7:26 AM

All replies

  • Ali

    What account SQL Server runs under? Is it local system?


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Monday, January 24, 2011 11:54 AM
  • Ali

    What account SQL Server runs under? Is it local system?


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Monday, January 24, 2011 11:54 AM
  • hi

       yes my problem is in local system.

    Thanks

    Ali.


    MD.Liakath ali
    Monday, January 24, 2011 12:01 PM
  • Hi Liakath,

     

    For the first error message, it is likely caused by the SQL Server is not running from your description.

     

    For the second error message, I would like to suggest you try to change the service account to a domain account or other built-in service account and then give a try to start.

     

    If there are any progress, please feel free to let me know.                                          

     

    Thanks,
    Weilin Qiao


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
    • Marked as answer by Liakath Friday, January 28, 2011 9:07 AM
    Wednesday, January 26, 2011 7:26 AM