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

.

Relevant Pages

  • Re: SQL open error
    ... > my connection string. ... > "SQL server does not exist or access denied". ... What user account id the MSSQLServer Windows ... >>> database thru the SQL Server Enterprise Manager. ...
    (microsoft.public.dotnet.general)
  • ASP.net returning error when trying to connect to a SQL w/ SQL Authentication
    ... I have set up a user account in my SQL server ... I have tried a bunch of connection strings and though I ... SQL Server does not exist or access denied. ... An example of a connection string I that works within .net studio ...
    (microsoft.public.inetserver.asp.db)
  • Re: sql server and asp.net problem
    ... Mixed SQL Server and Windows Authenitcation. ... the user account must be in Active Directory, ... In your Connection String, you included "Integrated Security=SSPI". ... indicates that only Windows Authentication should be used, ...
    (microsoft.public.dotnet.framework.aspnet)
  • ASP.NET 2.0 and SQL Server Access
    ... What NT user account must I setup with SQL Server to allow for NT ... I see a bunch of folks recommend using integrated security, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: One Connection String for Multiple Users (SQL)
    ... Hitchhiker’s Guide to Visual Studio and SQL Server ... "William Vaughn" wrote: ... This uses the> same connection string for all instances of the application. ...
    (microsoft.public.sqlserver.connect)
Loading