> vb adodc connect sql server
> no problem if use windows nt integrated security
> but when tried to connect using sa or other users
> it always reports login failed
> why

> Hi,

> I think your SQL Server configured to support integrated security, not SQL
> Server or combined authentication. You would need to reconfigure it to
> support it, but not sure if you could do that without reinstalling SQL
> Server

> --
> Val Mazur
> Microsoft MVP

> > vb adodc connect sql server
> > no problem if use windows nt integrated security
> > but when tried to connect using sa or other users
> > it always reports login failed
> > why

> No, you do not need to reinstall.

> http://mvp.support.microsoft.com/default.aspx?scid=kb;en-us;Q285097

> --
> -oj
> Rac v2.1 Public Beta is RELEASED.
> http://www.rac4sql.net

> > Hi,

> > I think your SQL Server configured to support integrated security, not
SQL
> > Server or combined authentication. You would need to reconfigure it to
> > support it, but not sure if you could do that without reinstalling SQL
> > Server

> > --
> > Val Mazur
> > Microsoft MVP

> > > vb adodc connect sql server
> > > no problem if use windows nt integrated security
> > > but when tried to connect using sa or other users
> > > it always reports login failed
> > > why