Problem with sql server connection sting

Hi,
I am testing a asp page using sql server as the backend database. However, I
cannot connect to the database from asp. I have the following error coming
and I have also added the connection string that goes with the asp page.
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E4D)
Login failed for user 'sa'.
/aspsqlserver/logonprocess.asp, line 16
cn = "Provider=SQLOLEDB.1;User ID=sa;password=;Initial Catalog=test;Data
Source = TSU_SUPER"
I do not user any password to get into the sql server. I can open it from
my Enterprise Manager without using the userid sa and any password. With thi
s
situation, any help is appreciated. Thanks in advance.Am Mon, 5 Jun 2006 09:24:01 -0700 schrieb Jack:

> Hi,
> I am testing a asp page using sql server as the backend database. However,
I
> cannot connect to the database from asp. I have the following error coming
> and I have also added the connection string that goes with the asp page.
> Error Type:
> Microsoft OLE DB Provider for SQL Server (0x80040E4D)
> Login failed for user 'sa'.
> /aspsqlserver/logonprocess.asp, line 16
>
> cn = "Provider=SQLOLEDB.1;User ID=sa;password=;Initial Catalog=test;Data
> Source = TSU_SUPER"
> I do not user any password to get into the sql server. I can open it from
> my Enterprise Manager without using the userid sa and any password. With t
his
> situation, any help is appreciated. Thanks in advance.
Maybe this helps:
http://support.microsoft.com/kb/307002/EN-US/
bye, Helmut