Hi, everybody?!
I cannot use debugging function on some clients. For example, on my PC I
cannot use debugging facility.
Whenever I try to use debugging facility, it just returns results and ends.
I cannot use step-by-step function.
But on my laptop, I can use the function very well.
I wonder why I can't use the function on some clients, and can on other
ones.
Thanks.This is usually fixed by stepping through the section in BooksOnLine under
"troubleshooting SQL Server, Transact-SQL debugger" and ensuring you have
all the steps done correctly.
--
Andrew J. Kelly
SQL Server MVP
"Kim, KeukTae" <zyuuzika@.korea.com> wrote in message
news:OweEoodSDHA.3700@.tk2msftngp13.phx.gbl...
> Hi, everybody?!
> I cannot use debugging function on some clients. For example, on my PC I
> cannot use debugging facility.
> Whenever I try to use debugging facility, it just returns results and
ends.
> I cannot use step-by-step function.
> But on my laptop, I can use the function very well.
> I wonder why I can't use the function on some clients, and can on other
> ones.
> Thanks.
>
>
Showing posts with label clients. Show all posts
Showing posts with label clients. Show all posts
Tuesday, March 20, 2012
Wednesday, March 7, 2012
Cannot connect with Enterprise Manager
Hi All
I can connect to a server with Query Analyzer but not with
Enterprise manager (from a lot of clients so problem is
not client based). I used to be able to connect using
both, then all of a sudden it stopped. I rebooted the
server and Enterprise Manager connectivity worked for a
few hours and then stopped again (QA access still works!).
Can anyone think of any reason why this may be so?
Thanks
Jono
Jono
Any error message?
"Jono" <anonymous@.discussions.microsoft.com> wrote in message
news:ad9901c488df$5d5c9690$a501280a@.phx.gbl...
> Hi All
> I can connect to a server with Query Analyzer but not with
> Enterprise manager (from a lot of clients so problem is
> not client based). I used to be able to connect using
> both, then all of a sudden it stopped. I rebooted the
> server and Enterprise Manager connectivity worked for a
> few hours and then stopped again (QA access still works!).
> Can anyone think of any reason why this may be so?
> Thanks
> Jono
|||No, just hangs.
>--Original Message--
>Jono
>Any error message?
>
|||No, just hangs.
>--Original Message--
>Jono
>Any error message?
>
I can connect to a server with Query Analyzer but not with
Enterprise manager (from a lot of clients so problem is
not client based). I used to be able to connect using
both, then all of a sudden it stopped. I rebooted the
server and Enterprise Manager connectivity worked for a
few hours and then stopped again (QA access still works!).
Can anyone think of any reason why this may be so?
Thanks
Jono
Jono
Any error message?
"Jono" <anonymous@.discussions.microsoft.com> wrote in message
news:ad9901c488df$5d5c9690$a501280a@.phx.gbl...
> Hi All
> I can connect to a server with Query Analyzer but not with
> Enterprise manager (from a lot of clients so problem is
> not client based). I used to be able to connect using
> both, then all of a sudden it stopped. I rebooted the
> server and Enterprise Manager connectivity worked for a
> few hours and then stopped again (QA access still works!).
> Can anyone think of any reason why this may be so?
> Thanks
> Jono
|||No, just hangs.
>--Original Message--
>Jono
>Any error message?
>
|||No, just hangs.
>--Original Message--
>Jono
>Any error message?
>
Cannot connect with Enterprise Manager
Hi All
I can connect to a server with Query Analyzer but not with
Enterprise manager (from a lot of clients so problem is
not client based). I used to be able to connect using
both, then all of a sudden it stopped. I rebooted the
server and Enterprise Manager connectivity worked for a
few hours and then stopped again (QA access still works!).
Can anyone think of any reason why this may be so?
Thanks
JonoJono
Any error message?
"Jono" <anonymous@.discussions.microsoft.com> wrote in message
news:ad9901c488df$5d5c9690$a501280a@.phx.gbl...
> Hi All
> I can connect to a server with Query Analyzer but not with
> Enterprise manager (from a lot of clients so problem is
> not client based). I used to be able to connect using
> both, then all of a sudden it stopped. I rebooted the
> server and Enterprise Manager connectivity worked for a
> few hours and then stopped again (QA access still works!).
> Can anyone think of any reason why this may be so?
> Thanks
> Jono|||No, just hangs.
>--Original Message--
>Jono
>Any error message?
>|||No, just hangs.
>--Original Message--
>Jono
>Any error message?
>
I can connect to a server with Query Analyzer but not with
Enterprise manager (from a lot of clients so problem is
not client based). I used to be able to connect using
both, then all of a sudden it stopped. I rebooted the
server and Enterprise Manager connectivity worked for a
few hours and then stopped again (QA access still works!).
Can anyone think of any reason why this may be so?
Thanks
JonoJono
Any error message?
"Jono" <anonymous@.discussions.microsoft.com> wrote in message
news:ad9901c488df$5d5c9690$a501280a@.phx.gbl...
> Hi All
> I can connect to a server with Query Analyzer but not with
> Enterprise manager (from a lot of clients so problem is
> not client based). I used to be able to connect using
> both, then all of a sudden it stopped. I rebooted the
> server and Enterprise Manager connectivity worked for a
> few hours and then stopped again (QA access still works!).
> Can anyone think of any reason why this may be so?
> Thanks
> Jono|||No, just hangs.
>--Original Message--
>Jono
>Any error message?
>|||No, just hangs.
>--Original Message--
>Jono
>Any error message?
>
Cannot connect with Enterprise Manager
Hi All
I can connect to a server with Query Analyzer but not with
Enterprise manager (from a lot of clients so problem is
not client based). I used to be able to connect using
both, then all of a sudden it stopped. I rebooted the
server and Enterprise Manager connectivity worked for a
few hours and then stopped again (QA access still works!).
Can anyone think of any reason why this may be so?
Thanks
JonoJono
Any error message?
"Jono" <anonymous@.discussions.microsoft.com> wrote in message
news:ad9901c488df$5d5c9690$a501280a@.phx.gbl...
> Hi All
> I can connect to a server with Query Analyzer but not with
> Enterprise manager (from a lot of clients so problem is
> not client based). I used to be able to connect using
> both, then all of a sudden it stopped. I rebooted the
> server and Enterprise Manager connectivity worked for a
> few hours and then stopped again (QA access still works!).
> Can anyone think of any reason why this may be so?
> Thanks
> Jono|||No, just hangs.
>--Original Message--
>Jono
>Any error message?
>|||No, just hangs.
>--Original Message--
>Jono
>Any error message?
>
I can connect to a server with Query Analyzer but not with
Enterprise manager (from a lot of clients so problem is
not client based). I used to be able to connect using
both, then all of a sudden it stopped. I rebooted the
server and Enterprise Manager connectivity worked for a
few hours and then stopped again (QA access still works!).
Can anyone think of any reason why this may be so?
Thanks
JonoJono
Any error message?
"Jono" <anonymous@.discussions.microsoft.com> wrote in message
news:ad9901c488df$5d5c9690$a501280a@.phx.gbl...
> Hi All
> I can connect to a server with Query Analyzer but not with
> Enterprise manager (from a lot of clients so problem is
> not client based). I used to be able to connect using
> both, then all of a sudden it stopped. I rebooted the
> server and Enterprise Manager connectivity worked for a
> few hours and then stopped again (QA access still works!).
> Can anyone think of any reason why this may be so?
> Thanks
> Jono|||No, just hangs.
>--Original Message--
>Jono
>Any error message?
>|||No, just hangs.
>--Original Message--
>Jono
>Any error message?
>
Sunday, February 19, 2012
Cannot connect to SQL Server
I have almost the same problem than Clive (cf 18/07). I have 2 servers S1,
S2 (windows XP Pro, SP2), and 2 clients C1 and C2 (Windows XP Pro, SP2).
The two servers are indentical, but if the two clients can connect S1, they
cant' connect to S2 ""Access denied or SQL Server does not exist" (but S2
can connect S1).
- I have checked the Server Network Utility and ClientNetwork Utility : all
is correct
- I have tried with the firewall unactivated : no change...
- The version of SQL 2000 on the two servers are the same.
- The network is a wire LAN.
Can anyone tell me where else to look or what else to try?
Many thanks in advance
Henri (Paris)
So you can connect:
C1 -> S1
C2 -> S1
S2 -> S1
but cannot connect:
C1 -> S2
C2 -> S2
Some things to check:
Can you connect from S2 to S2? If this fails, I suspect the SQL Server is
not started, or you have the name wrong because it's a named instance such
as S2\MSDN, or it is not accepting any connections on the protocol you are
using.
If you can connect from S2 to S2, then I would double-check the firewall. I
see that you said you tried turning off the firewall, but the Windows
firewall that is turned on in SP2 causes most of these problems.
What protocol are you using? If TCP/IP, try connecting using the TCP address
and port number, such as 120.24.118.17,1433. It's possible you have a
problem resolving the computer name. That would cause this error.
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Henri" <foucauld@.wanadoo.fr> wrote in message
news:%23ZoxT3gyHHA.1188@.TK2MSFTNGP04.phx.gbl...
>I have almost the same problem than Clive (cf 18/07). I have 2 servers S1,
>S2 (windows XP Pro, SP2), and 2 clients C1 and C2 (Windows XP Pro, SP2).
> The two servers are indentical, but if the two clients can connect S1,
> they cant' connect to S2 ""Access denied or SQL Server does not exist"
> (but S2 can connect S1).
> - I have checked the Server Network Utility and ClientNetwork Utility :
> all is correct
> - I have tried with the firewall unactivated : no change...
> - The version of SQL 2000 on the two servers are the same.
> - The network is a wire LAN.
> Can anyone tell me where else to look or what else to try?
> Many thanks in advance
> Henri (Paris)
>
|||Is the Browser service running on S2?
Did you see the whitepaper on my blog?
http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
www.hitchhikerguides.net
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)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Henri" <foucauld@.wanadoo.fr> wrote in message
news:%23ZoxT3gyHHA.1188@.TK2MSFTNGP04.phx.gbl...
>I have almost the same problem than Clive (cf 18/07). I have 2 servers S1,
>S2 (windows XP Pro, SP2), and 2 clients C1 and C2 (Windows XP Pro, SP2).
> The two servers are indentical, but if the two clients can connect S1,
> they cant' connect to S2 ""Access denied or SQL Server does not exist"
> (but S2 can connect S1).
> - I have checked the Server Network Utility and ClientNetwork Utility :
> all is correct
> - I have tried with the firewall unactivated : no change...
> - The version of SQL 2000 on the two servers are the same.
> - The network is a wire LAN.
> Can anyone tell me where else to look or what else to try?
> Many thanks in advance
> Henri (Paris)
>
|||Is the SQL Browser service running on S2?
Did you read
http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html ?
hth
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
www.hitchhikerguides.net
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)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Rick Byham, (MSFT)" <rickbyh@.REDMOND.CORP.MICROSOFT.COM> wrote in message
news:7F6297AB-2D3D-41FF-932D-A0971C0188F4@.microsoft.com...
> So you can connect:
> C1 -> S1
> C2 -> S1
> S2 -> S1
> but cannot connect:
> C1 -> S2
> C2 -> S2
> Some things to check:
> Can you connect from S2 to S2? If this fails, I suspect the SQL Server is
> not started, or you have the name wrong because it's a named instance such
> as S2\MSDN, or it is not accepting any connections on the protocol you are
> using.
> If you can connect from S2 to S2, then I would double-check the firewall.
> I see that you said you tried turning off the firewall, but the Windows
> firewall that is turned on in SP2 causes most of these problems.
> What protocol are you using? If TCP/IP, try connecting using the TCP
> address and port number, such as 120.24.118.17,1433. It's possible you
> have a problem resolving the computer name. That would cause this error.
> --
> Rick Byham (MSFT)
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Henri" <foucauld@.wanadoo.fr> wrote in message
> news:%23ZoxT3gyHHA.1188@.TK2MSFTNGP04.phx.gbl...
>
S2 (windows XP Pro, SP2), and 2 clients C1 and C2 (Windows XP Pro, SP2).
The two servers are indentical, but if the two clients can connect S1, they
cant' connect to S2 ""Access denied or SQL Server does not exist" (but S2
can connect S1).
- I have checked the Server Network Utility and ClientNetwork Utility : all
is correct
- I have tried with the firewall unactivated : no change...
- The version of SQL 2000 on the two servers are the same.
- The network is a wire LAN.
Can anyone tell me where else to look or what else to try?
Many thanks in advance
Henri (Paris)
So you can connect:
C1 -> S1
C2 -> S1
S2 -> S1
but cannot connect:
C1 -> S2
C2 -> S2
Some things to check:
Can you connect from S2 to S2? If this fails, I suspect the SQL Server is
not started, or you have the name wrong because it's a named instance such
as S2\MSDN, or it is not accepting any connections on the protocol you are
using.
If you can connect from S2 to S2, then I would double-check the firewall. I
see that you said you tried turning off the firewall, but the Windows
firewall that is turned on in SP2 causes most of these problems.
What protocol are you using? If TCP/IP, try connecting using the TCP address
and port number, such as 120.24.118.17,1433. It's possible you have a
problem resolving the computer name. That would cause this error.
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Henri" <foucauld@.wanadoo.fr> wrote in message
news:%23ZoxT3gyHHA.1188@.TK2MSFTNGP04.phx.gbl...
>I have almost the same problem than Clive (cf 18/07). I have 2 servers S1,
>S2 (windows XP Pro, SP2), and 2 clients C1 and C2 (Windows XP Pro, SP2).
> The two servers are indentical, but if the two clients can connect S1,
> they cant' connect to S2 ""Access denied or SQL Server does not exist"
> (but S2 can connect S1).
> - I have checked the Server Network Utility and ClientNetwork Utility :
> all is correct
> - I have tried with the firewall unactivated : no change...
> - The version of SQL 2000 on the two servers are the same.
> - The network is a wire LAN.
> Can anyone tell me where else to look or what else to try?
> Many thanks in advance
> Henri (Paris)
>
|||Is the Browser service running on S2?
Did you see the whitepaper on my blog?
http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
www.hitchhikerguides.net
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)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Henri" <foucauld@.wanadoo.fr> wrote in message
news:%23ZoxT3gyHHA.1188@.TK2MSFTNGP04.phx.gbl...
>I have almost the same problem than Clive (cf 18/07). I have 2 servers S1,
>S2 (windows XP Pro, SP2), and 2 clients C1 and C2 (Windows XP Pro, SP2).
> The two servers are indentical, but if the two clients can connect S1,
> they cant' connect to S2 ""Access denied or SQL Server does not exist"
> (but S2 can connect S1).
> - I have checked the Server Network Utility and ClientNetwork Utility :
> all is correct
> - I have tried with the firewall unactivated : no change...
> - The version of SQL 2000 on the two servers are the same.
> - The network is a wire LAN.
> Can anyone tell me where else to look or what else to try?
> Many thanks in advance
> Henri (Paris)
>
|||Is the SQL Browser service running on S2?
Did you read
http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html ?
hth
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
www.hitchhikerguides.net
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)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Rick Byham, (MSFT)" <rickbyh@.REDMOND.CORP.MICROSOFT.COM> wrote in message
news:7F6297AB-2D3D-41FF-932D-A0971C0188F4@.microsoft.com...
> So you can connect:
> C1 -> S1
> C2 -> S1
> S2 -> S1
> but cannot connect:
> C1 -> S2
> C2 -> S2
> Some things to check:
> Can you connect from S2 to S2? If this fails, I suspect the SQL Server is
> not started, or you have the name wrong because it's a named instance such
> as S2\MSDN, or it is not accepting any connections on the protocol you are
> using.
> If you can connect from S2 to S2, then I would double-check the firewall.
> I see that you said you tried turning off the firewall, but the Windows
> firewall that is turned on in SP2 causes most of these problems.
> What protocol are you using? If TCP/IP, try connecting using the TCP
> address and port number, such as 120.24.118.17,1433. It's possible you
> have a problem resolving the computer name. That would cause this error.
> --
> Rick Byham (MSFT)
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Henri" <foucauld@.wanadoo.fr> wrote in message
> news:%23ZoxT3gyHHA.1188@.TK2MSFTNGP04.phx.gbl...
>
Cannot connect to SQL Server
I have almost the same problem than Clive (cf 18/07). I have 2 servers S1,
S2 (windows XP Pro, SP2), and 2 clients C1 and C2 (Windows XP Pro, SP2).
The two servers are indentical, but if the two clients can connect S1, they
cant' connect to S2 ""Access denied or SQL Server does not exist" (but S2
can connect S1).
- I have checked the Server Network Utility and ClientNetwork Utility : all
is correct
- I have tried with the firewall unactivated : no change...
- The version of SQL 2000 on the two servers are the same.
- The network is a wire LAN.
Can anyone tell me where else to look or what else to try?
Many thanks in advance
Henri (Paris)So you can connect:
C1 -> S1
C2 -> S1
S2 -> S1
but cannot connect:
C1 -> S2
C2 -> S2
Some things to check:
Can you connect from S2 to S2? If this fails, I suspect the SQL Server is
not started, or you have the name wrong because it's a named instance such
as S2\MSDN, or it is not accepting any connections on the protocol you are
using.
If you can connect from S2 to S2, then I would double-check the firewall. I
see that you said you tried turning off the firewall, but the Windows
firewall that is turned on in SP2 causes most of these problems.
What protocol are you using? If TCP/IP, try connecting using the TCP address
and port number, such as 120.24.118.17,1433. It's possible you have a
problem resolving the computer name. That would cause this error.
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Henri" <foucauld@.wanadoo.fr> wrote in message
news:%23ZoxT3gyHHA.1188@.TK2MSFTNGP04.phx.gbl...
>I have almost the same problem than Clive (cf 18/07). I have 2 servers S1,
>S2 (windows XP Pro, SP2), and 2 clients C1 and C2 (Windows XP Pro, SP2).
> The two servers are indentical, but if the two clients can connect S1,
> they cant' connect to S2 ""Access denied or SQL Server does not exist"
> (but S2 can connect S1).
> - I have checked the Server Network Utility and ClientNetwork Utility :
> all is correct
> - I have tried with the firewall unactivated : no change...
> - The version of SQL 2000 on the two servers are the same.
> - The network is a wire LAN.
> Can anyone tell me where else to look or what else to try?
> Many thanks in advance
> Henri (Paris)
>|||Is the Browser service running on S2?
Did you see the whitepaper on my blog?
http://betav.com/blog/billva/2006/0..._connected.html
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
www.hitchhikerguides.net
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)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"Henri" <foucauld@.wanadoo.fr> wrote in message
news:%23ZoxT3gyHHA.1188@.TK2MSFTNGP04.phx.gbl...
>I have almost the same problem than Clive (cf 18/07). I have 2 servers S1,
>S2 (windows XP Pro, SP2), and 2 clients C1 and C2 (Windows XP Pro, SP2).
> The two servers are indentical, but if the two clients can connect S1,
> they cant' connect to S2 ""Access denied or SQL Server does not exist"
> (but S2 can connect S1).
> - I have checked the Server Network Utility and ClientNetwork Utility :
> all is correct
> - I have tried with the firewall unactivated : no change...
> - The version of SQL 2000 on the two servers are the same.
> - The network is a wire LAN.
> Can anyone tell me where else to look or what else to try?
> Many thanks in advance
> Henri (Paris)
>|||Is the SQL Browser service running on S2?
Did you read
http://betav.com/blog/billva/2006/0..._connected.html ?
hth
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
www.hitchhikerguides.net
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)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"Rick Byham, (MSFT)" <rickbyh@.REDMOND.CORP.MICROSOFT.COM> wrote in message
news:7F6297AB-2D3D-41FF-932D-A0971C0188F4@.microsoft.com...
> So you can connect:
> C1 -> S1
> C2 -> S1
> S2 -> S1
> but cannot connect:
> C1 -> S2
> C2 -> S2
> Some things to check:
> Can you connect from S2 to S2? If this fails, I suspect the SQL Server is
> not started, or you have the name wrong because it's a named instance such
> as S2\MSDN, or it is not accepting any connections on the protocol you are
> using.
> If you can connect from S2 to S2, then I would double-check the firewall.
> I see that you said you tried turning off the firewall, but the Windows
> firewall that is turned on in SP2 causes most of these problems.
> What protocol are you using? If TCP/IP, try connecting using the TCP
> address and port number, such as 120.24.118.17,1433. It's possible you
> have a problem resolving the computer name. That would cause this error.
> --
> Rick Byham (MSFT)
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Henri" <foucauld@.wanadoo.fr> wrote in message
> news:%23ZoxT3gyHHA.1188@.TK2MSFTNGP04.phx.gbl...
>
S2 (windows XP Pro, SP2), and 2 clients C1 and C2 (Windows XP Pro, SP2).
The two servers are indentical, but if the two clients can connect S1, they
cant' connect to S2 ""Access denied or SQL Server does not exist" (but S2
can connect S1).
- I have checked the Server Network Utility and ClientNetwork Utility : all
is correct
- I have tried with the firewall unactivated : no change...
- The version of SQL 2000 on the two servers are the same.
- The network is a wire LAN.
Can anyone tell me where else to look or what else to try?
Many thanks in advance
Henri (Paris)So you can connect:
C1 -> S1
C2 -> S1
S2 -> S1
but cannot connect:
C1 -> S2
C2 -> S2
Some things to check:
Can you connect from S2 to S2? If this fails, I suspect the SQL Server is
not started, or you have the name wrong because it's a named instance such
as S2\MSDN, or it is not accepting any connections on the protocol you are
using.
If you can connect from S2 to S2, then I would double-check the firewall. I
see that you said you tried turning off the firewall, but the Windows
firewall that is turned on in SP2 causes most of these problems.
What protocol are you using? If TCP/IP, try connecting using the TCP address
and port number, such as 120.24.118.17,1433. It's possible you have a
problem resolving the computer name. That would cause this error.
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Henri" <foucauld@.wanadoo.fr> wrote in message
news:%23ZoxT3gyHHA.1188@.TK2MSFTNGP04.phx.gbl...
>I have almost the same problem than Clive (cf 18/07). I have 2 servers S1,
>S2 (windows XP Pro, SP2), and 2 clients C1 and C2 (Windows XP Pro, SP2).
> The two servers are indentical, but if the two clients can connect S1,
> they cant' connect to S2 ""Access denied or SQL Server does not exist"
> (but S2 can connect S1).
> - I have checked the Server Network Utility and ClientNetwork Utility :
> all is correct
> - I have tried with the firewall unactivated : no change...
> - The version of SQL 2000 on the two servers are the same.
> - The network is a wire LAN.
> Can anyone tell me where else to look or what else to try?
> Many thanks in advance
> Henri (Paris)
>|||Is the Browser service running on S2?
Did you see the whitepaper on my blog?
http://betav.com/blog/billva/2006/0..._connected.html
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
www.hitchhikerguides.net
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)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"Henri" <foucauld@.wanadoo.fr> wrote in message
news:%23ZoxT3gyHHA.1188@.TK2MSFTNGP04.phx.gbl...
>I have almost the same problem than Clive (cf 18/07). I have 2 servers S1,
>S2 (windows XP Pro, SP2), and 2 clients C1 and C2 (Windows XP Pro, SP2).
> The two servers are indentical, but if the two clients can connect S1,
> they cant' connect to S2 ""Access denied or SQL Server does not exist"
> (but S2 can connect S1).
> - I have checked the Server Network Utility and ClientNetwork Utility :
> all is correct
> - I have tried with the firewall unactivated : no change...
> - The version of SQL 2000 on the two servers are the same.
> - The network is a wire LAN.
> Can anyone tell me where else to look or what else to try?
> Many thanks in advance
> Henri (Paris)
>|||Is the SQL Browser service running on S2?
Did you read
http://betav.com/blog/billva/2006/0..._connected.html ?
hth
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
www.hitchhikerguides.net
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)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"Rick Byham, (MSFT)" <rickbyh@.REDMOND.CORP.MICROSOFT.COM> wrote in message
news:7F6297AB-2D3D-41FF-932D-A0971C0188F4@.microsoft.com...
> So you can connect:
> C1 -> S1
> C2 -> S1
> S2 -> S1
> but cannot connect:
> C1 -> S2
> C2 -> S2
> Some things to check:
> Can you connect from S2 to S2? If this fails, I suspect the SQL Server is
> not started, or you have the name wrong because it's a named instance such
> as S2\MSDN, or it is not accepting any connections on the protocol you are
> using.
> If you can connect from S2 to S2, then I would double-check the firewall.
> I see that you said you tried turning off the firewall, but the Windows
> firewall that is turned on in SP2 causes most of these problems.
> What protocol are you using? If TCP/IP, try connecting using the TCP
> address and port number, such as 120.24.118.17,1433. It's possible you
> have a problem resolving the computer name. That would cause this error.
> --
> Rick Byham (MSFT)
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Henri" <foucauld@.wanadoo.fr> wrote in message
> news:%23ZoxT3gyHHA.1188@.TK2MSFTNGP04.phx.gbl...
>
Sunday, February 12, 2012
Cannot connect to FTP Site (Merge replication)
Hi;
We have mulitple clients (subscribers) with MSDE SP3. All but one subsriber
are able to retrieve the subscription and replication. The error message on
the failing subscriber is "The computer is disconnected from the network".
The computer runs XP Pro like most of the others and is connected via a VPN
like the others.
The schema script '' could not be propagated to the subscriber.
(Source: Merge Replication Provider (Agent); Error number: -2147201001)
The process could not connect to FTP site 'PL000' using port 21.
(Source: lachlan (Agent); Error number: 0)
The computer is disconnected from the network
(Source: (OS); Error number: 12163)
Any ideas what can cause this? The subscriber that fails was infected with a
virus earlier, but it is now clean the the virus software does not detect
any new or existing virus.
Thomas Born
there are many possibilities
1) the ftp server/site is not active
2) you have specified anonymous only in your ftp server and are trying to
connect using an NT account
3) the ftp server is listening on a different port
4) the snapshot folder does not have read rights for the NT account you are
using or if you are using anonymous authentication to the IUSER_MachineName
account
5) You are using an NT account that does not exist on the machine hosting
the FTP server.
6) your subscriber is on the deny acccess IP address list
Return to your publisher and confirm that all of the above is correctly set
up
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Thomas Born" <tborn_news@.hotmail.com> wrote in message
news:u2gIGJYZEHA.3564@.TK2MSFTNGP11.phx.gbl...
> Hi;
> We have mulitple clients (subscribers) with MSDE SP3. All but one
subsriber
> are able to retrieve the subscription and replication. The error message
on
> the failing subscriber is "The computer is disconnected from the network".
> The computer runs XP Pro like most of the others and is connected via a
VPN
> like the others.
>
> The schema script '' could not be propagated to the subscriber.
> (Source: Merge Replication Provider (Agent); Error number: -2147201001)
> ----
--
> --
> The process could not connect to FTP site 'PL000' using port 21.
> (Source: lachlan (Agent); Error number: 0)
> ----
--
> --
> The computer is disconnected from the network
> (Source: (OS); Error number: 12163)
> ----
--
> --
> Any ideas what can cause this? The subscriber that fails was infected with
a
> virus earlier, but it is now clean the the virus software does not detect
> any new or existing virus.
> Thomas Born
>
|||Thanks for the respone,
I am using anonymous authentication from all the other subscribers as well
and they are working. Also very sure that the server listens on 21. Need to
check 6) but I don't think it is a problem.
I have tested it with having two different machines as the subscriber on my
network at home. One is working and the other one gets the computer
disconnected message. I am getting close to reinstall the operating system
on the failing subscriber, will see if that fixes the problem.
Thomas
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:OFyXETaZEHA.3012@.tk2msftngp13.phx.gbl...
> there are many possibilities
> 1) the ftp server/site is not active
> 2) you have specified anonymous only in your ftp server and are trying to
> connect using an NT account
> 3) the ftp server is listening on a different port
> 4) the snapshot folder does not have read rights for the NT account you
are
> using or if you are using anonymous authentication to the
IUSER_MachineName
> account
> 5) You are using an NT account that does not exist on the machine hosting
> the FTP server.
> 6) your subscriber is on the deny acccess IP address list
> Return to your publisher and confirm that all of the above is correctly
set[vbcol=seagreen]
> up
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Thomas Born" <tborn_news@.hotmail.com> wrote in message
> news:u2gIGJYZEHA.3564@.TK2MSFTNGP11.phx.gbl...
> subsriber
> on
network".[vbcol=seagreen]
> VPN
> ----
> --
> ----
> --
> ----
> --
with[vbcol=seagreen]
> a
detect
>
|||Re-installing the operating system to fix ftp is radical.
Can you open up IE, and in the address bar connect to the ftp site on the
publisher. What do the ftp logs on the publisher reveal?
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Thomas Born" <tborn_news@.hotmail.com> wrote in message
news:eWZ00$%23ZEHA.3708@.TK2MSFTNGP10.phx.gbl...
> Thanks for the respone,
> I am using anonymous authentication from all the other subscribers as well
> and they are working. Also very sure that the server listens on 21. Need
to
> check 6) but I don't think it is a problem.
> I have tested it with having two different machines as the subscriber on
my[vbcol=seagreen]
> network at home. One is working and the other one gets the computer
> disconnected message. I am getting close to reinstall the operating system
> on the failing subscriber, will see if that fixes the problem.
> Thomas
> "Hilary Cotter" <hilaryk@.att.net> wrote in message
> news:OFyXETaZEHA.3012@.tk2msftngp13.phx.gbl...
to[vbcol=seagreen]
> are
> IUSER_MachineName
hosting[vbcol=seagreen]
> set
message[vbcol=seagreen]
> network".
a[vbcol=seagreen]
number: -2147201001)
> ----
> ----
> ----
> with
> detect
>
We have mulitple clients (subscribers) with MSDE SP3. All but one subsriber
are able to retrieve the subscription and replication. The error message on
the failing subscriber is "The computer is disconnected from the network".
The computer runs XP Pro like most of the others and is connected via a VPN
like the others.
The schema script '' could not be propagated to the subscriber.
(Source: Merge Replication Provider (Agent); Error number: -2147201001)
The process could not connect to FTP site 'PL000' using port 21.
(Source: lachlan (Agent); Error number: 0)
The computer is disconnected from the network
(Source: (OS); Error number: 12163)
Any ideas what can cause this? The subscriber that fails was infected with a
virus earlier, but it is now clean the the virus software does not detect
any new or existing virus.
Thomas Born
there are many possibilities
1) the ftp server/site is not active
2) you have specified anonymous only in your ftp server and are trying to
connect using an NT account
3) the ftp server is listening on a different port
4) the snapshot folder does not have read rights for the NT account you are
using or if you are using anonymous authentication to the IUSER_MachineName
account
5) You are using an NT account that does not exist on the machine hosting
the FTP server.
6) your subscriber is on the deny acccess IP address list
Return to your publisher and confirm that all of the above is correctly set
up
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Thomas Born" <tborn_news@.hotmail.com> wrote in message
news:u2gIGJYZEHA.3564@.TK2MSFTNGP11.phx.gbl...
> Hi;
> We have mulitple clients (subscribers) with MSDE SP3. All but one
subsriber
> are able to retrieve the subscription and replication. The error message
on
> the failing subscriber is "The computer is disconnected from the network".
> The computer runs XP Pro like most of the others and is connected via a
VPN
> like the others.
>
> The schema script '' could not be propagated to the subscriber.
> (Source: Merge Replication Provider (Agent); Error number: -2147201001)
> ----
--
> --
> The process could not connect to FTP site 'PL000' using port 21.
> (Source: lachlan (Agent); Error number: 0)
> ----
--
> --
> The computer is disconnected from the network
> (Source: (OS); Error number: 12163)
> ----
--
> --
> Any ideas what can cause this? The subscriber that fails was infected with
a
> virus earlier, but it is now clean the the virus software does not detect
> any new or existing virus.
> Thomas Born
>
|||Thanks for the respone,
I am using anonymous authentication from all the other subscribers as well
and they are working. Also very sure that the server listens on 21. Need to
check 6) but I don't think it is a problem.
I have tested it with having two different machines as the subscriber on my
network at home. One is working and the other one gets the computer
disconnected message. I am getting close to reinstall the operating system
on the failing subscriber, will see if that fixes the problem.
Thomas
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:OFyXETaZEHA.3012@.tk2msftngp13.phx.gbl...
> there are many possibilities
> 1) the ftp server/site is not active
> 2) you have specified anonymous only in your ftp server and are trying to
> connect using an NT account
> 3) the ftp server is listening on a different port
> 4) the snapshot folder does not have read rights for the NT account you
are
> using or if you are using anonymous authentication to the
IUSER_MachineName
> account
> 5) You are using an NT account that does not exist on the machine hosting
> the FTP server.
> 6) your subscriber is on the deny acccess IP address list
> Return to your publisher and confirm that all of the above is correctly
set[vbcol=seagreen]
> up
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Thomas Born" <tborn_news@.hotmail.com> wrote in message
> news:u2gIGJYZEHA.3564@.TK2MSFTNGP11.phx.gbl...
> subsriber
> on
network".[vbcol=seagreen]
> VPN
> ----
> --
> ----
> --
> ----
> --
with[vbcol=seagreen]
> a
detect
>
|||Re-installing the operating system to fix ftp is radical.
Can you open up IE, and in the address bar connect to the ftp site on the
publisher. What do the ftp logs on the publisher reveal?
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Thomas Born" <tborn_news@.hotmail.com> wrote in message
news:eWZ00$%23ZEHA.3708@.TK2MSFTNGP10.phx.gbl...
> Thanks for the respone,
> I am using anonymous authentication from all the other subscribers as well
> and they are working. Also very sure that the server listens on 21. Need
to
> check 6) but I don't think it is a problem.
> I have tested it with having two different machines as the subscriber on
my[vbcol=seagreen]
> network at home. One is working and the other one gets the computer
> disconnected message. I am getting close to reinstall the operating system
> on the failing subscriber, will see if that fixes the problem.
> Thomas
> "Hilary Cotter" <hilaryk@.att.net> wrote in message
> news:OFyXETaZEHA.3012@.tk2msftngp13.phx.gbl...
to[vbcol=seagreen]
> are
> IUSER_MachineName
hosting[vbcol=seagreen]
> set
message[vbcol=seagreen]
> network".
a[vbcol=seagreen]
number: -2147201001)
> ----
> ----
> ----
> with
> detect
>
Subscribe to:
Posts (Atom)