Re: SQL Server 2000 linked server problem
- From: v-adamqu@xxxxxxxxxxxxxxxxxxxx (Adams Qu [MSFT])
- Date: Thu, 03 Jan 2008 10:03:04 GMT
Dear Frank,
Thank you for your update.
Yes. If the Kerberos delegation does not work properly, other linked
servers should also be affected. If my understanding is right, your last
reply indicates that there are multi-linked servers created in your
environment but the issue only occurs when involving one specific link
server. If I have any misunderstanding, feel free to let me know.
I understand that you are in the process of moving databases off to a SQL
Server 2005 system. After completing the migration, please check if the
issue can still be reproduced. If you need further assistance, please feel
free to post back and also collect the requested information (MPS report).
I will do more research for you and try to find the root cause for this
problem.
Have a nice day!
Best regards,
Adams Qu
MCSE, MCDBA, MCTS
Microsoft Online Support
Microsoft Global Technical Support Center
Get Secure! - www.microsoft.com/security
=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| From: "frankm" <frankm@xxxxxxxxxxxxxxxx>
| Newsgroups: microsoft.public.sqlserver.connect
| References: <%jRcj.1769$pr6.1313@xxxxxxxxxxxxxxxxxxxx>
<#v9K5rLSIHA.3532@xxxxxxxxxxxxxxxxxxxx>
<v0Tcj.1219$se5.545@xxxxxxxxxxxxxxxxxxxx>
<OXddsaMSIHA.5288@xxxxxxxxxxxxxxxxxxxx>
<0jUcj.1202$6%.1061@xxxxxxxxxxxxxxxxxxxx>
<YbX87eSSIHA.5204@xxxxxxxxxxxxxxxxxxxxxx>
<Wj7dj.35070$Pv2.17450@xxxxxxxxxxxxxxxxxxxxxxxxxx>
<hYmJ424SIHA.5676@xxxxxxxxxxxxxxxxxxxxxx>
| Subject: Re: SQL Server 2000 linked server problem
| Lines: 423
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
| Message-ID: <muMej.2763$se5.664@xxxxxxxxxxxxxxxxxxxx>
| NNTP-Posting-Host: 165.152.63.227
| X-Complaints-To: abuse@xxxxxxxxxxx
| X-Trace: nlpi069.nbdc.sbc.com 1199281170 ST000 165.152.63.227 (Wed, 02
Jan 2008 08:39:30 EST)
| NNTP-Posting-Date: Wed, 02 Jan 2008 08:39:30 EST
| Organization: AT&T http://yahoo.sbc.com
| X-UserInfo1:
[[PA@SVDTRV[RQTYN[O@_WH@YR_B@EXLLBWLOOAF@YUDUWYAKVUOPCW[ML\JXUCKVFDYZKBMSFX^
OMSAFNTINTDDMVW[X\THOPXZRVOCJTUTPC\_JSBVX\KAOTBAJBVMZTYAKMNLDI_MFDSSOLXINH__
FS^\WQGHGI^C@E[A_CF\AQLDQ\BTMPLDFNVUQ_VM
| Date: Wed, 2 Jan 2008 07:39:29 -0600
| Path:
TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS02.phx.gbl!newsfeed0
0.sul.t-online.de!t-online.de!news.glorb.com!newscon02.news.prodigy.net!prod
igy.net!newsdst01.news.prodigy.net!prodigy.com!postmaster.news.prodigy.com!n
lpi069.nbdc.sbc.com.POSTED!e51d285f!not-for-mail
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.connect:1976
| X-Tomcat-NG: microsoft.public.sqlserver.connect
|
| My guess is that if it were Kerberos delegation, that it would be
happening
| on other Linked servers to the same system.
|
| We are in the process of moving databases off to a 2005 system.
| So, I was looking to see if there was something that could be done to
kick
| this one linked server loose.
|
|
| "Adams Qu [MSFT]" <v-adamqu@xxxxxxxxxxxxxxxxxxxx> wrote in message
| news:hYmJ424SIHA.5676@xxxxxxxxxxxxxxxxxxxxxxxxx
| > Dear Frank,
| >
| > Thank you for posting here.
| >
| > If the issue just occurs intermittently, the following factors may be
the
| > possible causes:
| >
| > 1. Temporarily network connection problem has been experienced.
| > 2. The delegated Kerberos authentication does not work stably.
| >
| > To do the troubleshooting, we may need to collect some information to
| > identify which cause this temporary connection problem. Before
collecting
| > this information, it is recommended that you apply the latest service
pack
| > of SQL Server 2000 (SP4) to fix some known bugs on the SQL Server side.
| > Please refer to the following KB article:
| >
| > 290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
| > http://support.microsoft.com/?id=290211
| >
| > IMPORTANT: Please ensure that you have done the Database Backup in avoid
| > any potential problem before upgrading to SP4,
| >
| > Please help us to collect the following information:
| >
| > I. SQL MPS Report
| > --------------------
| > When the issue occurs on the client side, please help create a
MPSReport
| > on
| > the both two SQL Server instances (local and linked server), which will
| > collect ERRORLOG, Windows event log and other helpful information about
| > the
| > SQL Server. To create a MPSReport, please visit the following web site:
| >
| >
http://www.microsoft.com/downloads/details.aspx?FamilyId=CEBF3C7C-7CA5-408F-
| > 88B7-F9C79B7306C0&displaylang=en
| >
| > And look for MPSRPT_SQL.EXE. Download it and run it on the machine.
| > Dismiss
| > the prompted dialog boxes and the readme window (usually a Notepad)
after
| > you read them. After the Command Prompt window closes itself, collect
the
| > cab file the tool has generated and sent it to me at
| > v-adamqu@xxxxxxxxxxxxx
| >
| > II.
| > --------------------
| > Please also let me know the extract time when the issue occurs so that
we
| > can check the entries in the MPS Report accordingly.
| >
| > Thank you for your cooperation.
| >
| > Have a nice day!
| >
| > Best regards,
| >
| > Adams Qu
| > MCSE, MCDBA, MCTS
| > Microsoft Online Support
| >
| > Microsoft Global Technical Support Center
| >
| > Get Secure! - www.microsoft.com/security
| > =====================================================
| > When responding to posts, please "Reply to Group" via your newsreader so
| > that others may learn and benefit from your issue.
| > =====================================================
| > This posting is provided "AS IS" with no warranties, and confers no
| > rights.
| >
| > --------------------
| > | From: "frankm" <frankm@xxxxxxxxxxxxxxxx>
| > | Newsgroups: microsoft.public.sqlserver.connect
| > | References: <%jRcj.1769$pr6.1313@xxxxxxxxxxxxxxxxxxxx>
| > <#v9K5rLSIHA.3532@xxxxxxxxxxxxxxxxxxxx>
| > <v0Tcj.1219$se5.545@xxxxxxxxxxxxxxxxxxxx>
| > <OXddsaMSIHA.5288@xxxxxxxxxxxxxxxxxxxx>
| > <0jUcj.1202$6%.1061@xxxxxxxxxxxxxxxxxxxx>
| > <YbX87eSSIHA.5204@xxxxxxxxxxxxxxxxxxxxxx>
| > | Subject: Re: SQL Server 2000 linked server problem
| > | Lines: 257
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
| > | X-RFC2646: Format=Flowed; Original
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
| > | Message-ID: <Wj7dj.35070$Pv2.17450@xxxxxxxxxxxxxxxxxxxxxxxxxx>
| > | NNTP-Posting-Host: 165.152.63.227
| > | X-Complaints-To: abuse@xxxxxxxxxxx
| > | X-Trace: newssvr23.news.prodigy.net 1198850422 ST000 165.152.63.227
| > (Fri,
| > 28 Dec 2007 09:00:22 EST)
| > | NNTP-Posting-Date: Fri, 28 Dec 2007 09:00:22 EST
| > | Organization: AT&T http://yahoo.sbc.com
| > | X-UserInfo1:
| >
OHZQB_WEZZWSP_@YMZJ\_Q\@TJ_ZTB\MV@BJ]Q]KEYUNDQUCCNSUAACY@L[ZX__HGFD]JBJNSFXT
| >
OOGA_VWY^_HG@FW_HUTHOH]TBPGCO\P^PLP^@[GLHUK@WLECKFVL^TYG[@RMWQXIWM[SDDYWNLG_
| > G[_BWUCHFY_Y@AS@Q[B\APPF@DCZM_PG_VSCPQZM
| > | Date: Fri, 28 Dec 2007 08:00:21 -0600
| > | Path:
| >
TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS02.phx.gbl!tornado.f
| >
astwebnet.it!tiscali!newsfeed1.ip.tiscali.net!newshub.sdsu.edu!newscon04.new
| >
s.prodigy.net!prodigy.net!newsdst01.news.prodigy.net!prodigy.com!postmaster.
| > news.prodigy.com!newssvr23.news.prodigy.net.POSTED!e51d285f!not-for-mail
| > | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.connect:1951
| > | X-Tomcat-NG: microsoft.public.sqlserver.connect
| > |
| > | 1. Can your client or application connect to linked SQL Server
instance
| > | directly via the required authentication method?
| > | Yes
| > |
| > | 2. If Windows Firewall or other third party firewall is used, please
| > also
| > | make sure that your Remote Procedure Call (RPC) port (135) and MSDTC
| > | "C:\Windows\System32\Msdtc.exe" has been added into the exception
list.
| > | Yes
| > |
| > |
| > | An an FYI - this happenes intermittantly and a reboot fixes it.
| > |
| > |
| > |
| > |
| > | "Adams Qu [MSFT]" <v-adamqu@xxxxxxxxxxxxxxxxxxxx> wrote in message
| > | news:YbX87eSSIHA.5204@xxxxxxxxxxxxxxxxxxxxxxxxx
| > | > Dear Frank,
| > | >
| > | > Thank you for posting here.
| > | >
| > | > Based on our experience, if we are able to connect the linked server
| > | > successfully on the SQL Server itself but fails to connect from the
| > remote
| > | > client, the most common cause of this behavior is the delegation
| > problem.
| > | >
| > | > Before going further, I recommend that you refer to this article and
| > check
| > | > if the requirements for your client, the first SQL Server (most
| > important)
| > | > and the second SQL Server (linked server) are satisfied:
| > | >
| > | > Configuring Linked Servers for Delegation
| > | > http://msdn2.microsoft.com/en-us/library/ms189580.aspx
| > | >
| > | > Apart from checking the delegation configuration, we also recommend
| > that
| > | > you check and let me know the following conditions for further
| > research:
| > | >
| > | > 1. Can your client or application connect to linked SQL Server
| > instance
| > | > directly via the required authentication method?
| > | > 2. If Windows Firewall or other third party firewall is used, please
| > also
| > | > make sure that your Remote Procedure Call (RPC) port (135) and MSDTC
| > | > "C:\Windows\System32\Msdtc.exe" has been added into the exception
| > list.
| > | >
| > | > You may also want to apply the latest service pack of SQL Server
2000.
| > | > Please refer to the following articles.
| > | >
| > | > 290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
| > | > http://support.microsoft.com/?id=290211
| > | >
| > | > If the issue persists, please help us to collect the following
| > | > information:
| > | >
| > | > SQL MPS Report
| > | > ========================================
| > | > Please help create a MPSReport on the both two SQL Server instances
| > (local
| > | > and linked server), which will collect ERRORLOG, Windows event log
and
| > | > other helpful information about the SQL Server. To create a
MPSReport,
| > | > please visit the following web site:
| > | >
| >
http://www.microsoft.com/downloads/details.aspx?FamilyId=CEBF3C7C-7CA5-408F-
| > | > 88B7-F9C79B7306C0&displaylang=en
| > | >
| > | > And look for MPSRPT_SQL.EXE. Download it and run it on the machine.
| > | > Dismiss
| > | > the prompted dialog boxes and the readme window (usually a Notepad)
| > after
| > | > you read them. After the Command Prompt window closes itself,
collect
| > the
| > | > cab file the tool has generated and sent it to me at
| > | > v-adamqu@xxxxxxxxxxxxx
| > | >
| > | > Reference
| > | > ----------------------------------
| > | > For your information, the error message "SQL Server does not exist
or
| > | > access denied" can be commonly caused by one of the following
factors:
| > | >
| > | > o That the logon process to SQL Server failed.
| > | > o That SQL Server does not have the correct permissions to process
the
| > | > query.
| > | > o That you cannot use SQL Server authentication because only Windows
| > | > authentication is permitted
| > | >
| > | > Below is related KB article
| > | >
| > | > Potential causes of the "SQL Server does not exist or access denied"
| > error
| > | > message
| > | > http://support.microsoft.com/kb/328306/
| > | >
| > | > NOTE: If the issue is urgent to your business, it is recommended
that
| > you
| > | > contact Microsoft Customer Service and Support (CSS) via telephone
so
| > that
| > | > a dedicated Support Professional can assist you in resolving the
issue
| > in
| > | > a
| > | > more efficient manner. Please be advised that contacting phone
support
| > | > will
| > | > be a charged call.
| > | >
| > | > To obtain the phone numbers for specific technology request please
| > take
| > a
| > | > look at the web site listed below.
| > | > http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS
| > | >
| > | > Have a nice day!
| > | >
| > | > Best regards,
| > | >
| > | > Adams Qu
| > | > MCSE, MCDBA, MCTS
| > | > Microsoft Online Support
| > | >
| > | > Microsoft Global Technical Support Center
| > | >
| > | > Get Secure! - www.microsoft.com/security
| > | > =====================================================
| > | > When responding to posts, please "Reply to Group" via your
newsreader
| > so
| > | > that others may learn and benefit from your issue.
| > | > =====================================================
| > | > This posting is provided "AS IS" with no warranties, and confers no
| > | > rights.
| > | >
| > | > --------------------
| > | > | From: "frankm" <frankm@xxxxxxxxxxxxxxxx>
| > | > | Newsgroups: microsoft.public.sqlserver.connect
| > | > | References: <%jRcj.1769$pr6.1313@xxxxxxxxxxxxxxxxxxxx>
| > | > <#v9K5rLSIHA.3532@xxxxxxxxxxxxxxxxxxxx>
| > | > <v0Tcj.1219$se5.545@xxxxxxxxxxxxxxxxxxxx>
| > | > <OXddsaMSIHA.5288@xxxxxxxxxxxxxxxxxxxx>
| > | > | Subject: Re: SQL Server 2000 linked server problem
| > | > | Lines: 88
| > | > | X-Priority: 3
| > | > | X-MSMail-Priority: Normal
| > | > | X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
| > | > | X-RFC2646: Format=Flowed; Response
| > | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
| > | > | Message-ID: <0jUcj.1202$6%.1061@xxxxxxxxxxxxxxxxxxxx>
| > | > | NNTP-Posting-Host: 165.152.63.227
| > | > | X-Complaints-To: abuse@xxxxxxxxxxx
| > | > | X-Trace: nlpi061.nbdc.sbc.com 1198788924 ST000 165.152.63.227
(Thu,
| > 27
| > | > Dec 2007 15:55:24 EST)
| > | > | NNTP-Posting-Date: Thu, 27 Dec 2007 15:55:24 EST
| > | > | Organization: AT&T http://yahoo.sbc.com
| > | > | X-UserInfo1:
| > | >
| >
TSU[@IONYJVWBTTXIBCBNWX@RJ_XPDLMN@GZ_GYO^JWTEPIB_NVUAH_[BL[\IRKIANGGJBFNJF_D
| > | >
| >
OLSCENSY^U@FRFUEXR@KFXYDBPWBCDQJA@X_DCBHXR[C@\EOKCJLED_SZ@RMWYXYWE_P@\\GOIW^
| > | > @SYFFSWHFIXMADO@^[ADPRPETLBJ]RDGENSKQQZN
| > | > | Date: Thu, 27 Dec 2007 14:55:25 -0600
| > | > | Path:
| > | >
| >
TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS02.phx.gbl!newsfeed0
| > | >
| >
0.sul.t-online.de!t-online.de!news.glorb.com!newscon02.news.prodigy.net!prod
| > | >
| >
igy.net!newsdst02.news.prodigy.net!prodigy.com!postmaster.news.prodigy.com!n
| > | > lpi061.nbdc.sbc.com.POSTED!e51d285f!not-for-mail
| > | > | Xref: TK2MSFTNGHUB02.phx.gbl
microsoft.public.sqlserver.connect:1949
| > | > | X-Tomcat-NG: microsoft.public.sqlserver.connect
| > | > |
| > | > | It is most likely a RPC service or something like that on the
| > Windows
| > | > side.
| > | > | This isn't a login issue, the Linked Server simply cannot connect.
| > It's
| > | > not
| > | > | authentication based.
| > | > |
| > | > | I'm kinda hoping that someone can tell me which service to
recycle
| > as
| > | > this
| > | > | is a business critical system and getting downtime to rebott is
| > rather
| > | > | dicey.
| > | > |
| > | > | I think I've seen this before, but for the life of me I can
remember
| > if
| > | > | there was a resolution.
| > | > |
| > | > |
| > | > |
| > | > |
| > | > | "Russell Fields" <russellfields@xxxxxxxxxx> wrote in message
| > | > | news:OXddsaMSIHA.5288@xxxxxxxxxxxxxxxxxxxxxxx
| > | > | > frankm,
| > | > | >
| > | > | > Could you describe the security settings on the linked server's
| > | > security
| > | > | > tab?
| > | > | >
| > | > | > If it is "Be made using the login's current security context"
then
| > it
| > | > | > might imply that something broke the delegation chain for the
| > | > double-hop
| > | > | > needed to pass a user's credentials to the next server. When
you
| > are
| > | > | > logged onto the server there is no double-hop since the linked
| > server
| > | > is
| > | > | > only one hop away.
| > | > | >
| > | > | > Does that make sense? In that case, it is not a SQL Server
| > problem,
| > | > but a
| > | > | > Windows or a domain problem. The SQL Server is simply
victimized.
| > | > Since I
| > | > | > am not a domain/network administrator I don't have good insight
| > into
| > | > what
| > | > | > could be wrong, but I am pretty sure that is where the problem
| > lies.
| > | > | >
| > | > | > RLF
| > | > | >
| > | > | >
| > | > | > "frankm" <frankm@xxxxxxxxxxxxxxxx> wrote in message
| > | > | > news:v0Tcj.1219$se5.545@xxxxxxxxxxxxxxxxxxxxxxx
| > | > | >> The error is "SQL Server does not exist or access denied" which
| > means
| > | > it
| > | > | >> cannot connect.
| > | > | >> I know all of it works - it works from EM on the server itself
| > and
| > | > | >> doesn't from any remote client.
| > | > | >> I have tried RPC settings and that does not work.
| > | > | >>
| > | > | >> Apparently this happens "once in a while", and it takes a
reboot
| > to
| > | > fix
| > | > | >> it.
| > | > | >>
| > | > | >>
| > | > | >>
| > | > | >>
| > | > | >>
| > | > | >> "Russell Fields" <russellfields@xxxxxxxxxx> wrote in message
| > | > | >> news:%23v9K5rLSIHA.3532@xxxxxxxxxxxxxxxxxxxxxxx
| > | > | >>> frankm,
| > | > | >>>
| > | > | >>> What error are you getting? That might reveal what the
problem
| > is.
| > | > In
| > | > | >>> general: Check the security tab of the linked server
properties
| > if
| > | > it
| > | > is
| > | > | >>> security context error. You might also check the Server
Options
| > for
| > | > how
| > | > | >>> RPC and RPC OUT are set.
| > | > | >>>
| > | > | >>> Out of curiousily, have their been any changes to your network
| > | > | >>> infrastructure for the purpose of making the network more
| > secure?
| > | > | >>>
| > | > | >>> RLF
| > | > | >>>
| > | > | >>> "frankm" <frankm@xxxxxxxxxxxxxxxx> wrote in message
| > | > | >>> news:%jRcj.1769$pr6.1313@xxxxxxxxxxxxxxxxxxxxxxx
| > | > | >>>> This is SQL Server 2000 sp3a.
| > | > | >>>>
| > | > | >>>> I have linked servers that have been working for a fairly
long
| > | > time.
| > | > | >>>>
| > | > | >>>> If I am on the server (TermSvc), I cann connect and test
| > through
| > | > the
| > | > | >>>> linked server successfully.
| > | > | >>>>
| > | > | >>>> If I am initiating this from any workstation or application
off
| > the
| > | > SQL
| > | > | >>>> Server itself, the linked server connection fails.
| > | > | >>>>
| > | > | >>>> Any ideas???
| > | > | >>>>
| > | > | >>>> frankm
| > | > | >>>>
| > | > | >>>
| > | > | >>>
| > | > | >>
| > | > | >>
| > | > | >
| > | > | >
| > | > |
| > | > |
| > | > |
| > | >
| > |
| > |
| > |
| >
|
|
|
.
- Follow-Ups:
- Re: SQL Server 2000 linked server problem
- From: Adams Qu [MSFT]
- Re: SQL Server 2000 linked server problem
- References:
- Re: SQL Server 2000 linked server problem
- From: frankm
- Re: SQL Server 2000 linked server problem
- Prev by Date: Re: Database connection is disconnected due to "network error"
- Next by Date: Re: Connection to SQL Server 2005 lost
- Previous by thread: Re: SQL Server 2000 linked server problem
- Next by thread: Re: SQL Server 2000 linked server problem
- Index(es):
Relevant Pages
|
Loading
