Re: Cant Connect anymore

I stumbled across the answer, if I change the default port, I HAVE to create
an alias name and use it in the login box instead of the servername itself..

BUC

<Buc> wrote in message news:%23rm9$GUSGHA.4600@xxxxxxxxxxxxxxxxxxxxxxx
Need help. I changed my TCP connect port for SQL2005 to port 9601.
(ON THE SERVER..went into SQL Config manager >
SQL 2005 Net Config / TCPIP Properties
Changed TCP Port to 9601
Changed TCP PORT for IP2 section to 9601 where ip is 127.0.0.1
Changed TCP for IPAll section to 9601
Dynamic TCP Port was unchanged and remained blank..
Under SQL Config Manager > SQL Native Client Network
Changed TCP PORT to 9601
-------------------
On my laptop went to
SQL Server Config manager
Changed TCP Port to 9601
under SQL Native Client /
Client Protocols / TCPIP..
REBOOTED EVERYONE..

I have a vb.net app, tried to access SQL DB and it failed, so I added the
new port (9601) in the connect
string, and then it worked, so I know the server port was changed to 9601.
However, can no longer connect VIA SQL 2005 Management STUDIO, says
An error has occ while establich connect... TCP Provider error: No
connection could be
made.. target machine actively refused it. Error #10061).

The vb.net app works with new port, why doesn't SQL Management studio?
Changed back to 1433 and everything works again. I've got to change the
port,
How can I and get SQL Management studio to work with a non default port?
Tried the Management studio on another machine.. same error, although
vb.net app connects fine under new port. This is crazy..

The server has an internet Ip address and I am accesing it via .com name
( in the vb.net app too)
( I tried the straight IP address, didn't work either)

Thanks BUC



.

Relevant Pages

  • Re: SQL DBA Client
    ... What is required depends on how you expose your SQL... ... measures you should consider are changing the port number ... you're using and using a User account with minimal ... Enterprise Manager accordingly (configuring the Client ...
    (microsoft.public.windows.server.sbs)
  • Re: Merge replication in SQL Server
    ... However, port 443 is for https, did you want your SQL ... Configuring an instance of SQL Server to use a static port ... you can script out replication jobs by right clicking on a publication ...
    (microsoft.public.sqlserver.replication)
  • Re: Cant Connect anymore
    ... service maps incoming requests to the port where the database is listening ... SQL 2005 Net Config / TCPIP Properties ... Changed TCP PORT for IP2 section to 9601 where ip is 127.0.0.1 ... The vb.net app works with new port, why doesn't SQL Management studio? ...
    (microsoft.public.sqlserver.security)
  • SQL Adapter with Map blocks SQL Server?
    ... We have a receive port that executes a stored procedure via an SQL ... XmlReceive/Passthrough as receive/send pipeline and simply dump the XML ... if we specify inbound and outbound maps, ...
    (microsoft.public.biztalk.general)
  • Re: Connecting to an instance in a cluster
    ... "Geoff N. Hiten" wrote: ... you cannot reuse port numbers. ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)