User/table access issues

[sk8save]

First, here's what my DB looks like (MSDE 2000):

userX.TableA
userX.TableB
...

The DSN in CFAdmin is functional, it validates. I have provided the username and password for userX specified earlier in my DB setup for the DSN. It indicates "OK".

Here's my error when I run the page:
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'TableA'.

I have specified the username and password in the cfquery tag as well. I'll be uploading this code on a production server. The code as it is works on production - it's shared hosting so I don't know how they're setup.

Not sure if someone can provide any clues to why this isn't working at my end on my development environment.

[shorlbeck]

Perhaps a name collision resulting from duplicate DSNs, usernames, or application names?

[sk8save]

I was talking with a DBA friend and I think we figured it out.

I was logged into the database using userX's credential. I ran a simple SQL and it didn't find the table unless I prefixed it using userX.

I looked at the security side of things for userX and the user wasn't mapped to that database in question. I'm assuming that this is the cause. In my case, I can't map the user due to the way I imported the backup (I get an error while trying to map due to the user already being in the database - or something like that).

My goal is to figure out how to import the DB properly without creating the user in the database. Then, I could simply create the login and map it to the database and in theory, I'd be done - I think.