Sql Server 2005 -- Select permission denied

Hot Topic

Failed to Start Project in SSIS after fixing DTC
Sharing time intelligence across cubes
SQL Server configuration similar to (Oracle Configuration) SQLNET.EXPIRE_TIME
Security while embedding SQL Server
error during quiet installation of June CTP.
AS Support for Teradata
Sql server with Source Control
Redimensionate parametervalue array
"product level is insufficient" message during flat file import
Installing SQL Server Express 2005 via Remote Desktop

SQL Server

Limited number of assemblies available in Visual Studio SQL Server Projects
Package Configuration Problem!!
Date Concatenation
ReportService "GetProperties" method
Report grouping question
Wildcard Searches
Report model
June CTP: Fantastic! Now...
OLE DB Command with property expression
Scheduling the SSIS Package

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

  • Schizm

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


  • Teddy076

    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'



  • jim from the foothills

    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

  • pgruderman

    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!!
  • Sql Server 2005 -- Select permission denied
Answer this question