Server 2008 host, Remote SQL 2005, Netflow Prof build 7591

Server 2008 host, Remote SQL 2005, Netflow Prof build 7591

Hi

I have installed Netflow Professional build 7591 on a Server 2008 (std) VM, seemed to install fine.

I have made no changes, not even logged onto it yet.

I want to configure it to use a remote MSSQL 2005 (std) database, rather than the local mysql db, and have followed instructions as best as possible from http://www.manageengine.com/products/netflow/configuring-mssql.html.

This is the output from the cmd window:

User dir C:\AdventNet\ME\NetFlow\bin jboss dir ..
The server address is Mysql 127.0.0.1
The vector array is  []
The vector array is  [UKCOLODB02;MSSQLSERVER;1433]
The instance name selected is MSSQLSERVER
Trying to create the database but failed
javax.xml.transform.TransformerException: java.io.FileNotFoundException: C:\Adve
ntNet\ME\NetFlow\bin\..\server\default\deploy\mssql-ds.xml (Access is denied)
        at com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.getOutpu
tHandler(Unknown Source)
        at com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.transfor
m(Unknown Source)
        at com.adventnet.netflow.dbutils.ChangeDBServer.updateDBConfigFile(Chang
eDBServer.java:275)
        at com.adventnet.netflow.dbutils.ChangeDBServerGUI.doSaveDBOperation(Cha
ngeDBServerGUI.java:523)
        at com.adventnet.netflow.dbutils.ChangeDBServerGUI.access$2200(ChangeDBS
erverGUI.java:16)
        at com.adventnet.netflow.dbutils.ChangeDBServerGUI$10.mouseClicked(Chang
eDBServerGUI.java:417)
        at java.awt.AWTEventMulticaster.mouseClicked(Unknown Source)
        at java.awt.Component.processMouseEvent(Unknown Source)
        at javax.swing.JComponent.processMouseEvent(Unknown Source)
        at java.awt.Component.processEvent(Unknown Source)
        at java.awt.Container.processEvent(Unknown Source)
        at java.awt.Component.dispatchEventImpl(Unknown Source)
        at java.awt.Container.dispatchEventImpl(Unknown Source)
        at java.awt.Component.dispatchEvent(Unknown Source)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
        at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
        at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
        at java.awt.Container.dispatchEventImpl(Unknown Source)
        at java.awt.Window.dispatchEventImpl(Unknown Source)
        at java.awt.Component.dispatchEvent(Unknown Source)
        at java.awt.EventQueue.dispatchEvent(Unknown Source)
        at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)


































        at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
        at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
        at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
        at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.io.FileNotFoundException: C:\AdventNet\ME\NetFlow\bin\..\server\
default\deploy\mssql-ds.xml (Access is denied)
        at java.io.FileOutputStream.open(Native Method)
        at java.io.FileOutputStream.<init>(Unknown Source)
        at java.io.FileOutputStream.<init>(Unknown Source)
        ... 26 more
---------
java.io.FileNotFoundException: C:\AdventNet\ME\NetFlow\bin\..\server\default\dep
loy\mssql-ds.xml (Access is denied)
        at java.io.FileOutputStream.open(Native Method)
        at java.io.FileOutputStream.<init>(Unknown Source)
        at java.io.FileOutputStream.<init>(Unknown Source)
        at com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.getOutpu
tHandler(Unknown Source)
        at com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.transfor
m(Unknown Source)
        at com.adventnet.netflow.dbutils.ChangeDBServer.updateDBConfigFile(Chang
eDBServer.java:275)
        at com.adventnet.netflow.dbutils.ChangeDBServerGUI.doSaveDBOperation(Cha
ngeDBServerGUI.java:523)
        at com.adventnet.netflow.dbutils.ChangeDBServerGUI.access$2200(ChangeDBS
erverGUI.java:16)
        at com.adventnet.netflow.dbutils.ChangeDBServerGUI$10.mouseClicked(Chang
eDBServerGUI.java:417)
        at java.awt.AWTEventMulticaster.mouseClicked(Unknown Source)
        at java.awt.Component.processMouseEvent(Unknown Source)
        at javax.swing.JComponent.processMouseEvent(Unknown Source)
        at java.awt.Component.processEvent(Unknown Source)
        at java.awt.Container.processEvent(Unknown Source)
        at java.awt.Component.dispatchEventImpl(Unknown Source)
        at java.awt.Container.dispatchEventImpl(Unknown Source)
        at java.awt.Component.dispatchEvent(Unknown Source)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
        at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
        at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
        at java.awt.Container.dispatchEventImpl(Unknown Source)
        at java.awt.Window.dispatchEventImpl(Unknown Source)
        at java.awt.Component.dispatchEvent(Unknown Source)
        at java.awt.EventQueue.dispatchEvent(Unknown Source)
        at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)










































        at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
        at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
        at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
        at java.awt.EventDispatchThread.run(Unknown Source)
Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException
        at com.adventnet.netflow.dbutils.ChangeDBServerGUI.doSaveDBOperation(Cha
ngeDBServerGUI.java:538)
        at com.adventnet.netflow.dbutils.ChangeDBServerGUI.access$2200(ChangeDBS
erverGUI.java:16)
        at com.adventnet.netflow.dbutils.ChangeDBServerGUI$10.mouseClicked(Chang
eDBServerGUI.java:417)
        at java.awt.AWTEventMulticaster.mouseClicked(Unknown Source)
        at java.awt.Component.processMouseEvent(Unknown Source)
        at javax.swing.JComponent.processMouseEvent(Unknown Source)
        at java.awt.Component.processEvent(Unknown Source)
        at java.awt.Container.processEvent(Unknown Source)
        at java.awt.Component.dispatchEventImpl(Unknown Source)
        at java.awt.Container.dispatchEventImpl(Unknown Source)
        at java.awt.Component.dispatchEvent(Unknown Source)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
        at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
        at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
        at java.awt.Container.dispatchEventImpl(Unknown Source)
        at java.awt.Window.dispatchEventImpl(Unknown Source)
        at java.awt.Component.dispatchEvent(Unknown Source)
        at java.awt.EventQueue.dispatchEvent(Unknown Source)
        at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)

























        at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
        at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
        at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
        at java.awt.EventDispatchThread.run(Unknown Source)


I have tried using both Windows auth with a domain user account i have created with all SQL 2005 server roles (securityadmin, dbcreator, sysadmin, serveradmin etc. etc.), and also using the SA account for the remote sql server, and the above messages do not seem to change.

SQL server is using default instance.

Can anybody point me in the right direction?

Many thanks.

Dave

                New to ADSelfService Plus?