Sql Server 2005 -- Select permission denied
We have a web app that accesses Sql Server 2000 using windows authentication. We recently installed SQL Server 2005 on a new server and are in the process of porting the data from SS2000 over to 2005. I expected some problems, but I've run into something that seems like it should be relatively simple to solve, yet I have been banging my head against the wall for a couple of days. After changing the connection string in web.config of the web app to point to the new SQL Server 2005 database, I keep getting ...
SELECT permission denied on object 'tUser', database 'GDoc', schema 'dbo'.
The problem is, when I go into Management Studio and check the permissions, the user I'm logged in as DOES have select permissions on that database. What am I not doing? Am I forgetting something simple?
[818 byte] By [
Tjam] at [2008-3-1]
I have the same problem and need to know more details.
Please elaborate on what changes/settings you made to fix your problem with your Web Application logging into SQL Server 2005.
Microsoft SQL Server 2005 Management Studio
Databases
'GDOC'
Security
Users
'tUSER'
Schemas
'tUSER'
Are you setting permissions here through properties?
If you are which object and for Schema is the owner 'dbo'?
