Navision with SQL - only database file on server

andy76
Member Posts: 616
Hello everybody,
I need to know if, on an installation of Navision with database SQL Server, we can only restore the backup on the server of SQL and so have on server ONLY the database file (MDF/LDF) without installing no components of Navision setup (nor client nor other components...).
Are there some problems / troubleshootings?
Thank you very much
Andy
I need to know if, on an installation of Navision with database SQL Server, we can only restore the backup on the server of SQL and so have on server ONLY the database file (MDF/LDF) without installing no components of Navision setup (nor client nor other components...).
Are there some problems / troubleshootings?
Thank you very much
Andy
0
Comments
-
You just needs the xp_ndo.dll in the MS SQL server to have correct Windows logins...0
-
Copied from my replies in the public MSFT NG:
SQL Server can be used just to store the database, without installing the NAV client. The only thing you really need is the extended stored procedures. In the Doc folder of your product disk you will find a document called w1w1isql.pdf, which is the installation manual for NAV on SQL Server. See if you can find your answer there.
You don't HAVE to install NAV, but you CAN if you want to. I always do, because it makes administering NAV easier, so you can do it right form SQL Server.0 -
[Topic moved from 'NAV/Navision' forum to 'SQL General' forum]Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!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