Leo_Frits


I want to design a new database. When I right-click on 'Data Connections' in the Database Explorer from VB I notice that the 'Create New SQL Server Database...' is greyed out, so I can't create a new database.

What is going wrong here, please help.




Re: New Database

Arnie Rowland


It could be that your login account does not have permissions to create new databases on the server.





Re: New Database

Leo_Frits

Thanks, but I found out that I can create it in an other way;

- name a new application and add a SQL Database from the templates.

But in the menu, that appears after right-click on "Data Connections' in the Database Explorer in VB the 'Create New SQL Server Database...' is still greyed out, that I don't understand why this is.

I am the only user of the computer, so I think I would have permission to create a new database, or not

I have set the user instances in SQL Server on enabled with;

exec sp_configure 'user instances enabled',1 and reconfigure

Must I still do something else