|
Home > Archive > MS SQL Server ODBC > August 2005 > Connection to SQL Server with network login id when not logged
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Connection to SQL Server with network login id when not logged
|
|
| axl@todojuegos.com 2005-08-04, 7:23 am |
|
I have a scheduled task that executes a program that, among other
stuff, every morning connects to a SQL Server that requires a login by
network login id. The problem is that, even if that scheduled task runs
as the network user, it doesn't work if that user is not logged on.
Is it any way to make ir connect when not logged?
Thanks in advance.
| |
| Brian Lawton 2005-08-08, 8:23 pm |
| By "scheduled task" I assume that to mean that it is set to run using SQL
Agent. If so, then you need to assign the SQL Agent service to run as a
specific windows domain id and that id in turn needs to be granted access to
your SQL Server instance and database(s).
--
--Brian
(Please reply to the newsgroups only.)
<axl@todojuegos.com> wrote in message
news:1123149165.623223.184430@g44g2000cwa.googlegroups.com...
>
> I have a scheduled task that executes a program that, among other
> stuff, every morning connects to a SQL Server that requires a login by
> network login id. The problem is that, even if that scheduled task runs
> as the network user, it doesn't work if that user is not logged on.
> Is it any way to make ir connect when not logged?
>
> Thanks in advance.
>
|
|
|
|
|