mibuso.com

Microsoft Business Solutions online community
It is currently Fri Apr 18, 2014 10:44 pm

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 77 posts ]  Go to page Previous  1, 2, 3, 4, 5, 6  Next
Author Message
 Post subject: Re: How to install and configure Microsoft Dynamics NAV 2009
PostPosted: Thu Oct 13, 2011 2:14 pm 
Offline

Joined: Wed Sep 29, 2010 3:18 am
Posts: 764
Country: Australia (au)
mohana_cse06 wrote:
Better you copy the dll file to
C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn\

and try


execute the extended stored procedure in your SQL server


Top
 Profile E-mail  
 
 Post subject: Re: How to install and configure Microsoft Dynamics NAV 2009
PostPosted: Thu Oct 13, 2011 2:28 pm 
Offline

Joined: Mon Jul 26, 2010 1:21 pm
Posts: 141
Country: Mauritius (mu)
mohana_cse06 wrote:
Better you copy the dll file to
C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn\

and try


I've copied to that folder both dll files and tried same error.
where can I find dlls that I excited in SQL Management studio
SQL Server -> Databases -> System Databases -> Master -> Programmability -> Stored Procedures -> [Stored Procedures]
I didn't see them in this path.
As you said I copied dlls to binn folder and tried to execute :

Quote:
USE master
EXEC sp_addextendedproc xp_ndo_enumusersids,'C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Binn\xp_ndo.dll'
GO

GRANT EXECUTE
ON [xp_ndo_enumusersids]
TO PUBLIC
GO

USE master
EXEC sp_addextendedproc xp_ndo_enumusergroups,'C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Binn\xp_ndo.dll'
GO

GRANT EXECUTE
ON [xp_ndo_enumusergroups]
TO PUBLIC
GO


then I'm getting these errors in SQL Qury write:
Msg 2714, Level 16, State 7, Procedure sp_addextendedproc, Line 29
There is already an object named 'xp_ndo_enumusersids' in the database.
Msg 2714, Level 16, State 7, Procedure sp_addextendedproc, Line 29
There is already an object named 'xp_ndo_enumusergroups' in the database.

Plz help me out ](*,)

Thanks
Chowdary

_________________
Pleasure in the job puts perfection in the work


Top
 Profile E-mail  
 
 Post subject: Re: How to install and configure Microsoft Dynamics NAV 2009
PostPosted: Thu Oct 13, 2011 2:37 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Sep 02, 2008 8:37 am
Posts: 4532
Location: Hyderabad
Country: India (in)
You will find under
SQL Server -> Databases -> System Databases -> Master -> Programmability ->Extended Stored Procedure..

_________________
-Mohana
http://mibuso.com/blogs/mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav


Top
 Profile  
 
 Post subject: Re: How to install and configure Microsoft Dynamics NAV 2009
PostPosted: Thu Oct 13, 2011 2:45 pm 
Offline

Joined: Mon Jul 26, 2010 1:21 pm
Posts: 141
Country: Mauritius (mu)
mohana_cse06 wrote:
You will find under
SQL Server -> Databases -> System Databases -> Master -> Programmability ->Extended Stored Procedure..


Great =D>
I have been able to login to Navision(finsql.exe) windows authentication
but still NAV Server giving the same error, I hv refreshed also

what should I do now?

Thanks
Chowdary

_________________
Pleasure in the job puts perfection in the work


Top
 Profile E-mail  
 
 Post subject: Re: How to install and configure Microsoft Dynamics NAV 2009
PostPosted: Thu Oct 13, 2011 2:45 pm 
Offline

Joined: Wed Sep 29, 2010 3:18 am
Posts: 764
Country: Australia (au)
Chowdary wrote:
mohana_cse06 wrote:
Better you copy the dll file to
C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn\

and try


I've copied to that folder both dll files and tried same error.
where can I find dlls that I excited in SQL Management studio
SQL Server -> Databases -> System Databases -> Master -> Programmability -> Stored Procedures -> [Stored Procedures]
I didn't see them in this path.
As you said I copied dlls to binn folder and tried to execute :

Quote:
USE master
EXEC sp_addextendedproc xp_ndo_enumusersids,'C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Binn\xp_ndo.dll'
GO

GRANT EXECUTE
ON [xp_ndo_enumusersids]
TO PUBLIC
GO

USE master
EXEC sp_addextendedproc xp_ndo_enumusergroups,'C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Binn\xp_ndo.dll'
GO

GRANT EXECUTE
ON [xp_ndo_enumusergroups]
TO PUBLIC
GO


then I'm getting these errors in SQL Qury write:
Msg 2714, Level 16, State 7, Procedure sp_addextendedproc, Line 29
There is already an object named 'xp_ndo_enumusersids' in the database.
Msg 2714, Level 16, State 7, Procedure sp_addextendedproc, Line 29
There is already an object named 'xp_ndo_enumusergroups' in the database.

Plz help me out ](*,)

Thanks
Chowdary


the easiest way is....
detach your database first
and then uninstall your NAV
install demo ... attach your database
run it...


Top
 Profile E-mail  
 
 Post subject: Re: How to install and configure Microsoft Dynamics NAV 2009
PostPosted: Thu Oct 13, 2011 2:55 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Thu Oct 16, 2003 8:50 am
Posts: 12283
Location: Brno
Country: Czech Republic (cz)
Chowdary wrote:
mohana_cse06 wrote:
You will find under
SQL Server -> Databases -> System Databases -> Master -> Programmability ->Extended Stored Procedure..


Great =D>
I have been able to login to Navision(finsql.exe) windows authentication
but still NAV Server giving the same error, I hv refreshed also

what should I do now?

Thanks
Chowdary


By NAV Server you mean Mid-tier (service tier) for NAV 2009? Or what? You have posted into classic client forum, thus I am asking...

_________________
Kamil Sacek
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.


Top
 Profile E-mail WWW  
 
 Post subject: Re: How to install and configure Microsoft Dynamics NAV 2009
PostPosted: Thu Oct 13, 2011 3:24 pm 
Offline

Joined: Mon Jul 26, 2010 1:21 pm
Posts: 141
Country: Mauritius (mu)
kine wrote:
Chowdary wrote:
mohana_cse06 wrote:
You will find under
SQL Server -> Databases -> System Databases -> Master -> Programmability ->Extended Stored Procedure..


Great =D>
I have been able to login to Navision(finsql.exe) windows authentication
but still NAV Server giving the same error, I hv refreshed also

what should I do now?

Thanks
Chowdary


By NAV Server you mean Mid-tier (service tier) for NAV 2009? Or what? You have posted into classic client forum, thus I am asking...


its Mid-tier (service tier) for NAV 2009
its here by mistake, should move it to NAV three tier

Thanks
Chowdary

_________________
Pleasure in the job puts perfection in the work


Top
 Profile E-mail  
 
 Post subject: Re: How to install and configure Microsoft Dynamics NAV 2009
PostPosted: Thu Oct 13, 2011 3:41 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Thu Oct 16, 2003 8:50 am
Posts: 12283
Location: Brno
Country: Czech Republic (cz)
THan it is much more complicated. You need to set SPNs correctly if the service tier is running on different server than SQL etc... have you read the documentation?

_________________
Kamil Sacek
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.


Top
 Profile E-mail WWW  
 
 Post subject: Re: How to install and configure Microsoft Dynamics NAV 2009
PostPosted: Fri Oct 14, 2011 7:28 am 
Offline

Joined: Mon Jul 26, 2010 1:21 pm
Posts: 141
Country: Mauritius (mu)
kine wrote:
THan it is much more complicated. You need to set SPNs correctly if the service tier is running on different server than SQL etc... have you read the documentation?


Hi Kine

Yes, I know that, but my NAV Server(middle tier) and SQL Server(Database tier) both on same computer running windows server 2008.

any more suggestions?

Thanks
Chowdary

_________________
Pleasure in the job puts perfection in the work


Top
 Profile E-mail  
 
 Post subject: Re: How to install and configure Microsoft Dynamics NAV 2009
PostPosted: Fri Oct 14, 2011 7:33 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Sep 02, 2008 8:37 am
Posts: 4532
Location: Hyderabad
Country: India (in)
check your connection with best practice analyser
http://dynamicsuser.net/media/p/192857.aspx

_________________
-Mohana
http://mibuso.com/blogs/mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav


Top
 Profile  
 
 Post subject: Re: How to install and configure Microsoft Dynamics NAV 2009
PostPosted: Fri Oct 14, 2011 8:01 am 
Offline

Joined: Mon Jul 26, 2010 1:21 pm
Posts: 141
Country: Mauritius (mu)
mohana_cse06 wrote:
check your connection with best practice analyser
http://dynamicsuser.net/media/p/192857.aspx


Hi Mohana

It may be silly question, I have to ask

its Microsoft Dynamics NAV 2009 R2 but not Microsoft Dynamics NAV 2009 SP1
I was checking for R2 best practice. Am I right here? If yes, can you sen me the link plz(if u have)

Thanks
Chowdary

_________________
Pleasure in the job puts perfection in the work


Top
 Profile E-mail  
 
 Post subject: Re: How to install and configure Microsoft Dynamics NAV 2009
PostPosted: Fri Oct 14, 2011 8:05 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Sep 02, 2008 8:37 am
Posts: 4532
Location: Hyderabad
Country: India (in)
Chowdary wrote:
I was checking for R2 best practice. Am I right here? If yes, can you sen me the link plz(if u have)

How many times i should request you to search the forum?
http://www.mibuso.com/dlinfo.asp?FileID=1155

_________________
-Mohana
http://mibuso.com/blogs/mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav


Top
 Profile  
 
 Post subject: Re: How to install and configure Microsoft Dynamics NAV 2009
PostPosted: Fri Oct 14, 2011 8:11 am 
Offline

Joined: Mon Jul 26, 2010 1:21 pm
Posts: 141
Country: Mauritius (mu)
mohana_cse06 wrote:
Chowdary wrote:
I was checking for R2 best practice. Am I right here? If yes, can you sen me the link plz(if u have)

How many times i should request you to search the forum?
http://www.mibuso.com/dlinfo.asp?FileID=1155


So thankful for your response
I wouldn't have come till here with out your help
Hope I will be thru by this analyzer

Thanks
Chowdary

_________________
Pleasure in the job puts perfection in the work


Top
 Profile E-mail  
 
 Post subject: Re: How to install and configure Microsoft Dynamics NAV 2009
PostPosted: Fri Oct 14, 2011 12:26 pm 
Offline

Joined: Mon Jul 26, 2010 1:21 pm
Posts: 141
Country: Mauritius (mu)
Hi

I found this error when I scan Best Practice Analyzer:

The Best Practices Analyzer for Microsoft Dynamics NAV could not read the Microsoft Dynamics NAV Server configuration file (CustomSettings.config). This could be because the file is corrupted, missing, or misnamed. Check also 'Other Reports', for detailed descriptions. Filename = 'C:\Program Files (x86)\Microsoft Dynamics NAV\60\Service\CustomSettings.config' .

what should I do ?

Thanks
Chowdary

_________________
Pleasure in the job puts perfection in the work


Top
 Profile E-mail  
 
 Post subject: Re: How to install and configure Microsoft Dynamics NAV 2009
PostPosted: Fri Oct 14, 2011 12:33 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Sep 02, 2008 8:37 am
Posts: 4532
Location: Hyderabad
Country: India (in)
Chowdary wrote:
Hi

I found this error when I scan Best Practice Analyzer:

The Best Practices Analyzer for Microsoft Dynamics NAV could not read the Microsoft Dynamics NAV Server configuration file (CustomSettings.config). This could be because the file is corrupted, missing, or misnamed. Check also 'Other Reports', for detailed descriptions. Filename = 'C:\Program Files (x86)\Microsoft Dynamics NAV\60\Service\CustomSettings.config' .

what should I do ?

Thanks
Chowdary


it clearly mentioned that your file is corrupted, missing, or misnamed..

make sure that name is same in path C:\Program Files (x86)\Microsoft Dynamics NAV\60\Service\CustomSettings.config

check the < and > inside the file..

_________________
-Mohana
http://mibuso.com/blogs/mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 77 posts ]  Go to page Previous  1, 2, 3, 4, 5, 6  Next

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: Google [Bot], rfajdiga and 4 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: