No sysadmin access Microsoft SQL server error 18461


Login failed for user reason single user mode only one administrator can connect at this time

Microsoft SQL server error 18461


You might get a situation that no sysadmin access to SQL server and server installed by someone. Breaking SQL server and adding SA sysadmin of yourself by SQLCMD. You should be OS administrator.


First find out ‘Binn’ folder where it is installed C or D drive. Better search in my computer.

Open a CMD with administrator

Type: cd /d E:\Program Files\Microsoft SQL Server\130\Tools\Binn


1.Stop the SQL server service

2.Start the service in Single user mode by adding ‘;-mSQLCMD’ to the parameters from SQL server configuration manager — right click SQL service — property — Advance — Startup parameters.


Type: SQLCMD -S SQLserver name -E

ex: sqlcmd -S.\Instance name

USE [master]





ALTER SERVER ROLE [sysadmin] ADD MEMBER [domain\user]

GoSysadmin Access

I’m currently working as a SQL server DBA in one of the top MNC. I’m passionate about SQL Server And I’m specialized in Administration and Performance tuning. I’m an active member of SQL server Central and MSDN forum. I also write articles in SQL server Central. For more Click here

Leave a Reply

Your email address will not be published. Required fields are marked *

2 + 1 =

hacklink panel hacklink al hacklink sollet hdxvipizle resim yükleme onwin venüsbet ai nude 1xbet güncel giriş eskort yeşilköy cami avizesi seo paneli soma kömür bahis forum backlink al pgslot สล็อตเวตรง holiganbetvds
hack forum hacklink panel hacklink hacklink cami halısı cami halısı cami halısı cami halısı cami halısı cami halısı cami halısı cami halısı cami halısı saricahali.com.tr cami halısı cami halısı cami halısı cami halısı cami avizesi cami avizesi cami süpürgesi cami süpürgesi cami ısıtma cami ısıtma evden eve nakliyat ofis taşıma seo hizmeti Onwin Rulet Casino Slot Oyna Bahigo 1xbet Deneme bonusu Bahis siteleri Maç özetleri Bahsegel Canlı Casino Siteleri Sweet Bonanza Blackjack Casino Rulet Oyna Canlı Casino takipçi satın al exeboost.com smm panel santenette.com google.com.tr m