[ralph.wigham]

Hi,

I am trying to develop a database driven web application. I have read the books, installed the software, followed the pointless example in the book to the letter but keep hitting this hurdle.

System.Data.SqlClient.SqlException: Login failed for user

Here is the code i habe typed in, it is an example from a book, the end product is supposed to be a pizza order system:

Line 50: SqlCommand1.Parameters("@pizzatype").Value = radlPizzatype.SelectedItem.Value
Line 51: SqlCommand1.Parameters("@comments").Value = txtComments.Text
Line 52: SqlConnection1.Open()
Line 53: SqlCommand1.ExecuteNonQuery()
Line 54: SqlConnection1.Close()

It is falling over at line 52: and giving me the following stack trace:

[SqlException: Login failed for user 'ASHLEY\ASPNET'.]
System.Data.SqlClient.SqlConnection.Open() +761
chapter9.InsertPizzaOrders.Button1_Click(Object sender, EventArgs e) in d:\inetpub\wwwroot\chapter9\InsertPizzaOrders.aspx .vb:52
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1263

I am reaching the end of my teather with this, if anyone could help me and point me in the right direction to get everything configured properly i will be very grateful.

Cheers

[BlazingWolf]

Does it tell you anything anything at all about a 'Trusted' connection?

[ralph.wigham]

Hi BlazingWolf,

Cheers for replying.

No, unfortunately it doesn't say anything about a Trusted connection.

I am running Visual Studio.NET 2003 and MySQL Server 2000. Do I need to get a more up to date SQL Server? I found some posts on the net last night about the error message I was getting @

http://weblogs.asp.net/coltk/archive...7/10/9920.aspx

but i do not seem to have the SQL Server in My Programs, i have tried to access it in other ways but cannot seem to find the section the forum is talking about, once i find it I think i can sort this. That is why i am unsure as to whether my SQL Server is the correct version.

Thanks for your reply, first time i have used a forum like this and to get a reply so quick was really nice

Ta

[ralph.wigham]

OK, if anyone out there can help you are a beautiful person.

I am running Visual Studio 2003, Microsoft Server 2000 Developer Edition and Windows XP Pro.

I have followed everything I have found on the internet about login issues, but still I keep getting the login failure messages that i originally posted.

I am starting to get quite desperate now as I have a project deadline getting ever closer, but until I can get my ASP.NET Applications to login to the server properly I am screwed.

Having read the posts via the link above, other people have had this problem and also it appears that people have managed to solve the problem also. So it can be done, I just need a helping hand please.

Cheers

R

[shan]

here's a stupid question, it's failing on line 52 (the sql open) becuase of the username or password. has this userid & password been added to be able to acces the db server....

try using the root account to see if you can access that? if so, looks like there could be a problem with the ASHLEY account.

[ralph.wigham]

Hi Shan,

Thanks for the reply, I have sorted what I was doing wrong, you were perfectly correct, the username and ID were not registered correctly. After downloading a free asp.net forum (which configured my server to work on it properly), I was able to see how it should work, and so copied the configuration. I feel a bit stupid as it was a really stupid mistake.

Just for info. I've been to Spokane, a friend of mine used to live there, I am jealous of you for being there, but jealous in a nice way.

Thanks

Ralph