July 7, 2015 at 5:47 pm
I am trying to connect to an sql server instance that is on a desktop machine running windows 7 Pro form a laptop running windows 7 Pro using ssms . When I start the ssms and enter the machine name\sql server instance name and select "connect" I get a error message "Login Fail; this login is from an untrusted domain and cannot be used with Windows authentification" Error 18452. I am not using active directory. Any ideas on what to start checking?
July 8, 2015 at 3:23 am
jwanutt (7/7/2015)
I am trying to connect to an sql server instance that is on a desktop machine running windows 7 Pro form a laptop running windows 7 Pro using ssms . When I start the ssms and enter the machine name\sql server instance name and select "connect" I get a error message "Login Fail; this login is from an untrusted domain and cannot be used with Windows authentification" Error 18452. I am not using active directory. Any ideas on what to start checking?
From your description it sounds like you are trying to use Windows Authentication. As you are not using AD you need to create a SQL login on the SQL Instance on the desktop machine that has the required server role membership \ database role membership. Then when connecting from the laptop supply the SQL login name and password when connecting using SQL Server Authentication.
MCITP SQL 2005, MCSA SQL 2012
July 8, 2015 at 10:04 am
Thanks. Are you saying since I don't have AD then I must use sql server authentication?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply