Hi,
I have a strange problem:
I have a directory with nopcommerce 2.10, on my local machine (iis7),
i install nopcommerce, that's ok.
i have in my machine db of nopcommerce with no sample. all ok.
The site work ok on local machine.
I copy the my directory nopcommerce site on host provider with iis 7, .net 4, mvc 3 ecc ecc.
Make backup of db and restore on my provider with sql server 2008 ... i see the table dbo schema ...
with managment studio, i try to connect with simple c# program, i open and close connection. all ok.
when i try to open site on provider www.xxx.com
i have this error:
Server Error in '/' Application.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - An attempt was made to access a socket in a way forbidden by its access permissions.)
Settings.txt :
DataProvider: sqlserver
DataConnectionString: Data Source = tcp:74.124.XX.XX,1089; Initial Catalog = nop21; Persist Security Info = True;User ID=adgXXXX;Password=YYYYY;
if i use :
same connection string on c# program on my local machine work , open and close connection ok.
Thank you :) :)