Last post Aug 15, 2015 05:14 PM by netproblems
Aug 10, 2015 09:26 AM|netproblems|LINK
After a few years in retirement, I reluctantly accepted being webmaster for an association when no one else would volunteer. The web site already exists, and is coded in asp.net (C#). I've had no problems editing web forms in it with Visual Studio Express.
There is a SQL Server 2008 database associated with the site, and that is working. The host company tells me that it has been enabled for remote access. I need to edit it.
I attempted to download and install SQL Server Management Studio Express - and wound up with something that looks like Visual Studio, but its desktop icon tells me that it s SQL Server Data Tools. The login details given to me correspond with
those I see in the site's web.config file. However when I attempt a remote log in with the Server Data Tools software, I get an error message that the log in has failed. Naturally, I have carefully checked that the correct strings have been entered. Since
the site itself can be accessed remotely, I can't see that I have a firewall problem. Any thoughts on what the solution might be?
Aug 11, 2015 01:39 AM|Nan Yu|LINK
Hi netproblems ,
Naturally, I have carefully checked that the correct strings have been entered. Since the site itself can be accessed remotely, I can't see that I have a firewall problem. Any thoughts on what the solution might be?
Are you sure the site itself can be accessed remotely ? if yes , have you got the correct IP address and port number of the remote database? Please try to specify IP address and port number in "Server name" box when login with
SQL Server Management Studio . And also double check the
Windows Firewall configuration , you could also refer to links for more details and solutions:
Aug 13, 2015 12:46 PM|netproblems|LINK
It looks like the problem is at the Sky hub blocking Port1433. I need to reserve an IP for the PC - and other computers on the network while I am at it, and enable port 1433 for the computers that need it. So hopefully all will be well - I'll post here
one way or the other.
Aug 14, 2015 07:31 AM|netproblems|LINK
I am still having problems, and have asked the host company to look at the server error log.
I have been getting error 18456 using SQL Server Management Express.
The router has been set to allow Port 1433 inbound for the computer IP which is fixed locally. I have confirmed that the IP address is correct with ifconfig. The PC has a Windows Firewall rule to allow Port 1433 inbound and outbound. Virus protection is
vial Microsoft Security essentials, which should accept the firewall rule. I have even tried switching off the PC firewall off altogether with no success.
Aug 14, 2015 03:25 PM|netproblems|LINK
Just out of curiosity, I ran telnet from my Mac - and got a response:
telnet sqlxxxx.xxxxx.co.uk. 1433
Connected to sqlxxxx.xxxxx.co.uk.
Escape character is '^]'.
Connection closed by foreign host.
So it looks like there is some bizarre problem in the PC.
Aug 15, 2015 05:14 PM|netproblems|LINK
I have finally managed to connect with SQL Server management Express. Most peculiar. In the process of taking screen shots for an expert friend, I ran a connection attempt relying on the ethernet, with the wifi turned off, since that had a dynamically allocated
IP from the router. Now I am sure that I have done this before - but - bingo -this time I got in.
What I did do differently was copy the username directly from the webconfig file, rather that the Word file I have been using up to now. I know Word has all sorts of crap in the background, but I didn't think that would worm its way into a connection field
- so maybe there is a typo somewhere. Whatever, I am now in.
I have to put my hand up to a simple error at this end.