cannot connect to my sql server

  • i tried log into my sql server and i get this message

    "the default settings sql server does not allow remote connections (Provider: Named Pipes provider error:40 - could not open a connection to sql server)( Microsoft sql error:2 ) )"

    and when i try to enable remote login and start the service again from sac i get this message

    "the service did respond to start or control request in a timely fashion, you need administrator priviledges to be able to start/stop this service sqlsac "

    help please i 've been on this for two days now

  • Hi,

    Check whether mysqld.exe or mysqld_nt.exe is running in the server machine or not. If not start this exe and try connecting to it.

    Regards,

    Ashok S

  • am using mssql not mysql so plse help

  • Hi,

    Ok, The issue is with your Server. Check whether the Named Connections are Enabled or not in the Server. If not Enable it and restart the server. Hope this will fix you problem.

    Also have a look at this,

    http://www.microsoft.com/products/ee/transform.aspx?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233

    Regards,

    Ashok S

Viewing 4 posts - 1 through 3 (of 3 total)

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