Mobile Server Management error

Patrik84Patrik84 Posts: 9Member
edited 2009-04-02 in Dynamics Mobile
Hello!

I am a total beginner at this technology, and I'm now trying to build up a full mobile system.
I want to build up this whole system on a local computer, so I installed the device and a server mobile component,
but now I have a problem with a Mobile Server Management. (I don't use SSL)
I use Windows authentication.

Message error: The underlying provider failed on Open. (So, I don't create Document Types)

Mobile Server Management web.config file:

User: ".\Administrators"

Connection String: "Integrated Security=SSPI; Initial Catalog=MobileManagement;Data Source= Titan;"
(MobileManagement is a management DB, Logging and Deployment management connect this DB too, but they work.)

I think, IIS works good , I can reach the services from the browser. The mistake may be in the SQL server. (in the authority)

If I use the above settings, what kind of settings do I have to set in the SQL server?

What name, what role should I assign to the database (MobileManagement)?

Or what the mistake may be?

Thanks in advance for your assistance.

Comments

  • laurentllaurentl Posts: 16Member
    Hello Patrik,

    In the web.config, you need to add a line after the ./Administrator like that <add value="Domain\Mobile Users Group"></add>
    That will allow the users belonging to this group to submit request documents.
    Laurent Lopez

    Dynamics Mobile Freelancer
    Former Microsoft Developer in the Microsoft Dynamics Mobile team
    Visit my dynamics mobile community site: http://www.dynamicsmobile.net
  • Patrik84Patrik84 Posts: 9Member
    Hello Laurent,

    First of all thank you for your kind help! You were right, I looked at my users, and there were big chaos in them. So, I created a new group in the active directory (MobileUsers), and I created a new user. (FPatrik) I gave to FPatrik user administrator rights / permission.

    The new user assigned to the new group (MobileUsers). Administrator is also in this group because I log in the Windows as administrator. After that I assigned Management and Staging DB to the group in the SQL Server.

    With these settings I tried to run the MMC snap-in, and I used in the web.config file the following "user":

    <add value="PATRIK\MobileUsers"></add>

    Unfortunately, I got the same error message: "The underlying provider failed on Open".

    Several snap-shot:
    MMC error



    Active Directory settings:



    SQL Server settings:



    What the mistake may be?

    Thanks in advance for your assistance.


    Config:

    IIS 6.0
    SQL Server 2005
    Server 2003
    NAV 5.1
    mmc.JPG
    67K
    directory.JPG
    39K
    sql server.JPG
    54K
  • Peter_ListPeter_List Posts: 21Member
    Hi Patrick,

    The management service connects to the database as "Network Service".
    You need to add that user to your database and assign him the "Management Service" role.
    Network Service setup.PNG
    73K
    Peter List
    Microsoft Dynamics Mobile Consultant
    http://www.taskletfactory.com
  • laurentllaurentl Posts: 16Member
    Hi Patrik,

    I agree with Peter that adding the Network service user should do the trick.
    But I was wondering, where are you hosting the handlers? On Nav or in the mobile server? I thought that the .net handlers were for Nav 2009 (but I am so 100% sure).
    Because if you have your "mobile queue" in Nav, then I don't think that you need the management service...

    Laurent
    Laurent Lopez

    Dynamics Mobile Freelancer
    Former Microsoft Developer in the Microsoft Dynamics Mobile team
    Visit my dynamics mobile community site: http://www.dynamicsmobile.net
Sign In or Register to comment.