How Can I Connect With windows authentication from SQL Server instance in PC name (SQL-PC) to another SQl Server instance in Another PC name (SQL2-PC) although this two PC in Workgroup not in Domain ?????
It’s very Easy on PC no 1 Create Windows User name Admin With password 123 for Example then Go to the another Server PC no 2 then Create Windows user Name Admin With same password 123
then Add this user in SQl Server instance in PC no 1 and PC no 2 the Try to Connect Form PC no1 to PC no 2 By SQL Server it Will be Connect Direct but if you Change the User name or the password in any PC SQL Server will give you Error