Posted by David on 01/17/07 12:20

Hi all,

I must be going blind because i can not these options anywhere.

We have a 2005 SQL Server running, what will become a live database
asap. This is running currently within a domain. Unfortunately the
users of the database currently automatically log in using their domain
username. How can this be blocked, so that they have to use a sa style
login. (Is this setup on the ODBC driver end?).

Secondly, if we do decide to use the domain logins, how can you assign
the rights of the domain users, to the database? sa and users created
in the software, have nice interfaces to do this, but domain users
again i just cannot seem to find?

I have the MSDN installed to look at the server instructions, but if
you can point me in the right direction even in msdn it would be great
thanks.

Many thanks

David

• Next in forum: Re: SS2000 shows password in icon tooltip
• Prev in forum: Re: Trusted Security in a Workgroup
• Thread view: Domain logins to a SQL 2005 Server User Rights Assignment

[Reply to this message]