Showing posts with label icannot. Show all posts
Showing posts with label icannot. Show all posts

Friday, March 9, 2012

non default port - client cannot connect

I have changed the default port away from 1433 on sql server 2005. Now I
cannot connect from pc. What do I need to change on the client pc?
Thanks
Connect by adding a comma and port number after machine name, like:
machinename,1456
Or use cliconfg.exe to add an alias and specify the port number in that alias.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"guest5" <guest5@.discussions.microsoft.com> wrote in message
news:0A38D0A1-E40F-4A97-93D6-5C288E867802@.microsoft.com...
>I have changed the default port away from 1433 on sql server 2005. Now I
> cannot connect from pc. What do I need to change on the client pc?
> Thanks

non default port - client cannot connect

I have changed the default port away from 1433 on sql server 2005. Now I
cannot connect from pc. What do I need to change on the client pc?
ThanksConnect by adding a comma and port number after machine name, like:
machinename,1456
Or use cliconfg.exe to add an alias and specify the port number in that alia
s.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"guest5" <guest5@.discussions.microsoft.com> wrote in message
news:0A38D0A1-E40F-4A97-93D6-5C288E867802@.microsoft.com...
>I have changed the default port away from 1433 on sql server 2005. Now I
> cannot connect from pc. What do I need to change on the client pc?
> Thanks