CODEWITHSUNDEEP
sqlsql-server-2012
MIle
MIle

Reputation: 65

Can`t create database in SQL Server 2012 Management Studio

Havent used SSMS in a while, today i tried to make new database and got this error:

enter image description here

I tried running as admin, also tried Security > Logins > myAccount > Server Roles > Checked : sysadmin, dbcreator and still getting that error.

Edit: This is how im trying to add new db:

enter image description here

Upvotes: 0

Views: 5632

Answers (2)

Syntax Error
Syntax Error

Reputation: 1640

When creating a database from the wizard, you need to provide a file path. If it is blank by default then it means there is no path specified in Database settings.

In Object Explorer, right-click the server and click Properties. In the left panel, choose database settings. In Database default locations, view the current default locations for new data files and new log files. To change a default location, enter a new default path name in the Data or Log field, or click the browse button to find and select a path name.

Upvotes: 1

Ragesh
Ragesh

Reputation: 738

Check Server Properties -- > Database Settings -- > Database Default locations --> Data and log Path.

Reason : Data and Log Path pointed doesn't exist or full rights are not given to this path.

Solution : Specify Correct Data and Log Path or give Full rights to this folder and then try to create database.It should work.

enter image description here

Below link will also help you :-

https://support.microsoft.com/en-us/kb/836873

Upvotes: 1

Related Questions