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

making those two logins under SQL express 2005 did NOT help

my connection string (designed by web app server explorer VS2003) is:

this.sqlConnection2.ConnectionString = "workstation
id=LANDON\\sqlexpress;packet size=4096;integrated security=SSPI;data
source=\"landon\\sqlexpress\";persist security info=False;initial
catalog=netexamplesasp";

"Landon Kelsey" wrote:

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

  • 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)
  • 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)
  • Re: Timeout problem with SS2K, VS03
    ... I noticed calls in sql profiler: ... This is the server side debug stored procedure. ... a timeout issue that I cannot identify the source of. ... transaction is committed and the connection is closed cleanly and all ...
    (microsoft.public.dotnet.framework.adonet)
  • Complicated Connection Problems bewteen ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.access.adp.sqlserver)
Quantcast