SQL connection issue

billybob01

I have posted this in the sql section but thought i would paste it here as well due to my desperation.

I am using SQL 2005 Server and Express editions.

i have serverA and ServerB. On serverA i can connect locally and remotely to serverB. On serverB i can connect locally but not remotely to serverA, when trying to establish a connection to serverA i keep recieving this error message:

A connection was successfully established with the server, but an error occured during the pre-login handshake. 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 0- No process is on the other end of the pipe.) (Microsoft SQL Server, error: 223)

I have checked in the configuration manager that TCP/IP is enabled. There is obviously something i am missing as i can connect one way but not the other, but i cannot see any difference with the setups.

billybob01

Ok i have just found the issue, if i right click on the database and goto connections the allow remote connections box was not ticked, but when i ticked the box i recieve an error message stating that this edition of SQL does not allow you to have remote connections!! Crazy. This database is on SQL 2005 Express.

Any ideas?