cfml

i am doing a withdoes Auth to connec to sql and also from the cf server i am using the windows Auth to connect but using windows Auth from front does not load all tables and have permisions issues, is it all due to the java driver used to connect ir or there is a way around it to have those things

Of course I have no idea what specifically is wonrg in your case, but we use windows user account to connect to SQL Server and it works fine when it's set up right.

Both humans (developers) and apps (CF and various analytics apps) all use windows logins. It does work.

i can connect using windows Auth, the main difference i noted is i do have have permissions if i run my queries from front end but in backend they run when in sql server, so i think there is some missing link which i am missing

see this is an issue i am having

[Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'Domain/Ainsley.Matthew'.

```&lt;cfdbinfo type="version" name="qryDatabaseInfo" attributeCollection="#variables.dataAttr#"&gt;```
the above is the line where i am getting an error, i tried windows sql login but it does not seems like it will work this way