hi,
i created one windows service which runs on the local machine connected to the
Sql server. how to connect the sql server if i run the window service in remote machine.
it is show time out expired which account property we have to use
how to connect to sql server remotely from the windows service?
Hot Topic
- How do I transfer data to an Excel file
- There is no row at position 447: Cannot fill in a DataTable
- Web Service Partial Class
- How to avoid page call back in ASP .NET 1.0
- adding name to the row and column of datagridview in windows c# application
- Running Windows Commands interactively in a WinForm like a DOS Window
- Reading the end of an XML file
- Edit a string?
- want to duplicate forms authentication salted hash password.
- Form MessageBox mouseleave
Visual C#
- [c#]I need help to write a class
- [c#]I need help to write a class
- How to create exe file from my program
- Many a C# Question
- Empty an Array
- How can I stop the illumination of the form ? GDI+
- what should be the character for "Enter" button?
- copy local default to "false"
- get folder share permissions
- keyboard and mouse
how to connect to sql server remotely from the windows service?
spelger
you can still connect to it in Windows Service but be sure that the ports are opened in the firewall. Be sure that SQL Server does have the user account you are running the Windows Service under, in its security login's page also.
To be perfectly honest, you should create a seperate user account which this service runs under so that we are not giving all access to the Windows network service account in SQL Server but rather keeping what we need to access and who needs to access, all these details to SQL Server so we do not give it more permissions/access than what we have to. It's just better design/practice.