Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 271 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
Options
Trouble connecting to a SQL Server
coascender
Member Posts: 19
We have two boxes each running sql server 2000. We created a Navision database on the frist one with no problem but it is too slow. So we are trying to connect to the second using the exact same procedures. We get the following error message:
18452,"28000"[Microsoft][ODBC SQL Server Drive][SQL Server] Login failes for user "xxxxx". Reason: Not associated with a trusted SQL server connection.
We can select the server from the list but we cannot connect to or see the database.
Both servers are in the same domain on the same subnet.
Help would be greatly appreciated.
Thanks
18452,"28000"[Microsoft][ODBC SQL Server Drive][SQL Server] Login failes for user "xxxxx". Reason: Not associated with a trusted SQL server connection.
We can select the server from the list but we cannot connect to or see the database.
Both servers are in the same domain on the same subnet.
Help would be greatly appreciated.
Thanks
Steve Gray
Enterprise Solutions
Salt Lake City, UT
Enterprise Solutions
Salt Lake City, UT
0
Comments
In no particular order:
1. You are attempting to connect with a Database Login, and your SQL Server is configured for Windows only.
2. You are trying to connect to a SQL Server 2000 database from a Windows account that does not have sufficient permissions to connect to the server
3. Also check the net libaries being used.
This will manage the insert of the needed stored procedure in sql-server.
This is needed to validate windows login from within navision.
You can do this manually if you follow instructions in one of the documents on Navision CD. I think it was w1w1ism.pdf , but I'm not sure.
But it's easier to install a client and if needed deinstall it afterwards...
another thing:
are the users in SQL in both boxes the same?
or are they missing on the second one?
Michael Schumacher
oh, what day is it? Backup day. OK, let's dump all data to /dev/nul ;-)
Today I installed the 4.0 client on the secon box. When I try to connect to any database using the SQL client I get more or less the following message.
The ODBC drive must be upgraded to work with this version of the program. You can reinstall the MDAC from Microsoft Business Solutions-Navision client setup or update the SQL server tools.
I reinstalled the Navision client but got the same error.
Why wouldn't the client install update the ODBC driver?
Enterprise Solutions
Salt Lake City, UT
because the MDAC supplied on the CD is not the latest version,
Why? Don't Know, Ask the danish or american people about that
But, to solve your problem:
Download the latest MDAC from Microsoft (the last I know is 2.8) and install it.
I'm not sure, but maybe it's also in SP4 for SQL2000....
Michael Schumacher
oh, what day is it? Backup day. OK, let's dump all data to /dev/nul ;-)