Sql Server 2005 -- Select permission denied

Hot Topic

SSIS Training
Conditional Split Question
Thread was being aborted
System.Windows.Form assembly is needed on script component task?
SSIS on SQL Express
Unable to use MS SQL 2000 SA Password
How do you process AS objects from the command-line?
SQL DMO Support in SQL Server 2005...
SQL Server Reporting from VS2005 not Deploying
Adding Borders in a matrix report RS 2005?

SQL Server

Count CustomersOrders
The proxy auto-configuration script could not be downloaded
re-establishing mirror
Error in Adding Maintenance Plan
SQL Express Management Setup Error on Windows Vista Beta 2
How do you use the upgrade.exe for sqlce 2.0 to sqlce 3.0?
Sql Reporting Services problem
How to sort that does not include duplicates in display?
How to limit the time Dimension to 24 months
Install SQL 2005 Express error (ParseBootstrapOptionsAction)

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

Answer this question

Sql Server 2005 -- Select permission denied

  • Dan Murphy At Trailmark

    That was it.  I thought I was coming in through my domain account, but it was NT Authority.  Set the permissions and all is well.  Thanks!!

  • Adem Çiçek

    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'



  • ejomm

    This might be a schema issue, can you post the textdata of the query


  • mittal

    Run Profiler to double-check which user is connecting through the web app. You might be coming in through one of the IIS accounts...

    Peter

  • Sql Server 2005 -- Select permission denied
Answer this question