|
Home > Archive > MS SQL Server > February 2006 > Login issues with non domain sql server
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 |
Login issues with non domain sql server
|
|
|
| I have a SQL 2005 server that is not a member of our domain
I have users that want to connect to this SQL server through enterprise
manager
I have created local accounts that are local administrators on the sql
server that I want them to use for this and not use SA
When they try to connect there is no way for them to enter in the local
account I created for them, it seems the enterprise connector automatically
just uses there account they are logged in as on there local machine, since
the SQL server is not part of the domain this does not work.
How can I have them use the SQL server local accounts instead of it
automatically trying to use domain accounts? They can connect using SA but I
need to track changes, the sql server I would rather not have to add to our
domain.
Thanks
| |
| Tom Mongold 2006-02-16, 1:23 pm |
| try creating sql accounts for them, and have them edit their registration
properties to use the sql account you assign to them.....that or add them
all(domain accounts) to a local group (not the admins group)on the server,
and then add the group to SQL...much easier....The local admins group should
be the first thing you remove from the logins in SQl server...you don't want
all the admins being SA...nor do you want everyione to be an Admin on your
SQL server either.....
"Pat" wrote:
> I have a SQL 2005 server that is not a member of our domain
>
> I have users that want to connect to this SQL server through enterprise
> manager
>
> I have created local accounts that are local administrators on the sql
> server that I want them to use for this and not use SA
>
> When they try to connect there is no way for them to enter in the local
> account I created for them, it seems the enterprise connector automatically
> just uses there account they are logged in as on there local machine, since
> the SQL server is not part of the domain this does not work.
>
> How can I have them use the SQL server local accounts instead of it
> automatically trying to use domain accounts? They can connect using SA but I
> need to track changes, the sql server I would rather not have to add to our
> domain.
>
> Thanks
>
>
|
|
|
|
|