Viewing 2 posts - 1 through 2 (of 2 total)
Use this query to find out disabled windows users/groups.
SELECT name from sys.server_principals
where is_disabled='1' and type_desc like '%WINDOWS%'
January 31, 2014 at 4:17 am
#1684982
Use management studio and give target server name in the server text box, if not connects, give port number as well. it will work.
January 31, 2014 at 1:35 am
#1684948