473,853 Members | 1,957 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

There is a problem with your selected data store

Hi,
I am using SQLServer 2005.I have created a simple website and i am trying
to membership to this.so when i click on 'Security' tab of the "WAT" tool its
showing the following message.

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.

Is there anyway out of this?

Pls pls pull me out of this.

Regards,
SSREDDI.
Jun 18 '07 #1
3 11780
I had faced the same prob. but am not able to do that

this link helped me a little but. may be this may help u better.

http://www.c-sharpcorner.com/UploadF...ipService.aspx

Jun 18 '07 #2
Hi Sravan,
Thank you for the information.I already tried this.I know this
works.My concern is that i dont want to use aspnet_regsql.e xe.Anyway thanks
for the info.

"sravan_reddy00 1" wrote:
I had faced the same prob. but am not able to do that

this link helped me a little but. may be this may help u better.

http://www.c-sharpcorner.com/UploadF...ipService.aspx

Jun 20 '07 #3
u try editing the web.config file...

there is lot more to do with that..
hav u created ur own database for your application. If so you have to
give the connection string for that database.

This is my webconfig file. see this and try. I tried for about 3 days
to that.

if u didn't include the roleManager then we can't create the roles and
it states and error message saying "website not configured to enable
roles"
<configuratio n xmlns="http://schemas.microso ft.com/.NetConfigurati on/
v2.0">
<appSettings/>
<connectionStri ngs>
<add name="MySqlProv iderConnection"
connectionStrin g="server=local host;integrated security =
true;database=a spnetdb" />
</connectionStrin gs>
<system.web>
<!--
Set compilation debug="true" to insert debugging
symbols into the compiled page. Because this
affects performance, set this value to true only
during development.
-->
<compilation debug="true"/>
<authorizatio n>
<deny users="?"/>
</authorization>
<membership defaultProvider ="MySqlMembersh ipProvider">
<providers>
<add connectionStrin gName="MySqlPro viderConnection "
enablePasswordR etrieval="false "
enablePasswordR eset="true" requiresQuestio nAndAnswer="tru e"
applicationName ="/" requiresUniqueE mail="true"
maxInvalidPassw ordAttempts="5"
passwordAttempt Window="10" name="MySqlMemb ershipProvider"
type="System.We b.Security.SqlM embershipProvid er, System.Web,
Version=2.0.0.0 , Culture=neutral , PublicKeyToken= b03f5f7f11d50a3 a"
minRequiredPass wordLength="6"
minRequiredNona lphanumericChar acters="0" />
</providers>
</membership>

<roleManager enabled="true" defaultProvider ="SqlRoleProvid er">
<providers>
<clear />
<add applicationName ="MyAppName"
connectionStrin gName="MySqlPro viderConnection "
name="SqlRolePr ovider"
type="System.We b.Security.SqlR oleProvider" />
</providers>
</roleManager>

Jun 20 '07 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2024
by: LineVoltageHalogen | last post by:
Greetings All, I was wondering if any of you would share some of your experiences regarding the task of loading a data store from an Oltp source. We are using Analysis Services in a BI product that requires data to be pulled from one of our products, an OLTP database. The design is to first run an ETL process from the OLTP source into an operational data store, from here Analysis Services will pull its data to do its thing. Now, for...
4
3449
by: Sanjeev K B | last post by:
Hi all, I am working on a project involving Datagrid with an extended feature of combo box i am trying to stop the occurance of duplicate ID's i want to trap the message "Error when committing the row to the original data store" i would like to display my own message box and cancel the row that is being added.
4
1839
by: William | last post by:
After much frustration I was able to update my data store via code only. Using the data adapter was the only way I was able to set up all the objects written in my code. Basically, I cheated by creating an adapter and then copy, paste, modify it's code to suite my needs. This was the end result: Private sub updateTable( ) Dim myData As DataSet 'Command is a form level oledbcommand object Dim Adapter1 As New OleDbDataAdapter(Command)
0
1293
by: sajenia | last post by:
i need to design a solid data store device. the prime use of the data store is to store text messages, with each message being structured as a linked list. the logical concept of the store will be a continous finite stream of cells, each cell to be capable of storing just one character of a message. any message might occupy one or more blocks of cells. thus the need for a linked list data structure. in addition to the cells that store the...
2
1390
by: tamatem | last post by:
I made ahuge load script in SQL Server 2000 as i load data from many tables(select some of each one collumns) into one single table and i want to test the loaded data against the selected data to make sure that the loaded data is the same the selected data is there a code or tool to make this test or monitoring ?? please urgent ....
2
1424
by: Ryan | last post by:
I am new to .net 2.0 and was wondering how best to leverage its membership capabilities to handle a situation similar to the following: We have a 4 web applications belonging to 3 departments. Each of these is owned by a particular department. Access to the systems can be shared across department, but access is controlled within each department. Ex:
1
3340
by: David | last post by:
Under asp.net 2, if I define SqlDatasource and bind it to a grid, is selected data accessible in code? Eg. if I select s single row from the grid, can I go to the base data from the SqlDatasource and get the specific row? If yes, then point me to an example. Also, I know that can selected grid row or I can select the single row from the database. Thanks
0
782
by: sravan_reddy001 | last post by:
i found the folloling error message when tried to administer the login control of the webpage:: 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...
0
1374
by: svgeorge | last post by:
I have web pages for making several 9 type of payments. The data gets loaded on web page from SQL server 2005 database. Then I have Process payment button(ProcPaymBTM_Click) on the web page(Detail View)This is done. on clicking this button(ProcPaymBTM_Click) on (Detail View) all selected (checked) data columns needs displayed on another page (Review Data) In this page i click confirm payment button to insert selected data to the SQL Tables. I...
3
1595
by: tetsuo2030 | last post by:
Greetings, This is probably an easy thing to do, but I can't seem to figure it out. My main data set is a massive table with 15 columns and thousands of rows. The data entry form forces certain consistencies in the data (if column A = "bluejay", column B = "bird"). However, I've agreed to upload archived data from a previous source where these consistencies were not enforced. So, I wrote 10 or so queries looking for specific...
0
9898
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
11020
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10670
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10358
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9506
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5934
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4549
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4143
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3180
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.