form submit to SQL Server w/Database wizard

[GinKirk]

Hi - looking for help with a submit form to SQL Server.

I've used the database options from the form properties to set up the
connection (form is .asp). The connection is a dsn on the same server
as IIS and uses a Windows trusted connection. SQL Server is on the
same box.

Clicking the submit button produces a results page that indicates the
user has submitted X information, but it is not saved to the database.
The connection is there, but no data is being saved.

When trying to view the data results, the following error is produced:
login failed for user [servername]\iusr_[servername]. this leads me to
believe the problem is with the trusted connection permissions for that
user. How are these permissions set up? It is not necessary for a
user to enter a uid/password, but I don't want a gaping security hole
either.

Any relevant comments/questions are welcome.

Thanks much

 

[Thomas A. Rowe]

You need to have a login/password set in the global.asa that allows writing to the database.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[GinKirk]

Do you mean for the \iuser... user? Or for a newly created user?

Also - thanks for your super prompt reply to my question. that's the
single fastest response I've ever seen. Much appreciated.

 

[Thomas A. Rowe]

No, the SQL server normally have a login assigned for accessing the database, this has nothing to do
with actual users.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[GinKirk]

OK - I added the \IUser... account to my db as a user with
db_datawriter only. I did not set up a new SQL Server user and add it
to the global.asa. Is using the global.asa more secure than using the
IUser account?

Thank you.

 

[Thomas A. Rowe]

No. I just always use a global.asa file and System DSN for database connections.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[GinKirk]

No. I just always use a global.asa file and System DSN for database connections.

Hi - one last confirmation: you set up a standard SQL Server user with
db rights and then put that in the global.asa? As opposed to a Windows
user?

Thanks for your help.

 

[Thomas A. Rowe]

Yes, login info would be for the SQL Server

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================