CODEWITHSUNDEEP
asp.net-mvciisweb-administration
user476896
user476896

Reputation: 11

ASP.NET Web Site Administration Tool database connection error

There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help enter code herein diagnosing the problem: Unable to connect to SQL Server database. here my connection string in web.config

<connectionStrings>
    <add name="MusicStoreEntities" connectionString="Data Source=.;Initial Catalog=MusicStore;Integrated Security=True"
      providerName="System.Data.SqlClient" />
  </connectionStrings>

Upvotes: 1

Views: 70

Answers (2)

Nimesh Gami
Nimesh Gami

Reputation: 381

user localhost like 127.0.0.1 it's should be work 

<connectionStrings>
    <add name="MusicStoreEntities" connectionString="Data Source=127.0.0.1;Initial Catalog=MusicStore;Integrated Security=True"
      providerName="System.Data.SqlClient" />
  </connectionStrings>

Upvotes: 1

EAnders
EAnders

Reputation: 112

set Data Source= your computer name instead of .

Upvotes: 0

Related Questions