Post reply

cannot connect to the database in the local machine

  • July 23, 2008 at 2:48 am

    #130173

    hi i have allready a database and a project but when i bring the database to a different machine the database cannot be connect an error has ben occour "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

    I have done all the procedure for remort connection from SQL server surface area configuration

  • July 23, 2008 at 3:43 am

    #846885

    Hi

    Check the database properties and on connection there is a check box that allows you to connect to remote machines, then also check on the network settings for TCP/IP settings, this will let you to connect to database 😀

  • July 23, 2008 at 3:58 am

    #846888

    Is the SQL Server Browser service running on the server you are trying to connect to?

  • July 23, 2008 at 4:18 am

    #846891

    Which version of sql server you are using???

  • July 23, 2008 at 4:18 am

    #846892

    Enable remote connection for the server and use tcp ip and named pipes...

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

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