Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 help to access sql server on another webserver

Author  Topic 

SHIVPREET2K1
Starting Member

32 Posts

Posted - 2010-09-25 : 03:53:05
Dear All

My problem is bit tricky. I had purchased a window hosting from godaddy server and deployed my website and sql server database there.

On that server the limit for database was 200 mb. It was working fine there.

as my data increased beyond that limit i had to resort to some other option. My network guy purchased sql server space from justhost.com which was cheaper and better and we transferred our sql server database to justhost.com.


now I am unable to access my sql server database which is on justhost.com, from my website which is on godaddy.com.

I changed the connection string and all. but still its not working.
Please help its urgent.


thanks in advance

Shivpreet2k1



Kristen
Test

22859 Posts

Posted - 2010-09-25 : 03:59:38
What is your connection string? (you should disguise the username / password etc but do it in a way that we can see what the general style of the connection string is please)

Is justhost allowing external access to the database? Can you access the database on justhost direct from your PC using a remote connection string? Personally I wouldn't allow any such remote access to our SQL Servers - except for approved IP addresses only (controlled by our firewall)
Go to Top of Page

SHIVPREET2K1
Starting Member

32 Posts

Posted - 2010-09-25 : 04:03:37
yes i can access database from justhost on my pc. and i change the connection string in the website too. and the connection string includes in it username and password. thanks for your help buddy. is there anything i need to do to sort this out.

thanks again
Go to Top of Page
   

- Advertisement -