RE: Problem with SQL trusted connection.

Thanks Peter,

I have decided to run IIS \ SQL within the same vm. If I ever need to scale
up the system I will have another go at running SQL on a seperate box. If I
get the same problem with initial connections taking a while to establish I
will open up anooher thread.

Thanks for your help,

Paul.

""Peter Yang[MSFT]"" wrote:

Hello Paul,

Thank you for your reply. It seems from the original post you just asked
IIS7 configuratoin when both SQL 2005 and IIS7 on the same box. It's good
to hear the whole story to know more background of this issue.

Usually having IIS and SQL running on different box is to seperate the load
of Web server and SQL Server. If you evaluate the current and future loads
and confirm it's OK for a new dual quad core server, you could consider use
this configuration. I'd say splitted servers mmight be more appropriate for
scale up purpose.

It's not normall that your applicaton needs 30s to open a connection to SQL
Server but it's a different problem and you may want to create a new thread
on that. You may start to try to a SQL authentication login other than
Windows login in your connection string to see if it's related to Windows
authentication.

If you have any further comments or questions, feel free to let's know.
Thanks.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


=====================================================

When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.


.

Relevant Pages

  • FW: Microsoft Security Advisory MS 03-007
    ... am trying to find a vulnerability tester/script and I could test it out ... Department of the Army server that had been compromised and that this ... announcement covers IIS 5.1 but not IIS 6, ... How a Hacker Uses SQL Injection to Steal Your SQL Data! ...
    (Focus-Microsoft)
  • RE: Confusion on standard security methodologies.
    ... Application will talk to a back-end SQL ... By "back-end," I assume you mean on a different box from IIS? ... If SQL is on a separate box, you won't be able to use NT authentication ... impersonations (meaning that once passed to the IIS server, ...
    (microsoft.public.inetserver.iis.security)
  • RE: MS patch-scanner for Win-NT, 2K, IIS, SQL
    ... MS patch-scanner for Win-NT, 2K, IIS, SQL ... XML file from the following location - mssecure.xml Possible ... and on a NT 4 Server, but the scanner works fine on a W2K Server ...
    (Focus-Microsoft)
  • Re: SQL CE Synching Problems
    ... install location of SQL CE instead of under Inetpub like I had done before. ... > so the issue has to be between the server tools and the publisher. ... >>I ran the wizard again to check all the permissions and this is what it ... >> A request to send data to the computer running IIS has failed. ...
    (microsoft.public.sqlserver.ce)
  • Re: General Network Error - MS Stumped
    ... > environment between our ASP.NET application and SQL Server 2000. ... > to be related to queries that return "large" amounts of data from SQL. ... > MS had us perform 3 data captures initially: MPSRPT_MDAC on the IIS ... > at System.Data.SqlClient.TdsParser.ReadByteArray(Bytebuff, Int32 ...
    (microsoft.public.sqlserver.connect)