Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jayam.cnu
Starting Member
45 Posts |
 Posted - 2013-10-24 : 08:45:48
|
| Hi,We've come across an issue by connecting to the Server. Because, the Sysadmin Login been dropped from the Server which was only the Login with administrative permissions and remaining ones having DB level permissions.Now, we are unable to connect the Server with admin Login to perform Server level activities.May I know any workaround for this issue?. Please suggest, it is an emegency.Sreenivasulu.p,Mail ID: sreenivas.puliverthi@gmail.com |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-10-24 : 08:59:38
|
| Use DAC connection. http://technet.microsoft.com/en-us/library/ms178068(v=sql.105).aspxBe sure to login as a windows admin user and run the SQL Server Management Studio as administrator. As described on that page, connect to Database Engine Query (not to database engine). |
 |
|
|
|
|
|
Sysadmin Login been dropped from the Server