Re: emergency about SQL Server connection

From: Nicholas Paldino [.NET/C# MVP] (mvp_at_spam.guard.caspershouse.com)
Date: 02/07/05 

Date: Mon, 7 Feb 2005 15:01:35 -0500

Shawn,

    You should not use the ASPNET account. It is a local account that
doesn't have access to the network. Rather, you should create a distinct
user that can connect to the db, and impersonate that user in the page.

    Hope this helps. 

-- 
               - Nicholas Paldino [.NET/C# MVP]
               - mvp@spam.guard.caspershouse.com
"Shawn Zheng" <szhenge897@rogers.com> wrote in message 
news:u2AyuxUDFHA.3256@tk2msftngp13.phx.gbl...
>I got a problem with connecting to SQL 2000 Server in Windows 2003. I have
> created ASPNET login account and granted to a database that I need to
> connect. but I still do not have permission to connect with C# ASP.NET. 
> Does
> any one can do a help for me?
>
> Shawn
>
>

Relevant Pages

  • Re: Access 2000 on Windows XP Home Edition
    ... you might be able to get it to work on a WinXP Pro ... > I have an Access database on a Windows XP machine. ... > network once it has been opened on the XP machine. ... or you need permission to access the data". ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Can Access do this
    ... No access can't do what your asking, surely the network ... >>permission due to security reasons to access eachother ... >>But we need one database for these people. ...
    (microsoft.public.access.security)
  • Access 2000 on Windows XP Home Edition
    ... I have an Access database on a Windows XP machine. ... a peer-to-peer network and users who do not have XP on ... network once it has been opened on the XP machine. ... or you need permission to access the data". ...
    (microsoft.public.windowsxp.security_admin)
  • Re: access to Access
    ... It's highly recommended to have the database split with the data on the shared network drive and a copy of the frontend (forms/reports/etc) on each PC. ... you must make sure each user has permission to create new files on the network dive/folder where the MDB is located as Access dynamically creates an LDB file for record locking. ...
    (comp.databases.ms-access)
  • Security and Windows Media Palyer
    ... I have a list of .WMV files stored in a network share. ... have permission to view the share contents. ... I'm able to use LogonUser to impersonate ... I'm able to copy the WMV file into my local user after impersonation. ...
    (microsoft.public.dotnet.general)