I am using Visualstudio.net 2003 as front end and Microsoft SQL Server 2000 (MSDE) as a back end.

i would like to use SQLDMO object. While connecting the SQLDMO object it is giving an error

"Connection problem. Cause: Trusted Sql Server Connection not found"

My code is

Dim ObjSqlDMO as new SqlDMO.SqlServer

ObjSqlDMO.Connect(".","sa")

even i have tried the servername as Machine Name and "(local)" also it is giving the same error.

How can i enable the "Trusted Connection"

Please help me.

Madhan