problems creating database

Started by rolly888, September 28, 2010, 01:32:46 AM

Previous topic - Next topic

rolly888

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

rolly888

sometimes the GRANT error comes back


Victor Kirhenshtein

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