Hello -

We are trying to move the site 'adxtactical.com' to a new GoDaddy.com Virtual Server from a shared-hosting account.

I have temporarily pointed the Virtual Server to the adxtactical.net domain to test the site, etc.

After everything is complete, I will rename the Virtual Server to the .com name and close the old shared-hosting account.

Anyways - first issue is the adxtactical.net site is running VERY slow, but I am hoping this specific issue is related to the issue below:

I have restored the full backup of the SQL Database onto the Virtual Server SQL Database already using Remote Desktop Connection and SQL Server Management Studio Express, but I am having trouble trying to connect the SQL Database with the site.

I have tried multiple connection strings, and nothing seems to be working.  Also, I am 'on my own' with this issue because the GoDaddy.com tech support basically told me this isn't there issue and they can't provide me with any more help!

I have tapped into forums, etc but all I can find is more connection strings to try.

The string I tried to use most recently is this, and it doesn't work:

Provider=sqloledb;Data Source=Server IP,1433;Initial Catalog=SQL Database Name;User Id=USER;Password=PASS;

(I have tested this string in ProductCart's Web Server Readiness Utility)

I think this issue might be bigger than just the connection string though, but this is my first time doing this so what do I know? haha

I've been pulling my hair out about this for over a week now and a solution would be most welcomed. 

I understand this is probably not a ProductCart issue, but I am hoping some of you have had this issue in the past and know how to resolve it.

Thanks for the help
-Joe


Edited by BlackReefDesigns - 09-January-2009 at 10:20pm

Ya I tried to reply to your PM but it wouldn't let me...

But let me say that I have learned the hard way that GoDaddy.com is horrible - from their tech support to their servers.  I wish I hadn't gone with them, but now I am in too deep since my customer had purchased a year plan of Virtual Dedicated server

I will utilize different hosting companies in the future..

Thanks for the hosting string BTW, but it doesn't seem to be working.  However I used my IP address for the Data Source - would that work?  I notice you have something different in that field