role tailerod client can't be connected to demodb

hewajith
Member Posts: 96
My installation is three machine installation.
Afrte creating SPN I tried to connect to demo DB the following massage appears.
"'The Microsoft dynamics NAV server can not connect the Change Listener to SQL Server due to the following error: Cannot open database ‘’Demo Database NAV (6-0) requested by the login.
The login failed
Login failed user ‘ENABLINGQLD\PANTHOM$’’
Has anyone had this sort of error massage????/
Afrte creating SPN I tried to connect to demo DB the following massage appears.
"'The Microsoft dynamics NAV server can not connect the Change Listener to SQL Server due to the following error: Cannot open database ‘’Demo Database NAV (6-0) requested by the login.
The login failed
Login failed user ‘ENABLINGQLD\PANTHOM$’’
Has anyone had this sort of error massage????/
0
Comments
-
Have you added this user into the NAV through classic client? Have you set permissions for this user? Installation added the user who installed the NAV as SUPER user into the database. Other users must be added manually...0
-
This is the user who installed the NAV db server and App srever.
Any how I manage to set up some of the parameter given in Walkthrough: Installing the Three Tiers on Three Computers document and now I ended up with this error massage
''The login failed when connecting to the SQL server DB6"'
where DB6 is the SQL server Name.
I did not perform LAST part of the Walkthrough: Installing the Three Tiers on Three Computers document. that is
To delegate access to the SQL Server service>>> http://msdn.microsoft.com/en-us/library/dd301254.aspx
step 9.>>>> I can't see MSSQLsvr service is running when I click users or computers
what will be the possible reasons for that
Thanx0 -
Ok, you need to finish the last step. Why you do not see it - may be because you are looking on wrong PC? :-k0
-
NO.. that is active directory server .but it is not listing srevices when i click on users ansd computers step 8 and then I can't see MSSQLSvc,.....
To delegate access to the SQL Server service
1. Click Start, and then click Run.
2. In the Open field, type dsa.msc.
This opens the Active Directory Users and Computers utility.
3.Right-click the node for the domain where you have installed Microsoft Dynamics NAV, and then click Find.
4. In the Find Users, Contacts, and Group dialog box, type the name of the domain user in the Name field, and then press ENTER.
5. In the Search results area, right-click the domain user, and then click Properties.
6. On the Delegation tab, click Trust this user for delegation to specified services only, and then click Use Kerberos only.
There is also the option to not restrict authorization to Kerberos, though the environment is not as secure when you are less restrictive. Your decision on this point must be reflect in the value you assign to the AllowNtlm setting in the RoleTailored client configuration file (ClientUserSettings.config). See Configuring the RoleTailored Client for details.
7. Click Add to open the Add Services dialog box.
8. Click Users or Computers, and then specify the domain user.
9. In the list of services for the domain user, click MSSQLSvc, which is the SQL Server service.
Thnkx
10. Click OK to close the Add Services dialog box. Continue clicking OK to close all open dialog boxes0 -
[Topic moved from 'NAV/Navision' forum to 'NAV 2009' forum]Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!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