Re: Trusted connection to SQL Server 2000

From: Henrik (nospam@please.com)
Date: 05/08/02 

From: "Henrik" <nospam@please.com>
Date: Wed, 8 May 2002 11:23:27 +0200

Roslyn,

As the error message says, the user ASPNET could not logon. ASP.NET pages
run in the user context of this user. You need to allow this user access to
the database in question.

Hope this helps,

Henrik

"Roslyn Lutsch" <roznjim@earthlink.net> wrote in message
news:2SlB8.1689$Uo5.78370@newsread2.prod.itd.earthlink.net...
> Hi,
>
> I'm having a similar problem. I do not have either SQL Server or the
client
> for SQL Server. All I have is the MSSQL engine that comes with VS.NET (I
> believe it is SQLServer 2000).
>
> I can set up a data adapter with NT Authorization via the wizard and
> generate a dataset. If I attempt to View Schema everything's fine. I can
> fill the data w/o a problem. But when I add the following code to the
> code-behind page in the Page_Load event:
>
> sqlDataAdapter1.Fill(dataSet1);
> List1.DataBind();
>
> The login fails on the first line (fill statement)
>
> I get the following error:
>
> System.Data.SqlClient.SqlException: Login failed for user
> 'myServerName\ASPNET'.
>
> I have also tried using a specific user (myself w/admin priv). The
services
> available are MSSQLServer and MSSQL$VSdotNET. I've switched both of these
to
> my specific admin user account and back to NT auth.. Obviously, stopping
and
> starting both services before attempting to run myWebForms app. No
success.
>
> Any suggestions?
>
> Thanks much,
> Roslyn L.
>
> "Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
> news:m384du0pbf4vb5isgig3auh1o9edliqvrv@4ax.com...
> > If you can use a trusted connection to connect to SQL Server
> > with Enterprise Manager, then you have SQL Server and your
> > account configured. So the problem is likely in how you are
> > handling the connection in your application. Without more
> > details and an exact error message, it's hard to say. If you
> > are using ADO to connect, check the following site for
> > connection string settings:
> > http://www.able-consulting.com/ADO_Conn.htm
> >
> > -Sue
> >
> > On Thu, 2 May 2002 12:09:29 -0700, "David Zaragoza"
> > <ZAZASADO1803@hotmail.com> wrote:
> >
> > >A beginner on SQL Server 2000 is looking for help to make
> > >a trusted connection to SQL Server 2000. If I use the
> > >Enterprise Manager I can access the server, but if I use
> > >an application to access it I receive an error message
> > >that says I don't have a user associated to a trusted
> > >connection. I was looking in the online books but I didn't
> > >find how to make it.
> > >
> > >Thanks in advance,
> > >
> > >DZS
> >
> >
>
>

Relevant Pages

  • Re: Classic ASP connectionstring to SQL Server 2005
    ... So this connection string is in the VB6 dll? ... What is the error message? ... Provider cannot be found. ... can you ping the sql server? ...
    (microsoft.public.inetserver.asp.db)
  • Re: Problem upgrading Microsoft Office Accounting Professional from 2008 to 2009 using SQL Express 2
    ... I tried adding the TCP but then I get a error message "Microsoft Office Accounting cannot open the company because of a connection error." ... I assume that's why trying to force a TCP connection doesn't work. ... Rick Byham, SQL Server Books Online ... Since the problem appears to involve some sort of interaction between Microsoft Office Accounting Professionaland SQL Express 2008 hopefully someone in this forum will understand the error message I'm receiving and can suggest some possible solutions for me to try. ...
    (microsoft.public.sqlserver.connect)
  • How to check if SQL Server is running via asp.net
    ... When my provider shuts down the SQL Server IIS receives a few ... establishing a connection to the server. ... This error message happens when the server is offline and my ASP.NET 2 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Remote Connection to SQL 2005
    ... I think you have an application, so can you show your Connection String? ... It's going to be the error message which will help us to solve the problem. ... You better investigate the problem from SQL Error Logs if it's only about SQL Server connection. ... If your SQL Server Instance is a Named Instance then ensure the Browser Service is running. ...
    (microsoft.public.sqlserver.setup)
  • RE: MS03-031: Cumulative Security Patch for SQL Server
    ... Microsoft SQL Server 2000 by using named pipes, ... Connection could not be established. ... To obtain a hotfix to resolve this error message, ... SQL Server Developer Support Engineer, MCDBA, MCSE, MCT ...
    (microsoft.public.sqlserver.security)