Hi Todd.
I've had this before. Cetin is correct, I think. Do a Google on the error message and you will find a white paper on it.
In the Enterprise manager, right click on the server, select properties, select the Security tab and be sure that the Authentication is set for SQL Server and Windows. I think you have it on Windows only.
- Glen -
>Greetings,
>I am unable to connect to my SQl Database with this connection string (see below) from within a C# program. Same parameters work fine in SQL Query Analyzer when connecting.
>
>This is the code:
>
>public class DataAccessSql : DataAccessBase
>{
>public DataAccessSql()
>this.ConnectionString= "server=myserver;uid=sa;pwd=mypass;database=Northwind;";
>
>Many thanks, Todd
- Glen -
The impossible we do immediately.
The miraculous will take a little longer.