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
1  1632 
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.comw rote in message
news:11******** *************@8 0g2000cwy.googl egroups.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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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 employee_temp order by lastname"
ConnectionString="<%$ ConnectionStrings:AppConnectionString1 %>"
ProviderName="System.Data.OleDb" UpdateCommand="UPDATE DBOWEB.EMPLOYEE_TEMP
SET firstname=?, lastname=? WHERE employee_ssno=?"> </asp:SqlDataSource>
Q1: ...
|
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& number, NumberFormatInfo info,
Boolean parseDecimal) +2178925"
This is beacuse some of my TextBoxes are empty (no value). If I enter a
value it is OK.
I need to use Null values to indicate that the field is not fileld in.
|
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: http:\\localhost\test.aspx, following
error occured:
The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and
then click the Refresh button, or try again later.
|
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 problem isolating individual fields in a FormView. I am
trying to manually add some values to a Dropdownlist in the EditMode of the
Formview.
I have a serious of dropdownlists in the formview that are populated from
|
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 .
When I hit the line:
DataView dv =
(DataView)(SiteInfoDS.Select(DataSourceSelectArguments.Empty));
in the code below, I get:
| | |
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 poor soul.
Situation: I want to do a lookup using a stored procedure for each
value in a Row within a GridView.
I use a lookup function in my code behind, evaluating the necessary
bound fields. The problem is the SqlDataSource representing...
|
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 comes back I am not interested for the Grid,
But I would like the first ROW's value for a label.
I could do another IO to go get this, but Is there any way I can
extract this data from the DATASOURCE directly in the Codebehind?
|
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 are doing the select/update/delete methods. I manually did the Insert method for each Gridview and I am able perform error handling on it.
Textboxes for data to add
<asp:Button ID="btnInsertNewService runat="server" Text="Submit"...
|
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 be the ID of a control of type
IDataSource. A control with ID 'SqlDataSourceGroup' could not be
found."
I've been suggested to move the SqlDataSource out of the Accordion to
get rid of the error message above, but when I do so the SqlDataSource
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
