CUrrently, we developed a db that uses windows mode with integrated security. Now, the application [.net] will be deployed to many clients who run their own usernames that are not registered in the sql server. What's more is that they can have their own passwords. Hence, user's cant be connected to the database server at all.
AN idea that came into mind was to create a windows service that would then be used to connect to sql server 2008. THe idea is it wouldn't matter who is currently logged in as long as the service auto-starts. I know how to create the service but not how to connect to sql server thru it.
Is the idea good and credible? ANy one have experience wit it? HOw about connecting from dot.net thru it? NOte that the sql server 2008 got one instance only.
Please share your insight and advice on it. Thank you all.