Can't login with remote servers

Able to connect just fine at the main server but when trying to get the other
servers to connect get the following error.
Using SQL Server 2005 Express Edition:
Connection Failed:
SQLState: '01000'
SQL Server Error: 11004
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).
Connection Failed:
SQLState: '08001'
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not
found.
Any ideas why I would be getting this error? All information is correct
according to where it is in the first server.
Dusitn D'Amour
Coyote Solutions Group
505.742.0066
www.coyotesolutions.com
Sure. See the archives of this list. We've discussed this any number of
times. Check back here if you don't find the answer(s).
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
Between now and Nov. 6th 2006 you can sign up for a substantial discount.
Look for the "Early Bird" discount checkbox on the registration form...
------
Microsoft MVP, Author, Mentor
Microsoft MVP
"Dustin D''Amour" <DustinDAmour@.discussions.microsoft.com> wrote in message
news:B13047CD-D41D-43A4-B80D-350B30B372AF@.microsoft.com...
> Able to connect just fine at the main server but when trying to get the
> other
> servers to connect get the following error.
> Using SQL Server 2005 Express Edition:
> Connection Failed:
> SQLState: '01000'
> SQL Server Error: 11004
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen
> (Connect()).
> Connection Failed:
> SQLState: '08001'
> SQL Server Error: 6
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server
> not
> found.
>
> Any ideas why I would be getting this error? All information is correct
> according to where it is in the first server.
>
> --
> Dusitn D'Amour
> Coyote Solutions Group
> 505.742.0066
> www.coyotesolutions.com
|||Where is the archive located?
I should also mention that mixed authentication is selected and the remote
servers still can not connect.
Dusitn D'Amour
Coyote Solutions Group
505.742.0066
www.coyotesolutions.com
"William (Bill) Vaughn" wrote:

> Sure. See the archives of this list. We've discussed this any number of
> times. Check back here if you don't find the answer(s).
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> Between now and Nov. 6th 2006 you can sign up for a substantial discount.
> Look for the "Early Bird" discount checkbox on the registration form...
> ------
>
> Microsoft MVP, Author, Mentor
> Microsoft MVP
> "Dustin D''Amour" <DustinDAmour@.discussions.microsoft.com> wrote in message
> news:B13047CD-D41D-43A4-B80D-350B30B372AF@.microsoft.com...
>
>
|||I found http://support.microsoft.com/kb/306865 which show the same error I'm
having but when I go through the steps for the workaround it still doesn't
work.
Anyone else have any other ideas?
Dusitn D'Amour
Coyote Solutions Group
505.742.0066
www.coyotesolutions.com
"Dustin D''Amour" wrote:
[vbcol=seagreen]
> Where is the archive located?
> I should also mention that mixed authentication is selected and the remote
> servers still can not connect.
>
> --
> Dusitn D'Amour
> Coyote Solutions Group
> 505.742.0066
> www.coyotesolutions.com
>
> "William (Bill) Vaughn" wrote:
|||This thread had an answer that seems to work for now.
Dusitn D'Amour
Coyote Solutions Group
505.742.0066
www.coyotesolutions.com
"Dustin D''Amour" wrote:
[vbcol=seagreen]
> I found http://support.microsoft.com/kb/306865 which show the same error I'm
> having but when I go through the steps for the workaround it still doesn't
> work.
> Anyone else have any other ideas?
>
> --
> Dusitn D'Amour
> Coyote Solutions Group
> 505.742.0066
> www.coyotesolutions.com
>
> "Dustin D''Amour" wrote:
|||Forgot t put the link in.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=129105&SiteID=1
Dusitn D''Amour
Coyote Solutions Group
505.742.0066
www.coyotesolutions.com
"Dustin D''Amour" wrote:
[vbcol=seagreen]
> This thread had an answer that seems to work for now.
> --
> Dusitn D'Amour
> Coyote Solutions Group
> 505.742.0066
> www.coyotesolutions.com
>
> "Dustin D''Amour" wrote: