SQL db login failed

[FranS37]

I created a page in my fp web to display the contents of a table in a SQL database. I used INSERT, DATABASE, RESULTS and followed the steps in the wizard. To connect, I used an odbc connection that tests fine. I have front page extensions installed. I publish the web, but when I view the page in IE, I see a message that says "[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'servername\IUSR_servername', where servername is the name of the SQL server. Any help?

Thanks.

 

[CoreyBryant]

When you published - did you change the server name, user name & password to meet with your hosting companies server name & the user name / password that was set up by them?

__________________________
Corey

http://www.merchantaccounts4less.com

http://www.pay-it.com

 

[FranS37]

Thanks for your reply. I don't have a hosting company yet, I'm running this locally with IIS.

 

[CoreyBryant]

OK - sorry - you said you publish the web. This might be better in an ASP forum or server forum. Do you have the folder to run ASP? Is your connection string something like this:
strConnString = "driver={SQL Server};server=server_name_here;uid=user_id_here;pwd=password_here;database=db_name"

__________________________
Corey

http://www.merchantaccounts4less.com

http://www.pay-it.com

 

[FranS37]

I added the userid and password to the connection string in the global.asa file and it worked. Thanks!