[AccessD] Way OT SQL Server/IIS permissions

Doug Murphy dw-murphy at cox.net
Sun Mar 25 16:55:28 CDT 2007


Looks like with SQL Express this is limited to one or the other, atleast
through Sever Management Studio Express.

I'll switch to SQL authentication and modify my connection string.  It make
sense that this could be the problem.

Doug 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Eric Barro
Sent: Sunday, March 25, 2007 2:36 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Way OT SQL Server/IIS permissions

You can do this via the SQL Computer Manager interface. SQL calls this mixed
mode.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy
Sent: Sunday, March 25, 2007 2:19 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Way OT SQL Server/IIS permissions

Hi Eric,

Just took a quick look at the server authentication and it is Windows.
Looks like the choice is either Windows Authentication or SQL Server.  How
would I set up both?

Doug 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Eric Barro
Sent: Sunday, March 25, 2007 2:00 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Way OT SQL Server/IIS permissions

Doug,

Here are some things to check:

1. Check the IUSR_MACHINENAME account to make sure it has enough permissions
to perform the action you need it to perform.
2. Check SQL Server Express to make sure that it is using SQL authentication
versus Windows authentication. Because of the focus on security, SQL server
versions default to Windows authentication only. You can use Windows
authentication or both Windows and SQL server authentication.
3. Does your .NET app perform anything other than load the page like
authenticating logins, reading cookies, etc...that would require permissions
other than what is already standard?

Eric

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy
Sent: Sunday, March 25, 2007 1:51 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Way OT SQL Server/IIS permissions

Folks,

This is way OT but I know there are some very knowledgeable SQL server folks
on this list.  Here is my problem (the main one today anyway). I have a web
application which I built for an organization I belong to.  I built it in
ASP.NET thinking that this would be a good chance to actually build
something in it.  The app. development went well.  Used VS2005 with SQL
Server 2005 express. Everything runs under the development server so, before
moving to the host I tried testing under IIS on my machine.  I keep getting
an error on the opening page:

"[SqlException (0x80131904): User does not have permission to perform this
action.]".  

The error occurs on the open connection command so it is way before any of
the site roles and permissions come into play. I have permissions set in SQL
Server for IIS and ASPNET.  There must be something else to set but my
knowledge of sql server security is minimal so don't know where to look.
 
Any suggestions you can give would be greatly appreciated.  I am really
sorry now that I just didn't go with what I know and use an access database
with ASP pages.  They work, are relatively easy to code and I know how to
trouble shoot them.  This learning thing is way too much trouble and time.

Thanks for any suggestions.

Doug

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.17/732 - Release Date: 3/24/2007
4:36 PM
 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.17/732 - Release Date: 3/24/2007
4:36 PM
 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list