I installed SQL Express 2005 on a Windows 7 computer. A Visual Basic application connects to SQL using Windows Authorization. No problem.
However, when others with accounts on this same computer attempt to run the VB application the result is "SELECT permission was denied.."
Necessary security is provided by the VB app. Can I change the connection string so that any user has access to the DB? I have the same issue with a SQL Server 2008 application.