x_ray,

There are two kind of security in SQL Server- Integrated and Mixed.

Integrated Security means that your SQL server will only accept Domain accounts for security

MIXED means that your SQL server will accept either Domain accounts or "local" accounts created in SQL Server.

Are you saying you want to get rid of Mixed security and move to Integrated Security?


Hal Levy
Please do your own homework.
I am here to help you, not do it for you.
I do not have sample code for anything

yes, that is what i want to do.and also i am asking if this will affect the connection to the server, and if yes how to solve it?
Sorry for any inconvenience.

x_ray- It will certainly affect the connection to the server. If your using a "sql" security account and need to change to a trusted source. You solve it by changing how you connect to your SQL server.

I don't have SQL access where I am at the moment- but I think you change it by right-clicking on the server in question and going to properties. I think it's a property on one of the sheets there.



Hal Levy
Please do your own homework.
I am here to help you, not do it for you.
I do not have sample code for anything

Hal, you are correct. If you right click the server and choose properties, there is a Security tab. You can change the mode there.

Jim

ok thanks a lot for both of you, me too i dont have access to sql server at the moment, but i will do it once i have a chance.
thanks again.