Solved

Unable to connect to SQL Server database.

Posted on 2009-07-11
8
1,352 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
  • 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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 500 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
ASP Focus problem 3 61
CDO.Message not able to send attachement 5 25
Error in SSIS while executing  - Potential data loss 4 24
Sql Server group by 10 27
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

772 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