Re: Win2.3k and dotnet. Urgent please

From: Ken Schaefer (kenREMOVE_at_THISadOpenStatic.com)
Date: 04/27/04 

Date: Tue, 27 Apr 2004 21:35:41 +1000

Did you install MSDE as an instance? If so, you need the instancename in the
connection string, unless it is the default instance.

Otherwise, try giving the IIS_WPG group access to SQL Server - see if that
makes the problem go away. If so, then ASP.NET is connecting as the Worker
Process identity for some reason.

Cheers
Ken

"Jay" <nospam@here.com> wrote in message
news:%23viquEELEHA.1348@TK2MSFTNGP12.phx.gbl...
: Quick scenario followed by details below.
: ASP.NET application and MSDE installed on our Win2k dev server. All is
good!
: Replicated this on our Win2.3k production server... problem!!
:
: Error is 'server does not exist or access is denied'
:
: Details.
: I installed MSDE via oSQL: setup sapwd=xxx securitymode=sql
: Then I installed SQL server client tools only.
: Restored the DB to the new instance from a .bak file.
:
: Created the login, gave it access to the required db and made it dbo.
: Set up IIS for the dot net app and did all the necessaries IIS and NTFS
: wise... treble checked!
:
: The dotnet app has a connection string that passes the db username and
pwd.
: (checked by running query analyser and connecting). The app error log
gives
: the above error.
:
: What can be wrong? The IIS/SQL/app is all the same server. have tried
: (local) and 127.0.0.1 for datasource.
: SQL is running. IIS is fine. NTFS is correct. SQL account has full
: permissions on sql. ASPNET and IUSR_machinename given full control for
: testing.
: Ran SQL profiler and there isn't even a log on attempt by the user/app.
: Any one shed any light? Any more details needed then feel free to yell
out.
: Supposed to be launching this tomorrow and am stumped for any more
debugging
: options.
:
: Jay
:
:
:

Relevant Pages

  • Re: Web and SQL Security
    ... Your connection string needs to be a low privileged account. ... SQL auth is never recommended, ... Therefore web app communicates with the SQL server using ...
    (microsoft.public.sqlserver.security)
  • Re: help with changing some code from mdb to adp
    ... At the end of this post is an example of an ADO connection string to a SQL ... Server database, and '' to the UNC path/name of your instance of SQL ... Windows, you can't create a new UDL file directly, but you can create a new, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Dataset - Error
    ... Server connection ... So looking at this we see that it is an error coming from SQL. ... Next we would look at the connection string, which is used to "login" to SQL ... What is does specify in regards to the userid is the ...
    (microsoft.public.cert.exam.mcsd)
  • how to configure ms sql server 2k and windows server 2k in order to sql from remote computer (with v
    ... My local database (under ms sql server 2000, ... database using a connection string with the ADODB VB object. ...
    (microsoft.public.sqlserver.connect)
  • Re: Installing MSDE 2000 Release A on a XP Home Machine
    ... Thanks Jim! ... > store the ADO connection string or the parameters for the connection ... Making a connection string for a different server ... >> By this I mean that when I install MSDE on my computer to conduct the ...
    (microsoft.public.sqlserver.msde)