Hello,

I have a WF8 Server and try to install the Client part on it but want the Repository to be placed on an existing MS SQL Server instead of the Derby Database provided by IBI.
Shouldn't be that hard, but I always get a pretty generic connection error after configuring the Database and I can't figure out what's wrong. Hopefully, someone here has done this and can point me in the right direction.

I created an empty Database on a separate Instance of SQL Server 2012 Enterprise, running on a fixed port. I created a windows user for this, gave it db_owner rights (and even made it sysadmin on that instance by now). I can telnet the port from the WF Server, the user can fully access the database via SQL Server Management Studio. So it shouldn't be the Database or the user rights.

I have installed the MS SQL JDBC Driver pack 4.1 on the WF8 Server. During setup I selected SQL Server 2012 as the database and plugged in the data on the database configuration page. I left the field JDBC Driver as it was (com.microsoft.sqlserver.jdbc.SQLServerDriver) and used sqljdbc41.jar in the JDBC path, but tried sqljdbc4 and sqljdbc as well. When I continue, I get the error "Database connectivity failed, Please ensure that your database is running and the correct values were entered for the database".

Does anyone have any ideas what could be wrong here?

This message has been edited. Last edited by: Kai Peters,

There is probably a log file in your home-directory that details what went wrong when the install tried to connect to the DB.

I had the same issue during my install, but I also had other issues too with my install of 8.1.3. Right now I have everything running with a SQL 2008 repository, but I am running with sqljdbc4.jar.

I will change up and see if I can run against a SQL 2012 and let you know what I come up with.

Are you trying to connect to a native MS SQL data base, or a named instance. If it is native (jdbc:sqlserver://serverNameort) then you shouldn't have any problem. If you are connecting to a named instance (jdbc:sqlserver://serverName\instanceName), then you may have to do it in multiple steps. For named instances, I install with derby then configure MS SQL after, then finally uninstall derby. If this is the case, then open a problem ticket to get the instructions.

dhagen - I never thought about that approach for named instances. I have always had a problem with doing an install with named instances, so I always went back to my DBA's asking not to do that.

I am now connected to a 2012 SQL database. I updated it in my admin console and bounced my client. I am using the 4.0 jar and not the 4.1.

Hi Kai,

do you have your REPOSITORY_DATABASE_NAME=webfocus as such not 'WebFOCUS80' for Derby.?

Believe, you have sqljdbc4.jar in the WF client machine itself.

Also, it's advisable to check ibi\WebFOCUS80\config\webconfig.xml file, the changes applied or not

Thanks a bunch, I got it to work by now. I switched to a separate SQL Server installation (standard instance) and ditched the named instance approach.