Sessions: 216 The postings on this site are my own and do not represent my Employer's positions, advice or strategies.

LifeAsBob

  Monday, January 18, 2021
Wider View Login

Cluster
DOS
IBM - AS400
MOM
Performance Counters
Service Broker
SQL Server
     Temporary Database
     Views
     Backup
     SQL Mail
     DTS - Data Transformation Services
     Memory
     Security
     Excel
     Jobs SQL Agent
     MSDE
     Install
     DBCC
     User Management
     System Databases
     BCV
     Deadlocks
     Temp Tables
     Find the physical se...
     Enable xp_cmdshell
     Intermittent Connect...
     Connection String Pr...
     Login Error ( State)...
     Turn Default Tracing...
     Re-index fails when ...
     SMO AND DMO
     Tracing of Errors
     Extra carriage Retur...
     Query to find Object...
     Named Instance Port ...
     Adding Domain Login ...
     Rename Logical File ...
     Error 3624 Delete st...
     SQL DMO Error 21776
     NetworkConnections
     SQL Server Service m...
     Trace Flags for Dead...
     Change Server Name
     Alternate to Count(*...
Windows OS


Will be added as a sub-category of, SQL Server
Adding Domain Login Fails
When trying to add the following domain account to SQL Server the following error occured: Error 15401: Windows NT user or group 'hrbinc\472683' not found. Check the name again. Using the following commands I was able to show the security identification number (SID) for hrbinc\a472683 was also associated with hrbinc\x1211 In this instance a contractor was converted to a full-time employee and was already a user on the SQL Server as hrbinc\x1211 Commands: select suser_sid ('hrbinc\A472683') select name from sysxlogins where sid = suser_sid ('hrbinc\A472683')