I have a windows service routine that reads an XML file and populates a database with new records using a typed dataset. Everything works great while I debug the application although, when I start the service the service doesn't write out new records to the database.

I've tried starting the servive logging in as a local system account and also with my domain level account that I'm a db owner. It only writes the database when I'm running in the .NET IDE. :mad:

Here is the connection string I'm using:
"Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=TMS Database;Data Source=TMS35"

I hope someone has some ideas.

Thanks!