How to test SQL connection with Sql authentication excluding Windows authentication?

[Fajolo]

I have to connect to a SQL db with db connectivìty tool via ODBC.The server will be external and now i'm testing with a sql server installed into my pc.

I've set my sql server on a windows/sql auth. mixed mode.(there is not  a sql auth. only mode).
How can i be sure to perform a sql authentication excluding the windows authentication?

[Matthew_Williams]

We usually create a file DSN, then pass the filename into DB Tools Open Connection.vi as the connection information.  When you create the DSN you can specify the auth method, username, server, etc.

If you want to confirm that you are using sql authentication, just create a user in sql that doesn't exist in Windows and try to connect with that new user.  If you can connect, you should be all set.

Hope that helps.

Matt