Could Someone Help me to Config SQL2005 to Connect to my Host Database Server

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

|||

bigmike40:

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:

Could not get into server instance

Hi,
I ran Enterprise manager, but I could not get into my
server. It said that it was not running or to check '
the config, which is fine and is Windows Only Authentication.
Here is the weird and scary part. ZoneAlarm had an alert
at the same time. The alert was asking for Management Console
to use USERINIT.EXE to access 192.5.6.30DNS.
This resolves to a.gtld-servers.net which is part of Verisign.
I refused this outbound access and kept retrying to get into
my server in Enterprise. No luck. I then decided to go ahead
and give outbound access. Next time I tried to get into
my server I was able to.
Does anyone know what's up?
I figured that maybe I should change all my logins?
But, does this show that there is a breach of my system?
There has been another odd thing where WSCRIPT.EXE has
been asking for access to DNS servers. That I keep blocked.
I am pretty sure that is a trojan, but do you think this is this related ?
Thanks for any advice.
FoxAs a very first step -- scan your computer for virus or Trojans, I think you
may have a serious exploit on your hands.
Steve
"Fox" <fox @. connexions .net> wrote in message
news:e9HspB2wDHA.2408@.tk2msftngp13.phx.gbl...

quote:

---

> Hi,
> I ran Enterprise manager, but I could not get into my
> server. It said that it was not running or to check '
> the config, which is fine and is Windows Only Authentication.
> Here is the weird and scary part. ZoneAlarm had an alert
> at the same time. The alert was asking for Management Console
> to use USERINIT.EXE to access 192.5.6.30DNS.
> This resolves to a.gtld-servers.net which is part of Verisign.
> I refused this outbound access and kept retrying to get into
> my server in Enterprise. No luck. I then decided to go ahead
> and give outbound access. Next time I tried to get into
> my server I was able to.
> Does anyone know what's up?
> I figured that maybe I should change all my logins?
> But, does this show that there is a breach of my system?
> There has been another odd thing where WSCRIPT.EXE has
> been asking for access to DNS servers. That I keep blocked.
> I am pretty sure that is a trojan, but do you think this is this related ?
> Thanks for any advice.
> Fox
>

---

|||I have already scanned several times and have come up with nothing.
I changed all logins related to admin.
A few weeks ago I found entries in my firewall to allow 3 IPs
access. I saw them in there once before and deleted them.
This time I block them entirely from access. It seems I've been
playing a cat and mouse game for a while. But I cannot find
the source and a re-install is out of the question. There were
a few other things that happend earlier this year. I don't
know what to do next to try to find the source of this.
Regards,
Fox
"Steve Thompson" <SteveThompson@.nomail.please> wrote in message
news:eZcXtC$wDHA.3116@.TK2MSFTNGP11.phx.gbl...

quote:

---

> As a very first step -- scan your computer for virus or Trojans, I think

---

you

quote:

---

> may have a serious exploit on your hands.
> Steve
>
> "Fox" <fox @. connexions .net> wrote in message
> news:e9HspB2wDHA.2408@.tk2msftngp13.phx.gbl...
?[QUOTE]
>

---

|||What are you using as a firewall?
Is this a "live" SQL Server on the internet?
What type of applications are connecting to this Server?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.