RE: How to access SQL Server from a non-privileged domain account

Hi,
Per my understanding, your SQL Server 2005 was configured to run with
Windows Authentication mode, but you wanted your non-privileged domain
account to be able to access the SQL Server.
If I have misunderstood, please let me know.

Since your SQL Server 2005 has been running with Windows Authentication
mode, previledged domain accounts are neccesary for connectivity.
For your situation, you may consider the following resolutions:
1. Contact your network administrator to add your domain account to the
trusted users and assign permissions on it;
For different domains, it is required to establish domain trust
relationship first and you may have a new post at:
microsoft.public.windows.server.active_directory

2. Change your SQL Server 2005 authentication mode to Mix mode so that you
can use a SQL Server account to connect to the instance.
Please refer to:
How to: Change Server Authentication Mode
http://msdn2.microsoft.com/en-us/library/ms188670.aspx

If you have any other questions or concerns, please feel free to let me
know.
Look forward to your response.

Charles Wang
Microsoft Online Community Support

======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

.

Relevant Pages

  • RE: IIS 6 and Windows Authentication to SQL Server 2000
    ... If you are truly using Windows Authentication, ie a user has an account on ... You may mean "bastardized windows authentication", meaning SQL Server uses ... I've read where mirroring the> ASPNET account and password on the web server and SQL server would> work. ...
    (microsoft.public.sqlserver.connect)
  • RE: IIS 6 and Windows Authentication to SQL Server 2000
    ... If you are truly using Windows Authentication, ie a user has an account on ... You may mean "bastardized windows authentication", meaning SQL Server uses ... I've read where mirroring the> ASPNET account and password on the web server and SQL server would> work. ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Login failed for user (null). Reason: Not associated with a
    ... > Windows Authentication, but then I changed it to the sa account to connect my ... make sure that both BOTH SQL Server and Windows Authentication are ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: How to access SQL Server from a non-privileged domain account
    ... If I log on to my PC (that is, the PC hosting SQL Server) ... PC as a non-privileged domain user, ... allow my non-privileged account access to it (short of using SQL Server ... Windows Authentication mode, but you wanted your non-privileged domain ...
    (microsoft.public.sqlserver.setup)
  • Re: connecting to sql remote database
    ... You can connect to a remote SQL Server using Windows Authentication, ... account can not connect to any resources that are on other computers. ...
    (microsoft.public.sqlserver.connect)