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

I called MS tech support and got an answer I like better. In Management
Studio, I added my domain account under the Security\Logins page. Works
like a champ.

- Bob

"Bob Altman" <rda@xxxxxxxxxx> wrote in message
news:es7BmUGTHHA.4844@xxxxxxxxxxxxxxxxxxxxxxx
Hi Charles,

Let me make sure I understand this correctly. My PC is a member of a
domain. I have SQL Server 2005 running on my PC, using Windows
Authentication. If I log on to my PC (that is, the PC hosting SQL Server)
as local admin, I can connect to the server. But if I log in to that same
PC as a non-privileged domain user, I can't.

If I understand your answer correctly, I can't configure SQL Server to
allow my non-privileged account access to it (short of using SQL Server
Authentication); I must grant some set of privileges to my non-privileged
account on my PC in order to allow that account to connect to the server.

Is this correct?

"Charles Wang[MSFT]" <changliw@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:6WgJ9QCTHHA.2356@xxxxxxxxxxxxxxxxxxxxxxxxx
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: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)
  • Re: SharePoint V3 Install Error
    ... But it our case it had to do with Group Policies that forbid the account of ... WSS FAQ:www.wssv3faq.com/wss.collutions.com ... Event Source: WindowsSharePointServices3Search ... whatever you are installing WSS as sufficient rights to the SQL Server ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: How to access SQL Server from a non-privileged domain account
    ... account to be able to access the SQL Server. ... Since your SQL Server 2005 has been running with Windows Authentication ... Contact your network administrator to add your domain account to the ... Change your SQL Server 2005 authentication mode to Mix mode so that you ...
    (microsoft.public.sqlserver.setup)
  • RE: Problems with WebParts
    ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Cannot connect to Query Analyzer
    ... For Query Analyzer, I tried replacing the file as you suggested but had the ... same results (Enterprise Manager starts up fine, ... I created an account on my laptop and changed SQL ... Try replacing the MMC app for SQL Server from the original ...
    (microsoft.public.sqlserver.connect)
Loading