Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
nop19832 Absent Member.
Absent Member.
2204 views

Moving the ZENworks Mobile Management Database

So, as a test, I wanted to check if I could move the DB from one
(internal SQL Express) server to another regular SQL 2008R2 Server. The
DB was before on the same server as the Web/HTTP feature was installed.

Now I moved the DB and I can't login as the administrators I've
specified. The only thing I see in the log is this:

Error: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite
(send()).
[00:35:17] SQLError:
ExecuteSQL returned status: -1
State: 08S01
Native: 0
Error: [Microsoft][ODBC SQL Server Driver]Communication link failure
[00:39:11] SQLError:
ExecuteSQL returned status: -1
State: 22001
Native: 0
Error: [Microsoft][ODBC SQL Server Driver]String data, right truncation
[00:39:47] SQLError:
ExecuteSQL returned status: -1
State: 01000
Native: 10054
Error: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite
(send()).

Anyone who did this with success?

--
Niels

-- Niels I have always liked... Cowabunga! If you find this post helpful, please show your appreciation by clicking on the star below. A member must be logged in before s/he can assign reputation points.
0 Likes
2 Replies
Micro Focus Frequent Contributor
Micro Focus Frequent Contributor

Re: Moving the ZENworks Mobile Management Database

The process for this involves contacting Novell Technical Support as it requires decryption and re-encrypting to configuration file that contains the db information and that tool is only available through support.

Jason

>>> Niels Poulsen<nopzcm@gmail.com> 8/9/2012 4:41 PM >>>

So, as a test, I wanted to check if I could move the DB from one
(internal SQL Express) server to another regular SQL 2008R2 Server. The
DB was before on the same server as the Web/HTTP feature was installed.

Now I moved the DB and I can't login as the administrators I've
specified. The only thing I see in the log is this:

Error: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite
(send()).
[00:35:17] SQLError:
ExecuteSQL returned status: -1
State: 08S01
Native: 0
Error: [Microsoft][ODBC SQL Server Driver]Communication link failure
[00:39:11] SQLError:
ExecuteSQL returned status: -1
State: 22001
Native: 0
Error: [Microsoft][ODBC SQL Server Driver]String data, right truncation
[00:39:47] SQLError:
ExecuteSQL returned status: -1
State: 01000
Native: 10054
Error: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite
(send()).

Anyone who did this with success?

--
Niels
0 Likes
nop19832 Absent Member.
Absent Member.

Re: Moving the ZENworks Mobile Management Database

Jason Blackett wrote:

> The process for this involves contacting Novell Technical Support as
> it requires decryption and re-encrypting to configuration file that
> contains the db information and that tool is only available through
> support.
>
> Jason
>
> >>> Niels Poulsen<nopzcm@gmail.com> 8/9/2012 4:41 PM >>>

> So, as a test, I wanted to check if I could move the DB from one
> (internal SQL Express) server to another regular SQL 2008R2 Server.
> The DB was before on the same server as the Web/HTTP feature was
> installed.
>
> Now I moved the DB and I can't login as the administrators I've
> specified. The only thing I see in the log is this:
>
> Error: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite
> (send()).
> [00:35:17] SQLError:
> ExecuteSQL returned status: -1
> State: 08S01
> Native: 0
> Error: [Microsoft][ODBC SQL Server Driver]Communication link failure
> [00:39:11] SQLError:
> ExecuteSQL returned status: -1
> State: 22001
> Native: 0
> Error: [Microsoft][ODBC SQL Server Driver]String data, right
> truncation [00:39:47] SQLError:
> ExecuteSQL returned status: -1
> State: 01000
> Native: 10054
> Error: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite
> (send()).
>
> Anyone who did this with success?


Okay... I must have misread the docs, I thought this was only required
if I moved the WEB server to?

--
Niels

-- Niels I have always liked... Cowabunga! If you find this post helpful, please show your appreciation by clicking on the star below. A member must be logged in before s/he can assign reputation points.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.