Mobile Server Management error

Patrik84 · 2009-04-01

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 · 2009-04-01

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 · 2009-04-02

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 · 2009-04-02

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 · 2009-04-02

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

Mobile Server Management error

Comments

Categories