Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Can not connect to database using Nav 2009 RTC
aby280679
Member Posts: 9
Hi,
I am not able to connect to the database using the RTC. I get the following error message:
A Server was not found at "net.tcp//sto17dev:7046/Service3/Service". Either the URL is incorrect or the server is currently not available.
Please help me how can i resiolve this error.
Backgroud:
The SQL Server and database is installed on a remote server called STO17DEV. The SQL Server name is STO17DEV. This Server only have SQL Server and databases. It does not have Navision RTC or Navision Classic.The RTC is installed on a local system. Both the server and local system are on the same domain. I am able to ping the server from my local machine.
I have installed a New Navision service Tier and the service for this new service tier is running. The database has a windows login with super rights.
Before running the service for the new service tier I have following changes to the config file:
<add key="NetType" value="Default">
</add>
<!--
Name of the database server to connect to.
-->
<add key="DatabaseServer" value="sto17dev">
</add>
<!--
Name of the database instance to connect to.
-->
<add key="DatabaseInstance" value="">
</add>
<!--
Name of the database to connect to.
-->
<add key="DatabaseName" value="PIC2009SP1Dev">
</add>
<!--
Name of the Microsoft Dynamics NAV Server instance to connect
to (for client) or listen on (for server).
-->
<add key="ServerInstance" value="Service3">
</add>
<!--
The listening TCP port for the Microsoft Dynamics NAV Server.
This is part of the server's URL.
Valid range: 1-65535
-->
<add key="ServerPort" value="7046">
</add>
<!--
Please help me out in resolving the problem. Am I missing something.
I am not able to connect to the database using the RTC. I get the following error message:
A Server was not found at "net.tcp//sto17dev:7046/Service3/Service". Either the URL is incorrect or the server is currently not available.
Please help me how can i resiolve this error.
Backgroud:
The SQL Server and database is installed on a remote server called STO17DEV. The SQL Server name is STO17DEV. This Server only have SQL Server and databases. It does not have Navision RTC or Navision Classic.The RTC is installed on a local system. Both the server and local system are on the same domain. I am able to ping the server from my local machine.
I have installed a New Navision service Tier and the service for this new service tier is running. The database has a windows login with super rights.
Before running the service for the new service tier I have following changes to the config file:
<add key="NetType" value="Default">
</add>
<!--
Name of the database server to connect to.
-->
<add key="DatabaseServer" value="sto17dev">
</add>
<!--
Name of the database instance to connect to.
-->
<add key="DatabaseInstance" value="">
</add>
<!--
Name of the database to connect to.
-->
<add key="DatabaseName" value="PIC2009SP1Dev">
</add>
<!--
Name of the Microsoft Dynamics NAV Server instance to connect
to (for client) or listen on (for server).
-->
<add key="ServerInstance" value="Service3">
</add>
<!--
The listening TCP port for the Microsoft Dynamics NAV Server.
This is part of the server's URL.
Valid range: 1-65535
-->
<add key="ServerPort" value="7046">
</add>
<!--
Please help me out in resolving the problem. Am I missing something.
0
Comments
Ian
Ian
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
I am also facing the same issue.
If your issue is solved, please share the solution.
Thanks in Advacne,
Mallikarjuna