Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / DB Engine / SQL Server / March 2008

Tip: Looking for answers? Try searching our database.

Recovering SA Password or Adding sysadmin Login

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
sacgar - 15 Mar 2008 23:01 GMT
Hi,
Recently some body played with our SQL Server and removed our Sys admin
group login and we dont have builtin\admin as login and no SA Password
can any body tell the way to come out with this situation to change the SA
Password or create our Group back with Sys admin priviledges.
also to confirm we are still in NT admin group for the server.
below article talk about similar case but as soon as i try to run sqlcmd
utility after taking server in single mode as per article ,it throws error
that you cant run sqlcmd since server in Single user mode.
Any help is appreciated...
sacgar - 15 Mar 2008 23:05 GMT
> Hi,
> Recently some body played with our SQL Server and removed our Sys admin
[quoted text clipped - 6 lines]
> that you cant run sqlcmd since server in Single user mode.
> Any help is appreciated...

Adding Link
http://blogs.msdn.com/raulga/archive/2007/07/12/disaster-recovery-what-to-do-whe
n-the-sa-account-password-is-lost-in-sql-server-2005.aspx

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.