none
TITLE: Connect to Server RRS feed

  • Question

  • hi

    I Have creted the local user in my system.and ia hev given the admin permision to the same user, and added in the sql all the groups.

    Hoever when i am trying to log into SQL using SQLserverathentication i am facing the below error.

    Thanks for your support.

     

    TITLE: Connect to Server
    ------------------------------

    Cannot connect to B4L-3Dqpwq1.

    ------------------------------
    ADDITIONAL INFORMATION:

    A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476

    ------------------------------
    BUTTONS:

    OK
    ------------------------------

    Tuesday, November 22, 2011 11:21 AM

Answers

  • Does this question have anything to do with BizTalk?

    -If you go to the SQL Server Configuration Manager, make sure that Named Pipes and TCP/IP is enabled under "SQL Server Network configuration"/Protocols for MSSQLSERVER

     

    Morten la Cour

    Tuesday, November 22, 2011 11:26 AM