ASP.NET Web Site Administration Tool database connection error

Question

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>

Nimesh Gami · Accepted Answer · 2015-08-03 12:55:10Z

1

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>

answered Aug 3, 2015 at 12:55

Nimesh Gami

3811 gold badge4 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user476896 Over a year ago

thanks but it still does not work,i move on that topic for now.

EAnders · Accepted Answer · 2015-08-03 12:52:05Z

0

set Data Source= your computer name instead of .

answered Aug 3, 2015 at 12:52

EAnders

1128 bronze badges

2 Comments

user476896 Over a year ago

i am not sure that is the problem but i'll try.

EAnders Over a year ago

Unfortunately, if setting it to localhost or 127.0.0.1 didn't work, this won't either. They're equivalent. Can you connect to the server itself, just not the database?

Collectives™ on Stack Overflow

ASP.NET Web Site Administration Tool database connection error

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related