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



Not Connected

Not Connected

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.