Login error when working with sql in windows authenctication

amarnath

hi friends,
I have connected the system and navision with sql on the same system and it has network functionality . It is able to connect to other system in the network using the the sql authentication user. But with the windows authenctication from the client side i get this error.

229,42000{microsoft]{odbc sql server driver} {Sql server} the exceute permission was denied on the object 'xp_ndo_enumusergroups', database 'master', 'dbo'.



To be more specific i have a database navision . which i use in the sql mode to work and all users have a super role privillege.

DenSter

The Public role needs to be granted execute rights to the extended stored procedure 'xp_ndo_enumusergroups'. In SSMS, open databases, system databases, master, programmability, extended stored procedures. You should see the 'xp_ndo_enumusergroups' and the 'xp_ndo_enumusersids'. If the public role is not already there you'll have to add it. On the permissions page in the properties click the 'Add' button and type in 'public' and then hit OK. The public role should now be in the 'Users or roles' area. In the bottom half of the window put a checkmark in the 'Grant' column, for the 'Execute' line. Click OK. Repeat for both extended stored procedures. Done.

amarnath

Can you be more clear i am new to this platform and unable to understand where to do this

garak

Read the "w1w1isql.pdf" Capter 1.1
The w1w1isql.pdf is on the Installation CD/ DV in DOC folder.
If you doesn't have the product CD search the web or mibuso for w1w1isql.pdf or download the CD from our Downloadsection here.

Regards

DenSter

amarnath wrote:

Can you be more clear i am new to this platform and unable to understand where to do this

It is in SQL Server Management Studio, and I gave you detailed steps. Can you tell me exactly what it is that you don't understand?

amarnath

Thanks all it work but i have a select database permission error. when i am trying windows authenctication. Can you tell me how to proceed with it.

mbrown

Hi,

Does anyone possibly have any other suggestions to try? I am trying to create a windows login but cannot login and receive the following error message when trying to synch the windows login. I have followed all the suggestions below including w1w1isql but still no luck. We're on NAV 4.0, SQL 2005 64bit.

kapamarou

Have you installed the dll following the instructions on the SQL Installation manual?

mbrown

Yes as I mentioned I've gone step by step through the manual. I've double checked everything and I've also restarted the server with no luck.