Re: 2000k connect from outside domain
- From: Simon Worth <REMOVEFIRST_simon.worth@xxxxxxxxx>
- Date: Mon, 04 Apr 2005 18:33:14 -0600
You cannot fill in the user name and password because by doing so you are telling the login process to use SQL Server Authentication rather than windows authentication, and you would need a SQL Server authenticated login to do so.
You can set up SQL Server to use mixed mode authentication where it accepts login requests for both windows authenticated users and SQL Server authenticated users, but that is less secure.
Simon Worth
Datasort wrote:
Login Problem:
Trying to log into a 2000K SQL Server using a windows user account when not logged into the domain.
Is this possible?
Example:
Domain Account is : aaa Password is: password Domain is: domain1
On the Server Box1 have a windows user account called : \domain1\aaa with a type of windows user.
I can also ping Box1
I want to use query manager to log into the box or enterprise manager 2000K. I have tried to fill in user ID and password with
aaa passord
And \domain1\aaa
password
Neither work. Any help would be appreciated
Thanks in advance,
Stewart Rogers
.
- References:
- 2000k connect from outside domain
- From: Datasort
- 2000k connect from outside domain
- Prev by Date: 2000k connect from outside domain
- Next by Date: missing DTS connections
- Previous by thread: 2000k connect from outside domain
- Next by thread: missing DTS connections
- Index(es):
Relevant Pages
|
