Well, there are a number of reasons. First, you should be using the SQL
Native Provider instead of SQLOLEDB when connecting to SS 2005. Use SQLNCLI
instead.
Next, you need to make sure that the SQL Server is configured to accept
"mixed-mode" security. This is off by default during setup.
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva www.betav.com Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit
www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------
"Padmalochan Sahu" <PadmalochanSahu@discussions.microsoft.com> wrote in
message news:D60C4786-94AB-430E-A72F-3256E6AE7AA9@microsoft.com...
[quoted text, click to view] > How can i connect to SQL server 2005 from classic ASP without trusted
> connection ? I have an application in classic ASP which is currently
> connecting to SQL server 2000. with connection string as
> Driver={SQL Server};Server=Servername;Database=DBNm;user id="DD"; password
> ="ff"; it is working fine.
>
> I am getting error while connecting to SQL Server 2005. i have given
> connection string as Provider=SQLOLEDB;Data
> Source=servername\SQL2005,8701;Initial Catalog=Alps;Network=DBMSSOCN;user
> id="DFDF"; password ="FF". Can anyone send me the connection string used
> to
> connect to SQL Server 2005 from classic ASP application without trusted
> connecting.
>
> Thanks in advance
> Padmalochan Sahu
