RE: SQL Server Authentication Question (easy I think)

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: skitrees (skitrees_at_discussions.microsoft.com)
Date: 02/24/05 

Date: Wed, 23 Feb 2005 16:09:01 -0800

James,

Thank you for your response!!

What I had done was setup (in Active Diretory) a user named Domain\User1.
Then, I went to the SQL server and under local users and groups, I added
domain\User1 as part of the of the admin group.

I then opened SQL and set the security on the specified database to allow
Domain\User1

Is this correct, or twisted?

Thanks
 

Relevant Pages

  • RE: Installation
    ... To run Unattended SQL Server setup at Command Prompt, ... How to record an unattended installation file ...
    (microsoft.public.sqlserver.setup)
  • RE: Problems upgrading SQL MSDE for Sharepoint
    ... Please try the following steps and then run the SQL Server 2000 setup again: ... Can we install SQL Server successfully at this time? ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: Keeping User From Deleting Table Records
    ... Hugo - Your comment about the user being a member of an admin group did the ... - I have created a new Windows user login in Security/Logins that is ... SQL Server to obtain default settings for the additional configuration ...
    (microsoft.public.sqlserver.security)
  • RE: setupsql.exe hangs. Cannot Install SQL server 2K
    ... Q. When I run the SQL Server 2000 setup, ... Q. What should I do if the installation of SQL Server 2000 is unsuccessful? ... Access Components (MDAC) setup, which is launched as part of the SQL Server ...
    (microsoft.public.sqlserver.programming)
  • Re: x64 2003 Cluster - SQL2000 named instance fail
    ... one the settings are not detected by the setup. ... > in the cluster log you will notice the a connection to the SQL Server ... > named instance cannot be established. ... >> Microsoft highly recommends that users with Internet access update their ...
    (microsoft.public.sqlserver.clustering)