Problem in running NAV2009 with SQL Server 2008

integrated
Member Posts: 22
Hi everyone.
Not sure if this is the right place to post my problem here. It does look more likely a SQL Server problem :?
Btw, my customer is using SQL Server 2008 and I have recently installed NAV2009 on it.
Installation was fine, and I could connect to the server DB from a remote client with SA password (database level of course).
Two more users tried connecting the same way and for 90% of the time, only 2 users could be connected to the DB with SA pwd.
Then I added 2 users in the DB server directly, granting them access to the NAV DB only.
So far so good... but about 30-45 mins later, suddenly no one could get access to the NAV 2009 DB, with whatever login. SA failed, those newly created ones failed. The error msg was "Invalid UserID and Password".
I have never experienced such problem in NAV4.0/5.0 with SQL Server 2005.
Just want to know if someone is hitting the same problem as me...
pretty frustrated indeed.. ](*,)
Not sure if this is the right place to post my problem here. It does look more likely a SQL Server problem :?
Btw, my customer is using SQL Server 2008 and I have recently installed NAV2009 on it.
Installation was fine, and I could connect to the server DB from a remote client with SA password (database level of course).
Two more users tried connecting the same way and for 90% of the time, only 2 users could be connected to the DB with SA pwd.
Then I added 2 users in the DB server directly, granting them access to the NAV DB only.
So far so good... but about 30-45 mins later, suddenly no one could get access to the NAV 2009 DB, with whatever login. SA failed, those newly created ones failed. The error msg was "Invalid UserID and Password".
I have never experienced such problem in NAV4.0/5.0 with SQL Server 2005.
Just want to know if someone is hitting the same problem as me...
pretty frustrated indeed.. ](*,)
0
Comments
-
Which users you added - DB users or Windows users? You need to define them through NAV to have access to the NAV.0
-
Kamil you are right...
I missed out the Database Login Table setup...
what a miss. Nothing to do with sql server at all..
Thanks a lot!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