web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / NAV 2016 - 'A serv...
Microsoft Dynamics NAV (Archived)

NAV 2016 - 'A server was not found at "Net.tcp://Server:7046/DynamicsNAV90/Service'

(2) ShareShare
ReportReport
Posted on by Hendo 584

Hi. We have a new install of NAV 2016 and we are accessing it via a RDC connect successfully.   We have also installed the client on a local PC (fat client).   Whenever we try to login in to NAV we get the following message ...

'A server was not found at "Net.tcp://Server:7046/DynamicsNAV90/Service". Either the URL is incorrect or the server is currently not available'.  Given we are able to log in using RDC, the server must be available.   What could the problem be???

Cheers.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Jens Glathe Profile Picture
    Jens Glathe 6,092 on at
    RE: NAV 2016

    Hi James,

    there could be several. The first thing you need to check whether the Service Tier is running. The URL to connect via RTC (Windows client) would be "localhost:7046/DynamicsNAV90". If you start the Service Tier, but it stops when you try to connect, there could be a permission problem. You would need to check if the account that runs the Service Tier has DBOwner-Rights on the database.

    with best regards

    Jens

  • Suggested answer
    aavio Profile Picture
    aavio 895 on at
    RE: NAV 2016

    is ur local pc connected to the domain network? Please confirm this under system properties.

  • Hendo Profile Picture
    Hendo 584 on at
    RE: NAV 2016

    Hi. Yes it is connected to the domain network.

  • Suggested answer
    Roberto Stefanetti Profile Picture
    Roberto Stefanetti 12,998 on at
    RE: NAV 2016

    hi,

    about this issue:

    'A server was not found at "Net.tcp://Server:7046/DynamicsNAV90/Service". Either the URL is incorrect or the server is currently not available'.

    > connection issue i think, not security issue.

    Some checks

    > Check local firewall (switch off)

    > Check fully qualified server name ex: Server.domain.xx

    > copy NAV configuration file from RDP (where NAV is working)

    Try with Development Environment (if you have)

    > check if you have Nav Server defined in "Database Information\Server Instance"

  • Suggested answer
    Miguel Llorca Gómez Profile Picture
    Miguel Llorca Gómez 7,019 User Group Leader on at
    RE: NAV 2016 - 'A server was not found at "Net.tcp://Server:7046/DynamicsNAV90/Service'

    I suggest you to check your connection through this port (firewall, av, etc.). You should also check the status and config for the NAV service with the "NAV Administrator" on the server.

    Good luck and let us know!

  • Suggested answer
    Raja Venkat Profile Picture
    Raja Venkat 192 on at
    RE: NAV 2016 - 'A server was not found at "Net.tcp://Server:7046/DynamicsNAV90/Service'

    hi,

    I would suggest to check for instance for is running or not...

  • Suggested answer
    Raja Venkat Profile Picture
    Raja Venkat 192 on at
    RE: NAV 2016 - 'A server was not found at "Net.tcp://Server:7046/DynamicsNAV90/Service'

    check it only for u

    http://beginnersnav.blogspot.in/

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: NAV 2016 - 'A server was not found at "Net.tcp://Server:7046/DynamicsNAV90/Service'

    Check it if user permissions and also check permissions give as super.

    Regards,

    Ramesh.

  • ManishS Profile Picture
    ManishS 86 on at
    RE: NAV 2016 - 'A server was not found at "Net.tcp://Server:7046/DynamicsNAV90/Service'

    We too are getting the same issue.

    We have two server one is the database and other is the application, both are in same domain.

    Services are running and in development i can see the service instance, but when i start RTC it shows error.

    When checked in event viewer i get this error,

    Server instance: XYZ

    Tenant ID:

    User:

    Type: Microsoft.Dynamics.Nav.Types.Exceptions.NavSqlException

    ErrorNumber: 102

    SuppressMessage: False

    SuppressExceptionCreatedEvent: False

    FatalityScope: None

    Message:

    The following SQL error was unexpected:

    Incorrect syntax near '='.

    Statement(s) could not be prepared.

    SQL statement:

    DECLARE @LastActiveDate AS DATETIME = GETUTCDATE();UPDATE [XYZ].dbo.[Server Instance] SET [Last Active] = @LastActiveDate WHERE [Server Instance ID] = @0;SELECT IIF(@@ROWCOUNT = 0, NULL, @LastActiveDate)

    StackTrace:

    at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)

    at System.Environment.get_StackTrace()

    at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.ThrowNavSqlException(SqlExceptionAdapter exceptionAdapter, NavSqlCommand command, Boolean isLastExceptionARollbackCause, Boolean logExceptions)

    at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.<>c__DisplayClass12`1.<ExecuteFunction>b__11()

    at Microsoft.Dynamics.Nav.Types.NavThread.RunExternalAction[T](Func`1 action)

    at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.ExecuteFunctionWithTrace[T](EventTask task, Func`1 function, NavSqlCommand command)

    at Microsoft.Dynamics.Nav.Runtime.Heartbeat.<>c__DisplayClass2.<ExecuteWriteHeartbeatToServiceInstanceTable>b__1()

    at Microsoft.Dynamics.Nav.Runtime.NavPerformanceCounterSetter.UpdatePerformanceCountersWithDuration(Stopwatch stopWatch, Action action, NavPerformanceCounterEntry performanceCounterEntry)

    at Microsoft.Dynamics.Nav.Runtime.Heartbeat.ExecuteWriteHeartbeatToServiceInstanceTable(NavDatabase database, NavSqlCommand updateCommand, NavSqlConnectionScope conScope)

    at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.ExecuteCommandAndCacheOnSuccess[T](NavSqlCommandCacheKey commandKey, Func`1 createFunc, Func`2 executeFunc)

    at Microsoft.Dynamics.Nav.Runtime.Heartbeat.WriteHeartbeatToServiceInstanceTable()

    at Microsoft.Dynamics.Nav.Runtime.PeriodicScheduler.RunAction()

    at Microsoft.Dynamics.Nav.Runtime.ThreadPeriodicScheduler.DoScheduledAction()

    at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

    at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

    at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)

    at System.Threading.ThreadHelper.ThreadStart()

    HResult: -2146233088

    ----------------------------------

    Type: System.Data.SqlClient.SqlException

    ClientConnectionId: 4a3d6d9e-3541-49d0-8aa6-dc9f1889dc73

    Class: 15

    LineNumber: 1

    Number: 102

    Server: SERVER\XYZ

    State: 1

    Source: .Net SqlClient Data Provider

    ErrorCode: -2146232060

    Message:

    Incorrect syntax near '='.

    Statement(s) could not be prepared.

    StackTrace:

    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

    at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

    at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()

    at System.Data.SqlClient.SqlDataReader.get_MetaData()

    at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)

    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)

    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

    at System.Data.SqlClient.SqlCommand.ExecuteScalar()

    at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.<>c__DisplayClass12`1.<ExecuteFunction>b__11()

    HResult: -2146232060

  • Suggested answer
    RockwithNav Profile Picture
    RockwithNav 8,467 Super User 2025 Season 2 on at
    RE: NAV 2016 - 'A server was not found at "Net.tcp://Server:7046/DynamicsNAV90/Service'

    Press Alt + f + b + i on Development Environment and check Server Instance is there or not. If its blank that means Service tier is yet not mapped correctly. Cross check it and restart the instance. check the event viewer for more information's.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Alexander Ermakov Profile Picture

Alexander Ermakov 2

#2
SC666 Profile Picture

SC666 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans