Question
SQL Server Express is being a real pain
I've been messing with this SQL Server Express installation
since Friday and still can't get this application and database to
work together correctly. The program is written in ColdFusion, but
the errors seem to be permissions related to me but I just can't
figure it out.
I've created a user within SQL Server Management Express program and all goes well. I then assign it as database owner for the particular database I'm using. I've created the datasource from within the ColdFusion administrator and it says the connection is being made.
When trying to access the script, I get the error below.
In the SQL Management system I have tried everything that I know to do - from adding this particular account as a user for the "tUsers" table and giving it "Select" permissions to re-creating the account and making it owner of the entire database. I tried adding the schema to the front and surrounding the table name in brackets [ ].
The database was restored from a backup on another server. Would that cause problems at all? I just tried deleting the database, creating it again, then restoring it from the file and setting the owner as this user during the import process. I'm still not having any luck though.
I've searched Google and almost every result is a forums post from people having this same problem who have fixed it by giving the account permission to access the database and/or table. For some reason that isn't working for me - or I'm an idiot and missing something.
Does anyone have any ideas?
I've created a user within SQL Server Management Express program and all goes well. I then assign it as database owner for the particular database I'm using. I've created the datasource from within the ColdFusion administrator and it says the connection is being made.
When trying to access the script, I get the error below.
In the SQL Management system I have tried everything that I know to do - from adding this particular account as a user for the "tUsers" table and giving it "Select" permissions to re-creating the account and making it owner of the entire database. I tried adding the schema to the front and surrounding the table name in brackets [ ].
The database was restored from a backup on another server. Would that cause problems at all? I just tried deleting the database, creating it again, then restoring it from the file and setting the owner as this user during the import process. I'm still not having any luck though.
I've searched Google and almost every result is a forums post from people having this same problem who have fixed it by giving the account permission to access the database and/or table. For some reason that isn't working for me - or I'm an idiot and missing something.
Does anyone have any ideas?
AdChoices