I have a service on server A that needs to connect to a SQL Server instance (2005 or 2008) on server B. Both A and B are on the same domain. What are the best practices for configuring both the service and SQL Server so that the former can connect to the latter?
In particular:
- I want to use Windows Authentication, right? Not store passwords in the registry or something.
- Should the service be running as NT AUTHORITY\NetworkService, or some other account?
- What logins need to be created on the SQL Server?