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
- 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
- 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
Options
SQL connection dropping
Herby06
Member Posts: 3
We have a server on our DMZ where users on a VPN can connect using RDP and then use the Nav client. we have opened the SQL ports through to our SQL server and all was running OK until 3 weeks ago. We have not made any chnages to our system at all but now users can still log into RDP OK and they can still use Nav ok for a while but then the connection drops (only SQL) and we get a message connection to server lost....
We have done a lot of work with the firewall and it is not blocking any SQL traffic.
We are running SQL Server 2005 64 Bit lastest service pack (4 I think) on a Windows Server 2003 64bit server. We are running Nav V5 sp1.
This is very frustrating and very differcult to determine what the issue is. I just hope that someone out there has had the same issue and can help [-o< .
Cheers
We have done a lot of work with the firewall and it is not blocking any SQL traffic.
We are running SQL Server 2005 64 Bit lastest service pack (4 I think) on a Windows Server 2003 64bit server. We are running Nav V5 sp1.
This is very frustrating and very differcult to determine what the issue is. I just hope that someone out there has had the same issue and can help [-o< .
Cheers
0
Comments
This has just happend again and we got the message:
The following ODBC error occured.
Error: [Microsoft][ODBC Driver Manager] Connection could not open State ID: 08003
Why and which ports did you open on SQL server? If you are using NAV as described (VPN+RDP) the default SQL port 1433 is enough. Are you sure that all of your users use RDP to connect to NAV. I bet that some use only VPN with the local installed NAV client to connect directly. Check it out.
SQL 2008, NAV 2009R2.
SQL service runs on dedicated machine.
there is terminal server where is permanently connected one session
in this session 2 NAV clients are running, there is one job scheduler active per each client.
in every NAV window, error [Microsoft][ODBC Driver Manager] Connection could not open State ID: 08003 is shown periodocally after some time.
what can be problem? this error is shown when user is connected to this session and is shown if user is not connected.
normally working users connected via the same terminal server are not getting this message.
can anybody help? I tried to search information related to error 08003 but I did not find anything.
thanks in advance.
anyone knows something concerning error 08003?
Thanks in advance