Hi everybody, I have a VB 2005 app connecting to SQL Server 2005 Express Edition, and I am unable to connect to my database when logged in to the PC as a regular (non-admin) user. I am getting the error "Login failed for user 'OEM-PC\TestUser'". Admin users work fine, and in the connection string, user instance is set to true. I really don't know where to start on this, but it is required that windows authentication be used, and we will not know all possible users from the start. essentially, we'd like to open the db up for anyone to access it. any tips?
It appears to be a problem with the MDF because the 'master' table is accessible, so the connection is working.