Error creating database by Visual Studio 2015

Asked

Viewed 317 times

1

I’m in trouble when I try to create a database by Visual Studio this message appears:

Como posso reslver isso

sql-server asp.net visual-studio

2 answers

0

As the error message itself says: you need to have Localdb or SQL Server Express installed and running on your local computer, that is, on your machine. I believe you do not have the program(s) installed(s) and/or running.

To troubleshoot the issue do what the message instructs, go to the link provided in the error message, select Microsoft SQL Server Data Tools, and install the latest version.

  • Okay, I’ll try, thank you very much.

  • Anything can look for me by the comments we’ll find a solution =D

0

You can also configure your database locally via web.config. Usually when creating the project the web.config file comes preconfigured, just adjust. Make sure you have the following code snippet.

Example:

<connectionStrings>
<add name="Nome do Banco" connectionString="Data Source=(LocalDb)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\aspnet-Vidly-20170823094631.mdf;Initial Catalog=aspnet-Vidly-20170823094631;Integrated Security=True" providerName="System.Data.SqlClient" />

Follow the configuration link of my web.config where you have the database configured.

Github

Browser other questions tagged sql-server asp.net visual-studio

You are not signed in. Login or sign up in order to post.