May 12, 2018 at 6:32 pm
Just built Windows 2012 R2 two Node Cluster SQL 2012 Enterprise
I have three databases added
1, Veeam Enterprise Manager Software using SQL Database running on a Windows 2012 R2 Server connecting remotely and works great
2. ORF Fusion Software for Exchange 2010 on Windows 2008 the SQL Database connects to a Windows 2008 R2 and SQL 2008 Enterprise Server works fine there
3. Manage Engine Ad Manager using SQL Database Running on Same Server as Number 1 and uses the same SQL Server as Number 2
Task is to move databases Number 2 & 3 to the luster SQL server.
I stopped the services and detached the databases from the SQL 2008 Server
I attached the SQL databases to the SQL Cluster server.
Created the logons required by each software product.
When I started the service I get failed to connect messages.
ADManager that Fails
transaction_isolation = TRANSACTION_READ_COMMITTED
sqlgenerator = com.adventnet.db.adapter.mssql.MssqlSQLGenerator
url = jdbc:jtds:sqlserver://SERV014-N1-SQLC:1433/ADManagerDB;ssl=request
dbadapter = com.adventnet.db.adapter.mssql.MssqlDBAdapter
username = sa
exceptionsorterclassname = com.adventnet.db.adapter.mssql.MssqlExceptionSorter
maxsize = 20
drivername = net.sourceforge.jtds.jdbc.Driver
minsize = 1
password = 0e09d8c940fe7404e8665a43de89a943
ADManager that works
transaction_isolation = TRANSACTION_READ_COMMITTED
sqlgenerator = com.adventnet.db.adapter.mssql.MssqlSQLGenerator
url = jdbc:jtds:sqlserver://SERV010:1433/ADManagerDB;ssl=request
dbadapter = com.adventnet.db.adapter.mssql.MssqlDBAdapter
username = sa
exceptionsorterclassname = com.adventnet.db.adapter.mssql.MssqlExceptionSorter
maxsize = 20
drivername = net.sourceforge.jtds.jdbc.Driver
minsize = 1
password = 0e09d8c940fe7404e8665a43de89a943
ORF that works
Provider=sqlncli10;server=serv010,1433;database=ORF;UserId=orfuser;Password=myeyesonly55;DataTypeCompatibility=80;
ORF that fails
Provider=sqlncli10;server=serv014-N1-SQLC,1433;database=ORF;UserId=orfuser;Password=myeyesonly55;DataTypeCompatibility=80;
Any way I can test the SQL connection remotely from the two computers?
Any ideas
Thank you
Tom
May 14, 2018 at 5:56 am
Hi,
you can use an udl file:
https://blogs.msdn.microsoft.com/farukcelik/2007/12/31/basics-first-udl-test/
It is quite simple to use
best regards,
Andreas
May 14, 2018 at 7:02 am
Please post the text for those error messages. Also check the SQL Server error log and post the details for the errors.
Sue
May 14, 2018 at 2:39 pm
Thank you for responding.
I had to install SQLNCLI11 on the Exch and I had to change the SQL Server Authentication Mode to MIXED
Now I can connect.
Thank you for all the help
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply