Howdy, Stranger!
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
- 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
SQL Server : Login failed
jorgito
Member Posts: 115
Hi all!
We use Navision 4 with SQL Server 2000 and Windows authentication. Most of the computers have WinXP and some Win2k.
Sometimes, when we try to connect to the server, we get the following message:
[SQL Server] Login failed for user (null). Reason: Not associated with a trusted SQL Server connection.
So we have to connect using SQL Server authentication.
Over time, the problem gets solved by itself and we are able to connect using Windows authentication.
What is the meaning of this error? How can it be solved?
Thanx
Jorgito
We use Navision 4 with SQL Server 2000 and Windows authentication. Most of the computers have WinXP and some Win2k.
Sometimes, when we try to connect to the server, we get the following message:
[SQL Server] Login failed for user (null). Reason: Not associated with a trusted SQL Server connection.
So we have to connect using SQL Server authentication.
Over time, the problem gets solved by itself and we are able to connect using Windows authentication.
What is the meaning of this error? How can it be solved?
Thanx
Jorgito
0
Comments
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
If there is no WindowsLogin arranged, every User with WindowsLogin has access without limitations
If WindowsLogin is arranged, noch User with WindowsLogin gains access
So perhaps you should check this in a test enviroment before