USE MASTER CREATE LOGIN [contoso\navsrvadmin] FROM WINDOWS; GO USE [Demo Database NAV (6-0)] CREATE USER [contoso\navsrvadmin] FOR LOGIN [contoso\navsrvadmin]; CREATE SCHEMA [$ndo$navlistener] AUTHORIZATION [contoso\navsrvadmin]; GO ALTER USER [contoso\navsrvadmin] WITH DEFAULT_SCHEMA = [$ndo$navlistener]; GRANT SELECT ON [Object Tracking] TO [contoso\navsrvadmin]; GO
setspn -A DynamicsNAV/NAVSERV.contoso.com:7046 contoso\navsrvadmin setspn -A MSSQLSvc/NAVSQL.contoso.com:1433 contoso\navsrvadmin
setspn -A http/NAVSERV.contoso.com contoso\navsrvadmin setspn -A http/NAVSERV contoso\navsrvadmin
httpcfg delete urlacl –u http://+:7047/DynamicsNAV/ message show completed with 87 httpcfg set urlacl -u http://+:7047/DynamicsNAV/ -a D:^(A;^;GX^;^;^;SID of contoso\navsrvadmin) message show completed with 0
The login failed when connection to SQL Server NAVSQL\MSSQLSVC.But when i use client sql, i can login from Client PC. Another, when i use RTC in NAV Server, i can open it.
Event Type: Error Event Source: MicrosoftDynamicsNAVServer Event Category: None Event ID: 0 Date: 3/23/2011 Time: 3:29:45 PM User: N/A Computer: NAVSERV Description: Service: The service MicrosoftDynamicsNavWS failed to start. This could be caused by a configuration error. Detailed error information:System.ServiceModel.AddressAccessDeniedException: HTTP could not register URL http://+:7047/DynamicsNAV/. Your process does not have access rights to this namespace (see http://go.microsoft.com/fwlink/?LinkId=70353 for details). ---> System.Net.HttpListenerException: Access is denied at System.Net.HttpListener.AddAll() at System.Net.HttpListener.Start() at System.ServiceModel.Channels.SharedHttpTransportManager.OnOpen() --- End of inner exception stack trace --- at System.ServiceModel.Channels.SharedHttpTransportManager.OnOpen() at System.ServiceModel.Channels.TransportManager.Open(TransportChannelListener channelListener) at System.ServiceModel.Channels.TransportManagerContainer.Open(SelectTransportManagersCallback selectTransportManagerCallback) at System.ServiceModel.Channels.TransportChannelListener.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.HttpChannelListener.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout) at System.ServiceModel.Dispatcher.ChannelDispatcher.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout) at System.ServiceModel.ServiceHostBase.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.Open() at Microsoft.Dynamics.Nav.WindowsServices.NavServiceBase.OnStart(String[] args). For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Comments
Epimatic Corp.
http://www.epimatic.com