How to Find and Fix Orphan Users in SQL Server || Ms SQL

Подписаться 13 тыс.

Просмотров 16 тыс.

50% 1

A database user for which the corresponding SQL Server login is undefined or is incorrectly defined on a server instance cannot log in to the instance. Such a user is said to be an orphaned user of the database on that server instance.
In this video i have shown 5 ways(with demo) to solve the issue of orphan users. Please do watch and subscribe to my channel.
How to Create login
click to watch: • How to create login in...
Roles in SQL server
click to watch : • Server roles , Databas...
sp_help_revlogin script : support.micros...
Data Migration tool
Dwonload: www.microsoft....

Опубликовано:

28 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 32

@chitranjankumar5011 3 года назад

Explained very well, So useful. Thanks for making such detailed video.

@vishwavishu8297 2 года назад

Very clean explanation.

@pathakalajayasree2661 4 года назад

Really good ,in detail explanation ....do more such videos

@righttolearnbk 4 года назад

Sure 😊

@kesavalur 3 года назад

Superb informative & detailed explanation 👋🏼

@dhirajkumar27 3 года назад

Excellent bro, do make this type of video in mirroring

@amitbhardwaj8801 2 года назад

Sir , kindly create a video on sql server architecture, if possible. And thanks a lot to sharing knowledge in simple way.

@righttolearnbk 2 года назад

Noted.

@appuaparna7360 Год назад

i really liked u r explanation,i like dma tool to do this

@rahulshende6073 2 года назад

Thanks a lot for detail explanations......

@Aswhole420 3 года назад

excellent video, last data migration technicque is easy

@Aswhole420 3 года назад

Can you please make a video on replication in mysql datbase

@abhay6276 Год назад

Hello Balu, Can you please tell us, How did you connect server which you restored the database on SSMS tool? what does it Means ? it means How did you add Multiple instances on SSMS?

@righttolearnbk Год назад

I installed two instances in my local machine and hence I am unable to connnect

@abhay6276 Год назад

@@righttolearnbk sir, it means you install two sql server with different version? Am i right sir?

@victor63708 2 года назад

Thank you, you really helped me!!

@sagarkashid123 3 года назад

Can we migrate only logins with server level permissions using DMA or any other tool.Dont want to migrate db.Db already migrated

@mohammadjunaidshaik207 3 года назад

Really awesome sir

@ravulakishan5998 3 года назад

brother in logshipping in secondary server i have restored new ndf with move option with recovery , the database comes standby to online , how to change the mode to standby again

@righttolearnbk 3 года назад

Go to primary and right click on database, options, ship transaction logs, configure settings

@pathakalajayasree2661 4 года назад

good one balu

@ravulakishan5998 3 года назад

excellent brother, do videos for running profiler also

@righttolearnbk 3 года назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-IcIXGaFWEco.html

@aneesashaik1850 2 года назад

Excellent explanation

@babuvenugopalan3089 2 года назад

Sir, can you please make some videos on performance tuning (cpu, memory & slow running queries)

@dba3579 2 года назад

Well explained and organized. Thanks for sharing. Do you have or could you make a video explaining how to drop a user who owns objects and how to change object ownership in order to drop user and\or login.