While creating database with Microsoft SQL Server I have faced this problem

Asked By 50 points N/A Posted on -
qa-featured

Hi,

While creating database with Microsoft SQL Server I have faced this problem. I have no idea about this exception. If you have any idea regarding this issue please help me.

An exception occurred while executing a transact-SQL statement or batch

Microsoft SQL Server Management Studio

Create failed for Database 'myDB'. (Microsoft.SqlServer.Smo)

Additional information:

An exception occurred while executing a transact-SQL statement or batch.

(microsoft.SqlServer.ConnectionInfo)

CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262)

SHARE
Best Answer by Lgoy Budion
Answered By 0 points N/A #141890

While creating database with Microsoft SQL Server I have faced this problem

qa-featured

Hello Desirae,

To resolve that issue:

  • Open SQL Server Management Studio, and then from the [Object Explorer] expand the server instance.
  • After that right Click on the [Database] name, and the select [Tasks] > [Restore] > [Database].
  • In the [Restore Database] Dialog window, select the [To database:] from the drop down selection menu.
  • After that select [From the device:], and then click the ellipse button to open the [Specify Backup] dialog box.
  • After that you will click [Add] to go where you stored your .bak database.
  • After you get the .bak file, you will need to put a [Check] in the [Restore] box beside its name.

Get more details here

Regards,

Nicke

Best Answer
Best Answer
Answered By 0 points N/A #141891

While creating database with Microsoft SQL Server I have faced this problem

qa-featured

You cannot create a table on the master database because the master database holds all the configurations and security settings of your SQL Program, you need to create a new database for your table which can be done with these simple steps:

1. Open your SQL Management.

2. On the Databases Right Click on the Databases.

Create a table on the master database

3. Name and Create a new Database where you will create your table.

Server Management Studio

4. After creating the database, click the "+" sign at the side of your database.

Create Table SQL Server management

5. On the Tables Folder, Right click on it and Create New Table.

Tables Folder Right click on it and Create New Table

6. After defining every column of your table, Press Ctrl+s to save your table.

Login/Register to Answer

Related Questions