Re: Linked Server Confusion - I don't know where to start...

Hi Sue,

Thank you very much for your continued help!

Please help me to understand your post.

First, the ODBC driver I'm using is not SQL Server, and there is no
protocol choice. This is a connection to a proprietary database.
There is no way to choose TCP/IP.

Second, the SQL Agent is logging in as the domain administrator
account. I don't know which account I could have it use that would
have more rights than that. I don't understand what you want me to
change it to? The job needs to run as REPL, but that is a SQL Server
account. It is not an NT account. Is there a way to make it both?

I'm open to just about anything at this point!

-Rick

.

Relevant Pages

  • Security context issue (weird behavior)
    ... The SQL Server is setup to use mix mode authentication. ... The users have a domain account. ... To log in to the SQL server I use an ADO connection. ... I tried to view the pages from another machine with the anonymous access ...
    (microsoft.public.data.ado)
  • Re: SQL Connection String using Domain Account
    ... Web.Config but now have the problem that the web site will not run under ... you can have a username/password set up in sql server - but this would ... The DBA has given me a Domain user account with rights to ... I am unable to get a connection to the database. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Passthrough authenication w/ SQL trusted connection
    ... separate connection will be used for each security context (each user ... account will have it's own pool). ... if you are using a Windows 2000 Domain, ... backend SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: SQL Server on XP Home Network
    ... There is an "sa" account under the Security>Logins area. ... Does that coorelate to a SQL Server login? ... I tried setting up the connection to use that SQL Server ...
    (microsoft.public.sqlserver.setup)
  • Re: Login failed for user (null)
    ... SSPI security assumes that the user credentials are known to the SQL Server. ... Setup a login account matching your credentials and give the account rights ... > When I created my connection in the Data Adapter Configuration wizard, ...
    (microsoft.public.dotnet.framework.adonet)