jaws1021
asked on
Asp.net website administration tool security tab not working
I have VS 2005 professional edition and sql server 2005 enterprise edition installed to my pc. when I click on asp.net website administration tool and security tab, I get this 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 in diagnosing the problem: Unable to connect to SQL Server database.
What do I need to do?
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 in diagnosing the problem: Unable to connect to SQL Server database.
What do I need to do?
ASKER
Thank you for the link, it solved my problem, but I don't know how putting this code make that much difference? And when I run the application still put another connectionstring automatically but didn't effect anything.
<configuration>
<connectionStrings>
<remove name=”LocalSqlServer”/>
<add name="LocalSqlServer" connectionString="Data Source=localhost;Initial Catalog=appservicesdb;Inte grated Security=True" providerName="System.Data. SqlClient" />
</connectionStrings>
</configuration>
<configuration>
<connectionStrings>
<remove name=”LocalSqlServer”/>
<add name="LocalSqlServer" connectionString="Data Source=localhost;Initial Catalog=appservicesdb;Inte
</connectionStrings>
</configuration>
ASKER
Also, why it is showing asp.net configuration setting? We don't change anything on that...
...you're trying to use "full" sql2005 right?
without that section in your web.config, the application tries to use the default db and location, which would be a sql express db and located in your app_data folder
>>why it is showing asp.net configuration setting
where?
without that section in your web.config, the application tries to use the default db and location, which would be a sql express db and located in your app_data folder
>>why it is showing asp.net configuration setting
where?
Thank you for your explaination, also do we need to leave code put there automatically or should delete it?
Right before the code, it is showing asp.net configuration setting dialog box, I was wondering why it show that?
Right before the code, it is showing asp.net configuration setting dialog box, I was wondering why it show that?
ASKER
Sorry, if question above is stupid for you, we are newbie on .net and sql 2005 just trying to learn it.
don't be sorry! we all start somewhere!
>>Thank you for your explaination, also do we need to leave code put there automatically or should delete it?
--You need to leave that section in your web.config just like the tutorial or else without it, your application will look for the default sql express database (which I assume you're not using)
>>Right before the code, it is showing asp.net configuration setting dialog box, I was wondering why it show that?
--I'm still unsure where you see a dialog box
>>Thank you for your explaination, also do we need to leave code put there automatically or should delete it?
--You need to leave that section in your web.config just like the tutorial or else without it, your application will look for the default sql express database (which I assume you're not using)
>>Right before the code, it is showing asp.net configuration setting dialog box, I was wondering why it show that?
--I'm still unsure where you see a dialog box
ASKER
thank you for being patient with us. You know the blog link you gave above when I click that and follow thru scroll down right above this code , has Asp.Net Configuration Settings Box there, we didn't understand why it is shown there even though doesn't say to do something on it? Is that made more sense now?
<configuration>
<connectionStrings>
<remove name=”LocalSqlServer”/>
<add name="LocalSqlServer" connectionString="Data Source=localhost;Initial Catalog=appservicesdb;Inte grated Security=True" providerName="System.Data. SqlClient" />
</connectionStrings>
</configuration>
<configuration>
<connectionStrings>
<remove name=”LocalSqlServer”/>
<add name="LocalSqlServer" connectionString="Data Source=localhost;Initial Catalog=appservicesdb;Inte
</connectionStrings>
</configuration>
ASKER
O also you are not using sql server express
ASKER
I am sorry. I meant above we are not using sql server express :)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you! you were a good help!
http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx