473,756 Members | 3,686 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Deploying VWD Express App to IIS using SQL Express w/ Membership i

Okay, I'm 18 hours into this now and am at a loss. What I've done is create
an application on my local workstation using VWD Express using the
membership/roles provider and SQL Server Express configured for local
authentication. I have an aspnetdb database in my app_data folder configured
with several users. Everything works fine when I run the application from my
workstation.

I've tried several attempts to copy the app to my w23k server running sql
express and can't get it to run. I've created a virtual directory and
configured it to run ASP.NET 2.0. Then I've copied the files, including the
aspnetdb files and I still can not login. I've tried using the aspnet_reqsql
tool, but all that does is give me another aspnetdb database without any
information in it.

I've read about changing connection strings, application names, and changing
the account the database runs in from the NETWORK SERVICE ACCOUNT. I still
don't understand a lot of this. I'm primarily a sysadmin that's had to write
this application due to our vendor not being responsive. It's a simple app
that uses the membership/roles login features of ASP.NET 2.0 and some data
controls to allow various users the ability to view information from our
database.

I have complete control over the web server and can reinstall everything,
including the OS if need be. Heck I reinstalled SQL EXPRESS two times today.

I'm looking for a step by step article, whitepaper, etc. on how to deploy a
VWD Express application that uses the membership/roles features in ASP.NET
2.0 and SQL Server Express 2005 with Windows Authentication to a Windows 2003
Server that has a default installation of SQL Server Express 2005 on it.

I can change primarily anything on the server, build it from scratch,
install anything on it. I just need to transfer my application to run on it.

It runs fine from the workstation.

Any help or links to such information would be most helpful.

Thanks in Advance,
Carl M.
St. Louis

PS A reasonable hourly fee is not out of the question. However if it's to
much I'll pay the MS fee of 295
Mar 1 '06 #1
3 1638

hi carl. did you ever get this resolved? i'm having the same exact
problem...been pulling my hair out for 3 days on it. the only advice
i've gotten is "you need to upgrade to sql server 2005 developer
edition", but that can't be right. i just can't imagine that this
system (vs2005, asp.net 2.0, membership, sql 2005 express) would only
work within a development environment. here's a thread i started at
the ASP.NET forums.

http://forums.asp.net/1222171/ShowPost.aspx

if you, or anyone has some practical advice on this...PLEASE send it my
way. Thanks!

--
dubious49
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------

Mar 11 '06 #2
No, I haven't resolved this. I've taken the login controls out and
restricted access via the firewall. However now the server is almost a waste
of money because it only serves this one application.

I've got a ton of things on my plate, here in a couple of weeks I have to
get it work for another project so I'll detail my trial and tribulations here.

BTW, the link didn't work. You can email me directly at c m i l l o s h (a
t) g m a i l (d o t) c o m

"dubious49" wrote:

hi carl. did you ever get this resolved? i'm having the same exact
problem...been pulling my hair out for 3 days on it. the only advice
i've gotten is "you need to upgrade to sql server 2005 developer
edition", but that can't be right. i just can't imagine that this
system (vs2005, asp.net 2.0, membership, sql 2005 express) would only
work within a development environment. here's a thread i started at
the ASP.NET forums.

http://forums.asp.net/1222171/ShowPost.aspx

if you, or anyone has some practical advice on this...PLEASE send it my
way. Thanks!

--
dubious49
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------

Mar 11 '06 #3
Any resolution for this? I'm also having the same problem, but would
like to retain the login functionality.

Mar 20 '06 #4

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

Similar topics

4
1771
by: Bruno | last post by:
Hello, VS.net installs sql express as datastore for role/membership management. I don't like this! I'm not able to choose other databases like ms-access, in the Web Site Administration Tool . (Only AspNetSqlProvider) I've tryed some c# stuff, but id did not work for me, to much trouble. I wish to work with vb.net anyway. Is there a tool/programm or something with less trouble, so i can choose from different providers in the Web Site...
5
1476
by: sloan | last post by:
Are there any "gotchas" on deploying the default Membership Provider (aspnetdb) to a hosting provider? I'm about to do it. And how does one get to the "auto configurer" .. that allows you to setup roles/users .....? Can I do these steps:
1
1542
by: Keith | last post by:
If I understand correctly, the SQL script called "InstallMembership.sql" can be used to create a membership database that exists in the instance of SQL Server 2005 used for my main application. Having created such a database, how can I get the ASP.NET Web Site Administration Tool to reference that database instead of the one that exists in the App_Data folder SQL Server Express database? Also, how can I get the membership controls in my...
0
1007
by: geek-y-guy | last post by:
I have a "newbie" deployment question. I want to confirm what's involved in deploying a web created with Visual Web Developer Express Edition to a production Server2003/IIS 6 server. The project to be deployed has a typical membership database created through the administrative interface ("App_Data/ASPNETDB.MDF"). For that dB to work on the webserver, does SQL Server Express Ed. have to be installed on the webserver as well?
1
1091
by: theBlindRef | last post by:
I'm going to be developing a new home page for my company's intranet. This page will have web parts on it that can be customized by registered users (employees). My development computer has SQL Server 2005 Express installed so my application uses that by default to handle the personalization. However, the production server does not have and won't have it. I do have access to a full version of SQL Server 2005. So: 1. How can I configure...
1
1353
by: OGG | last post by:
Hi guys, I hope this is the correct place to post this question. 1) My website makes use of the Membership and Roles of asp.net 2. 2) I have uploaded my website to a shared hosting server, which doesn't support sql express (mdf files). It does support mysql, so I used a custom Membership provider for MySql. 3) It worked greate on my local computer, however (!!) it still creates a aspnetbd.mdf file in the AppData folder. 4) Obviously,...
2
1746
by: =?Utf-8?B?SXbDoW4gU2Fpbno=?= | last post by:
I ran the aspnet_regsql.exe tool with the -sqlexportonly option to create the script. I searched and replace the string by and had the dba's run the script. When I do anything like Membership.CreateUser or click on the 'security' tab in the website admin tool I get... Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'. I think this is because "dbo" is harcoded in the framework. The hosting company won't let us use the dbo...
4
6709
by: jobs | last post by:
Works great on my client when I test from vs.net 2005. Howevever, when I deploy to the web server, I get this error: remotely and local from the web server. An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error...
10
1937
by: Scott M. | last post by:
I've seen many posts and ready articles discussing how changing the membership & roles "provider" in VS .NET is easy, but have yet to see instructions on how to do it. If I already have SQL Server 2000 on a machine and didn't install SQL Server 2005 Express with my VS .NET installation, how do I set up my existing SQL 2000 server to be the membership & roles provider for ASP .NET?
0
9275
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10034
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
8713
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...
1
7248
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6534
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5142
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5304
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3805
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
3
2666
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.