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
- 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
- 309 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Getting error "Login failed connecting to SQL server xxx"
twdavis1011
Member Posts: 4
Client is running 2012 SQL server based Navision 2009 R2 older version. Primary activity is in Payroll. The server is having problems so temporarily we are moving the sql database to a standalone workstation and continue to work from there until server issues resolved, then create backup from local wkst and restore back to original sever SQL.
Client installed SQL 2012 on the workstation. I created and restored an SQL backup of the original server SQL database into the SQL on the wkst. I am able to open SQL using windows login, no problem. database restored no problem. When I start Navision on the workstation and point to the local SQL database I get the error above. (I resolved the "xp_ndo.dll" issue).
Mibuso comments suggest "delete the entries in the dbo.users and dbo.window logins tables". Another person said "delete the users and window logins from the Master".
If I delete the entries from these sql tables how will i login from Navision?
Assuming I DO get into Navision and the user completes activities in the db. How will this impact the final backup and restore of the db retuning to the original server. Will I not incur the same problem at that time with the users and window logins?
Thanks
Client installed SQL 2012 on the workstation. I created and restored an SQL backup of the original server SQL database into the SQL on the wkst. I am able to open SQL using windows login, no problem. database restored no problem. When I start Navision on the workstation and point to the local SQL database I get the error above. (I resolved the "xp_ndo.dll" issue).
Mibuso comments suggest "delete the entries in the dbo.users and dbo.window logins tables". Another person said "delete the users and window logins from the Master".
If I delete the entries from these sql tables how will i login from Navision?
Assuming I DO get into Navision and the user completes activities in the db. How will this impact the final backup and restore of the db retuning to the original server. Will I not incur the same problem at that time with the users and window logins?
Thanks
0
Answers
which is weird because my license allows numerous companies.
the error above is when I try to use database login
it seems that when I start the finsql and select database, and specify windows authentication it is as if it is using the CRONUS license initially, thus the error indicating "license restricts me to 2 nondemonstration companies....".
when i change to database authentication it does not recognize the userids.
One note, during the setup of SQL 2012 we accepted the default instance name (not sure if that has anything to do with the issue at hand).
any comments would be appreciated.
I noticed someone else had a similar issue and the solution was the license was NOT stored in the database even when I imported. In Navision, I went to database\alter and set the option to store license in db.
Thank you for your comments!