sql server - VBScript, SQL Integrated security, DB Connection Timeout -

i have vbscript connects sql server. using integrated security in connection string:

provider=sqloledb;data source=servename;initial catalog=databasename; integrated security='sspi';

everything works when execute script double clicking .vbs file, when schedule .vbs file run through task scheduler, connection database times out.

i have task scheduler set run using credentials work when executing manually.

i hope plenty info , can help me problem is. please kind virgin has gotten lots of answers here before, has never asked question before.

try this:

setting connection timeout in connection string

provider=sqloledb;data source=servename;initial catalog=databasename; integrated security='sspi';connection timeout=300;

msdn

sql-server vbscript scheduled-tasks

Four