November 8, 2013 at 7:10 am
I have restored from live to our test environment which are on different domains.
I know how to run a report using the system sp's to get the orphaned users but the problem i am having is that a windows login from live to test which our app uses to connect is failing with
"The login is from an untrusted domain and cannot be used with Windows authentication."
I was under the impression that orphaned users is not an issue with windows authentication in sql so i dont think this is the problem.
No matter how many times i drop and recreate the windows login in ssms it does not work. Does this have something to do with SIDS being different from the live to test and if so how would i check/test and fix this ?
Any ideas please ?
November 8, 2013 at 7:28 am
Check whether below query results are part of AD or not
select name from SYS.server_principals where type in ('U', 'G')
and name not like 'NT %'
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 8, 2013 at 7:49 am
Using the results of that query I can see that when i open Local user and groups\Users - I can indeed verify that the logins exist.
What next ?
November 8, 2013 at 7:56 am
Ive just had a thought.....would this have anything to do with the matser database holding the incorrect info ? When i did the restore from Live to Test I didn't restore the master db ? Should I have ?
November 8, 2013 at 9:42 am
Do the domains have trust set up? The test Domain must trust logins from the prod domain.
The error indicates that may not be the case.
When you added the windows logins, did you add them as PROD_DOMAIN\login_name or TEST_DOMAIN\login_name?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply