Need to know how to grant SQL login for the ASPNET account on a remote host via a VPN

From: Tim Meagher (tim_at_aaom.net)
Date: 06/12/05 

Date: Sun, 12 Jun 2005 07:49:43 -0400

The MSDN article "How To: Use Forms Authentication with SQL Server 2000"
located at

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetHT03.asp

provides a SQL script for granting login, datbase access, and execute
permissions for stored procedures to the ASPNET user on the local machine
where the web application is being run. However, I want to be able to grant
permission to the web application when launched from my Visual Studio
debugger on a remote machine via a VPN. When I try to use the computer name
of the remote machine, then the statement:

exec sp_grantlogin [RemoteComputerName\APNET]

cannot identify the user. How can I correct this problem?

Thank you,

Tim

Relevant Pages

  • Re: Connection Woes :-(
    ... Then you didn't grant the appropriate permissions to the aspnet user on sql server. ...
    (microsoft.public.dotnet.framework.aspnet)
  • ADP, Application Role, and objects
    ... The above link is to an atricle on how to implement SQL Server Application ... After you connect with your ADP, fire a bit of code to set the ... third party tools to view the data on the same database. ... Scenario 1 - If I explicitly grant permissions on that object to the user ...
    (microsoft.public.access.adp.sqlserver)
  • Re: field level security question
    ... Vyas, MVP ... listBox control that gets data from a query of the sql server table. ... > recent change in requirement) I see the option to limit permissions right ... > utility opens except their is just no data. ...
    (microsoft.public.sqlserver.security)
  • RE: SQL 2008 - remote connection to the SSIS 2008 - Access denied
    ... SQL Server configures the appropriate rights during the installation process, ... then add users/groups and assign the appropriate permissions. ... user who created the package apply to the writer role. ... I checked DCOM MsDts component and my user rights for the Remote ...
    (microsoft.public.sqlserver.dts)
  • Re: Deny access to all users (including Administrator and DomainAd
    ... permissions on stored procedure override ... applictaion's user account permissions to the stored procedure which will ... Will try to deny access through the query for SQL Server 2005 and 2000. ... Remove everyone that you don't want rom an Administrator Groups ...
    (microsoft.public.sqlserver.security)