Customer login  |   Contact us
Home Company Products Support Purchase
Forum Home » Survey software » Opinio

Topic: Problems connecting to MS SQL Server DB
Replies: 0   Pages: 1  


Back to Topic List Back to Topic List
Replies: 0   Pages: 1  
mark.dixon@tis.tas.gov.au

Posts: 1
Registered: Jun 21, 2012
Problems connecting to MS SQL Server DB
Posted: Jun 21, 2012 3:10 AM
  Reply
attachment1.jpg (151,0 K)
attachment2.txt (1,0 K)
attachment3.txt (2,1 K)

Hi guys, we are having some issues connecting to an ms sql server database for Opinio. When using the default internal database Opinio webpage can be accessed and seems fully operational.But when we try to use the MS SQL database we get the following error when connecting to the webpage (see attachment1).

Using the database_sqlServer.properties file we have entered the correct server, port, db name, user name, and password, and then renamed this file as database.properties (see database.properties as attachment2).

we have test connected to the SQL database opinio with the opinio username and password and this connected correctly and has fulldbo rights.

When creating the opinio database we ran the sqlserver_create.sql script which executed without errors.

Software versions:
tomcat 7.0.28
jdk-7u5
Opinio 6.6
sqljdbc 4.0.2206

opinio server = windows 2008r2 64bit
SQL server = windows 2008r2 64bit, MS SQL 2008

Opinio Log file is attached (attachment3).

If anyone has any ideas on what I can try to resolve this issue then it would be greatly appreciated.

Mark.



© 1998-2019 ObjectPlanet, Inc. Øvre Slottsgate 5, 0157 Oslo, Norway Tel (+47) 2233 3360 | Fax (+47) 2233 3361