Re: SQL.Net connection in VS2005 from local IIS to local SQLExpres

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

my computer name is LANDON
SQL2005 server name is LANDON\SQLEXPRESS

Under Computer Management->Local users and groups->users I see
IUSR_LANDON : Internet Guest Account
IWAM_LANDON : Launch IIS process Account

so according to what you say, I need a SQL2005 login for one or both of
these 2 accounts...right?

"Roger Wolter[MSFT]" wrote:

My point exactly - because you are running in an ASP page as ASPUSER you
need a different connection string but I assume you're not interested in a
shallow answer to what has to be changed.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"Landon Kelsey" <landonmkelsey@xxxxxxxxxxx> wrote in message
news:950BA890-23D5-4BFD-B1BB-1DE963D822EC@xxxxxxxxxxxxxxxx
In my problem statement, I wrote that I had no problem with the connection
outside IIS in a "standalone" C# ADO.NET program using the same connection
string.
I can log into SQL Server 2005 and look at the tables.
Please no shallow replies!

"Roger Wolter[MSFT]" wrote:

I guess the obvious question would be is there a login defined in SQL
Server
for LANDON\ASPNET? Looking at the SQL Server errorlog file might also
tell
you more about what's happening.

You may be running into the difference between User Instance connections
and
normal database connection. Look at the connection string for the
applications that do work and see if User Instance is specified. If it
is,
then this would work unless you are using the 2.0 dotNet Framework.

--
This posting is provided "AS IS" with no warranties, and confers no
rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"Landon Kelsey" <landonmkelsey@xxxxxxxxxxx> wrote in message
news:8CCAA7FD-253B-4F3D-BD65-7F7C57BD1042@xxxxxxxxxxxxxxxx
I can connect easily using C# & ADO.NET on standalone programs.

I am trying to connect from a web site program under .NET 1.1 VS 7 and
always get

Login failed for user 'LANDON\ASPNET'.
Description: An unhandled exception occurred during the execution of
the
current web request. Please review the stack trace for more information
about
the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for
user
'LANDON\ASPNET'.

Source Error:


Line 46: private void Page_Load(object sender, System.EventArgs e)
Line 47: {
Line 48: sqlConnection1.Open();
Line 49: ds = new DataSet();
Line 50: daAttendees = new SqlDataAdapter(


Source File: c:\inetpub\wwwroot\pcswebapp2\webform1.aspx.cs Line: 48

having signed in under IE6 using:
http://localhost/PCSWebApp2/WebForm1.aspx
I've tried everything to fix the problem;




"Sue Hoegemeier" wrote:

Make sure the user is not orphaned and has a valid account
in the database you are specifying in the connection string.

-Sue

On Wed, 12 Apr 2006 11:19:35 -0400, "harry"
<mackey@xxxxxxxx> wrote:

Suddenly my trusted connection no longer works in VS. I try to create
a
new
one and recieve this:

"Database schema could not be retrieved for this connection. Please
make
sure the connection settings are correct and the database is online
Login failed for user ''. The user is not associated with a trusted
SQL
server connection."

1. I changed IIS to use a domain\user instead of IUSR_XX and still
recieve
this error.
2. The firewall has been disabled for now.
3. SQL has named pipes and TCP/IP open, SQL is in mixed mode.
4. I can browse the connection if I am in SQL Authentication using
'sa',
but
need to use WinAuth.

I cannot connect using Window Authentication.

Data Source=POLYP\SQLEXPRESS;Initial Catalog=HR15328;Integrated
Security=True
*Win2K3RC2

Suggestions?
Thanks
Harry










.

Relevant Pages

  • FW: Microsoft Security Advisory MS 03-007
    ... am trying to find a vulnerability tester/script and I could test it out ... Department of the Army server that had been compromised and that this ... announcement covers IIS 5.1 but not IIS 6, ... How a Hacker Uses SQL Injection to Steal Your SQL Data! ...
    (Focus-Microsoft)
  • Re: Connection issues between .Net framwok and SQl Express 2005
    ... You will no longer need the database MDF file name in the connection string. ... simply attach the ASPNETDB.mdf to SQL Server permenantly, ... as USER INSTANCE on existing SQL Server Express, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Performance of ODBC
    ... if you have a software firewall; forward 1433/1434 to your server ... I've now created my own server with SQL Server 2005 Express, ... glitch concerns the Upsizing Wizard. ... I originally set up my ODBC connection via ...
    (microsoft.public.access.adp.sqlserver)
  • Re: RPC-HTTP problems
    ... Exchange access within our office and with OWA access outside our ... rpc-http connection to work outside our office. ... assure iis is allowing the rpcproxy.dll web extension. ... server is unavailable" ...
    (microsoft.public.windows.server.sbs)
  • SQL 2005 Express and VS .Net 2003 wizard error More options
    ... Open the server explorer panel ... Go to the Provider tab and select SQL NAtive Client (DON'T use oledb ... Go back to the Connection tab and carry on setting up the connection ... I have installed Visual Studio 2005 Professional and then Visual Studio ...
    (microsoft.public.sqlserver)