Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Unable to connect to SQL Server database.

Posted on 2009-07-11
8
Medium Priority
?
1,367 Views
Last Modified: 2012-05-07
i am using visual studio 2008 and i want to apply membership controls to my website .

so i opned my project went to website->asp.ner configiration->security

and i am getting following errors...

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.


what is the problem can you  please tell me ??

The following message may help in diagnosing the problem: Unable to connect to SQL Server database.
0
Comment
Question by:siddharthkool
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
8 Comments
 
LVL 4

Expert Comment

by:khyer123
ID: 24832832
-Can you reach your SQL server from your web server?
-Do you have proper authentication configured?
0
 

Author Comment

by:siddharthkool
ID: 24832888
i have not downloaded sql 2005 or 2008 ..


is it required ??
0
 
LVL 4

Expert Comment

by:khyer123
ID: 24832899
Yes, it sounds like it is. You need some sort of server to connect to.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:siddharthkool
ID: 24832903
ok thanks i will install 2008 and see what happens...
0
 
LVL 4

Expert Comment

by:khyer123
ID: 24832907
Doesn't Visual Studio come with some version of a SQL server (like an express edition)? I haven't used 2008, but in 2005 it does. This is unless, of course, you specified the SQL server being somewhere else.
0
 

Author Comment

by:siddharthkool
ID: 24833146
yes visual studio 2008 comes with sql server 2008
 but still there is problem as follows : :

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.


what is the problem can you  please tell me ??
0
 
LVL 15

Accepted Solution

by:
jinal earned 2000 total points
ID: 24833171
did you configure connection string in web.config ?

It should be first connectino string in web.config.
0
 

Author Comment

by:siddharthkool
ID: 24833249
i want to go to

start new website in visual studio 2008 , then go to


website ---> asp.net configuration----->settings


and then i want to add membership but giving errors...plz help whats wrong...

do i have to change any ports settings

or do i have to make any new configuration ??
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question