Hello Team,
I have tried to configure DSA server in one environment but it is failing to connect to the Primary Server .
Telnet on port 52311 , 1433 is working bi-directional between Primary & Secondary Servers .
From Sencondary Server able to connect to Primary Server DB using Management Studio - Vise - Versa.
On Secndary Server , console is not able to launch and it gives error as unable to connect to DB.
Replication Graph shows Red in colour in both the Servers .
FillDB error-
Replication connection attempt failed for server âMXXXXXXX.nixt.domain.comâ: Database Error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user âNixt\MXXXXXXX$â
Has any one faced such issue ? Your expertise would be appreciated
Thank you so much in Advance!
Vishnu
It looks like youâre using a computer account (LocalSystem will authenticate as DOMAIN\computername$).
That can be made to work, but requires some setup. On the Domain, you should create a group containing both DSA serversâ computer objects. On each SQL server, ensure this group has the âAccess this computer from the networkâ right in Local Security Policy. In the SQL Server Management Studio, create a Login for this group and assign it the rights required for DSA database access (which I donât recall, but Iâm pretty sure are documented in the DSA server setup guide).
To test, obtain psexec from www.microsoft.com/sysinternals. Open a command prompt, and then use psexec to open a new command prompt in SYSTEM context - psexec -s -i cmd.exe
From this SYSTEM command prompt, launch SQL Server Management Studio and ensure you can connect to both SQL servers.