COnnection failure

  • hi I gopt this eroor in sql server 2005.

    select error:SQLSTATE=08s01 Microsoft OLEDB provider for sql server connection failure

    how can i resolve it. any one can help me.

  • There are only about a million ways to get that message..

    Assuming you have been able to connect before from this machine

    1. Is SQL Server up?

    2. Is SQL running on a non-standard port and SQL Browser is not running on the server.

    Lets start there..

    CEWII

  • we get this eroor while we reteriving the data from the databse.

  • What did SQL error log says? Check if Remore connection is enabled

    Paste the full error.

    "More Green More Oxygen !! Plant a tree today"

  • When you retrieve this data, are you only pulling it from one database? Are you connected to that database?

    Are you pulling from multiple DBs? Are you using a Linked Server?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

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