Re: xp_cmdshell and vb programs and SQL Server 2000
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/03/04
- Next message: Dolphin: "Compare Triggers/stored procs."
- Previous message: Wayne Snyder: "Re: error while executing this query"
- In reply to: Alex: "Re: xp_cmdshell and vb programs and SQL Server 2000"
- Next in thread: Alex: "Re: xp_cmdshell and vb programs and SQL Server 2000"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 3 Mar 2004 14:10:02 +0100
Did you read my previous post?
Perhaps the SQL7's service account is LocalSystem and has "allow to interact
with desktop" checked?
And the other's service account is not LocalSystem...
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp "Alex" <anonymous@discussions.microsoft.com> wrote in message news:085501c400a6$2c720ea0$3a01280a@phx.gbl... > VB can be launched from batch and terminates without user > interaction. Executed from the desktop. Only hangs if > executed from xp_cmdshell even using a batch or without a > batch. Even putting CMD /C in the batch to force it to > terminate after executing. This has been working on a > Windows NT with SQL 7. Not working on SQL2000 and Windows > 2000 Server. Tested on SQL2000 and Windows NT. Does not > work in that combination either. One more combination to > try. SQL7 and Windows 2000 Server. > > > >-----Original Message----- > >Can you launch your VB within a batch file and it > successfully terminates > >without user-interaction. > > > >-- > >-oj > >http://www.rac4sql.net > > > > > >"Alex" <anonymous@discussions.microsoft.com> wrote in > message > >news:2dc101c3fcc7$3cb915c0$a301280a@phx.gbl... > >> The VB does open a form, but does not need user > >> interaction to terminate. The MSSQLSERVER service > account > >> is not set to LocalSystem. Is this the service account > you > >> are referring to? > >> > >> > >> > >> >-----Original Message----- > >> >This is generally if the program tries to open some > >> window... Perhaps the > >> >service account on your SQL2 is LocalSystem and it is > >> configured to > >> >"interact with Desktop"? > >> > > >> >-- > >> >Tibor Karaszi, SQL Server MVP > >> >Archive at: > >> >http://groups.google.com/groups? > >> oi=djq&as_ugroup=microsoft.public.sqlserver > >> > > >> > > >> >"Alex" <anonymous@discussions.microsoft.com> wrote in > >> message > >> >news:0f7d01c3fb4b$03790e50$a301280a@phx.gbl... > >> >> Does anyone have any issues with xp_cmdshell with SQL > >> >> Server 2000 on Windows 2000 Server? The vb program > runs > >> >> but does not end properly. In other words, the task > >> >> manager shows the vb program hanging there. The same > >> >> program that shells out of SQL Server 7 on Windows NT > >> has > >> >> no problem. It's not a permissions issue either. > dir.exe > >> >> works. xp_sqlagent_proxy_account is set. Program is > >> >> running but does not terminate. Program does run and > >> >> terminate if run from the DOS prompt. Any clues?? I > am > >> in > >> >> the process of installing a SQL Server 7 on a Windows > >> 2000 > >> >> Server to see if the shell works with the program > there. > >> > > >> > > >> >. > >> > > > > > > >. > >
- Next message: Dolphin: "Compare Triggers/stored procs."
- Previous message: Wayne Snyder: "Re: error while executing this query"
- In reply to: Alex: "Re: xp_cmdshell and vb programs and SQL Server 2000"
- Next in thread: Alex: "Re: xp_cmdshell and vb programs and SQL Server 2000"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
