ASP.net returning error when trying to connect using SQL Authentication

Hello,

I have read a bunch of topics on this issue but none seems to have
resolved my problem. I have set up a user account in my SQL server
database. e.g. User: TheUser Password: Password and assigned it as a
datareader with the ability to issue SELECT statements on one table.

On a separate IIS server I am running a page that makes a connection to
this database. I have tried a bunch of connection strings and though I
can connect using the SQLDataConnection wizard in .net 2003 Interdev,
Windows ODBC, etc. When I actually browse to test the page using the
same connection string I get the message that:

SQL Server does not exist or access denied.

I do not want to Impersonate and existing account. I have enabled
Anonymous access in IIS. I do not want Windows Integrated Security.
An example of a connection string I that works within .net studio
(development) but now actuall when the ASP page is accessed via
localhost is:

"workstation id=myworkstation;packet size=4096;user id=TheUser;data
source=myserver;persist security info=True;initial
catalog=MyDB;password=password"

SQL Server is set to Mixed Mode Security on the SQL server server box.

What am I doing wrong?

Thanks,
Ryan