SPs, sqlCommand and Terminal Services

  • Thread starter Thread starter Benny Olsson
  • Start date Start date
B

Benny Olsson

Hi all,

I just ran into something very, very strange..

I have this application which fires of a series of SQL
Scripts using the sqlCommand Object. One of the
statements executes the
procedure "sp_addMergePublication" on the server. If I do
this on a local machine, everything works fine. But if I
run my application on a server using Terminal Services
then the application will Halt on that statement saying
that "A severe error has occured." and that any changes
should be discharged.
Note. This happens ONLY when I run the application remote
and it is not an error bound to a specific machine. I can
recreate the problem on any given server.

Has anyone ever had this problem, or perhaps even knows
why this happens?

B
 
Hi Benny,

..NET application has strong security limitation. So if you
run it from Terminal Services, it's likely to be
restricted.

HTH

Elton Wang
(e-mail address removed)
 
Back
Top