Re: Login fails. Login failed for user 'LAPTOP\ASPNET'
From: WJH (intLink_at_adelphia.net)
Date: 03/06/04
- Next message: Hari: "Re: DTS"
- Previous message: Noorali Issani: "Help"
- In reply to: David Schleifer [MSFT]: "Re: Login fails. Login failed for user 'LAPTOP\ASPNET'"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 6 Mar 2004 11:47:29 -0800
Thanks, using the free download from Microsoft "Sql Web Data Administrator"
I granted login access to LAPTOP\ASPNET, and my problem was solved
Thanks again
********************************************************
The SQL Server Web Data Administrator enables you to easily manage your SQL
Server data, wherever you are. Using its built-in features, you can do the
following from Microsoft Internet Explorer or your favorite Web browser:
Create and edit databases in SQL Server 2000 or Microsoft SQL Server 2000
Desktop Engine (MSDE 2000)
Perform ad-hoc queries against databases and save them to your file system
Export and import database schema and data
Manage users and roles
View, create and edit stored procedures
*********************************************************
"David Schleifer [MSFT]" <dschleif@online.microsoft.com> wrote in message
news:OKb6w4vAEHA.1452@TK2MSFTNGP09.phx.gbl...
> What's probably happening is that Web Matrix is making the connection to
sql
> server as the logged-on user (i.e. yourself) and since youre login has
> access to the database, it works.
>
> Visual Studio is making the connection through the account that IIS runs
> under, i.e. ASPNET. So you want to add the ASPNET login to the database,
> with whatever set of rights your application would need.
>
> - Dave
>
> "WJH" <intLink@adelphia.net> wrote in message
> news:XcCdnTE5dYPpNNXdRVn-ug@adelphia.com...
> > I don't care how I log on as long as I, and anyone else accessing the
> site,
> > can open the web page that includes the data from the database (I think
> that
> > requires anonymous access being enabled).
> >
> > What I don't understand is how the 3 lines of code below can work when
run
> > in Web Matrix, but not work when run in Visual Studio or accessed
directly
> > by my browser. If I could figure that out, I could presumably fix the
> > problem.
> >
> > Bear in mind also, that a number of possible causes of the problem can
be
> > ruled out by the fact that the code works fine if I change 'certainteed'
> to
> > 'store'.
> >
> > What do you think?
> >
> > "James Goodman" <james@norton-associates.REMOVE.co.uk> wrote in message
> > news:c29fip$j6l$1@hercules.btinternet.com...
> > > I am assuming you are not logging in to your computer as user
'ASPNET'.
> > >
> > > If you want to login as yourself to SQL Server, you need to set the
> > > properties for your website to only allow Windows Authentication. If
> > > Anonymous access is enabled, by default all users will attempt to
login
> as
> > > user 'COMPUTER\ASPNET'.
> > >
> > > If you do want to login as user 'ASPNET', you will need to add the
login
> > to
> > > the SQL server instance on your laptop.
> > >
> > >
> > > --
> > > James Goodman
> > > MCSE MCDBA
> > > http://www.angelfire.com/sports/f1pictures/
> > > "WJH" <intLink@adelphia.net> wrote in message
> > > news:yuCdnSxB7tE0NdrdRVn-sA@adelphia.com...
> > > > I'm trying to open a connection to a local SQLSERVER database (on my
> > > > computer named Laptop).
> > > >
> > > > The following code works in WebMatrix, but cut and pasted into
Visual
> > > Studio
> > > > it doesn't work. In Visual Studio, I get an error message, "Cannot
> open
> > > > database requested in login 'certainteed'. Login fails. Login failed
> for
> > > > user 'LAPTOP\ASPNET'".
> > > >
> > > > string connectionString = "server=\'(local)\';
> trusted_connection=true;
> > > > database=\'certainteed\'";
> > > > System.Data.IDbConnection dbConnection = new
> > > > System.Data.SqlClient.SqlConnection(connectionString);
> > > > IDbConnection.Open();
> > > >
> > > > If I change one word in the connection string, 'certainteed' to
> 'store',
> > > the
> > > > code works to open a connection to that database which is on a
> different
> > > > local web site.
> > > >
> > > > Can you reconcile these facts to see a possible solution, so that I
> > could
> > > > use Visual Studio to establish the connection to the certaineed
> > database?
> > > >
> > > > Thanks in advance
> > > >
> > > >
> > >
> > >
> >
> >
>
>
- Next message: Hari: "Re: DTS"
- Previous message: Noorali Issani: "Help"
- In reply to: David Schleifer [MSFT]: "Re: Login fails. Login failed for user 'LAPTOP\ASPNET'"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
