I have created a .NET Standard C# project and a SQL database in my LocalDB server (LocalDb)\MSSQLLocalDB. I have tried to configure the connection string in the project web configuration file but in runtime the connection to SQL server is not succeeded. How can I configure a local DB server in my project config file?
This is the connection string configured in my project web.config:
<connectionStrings> <add name="iPark.Database.Properties.Settings.iParkConnectionString" connectionString="Data Source=(LocalDb)\MSSQLLocalDB;Initial Catalog=iPark;User ID=iParkUser;Password=iParkPassword1" providerName="System.Data.SqlClient" /> </connectionStrings>
When I try to access the database, the following error occurs:
Relative to the database, I've created the user iParkUser with authentication type "SQL Server Authentication". I can login to the server and the database with the user and its roles are the following: