A word of warning, I am new to .NET and fairly new to SQL Server.
The problem I have must be a common one, but I am uable to make it
work. I have a .NET project and have the user management and roles
working fine via Visual Studio and the default
"ASPNewSQlMembe rshipProvider." There is database file called "ASPNETDB
..MDF", and users are easily created and logged in. I can access the
tables fine. Now I just need to upload the application to a web host.
With the host we have a SQL Server 2000 database. They created the
database for us, we don't have admin control to the whole SQL Server
(as is true with most web hosts). The book I have and all the resources
I have found simply say to run the SQL Server Setup Wizard from the
command prompt with "aspnet_reqsql. exe". But here are my problems:
When run the wizard I cannot get past the database selection screen
(3rd screen). The error I get says "Failed to query a list of database
names from the SQL Server. Invalid object name 'sysdatabases' ". I am
100% sure that the server and login information is correct, I am using
it other places and it works fine. I called the web host and they were
no help.
My .NET book also says that, instead of the wizard, I can run the SQL
script called "InstallMembers hip.sql" that is in this folder:
"C:\WINDOWS\Mic rosoft.NET\Fram ework\v2.0.5072 7". I am not sure how to
do this.
Can anyone shed some light on this? The only advice I could find was to
run the wizard, which seemed to work for most people. I don't really
care whether the application uses SQL Server or the default setup, I
just need it to work online.
Thanks in advance. 4 5637
It is pretty simple. Let me put up in stepwise,
1. Login to your database control panel (in most cases webhosting
companies provide web-based control panel for manipulating with the
database, for example in godaddy.com case the url for the db control
panel will look like mssqladmin.your sitename.com)
2. Open the InstallMembersh ip.sql in notepad and select all text, Copy
and paste in the control panel which has a kind of query analyzer interface.
3. Then just execute it.
Now if you check the list of tables you can see table's name starts with
aspnet_*.
Let me know in case of any trouble.
-
Vadivel Kumar http://vadivelk.net je************@ gmail.com wrote: A word of warning, I am new to .NET and fairly new to SQL Server.
The problem I have must be a common one, but I am uable to make it work. I have a .NET project and have the user management and roles working fine via Visual Studio and the default "ASPNewSQlMembe rshipProvider." There is database file called "ASPNETDB .MDF", and users are easily created and logged in. I can access the tables fine. Now I just need to upload the application to a web host. With the host we have a SQL Server 2000 database. They created the database for us, we don't have admin control to the whole SQL Server (as is true with most web hosts). The book I have and all the resources I have found simply say to run the SQL Server Setup Wizard from the command prompt with "aspnet_reqsql. exe". But here are my problems:
When run the wizard I cannot get past the database selection screen (3rd screen). The error I get says "Failed to query a list of database names from the SQL Server. Invalid object name 'sysdatabases' ". I am 100% sure that the server and login information is correct, I am using it other places and it works fine. I called the web host and they were no help.
My .NET book also says that, instead of the wizard, I can run the SQL script called "InstallMembers hip.sql" that is in this folder: "C:\WINDOWS\Mic rosoft.NET\Fram ework\v2.0.5072 7". I am not sure how to do this.
Can anyone shed some light on this? The only advice I could find was to run the wizard, which seemed to work for most people. I don't really care whether the application uses SQL Server or the default setup, I just need it to work online.
Thanks in advance.
Thanks for your help. The web host doensn't seem to have an admin
panel. Is there a way to execute these scripts through Visual Studio,
Access, or another program?
No way to do that from your local machine. There should be a control
panel provided by the hosting company for dealing with the database.
You should talk with about this.
--
Vadivel Kumar http://www.vadivelk.net va**@online.vad ivelk.net (remove "online.") je************@ gmail.com wrote: Thanks for your help. The web host doensn't seem to have an admin panel. Is there a way to execute these scripts through Visual Studio, Access, or another program?
Vadivel, thanks for all your help. I was actually able to execute the
scripts from my local machine using SQL Server Management Studio, which
can be downloaded here: http://msdn.microsoft.com/vstudio/ex...l/default.aspx
There is perhaps a better way to do this, but I am unable to find it. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Carl M. |
last post by:
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...
|
by: C.Joseph Drayton |
last post by:
I have a problem that I am hoping someone can help me with.
First let me describe the problem. I have an HTML form that in one
field has an onBlur call to a JavaScript function. When you exit the
field, it calls the JavaScript routine, which in turn calls a PHP
script. The PHP script runs returns the value needed. And returns to
the JavaScript. The JavaScript function is then supposed to set
alerts depending on the values returned from...
|
by: Andy |
last post by:
Hi, I was wondering if someone could advise on if the following is
possible. I have one website that is available to the public using
Forms authentication and the Membership class, it creates/stores user
information in a SQL Server 2005 db. I have another website that will
administer the first website, allowing admins to look at all of the
users in the db and see specific info from the database.The admin site
is more secure than the...
|
by: jan82 |
last post by:
Hi all
I'm developing a website with Visual web developer in C#. Everything
works fine when testing using ctrl+F5. Also, IIS runs ASP.NET pages
without any problems. The problem I'm facing now is that standard
ASP.NET membership is not working when not using the visual studio
testing webserver. I just get the message that logging in has failed.
Any suggestions?
|
by: Runsrealfast |
last post by:
I am currently setting up my website to login etc. The default that
asp.net is set for is sql server express (express edition, to poor to
buy the real thing!) my host will only allow for access. How can I
change the default settings to use access instead of sql server
express? please help!
| |
by: shaun.laughton |
last post by:
Hi All.
I am new to ASP.NET 2.0 development, and am writing a small
application to log time and expenses for projects.
I have successfully set up Membership, Role and Profile providers
using the 'SqlProvider's and all appears to be well while I am using
the built in 'ASP.NET Development Server'. I am also using SQL Server
2005 Standard Edition - not Express.
|
by: Andy Fish |
last post by:
Hi,
I am trying to figure out how to use asp.net membership providers for my
vs2005 web project. unfortunately the only walkthrough in MSDN uses the "Web
Site Administration Tool" to configure the providers, and that tool only
seems to be available for web sites, not web projects.
I can't figure out where the WSAT persists all the settings. the user and
group information seems to be all in a SQL server database but there is no
where...
|
by: George Lft |
last post by:
ok, first of all, i built my register page using dreamweaver tool which the codes haven been out of control. Now i'm thinking that turning over everything - by using this another set of codes. And these new sets of codes have overwhelmed me a bit. Here's the new code:
CREATE TABLE `users` (
`ID` int(11) NOT NULL auto_increment,
`Username` varchar(255) NOT NULL,
`Password` varchar(255) NOT NULL,
`Temp_pass` varchar(55)...
|
by: =?Utf-8?B?QU9UWCBTYW4gQW50b25pbw==?= |
last post by:
Hi,
I have been using the code (some of it has been removed for simplicity)
below to allow authenticated (using ASP.NET membership database) users to get
a file from their archive area. It seems to work fine, however I noticed
that no web log entry is added when a successful download occurs (normally a
200 HTTP status code, however, if there is an authorization failure, it gets
logged). I have a logging routine that logs a successful...
|
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...
|
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,...
| |
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...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |