Error while connecting to the server..

  • Please Help!!!!! This error is driving me crazy!

    "A network-related or instance-specific error occured while establishing a connection to SQL Server. The server was not found or was not accessible. Verify taht the instance name is correct and that the SQL server is configured to allow remote connections. (Provider: Named pipes provider, Error:40- could not open connection to the SQL Serevr."

  • 1) What authentication mode are you using?

    2) Are you trying to connect to the server remotely?

    3) Have you enabled remote access?

    4) Is TCP/IP enabled?

    You need to provide more info.

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

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • Firewall rules open and correct?

    Named instance or default instance?

    Static ports or dynamic ports?

    SQL Browser Service running?

    Can you telnet to the server over the correct port?

    Can you connect via IP instead of hostname?

    Is the hostname spelt correctly?

    Do you need to use the FQDN instead of just the hostname?

  • server type: Database engine

    authentication: windows Authentication.

    yes remotely.

    Im very fresh with SQL and struggling from time to time.

    Im trying to create a report in BIDS and thats the type of error im fighting with, i thought Im doing everything like i should.

    The problem must be somewhere deaper....

    Can you please help me, ill follow any instructions.

    Regards,

    Mel.

  • Is TCP/IP enabled? Check this in sql server configuration manager.

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

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • TCP/IP enabled

    The remote procedure call failed [0x800706be].

  • im using SQL Server express advanced eddition by the way.

  • I assume you also checked that sql server is configured to allow remote connections?

    Are you trying to connect to a named instance or is it just a default instance?

    Are you just putting the server name or are you using FQDN?

    Also, have you created a login on the sql server?

    Even with all this it could be a firewall issue on the machine that's hosting sql server!

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

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • You may have to create an inbound firewall rule but check the above first.

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

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • thank you I have found the problem.

  • Marlena.ibek (1/9/2013)


    thank you I have found the problem.

    Please detail the problem and the solution, so that if anyone having the same issue, may try your solution.

Viewing 11 posts - 1 through 10 (of 10 total)

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