Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Unable to add new account in SQL 2000

Answered Unable to add new account in SQL 2000

  • Tuesday, February 19, 2013 2:24 PM
     
     
    Sign In to Vote
    0

    I am unable to add a new account in SQL 2000, which is backend for SharePoint services

    Builtin\administrators group is added in SQL2000 and I am logged in with account, which is part of administrator on computer,

    I have also tried with moss service account and domain admin etc.

    I am unable to find password for SA or 2 other users added in SQL directly.

    What other options do I have?

     

All Replies

  • Tuesday, February 19, 2013 3:10 PM
     
     
    Sign In to Vote
    0

    So what happens when you run sp_addlogin or sp_grantaccess? If you get an error message please post it.

    What does "SELECT USER" return?

    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
     
  • Tuesday, February 19, 2013 5:28 PM
     
     
    Sign In to Vote
    0

    What operating system are you using? Vista, Windows 7, Window8, Windows Server 2008, Windows Server 2012 will all require that you select Run as administrator if you are relying on your membership in the local administrators group. After starting Management Studio once this way, you can add your individual Windows user account as a login to avoid this in the future.

    Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty

     
  • Tuesday, February 19, 2013 9:34 PM
     
     
    Sign In to Vote
    0

    Share the error message you get while adding user.

    Regards,
    Rohit Garg
    (My Blog)
    This posting is provided with no warranties and confers no rights.
    Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.

     
  • Wednesday, February 20, 2013 9:54 AM
     
     
    Sign In to Vote
    0

    Thanks for the reply

    -Its Win2003, I right click run as (uncheck run as restricited), but when I right click under security new login is grade out

    -if I click new user icon, select any account and hit okay get this error

    "Error: 22020
     Message: [SQL-DMO] You must be logged in as ‘sa’, or a member of sysadmin, or a member of securityadmin to perform this operation."

    -when I run when you run sp_addlogin, sp_grantaccess or select user 'user@domain.com', it says command completed successfully, but user not added


    -SP4 is not applied on SQL 2000 yet.
    • Edited by Beadmin Wednesday, February 20, 2013 9:55 AM
    •  
     
  • Wednesday, February 20, 2013 2:01 PM
     
      Has Code
    Sign In to Vote
    0

    Hi Beadmin

    Can you please run below query first and find what privileges u have on server or database.

    SELECT * FROM fn_my_permissions(NULL, 'SERVER');
USE AdventureWorks;
SELECT * FROM fn_my_permissions (NULL, 'DATABASE');
GO

    Permissions to create login :

    In SQL Server and SQL Server PDW, requires ALTER ANY LOGIN permission on the server or membership in the securityadmin fixed server role.

    In SQL Database, only the server-level principal login (created by the provisioning process) or members of the loginmanager database role in the master database can create new logins.

    Thanks
    Saurabh Sinha
    http://saurabhsinhainblogs.blogspot.in/
    Please click the Mark as answer button and vote as helpful if this reply solves your problem


     
  • Wednesday, February 20, 2013 2:18 PM
     
     
    Sign In to Vote
    0

    Something is not right at my end, when I run that query all I get: The commands completed successfully.

    I have sharepoint full permission, is it possible If I can add this account from front end, I have already added

    my account as farm admin and local admin on this server.

     
  • Wednesday, February 20, 2013 3:41 PM
     
     Answered
    Sign In to Vote
    0
    I never tried this on SQL Server 2000 Troubleshooting: Connecting to SQL Server When System Administrators Are Locked Out. I think it worked back them, but I'm not sure. Still it's worth a try. You will need this How to start the default instance of SQL Server in single-user mode (Command Prompt) http://msdn.microsoft.com/en-us/library/aa178018(v=sql.80).aspx

    Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty