IIS Index Server - Linked Servers - HELP GEORGE or HILARY

Author

Linked Servers - HELP GEORGE or HILARY

DougWallace

2004-04-14, 2:48 pm

We are adding our Indexing Server to our SQL Server using Linked servers.
Every day it seems to crash. Is there a right way and wrong way to link
servers. Is this the right approch for a high traffic system?

George Cheng [MSFT]

2004-04-14, 2:48 pm

What exactly is crashing? Any errors in the event viewer?

Thank You

George Cheng

Microsoft Application Center & Index Server Support

Note: This article has no warranties implicit or explicit.
All the content is given on the "as is" basis and the user
takes full responsibility for its use and assumption.
Microsoft Corporation Copyright 2004
All Rights Reserved

--------------------
| From: "DougWallace" <doug@agile.net>
| Subject: Linked Servers - HELP GEORGE or HILARY
| Date: Tue, 13 Apr 2004 16:38:04 -0400
| Lines: 5
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <uDfjOhZIEHA.1944@TK2MSFTNGP11.phx.gbl>
| Newsgroups: microsoft.public.inetserver.indexserver
| NNTP-Posting-Host: 67.70.189.2
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.inetserver.indexserver:28276
| X-Tomcat-NG: microsoft.public.inetserver.indexserver
|
| We are adding our Indexing Server to our SQL Server using Linked servers.
| Every day it seems to crash. Is there a right way and wrong way to link
| servers. Is this the right approch for a high traffic system?
|
|
|

DougWallace

2004-04-14, 2:48 pm

What happens is we see this message around the time:

aspnet_wp.exe (PID: 2696) stopped unexpectedly.

We restart IIS and then try to restart SQL Server but it still gives an
error till we reboot.

Thoughts

""George Cheng [MSFT]"" <GCheng@online.microsoft.com> wrote in message
news:Vty4qFaIEHA.3636@cpmsftngxa06.phx.gbl...
> What exactly is crashing? Any errors in the event viewer?
>
> Thank You
>
> George Cheng
>
> Microsoft Application Center & Index Server Support
>
> Note: This article has no warranties implicit or explicit.
> All the content is given on the "as is" basis and the user
> takes full responsibility for its use and assumption.
> Microsoft Corporation Copyright 2004
> All Rights Reserved
>
> --------------------
> | From: "DougWallace" <doug@agile.net>
> | Subject: Linked Servers - HELP GEORGE or HILARY
> | Date: Tue, 13 Apr 2004 16:38:04 -0400
> | Lines: 5
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
> | Message-ID: <uDfjOhZIEHA.1944@TK2MSFTNGP11.phx.gbl>
> | Newsgroups: microsoft.public.inetserver.indexserver
> | NNTP-Posting-Host: 67.70.189.2
> | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
> | Xref: cpmsftngxa06.phx.gbl microsoft.public.inetserver.indexserver:28276
> | X-Tomcat-NG: microsoft.public.inetserver.indexserver
> |
> | We are adding our Indexing Server to our SQL Server using Linked
servers.
> | Every day it seems to crash. Is there a right way and wrong way to link
> | servers. Is this the right approch for a high traffic system?
> |
> |
> |
>

George Cheng [MSFT]

2004-04-14, 2:48 pm

Hilary Cotter

2004-04-14, 2:48 pm

the account you are using to access your linked server must be a dbo in the
master database on the SQL Server. This could be your problem.

""George Cheng [MSFT]"" <GCheng@online.microsoft.com> wrote in message
news:Ttl49TjIEHA.2876@cpmsftngxa06.phx.gbl...
> Not my area of expertise but looks like a access violation in the asp.net
> worker process.
> Might look at the following articles:
>
> 823015, 321564, 326366, 812406, 821387, 823409, 835387.
>
> Thank You
>
> George Cheng
>
> Microsoft Application Center & Index Server Support
>
> Note: This article has no warranties implicit or explicit.
> All the content is given on the "as is" basis and the user
> takes full responsibility for its use and assumption.
> Microsoft Corporation Copyright 2004
> All Rights Reserved
>
> --------------------
> | From: "DougWallace" <doug@agile.net>
> | References: <uDfjOhZIEHA.1944@TK2MSFTNGP11.phx.gbl>
> <Vty4qFaIEHA.3636@cpmsftngxa06.phx.gbl>
> | Subject: Re: Linked Servers - HELP GEORGE or HILARY
> | Date: Wed, 14 Apr 2004 09:51:48 -0400
> | Lines: 54
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
> | Message-ID: <OkR0#iiIEHA.3444@TK2MSFTNGP11.phx.gbl>
> | Newsgroups: microsoft.public.inetserver.indexserver
> | NNTP-Posting-Host: 67.70.189.2
> | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
> | Xref: cpmsftngxa06.phx.gbl microsoft.public.inetserver.indexserver:28288
> | X-Tomcat-NG: microsoft.public.inetserver.indexserver
> |
> | What happens is we see this message around the time:
> |
> | aspnet_wp.exe (PID: 2696) stopped unexpectedly.
> |
> | We restart IIS and then try to restart SQL Server but it still gives an
> | error till we reboot.
> |
> | Thoughts
> |
> |
> |
> |
> | ""George Cheng [MSFT]"" <GCheng@online.microsoft.com> wrote in message
> | news:Vty4qFaIEHA.3636@cpmsftngxa06.phx.gbl...
> | > What exactly is crashing? Any errors in the event viewer?
> | >
> | > Thank You
> | >
> | > George Cheng
> | >
> | > Microsoft Application Center & Index Server Support
> | >
> | > Note: This article has no warranties implicit or explicit.
> | > All the content is given on the "as is" basis and the user
> | > takes full responsibility for its use and assumption.
> | > Microsoft Corporation Copyright 2004
> | > All Rights Reserved
> | >
> | > --------------------
> | > | From: "DougWallace" <doug@agile.net>
> | > | Subject: Linked Servers - HELP GEORGE or HILARY
> | > | Date: Tue, 13 Apr 2004 16:38:04 -0400
> | > | Lines: 5
> | > | X-Priority: 3
> | > | X-MSMail-Priority: Normal
> | > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
> | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
> | > | Message-ID: <uDfjOhZIEHA.1944@TK2MSFTNGP11.phx.gbl>
> | > | Newsgroups: microsoft.public.inetserver.indexserver
> | > | NNTP-Posting-Host: 67.70.189.2
> | > | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
> | > | Xref: cpmsftngxa06.phx.gbl
> microsoft.public.inetserver.indexserver:28276
> | > | X-Tomcat-NG: microsoft.public.inetserver.indexserver
> | > |
> | > | We are adding our Indexing Server to our SQL Server using Linked
> | servers.
> | > | Every day it seems to crash. Is there a right way and wrong way to
> link
> | > | servers. Is this the right approch for a high traffic system?
> | > |
> | > |
> | > |
> | >
> |
> |
> |
>

Joel Aufgang

2004-04-15, 11:34 am

Hi,
I work with Doug, who posted the original question...

I'm a little confused by this response for two reasons:

1. Do you mean the account that sql server is using to connect to
indexing service needs to be a dbo, or do you mean that the login the we are
using to connect to SQL server. We have set the security options on the
linked server to connect to indexing server using the sql login's current
security context, and we are using a sql server login with limited
permissions to connect to sql server from the asp.net web app. which do we
need to change?

2. If this is a login security problem, why is it only showing up once a
day at a particular time? I would expect that if the connection login has
not been set up properly then our app would not be ably to query the linked
indexing service at all. The site can run for 24 hours without a hitch and
then all of a sudden it stops working around the same time every day.

"Hilary Cotter" <hilaryk@att.net> wrote in message
news:e3L$%23VkIEHA.3968@TK2MSFTNGP12.phx.gbl...

> the account you are using to access your linked server must be a dbo in
the
> master database on the SQL Server. This could be your problem.

DougWallace

2004-04-19, 3:37 pm

Can you answewr this George?
"Joel Aufgang" <aufgang@agile.net> wrote in message
news:eT29y9vIEHA.2764@TK2MSFTNGP10.phx.gbl...
> Hi,
> I work with Doug, who posted the original question...
>
> I'm a little confused by this response for two reasons:
>
> 1. Do you mean the account that sql server is using to connect to
> indexing service needs to be a dbo, or do you mean that the login the we
are
> using to connect to SQL server. We have set the security options on the
> linked server to connect to indexing server using the sql login's current
> security context, and we are using a sql server login with limited
> permissions to connect to sql server from the asp.net web app. which do
we
> need to change?
>
> 2. If this is a login security problem, why is it only showing up once
a
> day at a particular time? I would expect that if the connection login has
> not been set up properly then our app would not be ably to query the
linked
> indexing service at all. The site can run for 24 hours without a hitch
and
> then all of a sudden it stops working around the same time every day.
>
>
>
>
>
> "Hilary Cotter" <hilaryk@att.net> wrote in message
> news:e3L$%23VkIEHA.3968@TK2MSFTNGP12.phx.gbl...
>
> the
>
>