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

Tech-Archive recommends: Speed Up your PC by fixing your registry

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: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)
  • Re: Changing Connection String programmatically
    ... Connection strings of different years can be stored in app.config ... is declared in MyDataset.Designer.cs as private, ... every year we will create new database. ... If you are storing connnection string information related to additional ...
    (microsoft.public.sqlserver.connect)
  • Re: User not associated with trusted SQL Server connection
    ... > using the osql utility. ... > associated with a trusted SQL Server connection. ... > database or is it just for that instance. ...
    (microsoft.public.sqlserver.security)
  • RE: Manipulating MS Access records with excel VBA + ADO
    ... While I cannot see how a working example of a connection to a database is ... Select the control button view dataor edit query. ... Look for SQL button to get the SQL ...
    (microsoft.public.excel.programming)
  • Send Form results to database error
    ... ' Send results to the database. ... ' myConnString = Connection string to database. ... ' myConnection = The database connection object. ...
    (microsoft.public.access.forms)