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
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 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
Installation Error
Mrinmay
Member Posts: 74
Hi Experts,
I am trying to install NAV 2009 in my system developer environment. After installation am getting this below mentioned error.
SQL Server option
Cronus Sample Database for Microsoft Dynamics NAV 2009
Fatal error during installation.
Error -2147217900: failed to execute SQL string, error detail: The server principal 'MRINMAY\Mrinmay' already exists., SQL key: CreateLoginFromLogin SQL string: DECLARE @CreateLogin sysname, @AddRole sysname SET @CreateLogin = 'CREATE LOGIN FROM WINDOWS' SET @AddRole = 'sp_addsrvrolemember , securityadmin' IF NOT EXISTS (SELECT * FROM [master].[sys].[syslogins] WHERE name = SYSTEM_USER AND isntname = 1) BEGIN EXEC ( @CreateLogin ) EXEC ( @AddRole ) END
Can anyone explain why this error is coming and how to resolved this.
Actually i have installed 2009 before in my system. in that time it was working fine. After that due some reason i un-installed that.Now when i am trying to install i am getting this error.
Regards
Mrinmay
I am trying to install NAV 2009 in my system developer environment. After installation am getting this below mentioned error.
SQL Server option
Cronus Sample Database for Microsoft Dynamics NAV 2009
Fatal error during installation.
Error -2147217900: failed to execute SQL string, error detail: The server principal 'MRINMAY\Mrinmay' already exists., SQL key: CreateLoginFromLogin SQL string: DECLARE @CreateLogin sysname, @AddRole sysname SET @CreateLogin = 'CREATE LOGIN FROM WINDOWS' SET @AddRole = 'sp_addsrvrolemember , securityadmin' IF NOT EXISTS (SELECT * FROM [master].[sys].[syslogins] WHERE name = SYSTEM_USER AND isntname = 1) BEGIN EXEC ( @CreateLogin ) EXEC ( @AddRole ) END
Can anyone explain why this error is coming and how to resolved this.
Actually i have installed 2009 before in my system. in that time it was working fine. After that due some reason i un-installed that.Now when i am trying to install i am getting this error.
Regards
Mrinmay
0
Comments
this sounds like your sql server, which is normaly installed with the demo installation was not uninstalled with your client (what is the normal case).
So if you reinstall NAV2009, the installation wants to create your login on this database again. But your login is already existing, this is what the message tells you.
In the normal case your NAV2009 should work nevertheless...
Regards
JoeK
The closes thing I get is the common error when you have a database already installed
Error: Error -2147467259: failed to execute SQL string, error detail: A database with name Demo Database NAV (6-0) already exists. Delete this database in SQL Server Management Studio, run setup.exe again, and then click Repair., SQL key: StopIfDatabaseExist SQL string: IF EXISTS (SELECT * FROM [master].[sys].[databases] WHERE name = 'Demo Database NAV (6-0)') RAISERROR (N'A database with name %s already exists. Delete this database in SQL Server Management Studio, run setup.exe again, and then click Repair.',20,1,'Demo Database NAV (6-0)')
The suggestions I can give to you is to install SQL Server Management Studio if you don't already have it and remove the database and the user login in your error message from that SQL server instance.
Peter Wibeck
Software Development Engineer in Test
Dynamics NAV Server and Installer team
http://blog.wibeck.org/