Re: IIS6,asp.neret,sqlserver2000

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Kristofer Gafvert (kgafvert_at_NEWSilopia.com)
Date: 03/31/04 

Date: Wed, 31 Mar 2004 11:06:56 +0200

Can you please include the _complete_ error message? It should tell us what
kind of permissions problem you have. Note however that it is not enough to
add the user access to the database server, you also need to grant it
permissions to use the database, the tables, views, stored prrocedures, and
so on. You probably got a new error message after adding the user in the
database, but the user probably still do not have permissions to access
whatever it needs to access. 

-- 
Regards,
Kristofer Gafvert - IIS MVP
Reply to newsgroup only. Remove NEWS if you must reply by email, but please
do not.
www.ilopia.com - FAQ and Tutorials for Windows Server 2003
"Zal" <zal@sage-partners.com> wrote in message
news:1611001c416f8$ad4f4390$a301280a@phx.gbl...
> hi,
> i hope someone can help me please, i have sql server 2000
> installed on SBS2003, i have the client toools of sql
> server 2000 installed on my local machine.  i am working
> on web developement, and am using IIS6.0 which im really
> struggling with.
>
> problem.
> 1. When  try to connect to the database via a connection
> string (declared correctly) from my aspx page it says that
> login for the user has failed, i know that this is
> permissions problem, but i dont know where to start
> looking.  i have added the user name and password into the
> users section of the database im using as well as the
> overall security for the server registration.  i have
> added the user to the permissions on IIS6.0 but it still
> dosent work,
> what do i do?????????????????????????????????????????
>
> The web application i am using used to work on our old
> server win2000 bu since we have installed 2003 from sratch
> i have been unable ot get the web application to work
>
> thanxz
>
> Also i have tried to changed the mode of the server e.g.
> when in e.manger the display name of the server is
> displayed with (Windows NT in brackets) i think this may
> have something to do with the connection string. but im
> not sure?

Relevant Pages

  • RE: copy permissions from one user to another?
    ... THIS STORED PROCEDURE GENERATES COMMANDS ... -- ADD USER TO SERVER ... -- CREATE TABLE TO HOLD LIST OF USERS IN CURRENT DATABASE ... -- SET COMMAND TO FIND USER PERMISSIONS HAS IN CURRENT DATABASE ...
    (microsoft.public.sqlserver.security)
  • Re: Effective Permissions Error with Domain User
    ... I set the database compatibility to 2005. ... server profile trace and found that it was calling the Execute As User. ... This leads me to believe it is some sort of permissions issue. ... Did you get these database from SQL Server 2000 by using a RESTORE command? ...
    (microsoft.public.sqlserver.security)
  • Re: How to prevent DELETEs in a table
    ... It is the dbo database USER, not server-level groups, that determins ... It has implicit permissions that can not be denied. ... SQL Server just skips any permission validation for sysadmins. ...
    (microsoft.public.sqlserver.server)
  • Re: Disable Sysadmin to view metadata in SQL2005
    ... you are looking for a DRM solution for your database. ... Server does not provide such a solution. ... SQL Server Engine ... If the permissions are not granular ...
    (microsoft.public.sqlserver.security)
  • Re: Table permissions: No matter what I set all users have full access?
    ... I have created a new Windows user the ... logged on to another PC as that user and can still access the database with ... The new user does not have a login on the server and is ... I even created a login for the user and denied SELECT permissions on various ...
    (microsoft.public.access.adp.sqlserver)