conncetion with sql server

Started by shailender, October 25, 2010, 08:18:35 PM

Previous topic - Next topic

shailender

guys i have been trying to install NETXMS server with the  microsoft sql as the backend database
but every time it is giving the problem  as "SQL QUERY CANNOT BE EXECUTED"
though it is able to conncet to the database and able to create a database as netxms_db
i have to complete my installtion as a project and in extreme need of hell and support
thanks .......

victrola

Are you using a SQL Server account to create the database or using NT Authentication?

The way I did it was to have a blank database created, add the user to the new database, then assign db_datawriter, db_datareader and db_ddladmin roles to the user.