SQL Server does not exist or access denied

From: Dan C (danc@nospam.com)
Date: 11/13/02


From: "Dan C" <danc@nospam.com>
Date: Tue, 12 Nov 2002 17:43:27 -0800


I have an ASP.NET web site on a computer trying to connect
to a SQL Server 6.5 on another computer; however I get
a "SQL Server does not exist or access denied" error.

The SQL Server is set up for Windows NT Integrated
security mode.

I tried adding the ASPNET account on the server (for both
Windows and within SQL Server), however it needed a
password I didn't know.

I tried creating a new account on the server (sqltest) and
adding:
<identity impersonate="true" userName="sqltest"
password="1234" />
but that didn't work either. I kept getting a
Configuration error: "Could not create Windows user token
from the credentials specified in the config file. Error
from the operating system 'A required privilege is not
held by the client"

How can I do this? Surely there must be a way since other
ASP.NET web sites need to connect to a SQL Server. Most
documents that I have read appear to indicate localhost
remedies which don't work here.

Thanks in advance.

Dan



Relevant Pages

  • RE: Management Point not available
    ... > configured the Default Web Site within IIS 6 to use port 8080. ... Manually restart the SMS Agent Host service on the MP. ... MP encountered an error when connecting to SQL Server. ... If using a standard SQL security account, ...
    (microsoft.public.sms.admin)
  • desperately needing help with a Server Error
    ... i know NOTHING about sql server, .net framework or probably anything ... this is NOT a problem with the web site. ... i tripped on to this board from access monster and thought it ... *** i posed this on sql server monster as well, not knowing if here or there ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: SQL Connection String using Domain Account
    ... Web.Config but now have the problem that the web site will not run under ... you can have a username/password set up in sql server - but this would ... The DBA has given me a Domain user account with rights to ... I am unable to get a connection to the database. ...
    (microsoft.public.dotnet.languages.csharp)
  • ASP.NET Web Site Administration Tool
    ... I'm developing a Web site with VS 2005 on a machine under Windows ... When I try to access the Security tab in the Web Site Administration ... it fails with a message "Unable to connect to SQL Server ... The database aspnetdb is attached, and my user login, which is in a ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Re:Connection
    ... I know you host a web site on your ISP. ... You want to know you'd better host the SQL server on ...
    (microsoft.public.windows.server.sbs)