Connection Woes :-(

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: lloyd (lloydmonteiro_at_rediffmail.com)
Date: 05/05/04 

Date: 5 May 2004 11:52:58 -0700

i am trying to connect to SQL 7.0 using the following connection
string
myConnectString = "Initial Catalog=[SmartLan 2.0 ED];Data
Source=localhost;Integrated Security=SSPI;"

i always the get the following error message
Cannot open database requested in login '[SmartLan 2.0 ED]'. Login
fails. Login failed for user 'L20935-P3\ASPNET'.

In the Web.Config file i have the following setup

<authentication mode = "None"></authentication>
<identity impersonate="false" />

I have also granted Permission in Sqlserver/Users to ASPNET which is
the Id for asp worker process.

I cant figure out whats going on, maybe you have come across this
problem.

I also tried changing the identity to true in the webconfig, but that
didnt work either???

i also noticed that the ASP.NET state service is off, is this
required??

Relevant Pages

  • Re: ADO connections question
    ... I have a module which creates the ADO connection object to validates the ... Function dbLogin(txtUser As String, txtPword As String, txtServer As String, ... I have a specific login form that calls the dbLogin function as shown below: ... Dim strCriteria As String ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Forms and ODBC connections
    ... This is a function I've used in the past to initiate a connection to to SQL ... I had login form that passed username and password to this function ... Public Function LoginBackendSQLUser(username As String, ...
    (microsoft.public.access.formscoding)
  • RE: dynamic connection string?
    ... I've implemented my solution for this scenario by puting my connection ... string in database and prior to login to my portal, ... to get authenticated and retrieve the connection string. ...
    (microsoft.public.dotnet.framework.aspnet.webcontrols)
  • Re: Change login and password prompt
    ... > Where can i change Password and Login Prompt. ... can confirm this with the dd command: ... bytes to get to the "Password:" string, ... replacement string in the same way as was in the input file. ...
    (comp.os.linux.misc)
  • Re: Can no longer connect as sa
    ... after I removed the password and user from the connection ... > Is there a reason you need to connect using SQL authentication? ... >> Login failed for user 'sa'. ... >> I can't figure out what is slightly different in the connection string. ...
    (microsoft.public.sqlserver.setup)