Allow currently logged in user to connect to sql server 2008/express no matter...

[samvb]

What would be a quick way to allow users to connect to sql server 2008 server or express editions no matter their username, password, windows group or domain?

My app is been installed from various accounts and i am forced to create the same username and password, or windows group. I don't have such power on the users who are going to work with the application. My only power is on the sql server and the client app we just developed.

Any global way to allow the user to connect to sql server? I thot of creating a service or use default services (such as NETWORK SERVICE) but am not sure if it is the best way to go.

Any idea would really really appreciated.

[NeoPa]

Every logon is a member of the group {Everyone}, and all logons within the Domain are members of {Domain Users}. If you set up permissions for whichever of these groups you feel is the more appropriate then you should have all the control you need.

[Rabbit]

I hope there's no confidential data in your databases because allowing everyone access means just that. It would be like a honeypot to people with malicious intent.

[NeoPa]

Rabbit's point is obviously very important, though as you mention access is via an app, I expect you have that handled already. Remember though, an open BE gives access to the data even without using your app. This could be a critical issue that you should get fully right.