Advertisement

12.26.2007 at 04:33PM PST, ID: 23044047
[x]
Attachment Details

ASP.NET configuration pages not connecting to SQL server

Asked by bd9000 in Visual Studio 2008, .Net Editors & IDEs, SQL Server 2005

Tags: ASP.NET VB.NET

I'm attempting to use the new login controls available in VS.NET 2008 for web development, but there seems to be no way to specify the database (default SQLExpress instance) in order to use the ASP.NET role-based security.  The tutorials claim that this is done automatically, but neither is the database created automatically, nor is there any way I can find to see where it thinks the database is residing.
A local copy of SQLExpress 2005 was installed first, followed by the Visual Web Developer Express 2008 version on WinXP Pro SP2 w/ DotNetFW 2.0, 3.0, and 3.5 installed.
I don't see an area inside the web.config file to specify the database.

If I try to configure security (via the ASP.NET configuration pages), I get 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. "

On the [Provider] Tab, the page says that it is configured for "AspNetSqlProvider"
(I presumed that was a user, but there is no user on the system with that name)
When I try to "test" the provider, I get the following error:
"Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider. "

I ran the command line utility and specified PI\SQLEXPRESS as the SQL2005 (the ONLY instance running on the machine, "PI"), logged in, typed in a new database name, and verified that the database was indeed created with all the correct tables in it VIA the SQL Server Management Express tool.

I'm not sure where I need to go now to point my ASP.NET app to the correct database for the role management and what "AspNetSqlProvider" means (a user? , a role?, a service?)

Start Free Trial
[+][-]12.26.2007 at 08:55PM PST, ID: 20532448

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.27.2007 at 08:48AM PST, ID: 20535148

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.27.2007 at 11:29AM PST, ID: 20536348

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.27.2007 at 12:10PM PST, ID: 20536756

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.27.2007 at 02:25PM PST, ID: 20537821

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.27.2007 at 02:39PM PST, ID: 20537926

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Visual Studio 2008, .Net Editors & IDEs, SQL Server 2005
Tags: ASP.NET VB.NET
Sign Up Now!
Solution Provided By: bd9000
Participating Experts: 2
Solution Grade: B
 
 
[+][-]12.27.2007 at 02:42PM PST, ID: 20537949

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.03.2008 at 06:57PM PST, ID: 20579536

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
Microsoft
  • Internet Protocols
  • Applications
  • Development
  • OS
  • Hardware
  • Windows Security
Apple
  • Operating Systems
  • Hardware
  • Programming
  • Networking
  • Software
Internet
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Spy / Ad Blockers
  • Web Browsers
  • New Net Users
  • Web Development
  • Chat / IM
  • Anti Spam
  • Web Servers
  • Anti-Virus
  • Email Clients
Gamers
  • Tips
  • Online / MMORPG
  • Puzzle
  • Emulators
  • Action / Adventure
  • Role Playing
  • Consoles
  • Game Programming
  • Strategy
  • Sports
  • Misc
  • Computer Games
Digital Living
  • Hardware
  • Automotive
  • New Net Users
  • New Users
  • Software
  • Digital Music
  • Gaming World
  • Home Security
  • Apple
  • Networking Hardware
Virus & Spyware
  • Vulnerabilities
  • IDS
  • Encryption
  • Anti-Virus
  • Operating Systems Security
  • Software Firewalls
  • WebApplications
  • Cell Phones
  • Operating Systems
  • Internet
  • Hardware Firewalls
Hardware
  • Displays / Monitors
  • Handhelds / PDAs
  • Components
  • Peripherals
  • Laptops/Notebooks
  • Servers
  • Misc
  • Apple
  • Embedded Hardware
  • Networking Hardware
  • Storage
  • Desktops
  • New Users
Software
  • System Utilities
  • Industry Specific
  • Network Management
  • Photos / Graphics
  • Page Layout
  • VMware
  • Misc
  • Web Development
  • OS
  • CYGWIN
  • Voice Recognition
  • Virtualization
  • Message Queue
  • Quality Assurance
  • Security
  • Firewalls
  • MultiMedia Applications
  • Development
  • Database
  • Office / Productivity
  • Business Management
  • OS/2 Apps
  • Server Software
  • Internet / Email
ITPro
  • OS
  • Storage
  • Encryption
  • Operating Systems Security
  • Apple Hardware
  • Laptops & Notebooks
  • Servers
  • Networking Hardware
  • Peripherals
  • Devices
  • Displays / Monitors
  • WebTrends / Stats
  • Search Engines
  • Firewalls
  • Web Computing
  • WebApplications
  • IDS
  • Vulnerabilities
  • Email Clients
  • File Sharing
  • Spy / Ad Blockers
  • Web Browsers
  • Web Servers
  • Networking
  • Anti-Virus
  • Consulting
  • Chat / IM
  • Anti Spam
Developer
  • Web Servers
  • Web Browsers
  • Game Programming
  • Dev Tools
  • Industry Specific
  • Office / Productivity
  • Database
  • CYGWIN
  • Web Development
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Programming
  • Content Management
  • Application Servers
  • Protocols
Storage
  • Removable Backup Media
  • Storage Technology
  • Servers
  • Grid
  • Remote Access
  • Backup / Restore
  • Misc
  • Hard Drives
OS
  • Miscellaneous
  • Security
  • Development
  • Linux
  • VMware
  • MainFrame OS
  • Unix
  • Apple
  • OS / 2
  • AS / 400
  • BeOS
  • Microsoft
  • VMS / OpenVMS
Database
  • Oracle
  • Miscellaneous
  • MySQL
  • Software
  • Sybase
  • Contact Management
  • PostgreSQL
  • Data Manipulation
  • Clarion
  • InterSystems Cache
  • Siebel
  • MUMPS
  • OLAP
  • SQLBase
  • SAS
  • GIS & GPS
  • 4GL
  • Berkeley DB
  • DB2
  • Informix
  • Interbase / Firebird
  • FoxPro
  • Reporting
  • LDAP
  • Filemaker Pro
  • MS SQL Server
  • dBase
  • MS Access
Security
  • Misc
  • Web Browsers
  • Software Firewalls
  • Operating Systems Security
  • File Sharing
  • Spy / Ad Blockers
  • Vulnerabilities
  • WebApplications
  • IDS
  • Anti-Virus
  • Encryption
  • Anti Spam
  • Email Clients
  • VPN
  • Chat / IM
Programming
  • Editors IDEs
  • Installation
  • Handhelds / PDAs
  • Multimedia Programming
  • System / Kernel
  • Automation
  • Algorithms
  • Game
  • Signal Processing
  • Project Management
  • Open Source
  • Database
  • Misc
  • Languages
  • Processor Platforms
  • Theory
Web Development
  • Scripting
  • Blogs
  • Web Servers
  • Software
  • Search Engines
  • Web Graphics
  • Web Services
  • Images
  • Internet Marketing
  • Images and Photos
  • Components
  • Document Imaging
  • Web Languages/Standards
  • Illustration
  • WebApplications
  • Fonts
  • WebTrends / Stats
  • Authoring
  • Digital Camera Software
  • Miscellaneous
Networking
  • Protocols
  • Apple Networking
  • Network Management
  • Message Queue
  • Application Servers
  • Content Management
  • File Servers
  • Email Servers
  • Misc
  • Java Editors & IDEs
  • Wireless
  • Networking Hardware
  • Backup / Restore
  • System Utilities
  • ISPs & Hosting
  • Web Servers
  • Storage Technology
  • Removable Backup Media
  • Servers
  • Web Computing
  • Broadband
  • Grid
  • OS / 2
  • Novell Netware
  • Unix Networking
  • Windows Networking
  • Security
  • Telecommunications
  • Operating Systems
  • Linux Networking
Other
  • Lounge
  • Business Travel
  • Community Support
  • New Net Users
  • Philosophy / Religion
  • Math / Science
  • Miscellaneous
  • URLs
  • Expert Lounge
  • Politics
  • Puzzles / Riddles
  • Automotive
Community Support
  • Suggestions
  • New to EE
  • New Topics
  • CleanUp
  • Announcements
  • General
  • Feedback
  • Input
  • EE Bugs
 
12.26.2007 at 08:55PM PST, ID: 20532448
Rahu_ketu_patal:
Hi Buddy,

In all of the express editions, default connection strings are mentioned  in machine.config file.

So, I will suggest you to define your own connection string in your application's config file and one more thing, you need to set that connection string as default one for the application.

In case of any further clairfication, please feel free to ask.

Rahul
 
12.27.2007 at 08:48AM PST, ID: 20535148
bd9000:
I found the connection string in the machine.config file under the dotnet2 framework, and it is pointing to the aspnetdb.mdf database file (like it should):
      <connectionStrings>
            <add name="LocalSqlServer" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient"/>
      </connectionStrings>

I don't understand why it won't connect to the database as it is configured.  It's pointing to it and the SSPI login works fine from the SQL manager.
I'll try another connection string from the web.config to see if it works anyway.
 
12.27.2007 at 11:29AM PST, ID: 20536348
bd9000:
no, the connection string in the web.config  doesn't work either.
I put in the absolute path to the database.
May be a security issue .
 
12.27.2007 at 12:10PM PST, ID: 20536756
bd9000:
Does anyone know the EXACT procedure for setting up SQLEXPRESS with WEB DEVELOPER EXPRESS?
I've completely uninstalled both, deleted their folders and completely reinstalled this.  Do I need to re-install Windows? This is madness!
 
12.27.2007 at 02:25PM PST, ID: 20537821
bd9000:
OK, I figured out the problem.
SQLExpress is incompatible with Terminal Server (what I was using).
This turned out to be a known bug with Microsoft - As soon as they send me the HotFix, I'll see if I can get it to work.
 
12.27.2007 at 02:39PM PST, ID: 20537926
bd9000:
Workaround:
Click the Edit Global Setttings and turn off the Integrated Security option as in:

data source=MyMachine\SQLEXPRESS;User ID=sa;Password=mypass;Trusted_Connection=False;initial catalog=aspnetdb

Make sure SQLExpress is set to allow both types of logins.

SSPI is where the bug is when trying via Terminal Server - this is the only workaround I know of
Accepted Solution
 
12.27.2007 at 02:42PM PST, ID: 20537949
bd9000:
Sorry, the global settings in IIS is where I went under the ASP.NET tab in the properties dialog.  Also the ASP.NET user MUST be a user in the SQLEXPRESS DB with read/write.
 
01.03.2008 at 06:57PM PST, ID: 20579536
Vee_Mod:
A request has been made in Community Support to close this question:
http://www.experts-exchange.com/Q_23056872.html

If there are no objections, a moderator will finalize this question in approximately 4 days as follows:
PAQ with refund using {http:#a20537926}

Please leave any recommendations here.

Vee_Mod
Community Support Moderator
 
 
Vee_Mod
01.07.2008 at 05:56PM PST, ID: 20605320
Closed, 500 points refunded.
Vee_Mod
Community Support Moderator
 
 
 
20080716-EE-VQP-32 / EE_QW_2_20070628