Discussion Locked

OSQL

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

4 replies

by p.j.hutchison

1. Yes but preferably with domain rather than local usernames, you need to configure access to DBs for specific users or groups of users using Security Groups.
2. I shouldn't think so.
3. No, I don`t think so.

This discussion is closed to new replies.