How To on connecting to a hosted SQL Server Express database


Author
Message
Jeff Pagley
Jeff Pagley
StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)
Group: StrataFrame Users
Posts: 223, Visits: 893
I am attempting to setup ES today.  I know it's a Saturday, but with my busy schedule it is the best time to attempt to do something like this without any interruptions.  However, I notice that after I extracted the ES.zip file into the website,  the DataSources.config file references <TypeAssemblyVersion>1.6.0.0</TypeAssemblyVersion>.  Since I am now using 1.7.0.1 version, am I going to have a problem with the ES website communicating with my windows app using 1.7.0.1? 

Also, in the Web.config file, for the key="StatusIpAddresses" value="127.0.0.1", am I to add the ip address of www.prospecthelper.com which is 66.226.20.91?  Just so that I am clear, I don't have to add every ip address of the computers running my windows app to this key...right?

Thanks,

Jeff

Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
First, go ahead and change the version to 1.7.0.0. That will make sure to use the 1.7 references. I will make sure that these are updated for the next point release.



Second, you DO NOT want to add the public IP as the status IP address. This would allow every person in the world to see the status, password, etc. If you have access to the local IP, then use the local IP. Otherwise, you will want to secure this. This is a lot more detailed in the help documentation. There is a section in the DOCs that explain this setting that will be more helpful than my post. Let me know if you don't get it going.
Jeff Pagley
Jeff Pagley
StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)
Group: StrataFrame Users
Posts: 223, Visits: 893
Hi Trent,

To activate the license I need to provide the MAC address.  So I contacted WebHost4Life about supplying me the MAC address of the server hosting my website and this is what they said:

Hi
Please provide details of the .net application you purchased such as its official site and relevant urls of descriptions and requirements so that our supervisors can have an evaluation on the application.
Regards

I am not sure where to go from here.  Please advise.

Thanks,

Jeff

Jeff Pagley
Jeff Pagley
StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)
Group: StrataFrame Users
Posts: 223, Visits: 893

Second, you [b]DO NOT
want to add the public IP as the status IP address. This would allow every person in the world to see the status, password, etc. If you have access to the local IP, then use the local IP. Otherwise, you will want to secure this. This is a lot more detailed in the help documentation. There is a section in the DOCs that explain this setting that will be more helpful than my post. Let me know if you don't get it going.

Oops   I should have known that about the public IP.  However, I have looked in the Help File under Enterprise Server->Step 3: Configure web.config and I do NOT see any additional details on how to secure things regarding the Web.config file for the key="StatusIpAddresses" value="127.0.0.1".   Where is the info?

Thanks,

Jeff

Jeff Pagley
Jeff Pagley
StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)
Group: StrataFrame Users
Posts: 223, Visits: 893
Hi Trent,

Here is another response about the MAC address I received from WebHost4Life:

Hi Jeff, MAC address is sentative information and we will not provide it.

Are you using MAC address to activate your License? I checked their official site and seems you can activate it at your Local PC first, move it to our server and then contact strataframe.net to reset your account so you can re-activate on the new machine. You activate online through the My Account area and download the license file as opposed to a live activation client.

I'm not sure if you have to use new MAC address during "Re-activation". Would you contact strataframe.net about this first?

Trent, where do I go from here?  Please advise!

Thanks,

Jeff

Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
Well, I know that we have a number of users that are using hosting. I think that Keith may be using this very hosting site so we may want to ask him what he did with them in regards to this. I do not recall having a conversation with Keith when he published this, so he might be the person to ask in regards to the MAC address here.
Jeff Pagley
Jeff Pagley
StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)
Group: StrataFrame Users
Posts: 223, Visits: 893
Hi Trent,

I am not sure what I am to do.  This is a brand new application I have been working on and testing in a beta site.  All has gone well and now it looks like I am ready to release the production version of the software in the next couple of weeks.  The very last piece of the puzzle is to move the database from the local network to a hosting site and implement ES.   If all fails, I will need to set-up local installs of the database...Big Yuk!!!!  Unfortunately for me, I am new to web hosting and I was not aware that something like this would be a problem. This will be very disappointing, because I decided to build my solution with SF so that I could use ES for this purpose, and unfortunately, I told my customers about this great feature. 

I don't know who Keith is.  I am willing to use another hosting site if it will guarantee me the ability to do all of this. 

Is it possible for your to get me in touch with Keith?  Or just tell me what hosting site I should use.

Thanks,

Jeff

Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
I spoke with another SF User and he recommended the following:



http://www.hosting.com/dedicatedservershosting/



There is a rep named Eric Hutts that has been recommended as well. This is a dedicated box for around $89 a month versus a shared server box. I know that GoDaddy has an option like this as well. If you do this you will have a full machine dedicated and it will resolve many of these types of issues.

Jeff Pagley
Jeff Pagley
StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)
Group: StrataFrame Users
Posts: 223, Visits: 893
Hi Trent,

Thank you so much for the info.  I am really looking forward to using ES.  I will pursue this avenue.

Jeff

Jeff Pagley
Jeff Pagley
StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)
Group: StrataFrame Users
Posts: 223, Visits: 893
Keith Chisarik (06/24/2009)
One note, if you open up your SQL server, makes ure you have a robust firewall that ideally will only allow traffic from your clients IP's. We were brute force attacked less than 24 hours after I exposed our SQL server, even with non-standard ports set up. I learned the true value of strong passwords that day.

We use HostMySite for our dedicated and virtual hosting needs and I could not possibly be happier.

Hi Keith/SF,

To be able to use ES, I found out I need to have a dedicated server (using HostMySite), because ES licensing activation requires a MAC address which I did not know about.  

Anyway, I am new to having a dedicate server running SQL Server Workgroup 2005 hosted on the internet.  I was hoping that you or SF could give me some best practices on securing the server, SQL Server and IIS.   I am going to have clients connect from many different locations including their homes and so hard coding client IPs in the firewall will be I think difficult to setup and manage.  I am willing to do that if necessary, but I just don't know about this stuff.  I know there is a first time for everything and I am willing to learn and follow advice.

Any advice anyone can give me would greatly be appreciated BigGrin

Thanks,

Jeff

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search