IIS Connection to MS SQL

Results 1 to 2 of 2

Thread: IIS Connection to MS SQL

  1. #1
    Join Date
    Dec 1969

    Default IIS Connection to MS SQL

    Anybody knows how to register IIS in another server to access database MS SQL in defferent server.<BR><BR>When I try to run ASP.NET app with IIS and MS SQL all in one machine that was no problem at all but prior to that I still have to register in MS SQL user call ASPNET for IIS in that particular server. But when IIS and AS.NET app in one server and MS SQL in another server that is SQL aunthentication problem. "not authorise it seems". I cant register because ASPNET for IIS in another server not exist in the list. fyi these 2 server are member server for 1 domain.<BR><BR>Healp me?<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: IIS Connection to MS SQL

    Applications that use SQL authentication to connect to a database are not generally affected by the switch to the ASPNET account. This is also true for applications that use integrated authentication and impersonation. However, if an application is not impersonating and is using Windows authentication, you must grant access to the database for the ASPNET account.<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts