Re: Access to sql2005

I have a website in VS2005 C#. Access to server is no problem in debug
mode.

Access in run mode gives an errror. What exactly do I need to do to
enable this?

Thanks and regards,
VK

How are you connecting to the database? I'm guessing "integrated security".
When you run the site in the debugger, it could run under your account,
which has access rights to the database.
When you run it "for real" it runs under a local ASPNET (or NETWORK SERVICE)
account, which isn't known to SqlServer.

Solution: connect to SqlServer using a specified sqlserver account.
(note: SqlServer needs to be set up to accept both integrated secirity
and local accounts - which isn't the default)

Hans Kesting


.

Relevant Pages

  • RE: SQL Agent wont start
    ... Both SQLServer and SQLAgent are now run under the Local System ... Windows Admin account which was used to start these services. ... Interestingly, when a sysadmin account ...
    (microsoft.public.sqlserver.server)
  • Re: Intranet connect to SQLServer Under users account.
    ... >> I have set up the Web site so that it uses Windows Integrated security, ... >> On a test webpage I can output the user account being used: ... >> SQLServer using their account. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: SBS 2003 server/SQLServer 2000 SP3a service fails to load locally
    ... Resetting the log doesn't change authentication. ... Does the account has a password ... The only error I get is an authentication process problem. ... > the SQLServer Enterprise application and on the service itself. ...
    (microsoft.public.sqlserver.server)
  • FIXED! xp_sendmail works from QA but not from DTS package
    ... >> Do you use the same account for running both your SQLServer service and your ... >> SQLAgent service? ... then try to set SQLserver to use the same account ...
    (microsoft.public.sqlserver.server)
  • Re: Worker Process Account for ASP.NET
    ... Under Windows 2000 and WinXP the worker process runs as the local ASPNET ... is the local Network Service account. ...
    (microsoft.public.dotnet.framework.aspnet.security)