Have database made called “OPENFIRE” when creating database connection in Openfire Setup I can on get it to connect.
Steps I have taken:
-
Added port in Firewall 1433
-
Created “OPENFIRE” Database and tried w/o a Database created or designation
-
added server(computers) IP address to Host file
-
Added Port to Server Configuration on TCP/IP
-
tried host name and server name all under these different ways:
jdbc:jtds:sqlserver://[host-name]:1433/OPENFIRE;appName=jive
jdbc:jtds:sqlserver://SERVERNAME:1433/OPENFIRE;appName=jive
jdbc:jtds:sqlserver://[host-name]:1433;appName=jive
jdbc:jtds:sqlserver://SEVERNAME:1433;appName=jive
jdbc:jtds:sqlserver://SERVERNAME:1433;instance=SQLEXPRESS;appName=jive
-
VIA and PIPES are disabled
-
TCP/IP is enabled
-
Dynamic Port is “0”
-
Made sure my Database is set for “SQL Server and Windows Authentication mode”
any other suggestions
I am new to using using and creating databases but my goal is to get Spark working thus I am still learning.
Thanx.