Q: Executing sqlCommand under a Windows Service, not possible?

  • Thread starter Thread starter Visual Systems AB \(Martin Arvidsson\)
  • Start date Start date
V

Visual Systems AB \(Martin Arvidsson\)

Hi!

I am trying to create a service that will maintain a database in SQL Server.

Using a sqlConnection and a sqlCommand. When executing
sqlCommand.ExecuteNonQuery. It totaly hangs, and i have to stop the
service...

Is there any security issues, what users should run the service, any special
account on the server, sql server...

Any tip, ideas, links would be highly appreciated....

Thanx
Martin
 
How are you performing authentication - passthrough or supplying a user and password?

Regards

Richard Blewett - DevelopMentor
http://www.dotnetconsult.co.uk/weblog
http://www.dotnetconsult.co.uk

Hi!

I am trying to create a service that will maintain a database in SQL Server.

Using a sqlConnection and a sqlCommand. When executing
sqlCommand.ExecuteNonQuery. It totaly hangs, and i have to stop the
service...

Is there any security issues, what users should run the service, any special
account on the server, sql server...

Any tip, ideas, links would be highly appreciated....

Thanx
Martin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

C# Windows Service Problem 16
Literals possibly fouling connectionstring 2
Windows Service Memory Usage 7
How to execute DROP/CREATE TABLE from c#? 0
TransactionScope vs SqlTransaction vs (BEGIN TRAN/COMMIT TRAN) on a SINGLE 2005 database 2
Interaction of windows service with UI 5
3 SQL queries in 1 string...in what order will they execute? 2
Issue retriving data from mssql 2005 1

Back
Top