Mobile Server Management error

Patrik84

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.

laurentl

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.

Patrik84

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

Peter_List

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.

laurentl

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