please, help me. I am trying to start DSA architecture between two servers and still without any success…
I have two SQL Servers 2008 Express on MS Win Server 2003 installed. According to TEM_Admin_Guide_81 I have create a db user, register values, have restarted FillDB,…
During installation process on the second server I fill db connection to the master server, again create the (same) db user for replica db, reg values, restart FillDB…
From Administration Tool on the second server I can see in the Last Replication Status column this text:
"Database Error: The action site has not been created. -
date & time here
"
and also info that the “connection broken”…
Can you help me where I did some mistake? Where are the logs from that connection process, etc. ?
I found my error. It was misconfiguration on the database side…
But please, could you explain me more deeply how does the DSA work? I read Admin guide, etc… but I did not find more details about it. Does it work more on TEM level or on db level, how, who, when, why… ?
repair… I was able to start DSA with SQL Server 2005 Express, but I am not able to do this with SQL Server 2008 Express. Sorry, I have a lot of test images…
sure! I have read this as well as the Admin guide pdf…
But there is nothing about how it works (not so much). Is the synchronization based on the SQL server processes, or TEM server services do the big part of the job - let’s say FillDB service (I hope I partially know what is done by this process but I don’t know its exact role during replication)…? During the installation, is the replication between that databases set up (on the database level) or are there only two (three,…) instances of databases and all the work is done by TEM servers?
Are there some detailed instructions like here about network traffic?
and please, tell me… Which information is more up to date because on the wiki site you sent there is no info in requirements about support of SQL Server 2008 (there are mentioned only version 2000 and 2005)? In Admin guide which seems to be from 28.2.2011 there is nothing about requirements…
SQL Server 2008 is supported as well as for DSA, sorry for my question regarding requirements - finally, now I am able to set up DSA with SQL Server 2008 (it was bad configuration on the database side).
But my question regarding the deeply information about DSA is still valid, also for the others
Can you share me what are the database configuration you done on TEM, bcz i am also facing the same issue replication is not happening from my side also .
As far as my memories (but I’m not confident with it) in my case just the Windows authentication was enabled and then the DSA failed to connect with each other by the SQL Server authentication.
If you’d like to use the SQL Server authentication, make sure to have SQL server installed with the mixed mode.
