How to create a database in SQL Server?

Question

I installed SQL Server, and comes Magnament Studio, how do I create my bank? I tried going there, and I had authenticated by Windows but it is error.

How I create my bank?

Answer 1

The user must be valid either in SQL Server or even in Windows if using delegated authentication to the operating system.

using (var connection = new SqlConnection("data source=NomeDoServidor; uid=usuario; pwd=senha;")) {
using (var cmd = new SqlCommand()) {
    connection.Open();
    cmd.Connection = connection;
    cmd.CommandText = "create database NomeDoBancoDeDados;";
    cmd.ExecuteNonQuery();
    cmd.CommandText = "use NomeDoBancoDeDados; create table tabela (ID int, campo1 varchar(20));";
    cmd.ExecuteNonQuery();
}

I put in the Github for future reference.

Of course the creation of tables is an example, it is not necessary.

Alternative to the string connecting: "Server=localhost; Integrated security=SSPI; database=master"

Of course it can be sophisticated but this should work if you do not have installation and configuration problems in SQL Server. If you do, you need to review this part. Read the documentation before installing. Understand the implications of each choice.

More recently can do:

using var connection = new SqlConnection("data source=NomeDoServidor; uid=usuario; pwd=senha;"));
using var cmd = new SqlCommand());
connection.Open();
cmd.Connection = connection;
cmd.CommandText = "create database NomeDoBancoDeDados;";
cmd.ExecuteNonQuery();
cmd.CommandText = "use NomeDoBancoDeDados; create table tabela (ID int, campo1 varchar(20));";
cmd.ExecuteNonQuery();

Answer 2

There is no secret to connect, let’s see the simple steps:

1 - In the server name option you put the name of your local pc, ex Name-Pc/user

2 - Brand windows Authentication and will connect.

No mistake.