i strucked at the installation process, using MSSQL 2005 statderd edition with windowsXP SP2..... i given " * " at DBA login name and left empty at password, db login name with netxms left password empty... MSSQL was at local system and with windows authentication ... at final when db creation it shows at error message as follows: "" sql query failled: CREATE DATABASE Table netxms_db failed "".... when i saw in database it was created and there...... connection to DBA is okay but when it comes to create database it failed.....
please tell me how to resolve this problem
Hello!
Could you please send screenshots with your database configuration, service configuration, and error message screens?
Best regards,
Victor
Quote from: Victor Kirhenshtein on March 18, 2008, 09:07:07 PM
Hello!
Could you please send screenshots with your database configuration, service configuration, and error message screens?
Best regards,
Victor
thanks for your response Mr.Victor Kirhenshtein, i am sending screenshots for my installation please check the attachment
Hello!
Now, recovery procedure can be following:
1. Delete database netxms_db.
2. Delete SQL user netxms if it's exist (under Security -> Logins).
3. Ensure that you have mixed mode authentication: in SQL Server Management Studio right click on server object, select Properties, select "Security", and ensure that under "Server authentication" selected "SQL Server and Windows Authentication mode".
4. Reinstall NetXMS, and when on database configuration tab, enter any random password for database user "netxms".
Best regards,
Victor