Re: Linked Servers - HELP GEORGE or HILARY

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: DougWallace (doug_at_agile.net)
Date: 04/19/04 

Date: Mon, 19 Apr 2004 14:42:07 -0400

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 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.
>
>

Relevant Pages

  • Re: Database security design with ASP.net and form-based authentication
    ... This allows SQL Server to control security from both ... database security context to enable when a user belongs to multiple roles ... the single login approach is best in your situation since you don't ...
    (microsoft.public.sqlserver.security)
  • Re: Security Implementation???
    ... > MSDE, ... > In users node in the db node, only dbo with no login name exists. ... Make the security machine independent, ... running the SQL Server Agent (especially if you are running MSDE sp4 as ...
    (microsoft.public.sqlserver.security)
  • Re: application login , but user security
    ... SQL Server security context is determined by the login used to connect to ... SQL Server or an application role enabled after the connection is made. ... ES_MTO uses a single login, you won't be able to implement a SQL Server ... USERA logins in to the ES-MTO ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Logins vs Windows Authentication
    ... Microsoft recommends using Windows Authentication for security purposes as you avoid using SQL Server Logins because then it would be easier to capture these login info and infiltrate into your SQL Server system. ...
    (microsoft.public.sqlserver.security)
  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)