SQL connection - ASP.NET

Brad

I am building my first ASP .Net web app using VB .Net and I am getting the
error:

Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.

Where in my program do I set the user or what do I need to configure? I was
starting to build a windows app and it works fine there. It is just
whenever I try to do an ASP app I get this message.

Thanks for the information and any help provided.

Brad

Nov 19 '05 #1

Subscribe Post Reply

1011

Kevin Spencer

ASP.Net runs under a different user account than executables, which
generally run under the Local System account. It sounds like your SQL Server
is configured to use Windows Only authentication, but that may not be the
case. When using a trusted connection, you must have a domain user account
that has the necessary permissions. On the other hand, if your SQL Server is
configured for mixed authentication, you can create a SQL Server account,
give it th3e necessary permissions, and use the User ID and Password in your
Connection String.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
What You Seek Is What You Get.

"Brad" <ba******@ukcdogs.com> wrote in message
news:eb**************@TK2MSFTNGP09.phx.gbl...

I am building my first ASP .Net web app using VB .Net and I am getting the
error:

Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.

Where in my program do I set the user or what do I need to configure? I
was starting to build a windows app and it works fine there. It is just
whenever I try to do an ASP app I get this message.

Thanks for the information and any help provided.

Brad

Nov 19 '05 #2

Brad

Kevin,

Thank you for the help. With some tweaking, setting up users and then
granting then db_owner access, it is now working.

Brad

"Kevin Spencer" <ke***@DIESPAMMERSDIEtakempis.com> wrote in message
news:OW**************@TK2MSFTNGP09.phx.gbl...

ASP.Net runs under a different user account than executables, which
generally run under the Local System account. It sounds like your SQL
Server is configured to use Windows Only authentication, but that may not
be the case. When using a trusted connection, you must have a domain user
account that has the necessary permissions. On the other hand, if your SQL
Server is configured for mixed authentication, you can create a SQL Server
account, give it th3e necessary permissions, and use the User ID and
Password in your Connection String.

--
HTH,

Kevin Spencer
Microsoft MVP
.Net Developer
What You Seek Is What You Get.

"Brad" <ba******@ukcdogs.com> wrote in message
news:eb**************@TK2MSFTNGP09.phx.gbl...
I am building my first ASP .Net web app using VB .Net and I am getting the
error:

Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.

Where in my program do I set the user or what do I need to configure? I
was starting to build a windows app and it works fine there. It is just
whenever I try to do an ASP app I get this message.

Thanks for the information and any help provided.

Brad

Nov 19 '05 #3

Kevin Spencer

You're very welcome, Brad! :)

--

Kevin Spencer
Microsoft MVP
..Net Developer
What You Seek Is What You Get.

"Brad" <ba******@ukcdogs.com> wrote in message
news:ep**************@TK2MSFTNGP12.phx.gbl...

Kevin,

Thank you for the help. With some tweaking, setting up users and then
granting then db_owner access, it is now working.

Brad

"Kevin Spencer" <ke***@DIESPAMMERSDIEtakempis.com> wrote in message
news:OW**************@TK2MSFTNGP09.phx.gbl...
ASP.Net runs under a different user account than executables, which
generally run under the Local System account. It sounds like your SQL
Server is configured to use Windows Only authentication, but that may not
be the case. When using a trusted connection, you must have a domain user
account that has the necessary permissions. On the other hand, if your
SQL Server is configured for mixed authentication, you can create a SQL
Server account, give it th3e necessary permissions, and use the User ID
and Password in your Connection String.

--
HTH,

Kevin Spencer
Microsoft MVP
.Net Developer
What You Seek Is What You Get.

"Brad" <ba******@ukcdogs.com> wrote in message
news:eb**************@TK2MSFTNGP09.phx.gbl...
I am building my first ASP .Net web app using VB .Net and I am getting
the error:

Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection.

Where in my program do I set the user or what do I need to configure? I
was starting to build a windows app and it works fine there. It is just
whenever I try to do an ASP app I get this message.

Thanks for the information and any help provided.

Brad

Nov 19 '05 #4

Similar topics

Changing a DataAdapter connection

by: G-Fit | last post by:

Hello group, I have several servers hosting SQL databases. On each of them, I have several databases. All those databases have the same structure (even those on different servers), only the data...

.NET Framework

Database Connection questions.

by: pradeep_TP | last post by:

Hi all, I have a few questions that I have been wanting to ask for long. These are all related to ADO.net and specifically to conenction to database. 1) If I have opened a connection to a...

C# / C Sharp

connection pooling error

by: Chris Szabo | last post by:

I've created a data access layer for a .NET web application. I'm using C# and framework 1.1. I'm getting an error from time to time when I close a connection saying: ...

ASP.NET

ADO.NET, connection pooling and ASP.NET

by: Rob Nicholson | last post by:

We're getting an occasional occurrence of the following error when two users try and open the same record in our ASP.NET app: "There is already an open DataReader associated with this Connection...

ASP.NET

2 ways to close a connection

by: Eric Sabine | last post by:

In my Finally block, I was using cn.close (where cn is an ADO.NET connection object, SQLConnection to be exact) and then I came across the following in some microsoft code. If Not cn Is Nothing...

Visual Basic .NET

database connection loss

by: Martin B | last post by:

Hallo! I'm working with C# .NET 2.0, implementing Client/Server Applications which are connecting via Network to SQL-Server or Oracle Databases. To stay independent from the underlaying Database...

C# / C Sharp

Connection pooling question

by: fniles | last post by:

I am using VS2003 and connecting to MS Access database. When using a connection pooling (every time I open the OLEDBCONNECTION I use the exact matching connection string), 1. how can I know how...

Visual Basic .NET

Database connection pooling in ASPx

by: fniles | last post by:

In the Windows application (using VB.NET 2005) I use connection pooling like the following: In the main form load I open a connection using a connection string that I stored in a global variable...

ASP.NET

Connection watching in VB.NET 2008

by: Robert Avery | last post by:

In VBA/VB6, I had a class (incomplete sample below) that watched and displayed for the user all connection events, so that I could easily see what SQL was taking a long time, and when it freezes, I...

Visual Basic .NET

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware