anil21_22gupta wrote:Hello! This is my first post on NopCommerce, and I must say it is a VERY powerful tool if you have a lot of patience and time, and know how to research. There is tons of great information on this forum, and I think you guys/gals are great that offer your time to lend a helping hand. I would like to add to the solution offered above. This was the route I ended up going, and it took many hours of my time but I finally managed to get Nopcommerce 1.9 installed on GoDaddy hosting. I must also add that I agree with many of the individuals on this site about the poor hosting product that GoDaddy offers. I ran into a problem publishing a SQL database from my local environment to GoDaddys SQL database, and the GoDaddy representative simply told me that what I was looking for didn't exist and was not available. Because I did not feel like arguing with him and did not know what I know now to be able to explain myself competently, I just kept on experimenting. Hopefully this information will help someone out that struggled like I did. To begin, I originally installed Nop 1.6 using GoDaddys hosting applications. When this was installed, the end result was an extremely slow website. I never figured out exactly what it was, so being the tenacious person I am, I aimed to install 1.9 for a client using GoDaddy. I did not know what I was getting into! To make this solution/story as short as possible, MY problem when trying to install 1.9 onto GoDaddy was trying to get writing permissions to GoDaddys hosting server, which most of us know is not possible. I used the solution above mine to first install Nop 1.9 to the local host, and then attempt to copy the SQL database Schema to GoDaddys database. Here is where it gets tricky. I had SQL 2008 R2 on local machine, and I also selected 2008 on GoDaddy. To copy the database, I needed to use the Database Publishing Wizard, found in the Microsoft SQL Server Tools. If you need more details about what steps I followed, you can look at the solution above or follow up to this post. Now, my issue was that when you are using the Database Publishing Wizard (lets refer to it as DPW from here) is that it requires a "Web Server Address" to publish the database too. I had trouble locating this link, and was very confused thinking it was my host name or SQL server host address. This was incorrect. In many tutorials I've found for installing NOP on GoDaddy, it tells you to get this Web Server Address for publishing the database in the "edit" section of the SQL Server section in the hosting control Panel. For those of you who are familiar, this section also contains the ConnectionString or Connection Strings for SQL and ODB, etc. The link that I needed was for the Publishing Wizard. I couldn't find this link to save my life! The reason I couldn't find it is because GoDaddy does not provide this URL for SQL 2008!!! After scratching my head looking for this information, I finally figured it out that it only showed this information for SQL 2005. I switched database versions to 2005, and voila, it was there. The link is something like this.....https://p3*******.secureserver.net. Now , I was just getting started. I had created my Local site using SQL 2008, so now I felt I was back to square one. However, I was wrong. I downloaded Visual Studio Web Developer and used the Database explorer to convert my SQL 2008 database that I created to 2005 (target file). Once I did that, I was able to publish my database to GoDaddy with no errors!!! The moment of truth came when I manually edited my connection strings. YOU MUST DO THIS! Especially when starting from a local environment, because you will have something similar to SQLEXPRESS for the data source instead of your server from GoDaddy. Once you update the connection string, and set your permissions for App Data, images, and all their children (inherit), You should now be close to having a fully functioning NoPCommerce installation on GoDaddy, 1.9!!! If you have any questions about what I did, please let me know and I'll run down what I did. I'm in a hurry typing this, so I apologize if this is convoluted. Don't give up, it can be done, and without all the steps that some people are going through to get this to work. It's very simple, believe it or not way more simple starting locally.
