Hello,
I am trying to run a query on MS SQL Server 2000 using OSQL and am running into the following error:
Login failed for user ‘test’. Reason: Not associated with a trusted SQL Server connection.
I have found articles that suggest changing the security to mixed mode instead of Windows only. I have a couple questions in regards to that.
1. Is there a way to connect using Windows only mode, if so how?
2. Is there any downtime when switching to mixed mode (i.e. do I need to restart any services, reboot the server, etc?)
3. Do any of the existing connections to the server need to be reconfigured if I change to mixed mode?
I would really appreciate a way to do this without changing to mixed mode, but if that is not possible, the option is there.
Thanks for your help!
-Regan
