Open/Close menu
Products & services
Close menu
Back
Products & services
SaaS
Close menu
Back
SaaS
SaaS solutions
Read product guides and documents for IdentityNow and other SailPoint SaaS solutions
AI-Driven identity security
Get better visibility and understanding of your identity and access data
SaaS release notes
View new SaaS features, enhancements and fixes
Software
Close menu
Back
Software
IdentityIQ server software
Simplify the management of on-premise or cloud based applications
File Access Manager
View documentation and download recent releases
Integrations
Close menu
Back
Integrations
Connector directory
See listings of common connectors used across SailPoint's platforms
Customer Success Center
Close menu
Back
Customer Success Center
Overview
Get to know your customer success team and your available resources
Onboarding guide
The support you need to get started on your SailPoint journey
Success planning guide
Get the most out of your identity security program with a customized success plan
Resources
Close menu
Back
Resources
Getting started
Close menu
Back
Getting started
New to SailPoint
Get tips for IdentityIQ, SaaS products and more
Customer support
Here you can find more information about how to log a support ticket and get help
Services
Here you can find more information about our team and services
Education
Close menu
Back
Education
Identity University
Get technical training to ensure a successful implementation
Training
Discover our training paths and other learning opportunities
SailPoint professional certifications
Earn certifications that validate your product expertise
Blogs
Close menu
Back
Blogs
The SailPoint blog
Community
Close menu
Back
Community
Discussion
Close menu
Back
Discussion
Knowledge
Close menu
Back
Knowledge
IdentityIQ wiki
Discover crowd sourced information or share your expertise
IdentityNow wiki
Discover crowd sourced information or share your expertise
File Access Manager wiki
Discover crowd sourced information or share your expertise
Submit an idea
Get writing tips curated by SailPoint product managers
Network
Close menu
Back
Network
Events and webinars
Check out SailPoint's Compass community events hub
Become an admiral
Join the Admirals Club and network with SailPoint crew and customers
Community Corner
Close menu
Back
Community Corner
Customer Success Engineering
Meet the team and see their responses to most frequent customer FAQs
SailPoint community benefits
Learn, collaborate, and celebrate your achievements
Sign In
Help
All community
This category
Knowledge base
Users
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Show
only
|
Search instead for
Did you mean:
Compass
:
Products
:
File Access Manager
:
File Access Manager Wiki
:
Recover system admin permissions
Options
Article History
Subscribe to RSS Feed
Mark as New
Mark as Read
Bookmark
Subscribe
Printer Friendly Page
Report Content to Moderator
Recover system admin permissions
Recover system admin permissions
General
Permissions
Solution Steps
Detailed steps
Single User Mode
SQL Command Line
Create New Account
Assign sysadmin
General
Permissions
Local administrator password for the SQL Server.
Access to the server's console.
Solution Steps
Start the SQL Server in SINGLE_USER mode (from command line or from the configuration manager).
Open CMD using administrator's account.
(optional) Create a new account.
Assign the designated account the
sysadmin
server role.
(optional) Reset the SA password.
Return the server to MULTI_USER mode.
Detailed steps
Single User Mode
Open the "SQL Configuration Manager Console".
Navigate to "SQL Server Services"
Right click on the specific instance and choose properties.
Navigate to "Advanced" tab to the "Startup parameters" attribute.
Add "-m;" before the existing string.
Restart the SQL Server.
Verify that no other user is trying to connect because in SINGLE_USER only a single user can connect at a time.
SQL Command Line
Using the Administrator account run from CMD
sqlcmd –S <host\instance>
Create New Account
Create LOGIN '<username>' WITH PASSWORD '<password>'
Assign sysadmin
SP_ADDSRVROLEMEMBER '<username>','sysadmin'
Version history
Revision #:
2 of 2
Last update:
May 29, 2023
07:44 PM
Updated by:
darylclaude_med
ina
View Article History
Contributors
darylclaude_med
ina