Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K 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
- 295 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 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
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
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
I missed out the Database Login Table setup...
what a miss. Nothing to do with sql server at all..
Thanks a lot!