problem in implementing sql server connection in windows service
-
Hello sir, i am maintaining a windows service which run in every ten second and check if certain condition is true then it will connect with the database and made some entry when i install it on machine , at run time it display AN Unhandled Exception('System.Data.SqlClient.SqlException')occurred in windowsservice.exe. just in time debugging this exception failed with the following error:No installed Debugger has just in time debugging enabled. say not to connect with sql server. please sir resolve my problem Siddharth jain siddharth
-
Hello sir, i am maintaining a windows service which run in every ten second and check if certain condition is true then it will connect with the database and made some entry when i install it on machine , at run time it display AN Unhandled Exception('System.Data.SqlClient.SqlException')occurred in windowsservice.exe. just in time debugging this exception failed with the following error:No installed Debugger has just in time debugging enabled. say not to connect with sql server. please sir resolve my problem Siddharth jain siddharth
In VS.NET go to Debugger menu and select the 'Attach process', you'll be able to debug the service.
-
Hello sir, i am maintaining a windows service which run in every ten second and check if certain condition is true then it will connect with the database and made some entry when i install it on machine , at run time it display AN Unhandled Exception('System.Data.SqlClient.SqlException')occurred in windowsservice.exe. just in time debugging this exception failed with the following error:No installed Debugger has just in time debugging enabled. say not to connect with sql server. please sir resolve my problem Siddharth jain siddharth
In your connection string, did you use trusted connection or did you supply a username and password that the SQL Server recognizes? If you used trusted connection, it won't work. The Local System account has no rights to the SQL Server. Change this to supply a username and password of an account that the SQL server trusts and you shouldn't have any problems.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007