MS SQL server through non standard ports??

ragsy · Joined: 03 Jun 2003 Posts: 6 Location: Barton ACT

Hi all

Just purchased HM yesterday and i'm trying to setup some database tests

I have managed to get the MS SQL tests running on the local LAN but i cant get it to work in our Secure environment

I normally can connect to this server using query analyser via non standard ports, but i cant find anywhere to specify these ports or the IP address in HM

Is this somthing that can be done???

[ This Message was edited by: ragsy on 2003-06-04 21:04 ]

KS-Soft · Joined: 03 Apr 2002 Posts: 12795 Location: USA

I think you can create alias using IP address and port. And use that alias instead of server name.
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q265/8/08.ASP&NoWebContent=1

Regards
Alex

ragsy · Joined: 03 Jun 2003 Posts: 6 Location: Barton ACT

Thanks Alex

That was the answer i needed

All working well now