Microstockr istock login fail8/1/2023 ![]() ![]() This is how the linked server is configured on Server1: EXEC _addlinkedserver = N'server2', Server'ĮXEC _addlinkedsrvlogin _serveroption compatible', _serveroption access', _serveroption _serveroption _serveroption _serveroption out', _serveroption _serveroption timeout', _serveroption name', _serveroption schema validation', _serveroption timeout', _serveroption remote collation', _serveroption proc transaction promotion', Server1 the MSSQLSERVER service (sqlservr.exe) runs under user called NT Service\MSSQLSERVER. I can Remote Desktop to both of them using other_domain\my.name user with a different password than my main domain user. The Server1 and Server2 themselves are not in MAIN_DOMAIN, they are in other_ Server2: CREATE LOGIN FROM WINDOWS WITH DEFAULT_DATABASE=, DEFAULT_LANGUAGE= Server1: CREATE LOGIN FROM WINDOWS WITH DEFAULT_DATABASE=, DEFAULT_LANGUAGE=ĪLTER SERVER ROLE ADD MEMBER When I run SSMS on my laptop I can connect to both Server1 and Server2 using Windows authentication.Īs far as I understand, my login in both SQL Servers has pretty much all the permissions: Our company has a domain MAIN_DOMAIN and I log into my Windows laptop as MAIN_DOMAIN\my.name. 0 (X64)Įnterprise Edition: Core-based Licensing (64-bit) on Windows Server 2016 Datacenter 10.0 (Build 14393: ) (Hypervisor) Standard Edition (64-bit) on Windows NT 6.3 (Build 9600: ) (Hypervisor) ![]() There is Server1: Microsoft SQL Server 2012 (SP4) (KB4018073). I don't really know where to look, so I'll try to explain the current setup to the best of my ability. I'm a developer trying to run some queries and I'm having hard time trying to figure out how to configure access correctly. Our company doesn't have a SQL Server DBA and we have inherited a few SQL Servers from another company after acquisition. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.īut, there is another user who can run this query without problems. When I try to run a simple query involving a linked server it fails: SELECT * FROM. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |