Hello,
Like many other times this question is posed, I attached a DB to SQL Express, and am trying to use a sql account to access it from my application. But I get the login failed for user X. Now, I enabled mixed mode security, added the user to the logins, and enabled the user with dbo permission to the database. But I'm getting this in my application; I also can't connect to the server with this user account. I also know I'm trying to get in with the right password... Also, when I enabled mixed mode, I shut down SQL, and restarted the database engine.
Oh, and the specific object I'm trying to access is in a custom schema, which is specified in the data source control. But I don't see how that is a problem, but I figured I make sure to add it.
I know I'm missing something obvious, but what is it?
Thanks.
Hi, as I understand now you can connect to the database using the account X, right? Then it's a permission/schema issue on the referenced database object. First, you need to reference the right object by using full name in the form of:
database.schema_name.object_name
Then make sure the X account has proper permissions on the project.
|||
Hey,
I added the user as part of that, I think temporarily dbo, so that I could see if that was the problem.
Brian
