Start
All Programs
Microsoft SQL Server 2005
Configuration Tools
SQL Server Configuration Manager
In the tree on the left expand the SQL Server 2005 Network Configuration
node
Click on Protocols for ... (your instance name)
In the details pane double-click on TCP/IP
In the property pages that appear click on the IP Addresses tab
Change your ports accordingly.
RE: Cannot connect to remote Sql Server 2005 ... Start SQL Server Configuration Manager in the Start Menu -> Microsoft...Microsoft Online Community Support... (microsoft.public.sqlserver.clients)
RE: Connet to MS SQL Express ... I understand that you could not connect to your SQL Server 2005 Express ... and then click SQL Server Configuration Manager.... to enable TCP/IP and Named Pipes protocols on your SQL Server 2005 client ... (microsoft.public.sqlserver.connect)
Re: Connet to MS SQL Express ... I understand that you could not connect to your SQL Server 2005 Express ... to Configuration Tools, and then click SQL Server Configuration Manager.... (microsoft.public.sqlserver.connect)
Re: SQL server access ...open sql server configuration manager... I suggest you to use a static port instead of a dynamic one. ... Configuration is set to local and remote connections using tcp/ip only. ... You can configure your port settings through SQL Server Configuration... (microsoft.public.sqlserver.setup)
RE: Cannot connect to remote Sql Server 2005 ... Any suggestions of a good Sql Server 2005 book for someone who knows Sql ... Start SQL Server Configuration Manager in the Start Menu -> Microsoft...Microsoft Online Community Support... (microsoft.public.sqlserver.clients)
