Connecting to SQL database from ASP.NET - UK Web Hosting | Dedicated Server Windows and Linux VPS Forum

**ChrisF** · #1 (**permalink**) 27-03-2007, 09:16

Hi, I've created a new SQL Server database through Hosting Controller, how can I connect to it through SQL Server Management Studio or Enterprise Manager? Also, what connection string should I use to connect to it from my ASP.NET application? Thanks

Rock · #2 (**permalink**) 02-04-2007, 21:38

Hi Chris,

If you are on HC6.1 server (Tucano), use the following steps to connect to SQL 2000 server:
Connecting to MS SQL DB via Enterprise Manager
How do I use Enterprise Manager to connect to my MsSQL DB?

If you are HC7 server (Vigilant), use the following steps to connect to SQL 2005 server:
You need to follow all the steps mentioned above except a small change, the DB server's IP should be set as 'IP\sqlexpress' (eg: 10.10.10.10\sqlexpress)

Regarding the connection strings, refer the following URL for more accurate details:
http://www.connectionstrings.com/?carrier=sqlserver
http://www.connectionstrings.com/?carrier=sqlserver2005

Let me know if you need any further help.

**roboteknic** · #3 (**permalink**) 26-04-2007, 12:21

Hi,

I have tried using the above format IP:sqlexpress to 2 differnt db's i have and using the loginand pass (i am using SQL Server management studio express) but can not connect to eitehr of them?

has anyone achieved this? if so please let me know how

thanks,

Paul

**eUKhost.com** · #4 (**permalink**) 26-04-2007, 22:09

hello Paul,

Jack sorted your problem in reply to AMZ-73312-581

It takes some time to respond to tickets but helpdesk is the best option to get high level technical solution. You did mention that you lost time in MSN support but we cannot deploy our senior staff members on MSN as chats or phones distract them and they cannot solve critical problems if they are forced to give priority to communication.

**DavidAllen** · #5 (**permalink**) 28-04-2007, 21:51

Could you post the solution here cos I am also having trouble connecting to 2005 using SQL Server Management Studio & Enterprise Manager
Thanks
David

**eUKhost.com** · #6 (**permalink**) 28-04-2007, 22:00

Please use the following details to connect to your database:
----------------------------------------------------------------------------------
Server name (HOST) : vigilant.eukdns.com\SQLEXPRESS or 87.117.234.246\SQLEXPRESS
DB name : user_dbname
DB Username : user_dbuser
DB Password : userdbpass
----------------------------------------------------------------------------------
I am able to connect to your DB using the above details.

Also, please check whether your ISP is blocking port 1433 (Default SQL Server port).
Turn off your local machine's firewall/anti-virus, it might be the possibility for the problem.

Please check the same at your end & let us know if you are still unable to connect to your DB. Standing by to assist,

Regards,
Jack L.

**DavidAllen** · #7 (**permalink**) 29-04-2007, 12:06

I suspect that NTL (Virgin Media these days) might be blocking 1433 - is there an easy way to check (other than phoning them - which with NTL is not likely to lead to an answer).
TIA
David

**eUKhost.com** · #8 (**permalink**) 29-04-2007, 12:28

telnet 87.117.234.246:1433

**DavidAllen** · #9 (**permalink**) 29-04-2007, 13:48

Thanks for that - I just tried the telnet and get

Quote:

Connecting to 87.117.234.246...Could not open connection to the host, on port 1433: Connect failed

Guess that mean the port is blocked by NTL?
Is there anything alse that can be done?
Regards
David

Rock · #10 (**permalink**) 29-04-2007, 19:18

Hi David,

Usually ISP's (here NTL) don't block the SQL Server port, so working of 'telnet 87.117.234.246:1433' isnt necessary. I'd suggest you to try connecting to your DB from a different machine or network. Calling NTL may help clearing any thoughts of port-blocking.
Or you can have a ticket opened up with our support dept. They'll get your issue sorted out ASAP. Thank you

**DavidAllen** · #11 (**permalink**) 03-05-2007, 17:35

Hi Rock
Well I tried connecting using my laptop from a friends house and it worked just fine. I also spoke to NTL/Virgin who said categorically that they don't block ports (although a quick google suggests they do). So I'm stuck not being able to connect from here.
Someone suggested port forwarding - but that is apparently not allowed
So does anyone have any other ideas?? Please

**DavidAllen** · #12 (**permalink**) 10-05-2007, 21:19

Is there anyone who uses ntl/virgin Media who can connect remotely to MS SQL Server 2005 on euk servers? - My main customer wants several more domains with me but needs the remote access and he is also on NTL/Virgin.

Other than that i read that MS SQL Server 2005 can communicate remotely with two different ports (1433 and A N other ??) but the depths of this is beyond me
Regards

**flesso** · #13 (**permalink**) 10-05-2007, 21:24

I'm no expert at this stuff, but how about you try and route it all via a proxy or if you're on cable internet and have a static IP, get them to open the port up for you.

**eUK-Martin** · #14 (**permalink**) 14-06-2007, 15:10

SQL Server requires port 1434 open to connect remotely. Since remote connections are handled by "SQL Browser Service" which runs on port 1434. Telnet might not work on some occasions as they are disabled at the server end.

Just make sure that your personal firewall allows you connect on these ports. The best way is to shutdown the firewall/antivirus program and then try to connect.

**DPS Computing** · #15 (**permalink**) 15-06-2007, 08:59

Yes, I have had many a trouble with firewalls in the past - getting them configured properly takes a lot of work!