Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Changing SQL TCP Port from 1433
rust
Member Posts: 27
Hi
I am Installing SQL 2005 with NAV 5.0 sp1 in Windows Server 2003.
My User does not want to use the SQL default port 1433.
I have try changing the port from 1433 to 1434 using SQL Server configuration Manager, restarted the services and firewall port is opened.
However only the Server is able to connect, other PC in the network is unable.
I would like to check with you guys is it possible to change the port ?
How Can i do it?
I am Installing SQL 2005 with NAV 5.0 sp1 in Windows Server 2003.
My User does not want to use the SQL default port 1433.
I have try changing the port from 1433 to 1434 using SQL Server configuration Manager, restarted the services and firewall port is opened.
However only the Server is able to connect, other PC in the network is unable.
I would like to check with you guys is it possible to change the port ?
How Can i do it?
0
Comments
Did never try any of these but this seems a logical solution.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
test following:
configure alias using the SQL Server Configuration Manager and configure the port number in the alias. (alias = YourServername, Portno = YourNewPort, Servername = YourServername)
other question: is NAV the only application which can't connect :?: Or can you also not connect from other PC with SQL Server Manager to your SQL server :?:
Regards