Re: SQL Server does not exist or access denied.

From: Chris Jackson (chrisj_at_mvps.org)
Date: 08/06/03

  • Next message: Carl Prothman [MVP]: "Re: SQL Server does not exist or access denied." 
    Date: Wed, 6 Aug 2003 12:26:52 -0400

    Set up your ASP.NET process to use a domain account rather than a local
    account. You can do this by editing your machine.config, or by using
    impersonation on ASP.NET, having anonymous authentication, and then setting
    IIS to use that domain account as its process identity. Alternately, you
    could use authentication and set up permissions for all of your users on the
    SQL server. 

    -- 
Chris Jackson
Software Engineer
Microsoft MVP - Windows XP
Windows XP Associate Expert
-- 
"gg" <gg.subscribe@hotpop.com> wrote in message
news:OSyVuSDXDHA.1888@TK2MSFTNGP10.phx.gbl...
> hi group,
>
> i previously have a single machine development environment on server03
> (w2K3, stand alone, SQL2K).
> i configured it so that my app is using "NT AUTHORITY\NETWORK SERVICE" to
> access to the database it and it worked just so fine.
>
> now, i am installing my asp.net app and database to a new production
> environment.
> my asp.net apps goes on server01 (w2k3, .net 1.1, domain controller).
> my database on server02 (w2K3, stand alone, SQL2K).
> now i get an error "SQL Server does not exist or access denied".
> how do i setup so that my apps on server01 gets to access the database on
> server02?
>
> any help will be appreciated.
>
> tnx!
>
> GG
>
>
  • Next message: Carl Prothman [MVP]: "Re: SQL Server does not exist or access denied."

    Relevant Pages

    • Re: Webservices - the way to go...?
      ... about your lack of secure network connectivity your between a rock and a ... To summarize the posts so far: you have a winform app. ... using a webservices data layer to handle all the database interactions. ... Upgrade your database to SQL Server. ...
      (microsoft.public.dotnet.general)
    • Re: MSVC++ app type choice, form design questions
      ... > 1) MSVC Project definition requires that for an MFC app I choose ... MFC's built-in database support is really built around the document/ ... with the full version of SQL Server, but it's still pretty usable -- ...
      (microsoft.public.vc.mfc)
    • Re: SQL Licensing
      ... it depends on the features you used in your database development. ... If your app works with Express, then go with it not to buy license for SQL Server instances. ...
      (microsoft.public.sqlserver.clients)
    • Re: .NET and SQL Server on Separate Machines
      ... add this domain account as a valid login to your sql server. ... Everything was running correctly when the database ... > The connection string in our web.config file originally looked like this: ...
      (microsoft.public.sqlserver.connect)
    • Re: .NET and SQL Server on Separate Machines
      ... add this domain account as a valid login to your sql server. ... Everything was running correctly when the database ... > The connection string in our web.config file originally looked like this: ...
      (microsoft.public.dotnet.framework.adonet)