|
Home > Archive > MS SQL Server > February 2006 > SQL Server 2000 Permmission
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Server 2000 Permmission
|
|
| Juan Fontanet 2006-02-17, 7:23 am |
| I have a Windows 2000 Domain, Sql Server 2000, Visual Basic 6.0. This is the
problem when the user have Domain Admin he can use the database without error
connection. When i Change the windows 2000 user account permission to Domain
User the system show an error connection.
I want that all my user have only domain user.
Thank You
| |
| DBADave 2006-02-17, 7:23 am |
| What is the specific error message?
"Juan Fontanet" wrote:
> I have a Windows 2000 Domain, Sql Server 2000, Visual Basic 6.0. This is the
> problem when the user have Domain Admin he can use the database without error
> connection. When i Change the windows 2000 user account permission to Domain
> User the system show an error connection.
>
> I want that all my user have only domain user.
>
> Thank You
>
| |
| Adam Warne 2006-02-17, 9:23 am |
| Hi Juan,
As Dave has asked, details of the error would help.
However, without those details I'd guess that the domain user you've set up
hasn't got a login set up withing SQL. As a default install SQL sets up a
BUILTIN\Admininstrat
ors group, which allows administrators of the domain to
log into sql. If you want to let non-admin users connect to sql you have to
set up a user under the Security->Logins page within sql. You can either set
up a login linked directly to the user account or via a group membership that
the user is a member of.
If this is your problem and need more help, just let me know.
HTH
--
Adam J Warne, MCDBA
"Juan Fontanet" wrote:
> I have a Windows 2000 Domain, Sql Server 2000, Visual Basic 6.0. This is the
> problem when the user have Domain Admin he can use the database without error
> connection. When i Change the windows 2000 user account permission to Domain
> User the system show an error connection.
>
> I want that all my user have only domain user.
>
> Thank You
>
| |
| Juan Fontanet 2006-02-17, 1:23 pm |
| Thank You for your answer. I add a domain user group to sql and it resolve
the problem
"Adam Warne" wrote:
[color=darkred]
> Hi Juan,
>
> As Dave has asked, details of the error would help.
>
> However, without those details I'd guess that the domain user you've set up
> hasn't got a login set up withing SQL. As a default install SQL sets up a
> BUILTIN\Admininstrat
ors group, which allows administrators of the domain to
> log into sql. If you want to let non-admin users connect to sql you have to
> set up a user under the Security->Logins page within sql. You can either set
> up a login linked directly to the user account or via a group membership that
> the user is a member of.
>
> If this is your problem and need more help, just let me know.
>
> HTH
> --
> Adam J Warne, MCDBA
>
>
> "Juan Fontanet" wrote:
>
|
|
|
|
|