Re: Web connectivity to SQL Server

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Bob Barrows [MVP] (reb01501_at_NOyahoo.SPAMcom)
Date: 04/20/04


Date: Tue, 20 Apr 2004 08:53:41 -0400

whiteoak wrote:
> I have been developing a web site on my desktop (Win XP Pro) using
> ASP, IIS 5.0, and SQL Server 2000. All the components work together
> just fine on this one machine. When I move the web pages and
> database to my SBS 2003 server (IIS 6.0, SQL Server 2000), I get a
> login failure message when attempting to open any page that connects
> to the database.
>
> "Cannot open database requested in login 'TestInet'. Login fails"
>
> I am assuming that SQL Server needs a user account that is associated
> with IIS but I am unable to make this work. Any suggestions will be
> greatly appreciated.

http://www.aspfaq.com/show.asp?id=2009

-- 
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


Relevant Pages

  • RE: OWA doesnt display sent items
    ... Microsoft CSS Online Newsgroup Support ... Open Internet Information Service Manager. ... Right-click the Default Web Site, ...
    (microsoft.public.windows.server.sbs)
  • RE: WSS 3.0 - WSUS and default web site issue in R2
    ... I ve stoped WSS 3.0 and use Configuration Wizard to do the job properly. ... Please open IIS manager, extend Web Sites, select the new web site ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: asp pages error
    ... i cant install this on any other machine as i only have 1 server and dont ... SBS server has hosted four web sites already. ... Hosting a new web site ... > This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: Access/Publish SBS Web Site
    ... I did create a WEB Publishing rule as per KB885186 ... I understand that you set up customize web site on IIS ... > Microsoft CSS Online Newsgroup Support ... > This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: CEICW KEEPS GIVING ERRORS
    ... For you have installed ISA 2004 on ... the SBS server box, the default web site should listen on the internal IP ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)