Hi
I'm new this .I' using SQL 2005 VWD05.Could some body tell me how to upload to my host server database to to run a membership user account.I dont know what are the procedure to do on my pc in order to transfer the file on the database.
Thanks
I'm not sure what's your exact meaning, but if you want to connect to a remote SQL Server (that's a SQL Server on a different machine rather than the client website application machine), you need to configure the connection string used by the membership provider. For more information, you can refer to this article:
http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx
And if you want to upload a existing database file which is being used by your website to the remote SQL Server, you'd better copy the database file to the local disk on the remote SQL machine, and then have the database file attached to the SQL intance.
|||I'm trying run a membership page using the createuserwizard.So how do you upload to the database on
the host server inorder to run the createusewizard to accept new account.
|||Lori could you give me a walk through example on how to create a blank instance?|||
bigmike40:
Lori could you give me a walk through example on how to create a blank instance?
ScottGu made clearly answer to this question on the link I post
The blank instance here just mean a new database without database objects required by membership management--this can be a newly created database or some existing database. So you can use Enterprise Manager/Management Studio to create a new database, and then use aspnet_regsql.exe to create database objects on the newly created database. If you want to use existing database on the remote SQL Server, you can move the database to the remote SQL Server using Backup/Restore or Detach/Attach. Here are some useful links for moving database:
Move database with Backup/Restore:http://msdn2.microsoft.com/en-us/library/ms190436.aspx
Move database using Detach/Attach:http://msdn2.microsoft.com/en-us/library/ms187858.aspx
|||Ok i have a question.Are you suppose to upload the data explorer files... in vwd in order for the createuserwizard to work, or just the app data folder|||Sorry I'm not familiar with what you said "upload data explorer files". However to use CreateUserWizard control you need to connect to an available SQL database. So if you want to use the existing database file on the remote SQL database, you'd better copy the database file to the local disk on the remote SQL machine so that the database file can be attached to the SQL instance.|||I'm sorry lori but i'm a newbei and some to the term i don't understand ,so can be a little more specifc on what u mean byif you want to use the existing database file on the remote SQL database, you'd better copy the database file to the local disk on the remote SQL machine so that the database file can be attached to the SQL instance.
|||OK, when you connect to a SQL database, first you need to login to the SQL instance (specified in Data Source property in connection string), right? And then you can use Database property to access an existing database on the SQL instance (for example pubs, tempdb); or use AttachDBFilename to attach a database and then access the attached database (note currently AttachDBFilename must points to a local database file, UNC, network path, HTTP are not supported), this is what I mean "using an existing database file". Apparently, no matter which database you're going to use, the database file must be on the local disk of the SQL machine, that's why I say "copy database file to the local disk on the SQL machine"
|||Would this help my CreateUserWizard to configure and create new user account ? Because i cannot
Get the CreateUserWizard to work on my host server whenever... i hit the submit button it give me an error
But it work fine on my local machine
thanks
|||What's the error you got? Have you configure the membership database connection according to theScottGu's article?|||
Iori i'd like to thank you for taking the time on helping me.For the past month i've trying to get my project to work, but so far no luck.I did try setting up VWD the way scott did , but for some reason when i ran the wizard PUBS, ASPNET, NORTWIND ISSUE TRACKER STARTERKIT, doesn't shows up in the drop down box ..But the others components are listed.I do belive that my problem is that my database is not settup properly. In order to settup my database, do i need to download any other software in order for all the missing componets to show up in the drop down box. I think u did explain it another thread that you did that precedure before. So can you tell me how you went about doing setting up the database.
Thanks you
|||
but for some reason when i ran the wizard PUBS, ASPNET, NORTWIND ISSUE TRACKER STARTERKIT, doesn't shows up in the drop down box ..But the others components are listed.I do belive that my problem is that my database is not settup properly.
Nevermind, it's my pleasure to share your issue Did you mean you can connect to the remote SQL Server in the aspnet_regsql.exe wizard, but some existing databases (PUBS, ASPNET, NORTWIND ISSUE TRACKER STARTERKIT) on the remote SQL instance don't show up? Then what's the meaning of "others components are listed"? Did you mean other databases on the remote SQL can be listed? If so, that's really strange, as I know there is no such database setting to control the listed databases in the aspnet_regsql wizard. Are you sure the permission setting of the account you're using is proper on the remote SQL instance? Can you connect to the remote SQL instance using this account?
I'm talking about the page where it say to select server and database on Scott blog.In the dropdown list he as
appservers,
ASPNET
Issue Tracker Kits
Master
model
msdb
Northwind
pubs
Those are the componets that are listed under database in Scott blogs
I did settup my config, but northwind, pubs, aspnet and the tracker kit didnt show up.
is it suppose to show up in the dropdown menu like how scott as it listed ?
And as far as can i connect to a remote SQL instance the answer is yes
On my host server i notice that there is nothing listed there in the database.
But my database name is listed in vwd and when hit test connection it said connected, so it seems that i can connect to myhost database, but i think that the info some how is not transfering over there some how.My project works
fine on my local machine but once i uploaded it on the server the CreateUserWizard doesn't work but all the other pages work fine. I belive that all the server control componets doesnt work on the server
I'm using WEB.com as my Host provider and the tech support don't seem to understaand anything about ASPNET 2.0
I think i might just get a better hosting company that don't out source their tech support
Thanks
|||After trying to follow Scott config i cannot get this screen.
Step 3: Point your web.config file at the new SQL Database
ASP.NET 2.0 now supports a new section in your web.config file called “<connectionStrings>” which (not too surprisingly) are used to store connection strings. One nice thing from an administration perspective is that the new ASP.NET Admin MMC Snap-in now provides a GUI based way to configure and manage these:
No comments:
Post a Comment