Post reply

Strange taht I cannot connect to localhost but can connect to remote one.

  • September 20, 2012 at 10:26 am

    #393224

    My SQL server is SQL 2012. right now I can connect to remote server but connect to localhost is always failed. Can you tell me what reason for it?

  • September 20, 2012 at 10:28 am

    #1540227

    Fail to connect. Depends, what is the actual error message you are getting?

  • September 20, 2012 at 10:53 am

    #1540239

    Error:2

  • September 20, 2012 at 10:58 am

    #1540247

    xinli923 (9/20/2012)

    Error:2

    the entire error message is what we need to help; the state and actual error message are critical.

    error 2 is cannot connect in general;

    for example:

    Microsoft SQL Server Login

    Connection failed: SQLState: '01000'

    SQL Server Error: 2

    [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen (CreateFile()).

    Connection failed:

    SQLState: ‘08001’

    SQL Server Error: 6

    [Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not found.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • September 20, 2012 at 11:04 am

    #1540255

    And message include,cannot find default browser

    I named my SQL server : SQL 2012. If cannot connect to it,it means cannot find SQL 2012. But why say cannot find default browser?

  • September 20, 2012 at 11:13 am

    #1540263

    xinli923 (9/20/2012)

    And message include,cannot find default browser

    I named my SQL server : SQL 2012. If cannot connect to it,it means cannot find SQL 2012. But why say cannot find default browser?

    Maybe a screen print of the error? Sorry, but this makes no sense to me.

  • September 20, 2012 at 11:26 am

    #1540271

    My question Is :

    My SQL server is SQL 2012. right now I can connect to remote server but connect to localhost is always failed. Can you tell me what reason for it?

    All of message showed on screen is:

    A network-related or Instance-spefic error occured while establishing a connection to SQL Server.Verify that Instance name is correct and that SQL server is configured to allow remote connection. Provider:named pipes,error 40-could not open a connection to SQL Server (Microsoft Server ,Error:2).

    ------------------

    Instance name I gave is SQL 2012 and it can connect to remote one.it means SQL server is configured to allow remote connection.

    Problem is at A network-related or Instance-spefic error occured while establishing a connection to SQL Server.

    what problem? How to resolve it?

    I don't know. So Ask for help !

  • September 20, 2012 at 12:39 pm

    #1540309

    What name/address are you using in the connection string? "localhost" or "(local)" or "SQL 2012" or something else?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • September 20, 2012 at 7:30 pm

    #1540446

    Thanks, I watch your words and seems understand what ,where I was wrong. I try localhost\sql2012. It works.

Viewing 9 posts - 1 through 8 (of 8 total)

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