Confused about which webserver to use(closed gave up)

[Beast777]

Still really new at this and quite confused. I want to build a web app that the person fills out a form and it saves in my sql database. When I am using VS, I have my local webserver and the live webserver. DO I build this app using my local or the live webserver? Can I test it from my local machine on the live webserver or do I need to move the app there first? It seems if I try to use the live webserver and SQL I always get the "Login failed for user 'null" and the only time I have had any success is using the local IIS. I am unsure of what I should be using to build and how to change it to the live server. Lots of help would be appreciated, lol.

[Beast777]

I can get a windows app built and running in seconds with an sql connection so the only difference is the web server part and the security. I dont know if theres a guide or a walkthru to get a first app up that includes the security or not but if someone knows one, please let me know. I have alot of books on web apps but they all just code the app and then say hit run and expect them to run. None talk about what security needs to be set up.

[RobDog888]

Here is one I am starting on - http://www.asp101.com/

Its also another Internet.com site.

[Beast777]

I have been googling and there seems to be some speculation that windows 2003 causes some extra problems with the security. RIght now I have the impersonate = true in my webconfig, aspnet/IIS_WPG/IUSR_WEBSERVER all have owner access and still have the error.

[Beast777]

All the lessson at www.asp101.com are covered in the book I have MCAD/MCSD Developing and Implementing Web Applications with VB and VS .NET. They basically cover building the app, the controls and such but they all just want you to run the app without changing anything on your SQL or webserver which is what is missing. RIght now I just doing a simple dataform wizard to Northwind database and I still am stuck at the login failed. Surely someone, somewhere has written an asp app and gone through this same hell.

[Beast777]

I just found that on the SQL/WEBSERVER (windows 2003) that in the windows components under applications that the asp.net was not installed. SO I installed it and now have a new error. SQL server does not exist or access denied.

[Beast777]

Damn, it was cause the sql server engine was stopped, back to the login failed.

[Beast777]

Why would I get the "Login failed for user 'null" and yet when I go the dataadapter and configure and do a preview data, it works for that.

[RobDog888]

Not sure as I am just getting into the same thing today. Still have to configure the sql server on the host site so almost there.

[Beast777]

Great, please let me know what happens. I can't see us being the first two people in this forum to setup a web application on a live server. The data adapter can preview yet when I run the program in debug and step through, its the connection open that fails.

[Beast777]

Heres a great article that i used http://www.asp.net/faq/AspNetAndIIS6...ndex=0&tabid=1

[RobDog888]

Thanks for the link. I am running Server 2003 and ASP.NET 1.1

[Beast777]

Yes I am running server 2003 and asp net 1.1.4322.0. You can find the version by using the aspnet_regiis -lv command at the command prompt. You may have to go the directory usually c:\winnt\microsoft .net\framework\whateverversion.

[RobDog888]

I think this is why I am not able to remotely develop web apps from my system to my server, its probably not configured correctly.

[Beast777]

Ok heres exactly what i am doing, its quick so if someone can help that would be great.

1. New project, in the add new item select Data form Wiz. CLick next on welcome.
2. Create a new dataset named dsCustomers and click next.
3. Build a connection to the sql server on a different box. I am not using local SQL.
4. Choose the northwind database.
5. Click ok to create the connection and on the choose table, choose Customers.
6. Go to the Finish.
7. CHoose this page as start up and run the project.

For me, this is the part where i watch it fail.

[Beast777]

ANy luck RobDog888? ANyone else can try it too please, the more help the merrier. I just cant get my head around my a windows app will work fine. Take the same easy thing of just a dataform wiz in asp.net and suddenly all these problems. The adapter can preview so there should not be any problems yet there are. Desperately seeking help.

[-TPM-]

Are you specifying a user/password in your connection string?
What security setting is your SQL set for? (intergrated or windows or both)

[RobDog888]

I thought if you just add the user to the web.config file its considered as integrated login?

[-TPM-]

I thought if you just add the user to the web.config file its considered as integrated login?

I believe the answer to that is it'll use the aspnet user account, which if your useing intergarted won't make a difference. If you using windows then you'll need to set access for the aspnet user.

[RobDog888]

Integrated login is th Windows authentication and that makes sense about the ASPNET_USER user account.

[-TPM-]

You know what I mean

[Beast777]

-TPM- Thank you for the response. The SQL server is set for Windows ONly. I do have the ASPNET account setup with full access to the database. My connection string that was generated by the dataform wiz is:

Me.OledbConnection1.ConnectionString = "Integrated security=SSPI;packet size=4096;data source=""WEBSERVER"";Tag with column collation when possible=False;initial catalog=Northwind;Use Procedure for Prepare=1;Auto Translate=True;Persist Security Info=False;Provider=""SQLOEDB.1"";workstation id=""IMOWORK;Use Encryption for Data=False"

My app that I actually trying myself, the connection string is:

Dim strConnString As String = "workstation id=""IMOWORK"";packet size=4096; integrated security=SSPI;data source=""WEBSERVER"";persist security info=False;initial catalog=Webtest"

[Beast777]

The only change I have made to my webconfig was to add the identity impersonate=true. In the end, all I want is anyone on the net to be able to fill out a form and save it to my sql.

[-TPM-]

Aaah ok, so I checked up on identity impersonate=true, turns out it replaces the default aspnet user with the clients credentials (probably anonymous), I think you should either take it out, or use something like this: <identity impersonate="true" userName="joeblow" password="123456" />

[Beast777]

Since I have the aspnet account should I be using it there? If so, I guess I go set the account password first, because how will I know what it is?

[-TPM-]

If you want to use the aspnet user just take out the impersonate=true.

[Beast777]

I removed the impersonate and changed the sql server authentication to Windows and SQL and still same login failed problem. ANy ideas?

[-TPM-]

Hmm I'm pretty sure the aspnet user is set as a local user, when added aspnet to you SQL did you use the aspnet user from the web server?

[Beast777]

My SQL is on the same server(WEBSERVER) as the IIS. So I use the account WEBSERVER/ASPNET and I put it in the northwind database and put in the owner group so it should have full access.

[-TPM-]

Ok, what if you try SQL authentication? Does that work? (I.E use sa in the connection string)

[Beast777]

I am sorry I am very new to the web side. Can you give me a quick example, say my password was test?

[Beast777]

I tried this:

Me.OledbConnection1.ConnectionString = "Integrated security=SSPI;packet size=4096;data source=""WEBSERVER"";Tag with column collation when possible=False;initial catalog=Northwind;Use Procedure for Prepare=1;Auto Translate=True;Persist Security Info=False;Provider=""SQLOEDB.1"";workstation id=""IMOWORK;User ID=sa;pwd=test;Use Encryption for Data=False"

and recieved the same error - Login failed for user 'null', Not associated with a trusted SQl server connection.

[-TPM-]

Oh it's a trusted connection. in that case try this:
Me.OledbConnection1.ConnectionString = "Server=WEBSERVER;Database=Northwind;Trusted_Connection=True"

Odd it says user "null", did you delete 'identity impersonate=true' or set it to false?

[Lord_Rat]

Just on a note, if you are doing impersonation, you should persist the security info.

Persist Security Info=True;

[Beast777]

Just a couple of quick questions since I am spinning here. IS it Server=WEBSERVER or data source=WEBSERVER? Also Database=Northwind or initial catalog=Northwind? WHen I am doing this Trusted Connection, am I still impersonating?

[Beast777]

Ok, got some different errors about ole, so here is the string I have now and I have the error - Login Failed for ASPNET

Me.OledbConnection1.ConnectionString =data source=WEBSERVER;initial catalog=Northwind;Provider=""SQLOEDB.1"";Trusted_Connection=True;Persist Security Info=False"

[-TPM-]

Just a couple of quick questions since I am spinning here. IS it Server=WEBSERVER or data source=WEBSERVER? Also Database=Northwind or initial catalog=Northwind? WHen I am doing this Trusted Connection, am I still impersonating?

I think either way is fine.

[-TPM-]

Ok, got some different errors about ole, so here is the string I have now and I have the error - Login Failed for ASPNET

Me.OledbConnection1.ConnectionString =data source=WEBSERVER;initial catalog=Northwind;Provider=""SQLOEDB.1"";Trusted_Connection=True;Persist Security Info=False"

Is that exactly how you have it?

[Beast777]

Well here I am at a new error, any suggestions?

[-TPM-]

If thats exactly as you have it the reason it's not working is because of the "s you have. You'd want to do this; Me.OledbConnection1.ConnectionString =data source=WEBSERVER;initial catalog=Northwind;Provider='SQLOEDB.1';Trusted_Connection=True;Persist Security Info=False"