Help with Remote Connection

I am attempting to connect to SQL 2005 server. The server and the VS 2005 are on the same computer. I have configured the db so it uses the security for asp. The log in section connects fine and checks for the user. I have combined the old db with the new ASP security. If the user is not found then I open a connection using the open command and check for the user in the old part of the db. The is where I have trouble. I get the message below that the server connect but then won't allow remote connections. I have check the setting and the allow remote connections is checked. Thank in advance if anyone can help.

Endeavor

A connection was successfully established with the server, but then an error occurred 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.)

The error came from Named Pipes Provider. Please check the server network protocols to maks sure Named Pipes is enabled. You can check this in 'Configuration Tools'->'SQL Server Configuration Manager'->'SQL Server 2005 Network Configuration'.

You'd better also configure remote connections to use both TCP/IP and Named pipes in 'SQL Server 2005 Surface Area Configuration'.

|||

thanks for your response, I went throught a configured like you said, the named pipes were disabled in the configuration manager but the other were correct in the surface area config. But I am still getting the same error message when it get to the trying to open a connection useing the open command. Have you got any other ideas I can try to get it to work.

Endeaveor

sql

Help with Outer Joins

Hi. I'm using Microsoft Query to create a query for Excel 2003. I'm
attempting to create 3 Left Outer Joins, but upon doing so I receive the
error message "Query Can Have Only One Outer Join" as described here...
http://support.microsoft.com/defaul...14027#appliesto
After reading this article, I am under the impression that multiple Outer
Joins CAN indeed be created, only you must write the SQL code directly in
order to create them. That's were I'm lost. I'm not sure how to write the
necessary SQL code in order to join the 3 tables. Could someone please
assist me with the necessary code?
My tables are: tblOrder, Customer, tblSQFTByStation, and tblOrderDetail
tblOrder should be joined to the other 3 tables as follows...
FROM {oj `H:\Application_be`.tblOrder tblOrder LEFT OUTER JOIN
`H:\Application_be`.tblSQFTByStation tblSQFTByStation ON tblOrder.OrderID =
tblSQFTByStation.OrderID}
FROM {oj `H:\Application_be`.tblOrder tblOrder LEFT OUTER JOIN
`H:\Application_be`.Customer Customer ON tblOrder.CustomerID =
Customer.CustomerID}
FROM {oj `H:\Application_be`.tblOrder tblOrder LEFT OUTER JOIN
`H:\Application_be`.tblOrderDetail tblOrderDetail ON tblOrder.OrderID =
tblOrderDetail.OrderID}What you might be missing is that each join is not from 1 source to another,
it is from what you have so far to anothersource...
So (THis is probably wrong syntactically cause I don't know Exce
lsyntax...)tr this structure.
FROM oj `H:\Application_be`.tblOrder tblOrder
LEFT OUTER JOIN `H:\Application_be`.tblSQFTByStation tblSQFTByStation
ON tblOrder.OrderID = tblSQFTByStation.OrderID
LEFT OUTER JOIN `H:\Application_be`.Customer Customer
ON tblOrder.CustomerID = Customer.CustomerID
LEFT OUTER JOIN `H:\Application_be`.tblOrderDetail tblOrderDetail
ON tblOrder.OrderID = tblOrderDetail.OrderID
"MrMike" wrote:

> Hi. I'm using Microsoft Query to create a query for Excel 2003. I'm
> attempting to create 3 Left Outer Joins, but upon doing so I receive the
> error message "Query Can Have Only One Outer Join" as described here...
> http://support.microsoft.com/defaul...14027#appliesto
> After reading this article, I am under the impression that multiple Outer
> Joins CAN indeed be created, only you must write the SQL code directly in
> order to create them. That's were I'm lost. I'm not sure how to write th
e
> necessary SQL code in order to join the 3 tables. Could someone please
> assist me with the necessary code?
> My tables are: tblOrder, Customer, tblSQFTByStation, and tblOrderDetail
> tblOrder should be joined to the other 3 tables as follows...
> FROM {oj `H:\Application_be`.tblOrder tblOrder LEFT OUTER JOIN
> `H:\Application_be`.tblSQFTByStation tblSQFTByStation ON tblOrder.OrderID
=
> tblSQFTByStation.OrderID}
> FROM {oj `H:\Application_be`.tblOrder tblOrder LEFT OUTER JOIN
> `H:\Application_be`.Customer Customer ON tblOrder.CustomerID =
> Customer.CustomerID}
> FROM {oj `H:\Application_be`.tblOrder tblOrder LEFT OUTER JOIN
> `H:\Application_be`.tblOrderDetail tblOrderDetail ON tblOrder.OrderID =
> tblOrderDetail.OrderID}
>|||Thanks!
"CBretana" wrote:
> What you might be missing is that each join is not from 1 source to anothe
r,
> it is from what you have so far to anothersource...
> So (THis is probably wrong syntactically cause I don't know Exce
> lsyntax...)tr this structure.
> FROM oj `H:\Application_be`.tblOrder tblOrder
> LEFT OUTER JOIN `H:\Application_be`.tblSQFTByStation tblSQFTByStation
> ON tblOrder.OrderID = tblSQFTByStation.OrderID
> LEFT OUTER JOIN `H:\Application_be`.Customer Customer
> ON tblOrder.CustomerID = Customer.CustomerID
> LEFT OUTER JOIN `H:\Application_be`.tblOrderDetail tblOrderDetail
> ON tblOrder.OrderID = tblOrderDetail.OrderID
>
> "MrMike" wrote:
>