General discussion



By regan.anderson ·

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!


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by regan.anderson In reply to OSQL

Point value changed by question poster.

Collapse -

by p.j.hutchison In reply to OSQL

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.

Collapse -

by regan.anderson In reply to

Poster rated this answer.

Collapse -

by regan.anderson In reply to OSQL

This question was closed by the author

Related Discussions

Related Forums