Print Page - problems creating database

Title: problems creating database
Post by: rolly888 on September 28, 2010, 01:32:46 AM

First I had the problem " cannot connect to database": i replaced local host by the name of the sql instance and now it is OK (TCP/IP is also enabled)

Second I had the problem " GRANT TO username" I added the username in the properties of the SQL instance and the problem was fixed.

Now I still have a problem: SQL query failed: CREATE DATABASE netx_db

Please advise

I am running Windows 2003 with MS SQL EXPRESS 2005

Title: Re: problems creating database
Post by: rolly888 on September 28, 2010, 02:13:36 AM

sometimes the GRANT error comes back

Title: Re: problems creating database
Post by: rolly888 on September 30, 2010, 11:40:40 PM

any help ?

Title: Re: problems creating database
Post by: Victor Kirhenshtein on October 01, 2010, 10:40:29 AM

Hi!

You are using installation wizard, right? What user you are using as DBA account? Does it have rights to create new database? If you not using Windows authentication, do you enable SQL Server authentication?

Best regards,
Victor

NetXMS Support Forum

English Support => General Support => Topic started by: rolly888 on September 28, 2010, 01:32:46 AM