Server Port

dabel
Member Posts: 44
I have a client that does not want to use port 1433. They have no problem connecting to the database using windows authentication, however, each time they close and come back in, they have to renter the port number. I have tried setting the port in the parameters of the target line, but I am either doing something incorrectly or this is not designed to work this way.
Any suggestions?
Thanks
Any suggestions?
Thanks
0
Comments
-
server=192.168.100.1:1234 doesn't work on shortcut parameter?0
-
1) By the port no. I assume that you are using MS SQL server... thanks for saying that... ;-)
2) You can start the Client Network utility (C:\WINDOWS\system32\cliconfg.exe) on each PC (part of the MS SQL client instalation) and set the default TCP port to other one.0 -
I am in the process of trying the first suggestion, they were using the actual server name and not the IP Address. First I am going to have them enter the IP in the standard connection dialog window, if that fails, then the shortcut parameter and if that fails then the config utility.
Sorry about leaving out the SQL reference, I thought about that later, but got distracted.
Thanks for the help, both sound as if they will resolve the issue.0
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
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions