Getting error when trying to use SQLdatasource in ASP.NET 2.0

Developer

Dear Group Member,

I am sorry if I have posted this query in wrong group, but since this
is connected with ASPO.NET2.0, thought of posting here.
I am doing a very simple program where I am inserting Grid control, SQL
datasource control.
I am attaching the default Northwind database to this Sql Datasource
and binding this to the grid control. When I click test connection on
the Sql Datasource, it says conncetion succeded.
Now I am tryign to view this in Web browser, but it is giving me error
as ,
Login failed NT Authority
Falied to connect to SQL server.

Please can you help me in getting rid of this error as this is annoying
because this is the first program I am doing for Data binding and I am
not getting through.

FYI - I am using Win 2003/SQL server 2000 and there is not password for
Win 2003.
This is my home PC.

Thanks and Regards,
Deo

Dec 8 '06 #1

Subscribe Post Reply

1589

Peter Bradley

My guess is that you are trying to make a trusted connection as the default
ASP.NET user, but that that user does not have any privileges on your
database. If I'm right, you either need to give appropriate rights on the
database to whatever user IIS is using (I forget what the default is), or
you need to specify a UID and pwd in your connection string, and connect
with those credentials.

HTH

Peter
"Developer" <gr****************@gmail.comwrote in message
news:11*********************@80g2000cwy.googlegrou ps.com...

Dear Group Member,

I am sorry if I have posted this query in wrong group, but since this
is connected with ASPO.NET2.0, thought of posting here.
I am doing a very simple program where I am inserting Grid control, SQL
datasource control.
I am attaching the default Northwind database to this Sql Datasource
and binding this to the grid control. When I click test connection on
the Sql Datasource, it says conncetion succeded.
Now I am tryign to view this in Web browser, but it is giving me error
as ,
Login failed NT Authority
Falied to connect to SQL server.

Please can you help me in getting rid of this error as this is annoying
because this is the first program I am doing for Data binding and I am
not getting through.

FYI - I am using Win 2003/SQL server 2000 and there is not password for
Win 2003.
This is my home PC.

Thanks and Regards,
Deo

Dec 8 '06 #2

by: Jason Shohet | last post by:

I'm using the new SqlDataSource successfully. Just for reference, here's my code: asp:SqlDataSource ID="ds" Runat="server" SelectCommand="SELECT employee_ssno, firstname, lastname FROM...

C# / C Sharp

FormView, empty TextBox gives error: Input string was not in a cor

by: Ottar | last post by:

I have a few numeric fields, and when I update i get the error: "Input string was not in a correct format". Next line:" System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer&...

ASP.NET

Error: The XML page cannot be displayed

by: Luqman | last post by:

I have copied the following code from Internet, and copied it to a file named : test.aspx, and copied that file to c:\Inetpub\wwwroot Directory. When I type on my Internet explorer:...

ASP.NET

Just getting started

by: abillmeier | last post by:

I am just getting started messing with ASP 2.0, and am working on creating a quick data entry web hooked to a SQL database. I am using stored procedures to get and push data. I am having a...

ASP.NET

DataSourceSelectArguments error

by: ashkaan57 | last post by:

Hi all, I am new to ASP.NET and VS 2005 Express. I am having problems with an error message and can't figure out why. I am trying to run a "SELECT" query triggered by a change in dropdown ....

ASP.NET

Getting an Output Parameter from a SqlDataSource

by: John Bailo | last post by:

This is a my solution to getting an Output parameter from a SqlDataSource. I have seen a few scant articles but none of them take it all the way to a solution. Hopefully this will help some...

.NET Framework

Getting Other Data from SQLDataSource ?

by: jobs | last post by:

I have a GRIDVIEW I have bound to an OBJECTDATASOURCE that has the select pointing to a class method that uses ADO to grab a dataset from SQL Server Stored Procedure. One of the columns that...

ASP.NET

SqlDataSource Error Handling

by: dhyder | last post by:

I'm working on an admin page for a SQL Server 05 db. The page is in ASP.NET 2.0/C#. The db has multiple tables with foreign keys/constraints. I have multiple SqlDataSources and GridViews, which...

.NET Framework

SqlDataSource error in Accordion

by: staeri | last post by:

I have a dropdownlist attached to a SqlDataSource inside an Accordion. I receive the following error message when the SqlDataSource is inside the Accordion: "The DataSourceID of 'ddGroup' must...

ASP.NET

React to native button blinking effect

by: lllomh | last post by:

Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{

Software Development

How to find best mobile app development company in usa

by: Aliciasmith | last post by:

In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...

Mobile Development

Can faster file sharing be achieved by connecting computers simultaneously via WiFi and LAN cables

by: tracyyun | last post by:

Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...

Networking - Hardware / Configuration

Energy Model code modification to account for year dependent interest rate

by: giovanniandrean | last post by:

The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...

Python

Report value list

by: Teri B | last post by:

Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...

Microsoft Access / VBA

Finding a record, and then saving a new record after the record has been amended.

by: nia12 | last post by:

Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...

Microsoft Access / VBA

VBA Class Basics (Report Class)

by: NeoPa | last post by:

Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...

Microsoft Access / VBA

Access Europe Meeting - Wed 6 Dec - Streamline Your Import/Export Spec Workflow with VBA Classes

by: isladogs | last post by:

The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...

Microsoft Access / VBA

Take a Database to the Next Level

by: GKJR | last post by:

Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

Microsoft Access / VBA

Getting error when trying to use SQLdatasource in ASP.NET 2.0

Similar topics