SQL Database Connection Size

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Sam (cybersam88_at_hotmail.com)
Date: 03/16/05 

Date: Wed, 16 Mar 2005 14:54:14 +0800

I wanna perform query and load the result from SQL Server to Client PC via
ADO.Net and ASP.Net.

However, if the data is large > 15MB, it is prompt for username and
password.

When I input domain username and password, it is cannot accept.

Then I try for SQL username and password but it is also rejected.

Error Message
---------------
You are not authorized to view this page
You do not have permission to view this directory or page using the
credentials that you supplied.
Please try the following:
Contact the Web site administrator if you believe you should be able to view
this directory or page.
Click the Refresh button to try again with different credentials.
HTTP Error 401.1 - Unauthorized: Access is denied due to invalid
credentials.
Internet Information Services (IIS)

Questions?
-----------
- What's wrong ? SQL Server? IIS 6.0? Active Directory?
- How to solve this?

Please advise.

Relevant Pages

  • RE: Audit Table
    ... Both IIS and SQL Server if possible. ... windows Authentication w/SSL on another. ... >want to record and return the current login username to ...
    (microsoft.public.sqlserver.security)
  • Re: Integrated Authentication in an Intranet
    ... IIS is only aware of the client's username if the client chooses to send ... This may be the credentials that the user is logged on as, ...
    (microsoft.public.inetserver.iis.security)
  • IIS 6 - UNC - 401.1 - Access is denied due to invalid credentials
    ... >I've setup a Windows 2003 Standard Server as PDC with IIS ... >password protected directory for the website statistics ... username & password are not accepted ... >denied due to invalid credentials. ...
    (microsoft.public.inetserver.iis.security)
  • user authentication
    ... 2 The web services that works through ... IIS, and lastly my SQL server. ... credentials from one level to another by user impersonation? ...
    (microsoft.public.sqlserver.security)
  • Integrated Windows && Anonymous combination
    ... >alike, credentials are passed to the SQL Server, ... >credentials to the SQL Server from IIS. ... >When evaluating client credentials, IIS represents our ...
    (microsoft.public.inetserver.iis.security)