Data Backup and Recovery

SMSQL errors on initial configuration wizard setup

lrhvidsten
19,772 Views

I'm guessing there's some obvious configuration step I'm missing here...probably on my mostly default SQL Server setup.

I'm receiving errors every time I try to run the configuration wizard script to migrate my databases from the local drives to the iSCSI luns. The error occurs after the pre-migration DBCC checkdb and the remapping of the system dbs. Then the config wizard script stops the sql server, and continually fails to restart the sql server services. At this point, it's unable to connect and fails with SQL-DMO authentication errors. I've checked my settings and can't seem to find anything wrong. This problem first occurred yesterday. Today, I uninstalled Snapmanager and SQL server 2005 from the machine. I then reinstalled both products. I left Snapdrive alone as it seemed to be working fine. SQL Server 2005 with sp3 is what I've been using.


Please help!

Note: SQL server services are using a domain user service account with no admin privs per MS best practices.

Snapdrive and SMSQL are using a domain administrator service account.

Windows 2003 R2 SP2 host using iSCSI initiator 2.08

Snapdrive 6.1

SMSQL 5.0R1

FAS2020A

Data ONTAP 7.2.5.1

Even with the fresh install of SMSQL and SQL Server today, I'm getting the same errors.

Here is the SMSQL log of events...

[19:05:50.317]  Retrieving ONTAP virtual disks information...
[19:05:56.259]
[19:05:56.259]  *** SnapManager for SQL Server Report

[19:05:56.259]  Configuration Time Stamp: 04-14-2009_19.05.28
[19:05:56.259]  Host Name: SAWTOOTH
[19:05:56.259]  New default SnapInfo directory for [SAWTOOTH] : H:\SMSQL_SnapInfo
[19:05:56.259]
[19:05:56.259]  Database: master
[19:05:56.259]  [PRIMARY] New database file - 1 : [I:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf]
[19:05:56.259]  [PRIMARY] Original database file : [C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf]
[19:05:56.259]  New log file - 1 : [I:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf]
[19:05:56.259]  Original log file : [C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf]
[19:05:56.274]  System Database: Yes
[19:05:56.274]
[19:05:56.274]  Database: model
[19:05:56.274]  [PRIMARY] New database file - 1 : [I:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\model.mdf]
[19:05:56.274]  [PRIMARY] Original database file : [C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\model.mdf]
[19:05:56.274]  New log file - 1 : [I:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\modellog.ldf]
[19:05:56.274]  Original log file : [C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\modellog.ldf]
[19:05:56.274]  System Database: Yes
[19:05:56.274]
[19:05:56.274]  Database: msdb
[19:05:56.274]  [PRIMARY] New database file - 1 : [I:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\MSDBData.mdf]
[19:05:56.274]  [PRIMARY] Original database file : [C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\MSDBData.mdf]
[19:05:56.274]  New log file - 1 : [I:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\MSDBLog.ldf]
[19:05:56.274]  Original log file : [C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\MSDBLog.ldf]
[19:05:56.274]  System Database: Yes
[19:05:56.274]
[19:05:56.274]  There is no change for SQL Server user database.
[19:05:56.274]  Maximum databases of concurrent backup: 255

[19:05:56.274]  New default SnapInfo directory for [SAWTOOTH] :
[19:05:56.290]  H:\SMSQL_SnapInfo
[19:05:56.290]  Set SnapInfo Directory...
[19:05:56.290]  Copying new loginfo sml file...
[19:05:56.290]  Set LogInfo directory path to registry...
[19:05:56.290]  New LogInfo Path for Server SAWTOOTH: [H:\SMSQL_SnapInfo]

[19:05:56.290]  Configuration of the normal Snapinfo directory completed.

[19:05:56.290]  Configuration of the multiple databases per disk SnapInfo directory completed.

[19:05:56.306]  Checking SQL Server [SAWTOOTH]...


[19:05:56.306]  Connecting to SQL Server [SAWTOOTH]...
[19:05:56.321]  Getting SQL Server Agent status...
[19:06:01.372]  DBCC CHECKDB (N'master')
[19:06:04.953]  DBCC results for 'master'.
Service Broker Msg 9675, State 1: Message Types analyzed: 14.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
Service Broker Msg 9667, State 1: Services analyzed: 3.
Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
DBCC results deleted for brevity
CHECKDB found 0 allocation errors and 0 consistency errors in database 'master'.
DBCC results for 'mssqlsystemresource'.
Service Broker Msg 9675, State 1: Message Types analyzed: 14.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
Service Broker Msg 9667, State 1: Services analyzed: 3.
Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
DBCC results deleted for brevity
CHECKDB found 0 allocation errors and 0 consistency errors in database 'mssqlsystemresource'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
[19:06:04.953]
[19:06:04.953]  DBCC CHECKDB completed successfully.

[19:06:04.953]  DBCC CHECKDB (N'model')
[19:06:05.219]  DBCC results for 'model'.
Service Broker Msg 9675, State 1: Message Types analyzed: 14.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
Service Broker Msg 9667, State 1: Services analyzed: 3.
Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
DBCC results deleted for brevity
CHECKDB found 0 allocation errors and 0 consistency errors in database 'model'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
[19:06:05.235]
[19:06:05.235]  DBCC CHECKDB completed successfully.

[19:06:05.235]  DBCC CHECKDB (N'msdb')
[19:06:05.938]  DBCC results for 'msdb'.
Service Broker Msg 9675, State 1: Message Types analyzed: 16.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 7.
Service Broker Msg 9667, State 1: Services analyzed: 5.
Service Broker Msg 9668, State 1: Service Queues analyzed: 5.
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
DBCC results deleted for brevity
CHECKDB found 0 allocation errors and 0 consistency errors in database 'msdb'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
[19:06:05.938]
[19:06:05.938]  DBCC CHECKDB completed successfully.

[19:06:05.970]  Set SQL Server to start with T3608...
[19:06:06.064]  Stopping SQL Server...
[19:06:06.173]  Description: This server has been disconnected.  You must reconnect to perform this operation.
[19:06:14.179]  SQL Server was stopped.

[19:06:18.183]  Copying file...
[19:06:18.198]  From:
[19:06:18.198]  C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\model.mdf
[19:06:18.198]  To:
[19:06:18.198]  I:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\model.mdf
[19:06:18.214]  From:
[19:06:18.214]  C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\modellog.ldf
[19:06:18.214]  To:
[19:06:18.214]  I:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\modellog.ldf
[19:06:18.230]  50% copied
[19:06:18.245]
[19:06:18.245]  Copying file...
[19:06:18.245]  From:
[19:06:18.245]  C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\MSDBData.mdf
[19:06:18.245]  To:
[19:06:18.245]  I:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\MSDBData.mdf
[19:06:18.323]  From:
[19:06:18.323]  C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\MSDBLog.ldf
[19:06:18.323]  To:
[19:06:18.323]  I:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\MSDBLog.ldf
[19:06:18.386]  50% copied
[19:06:18.417]
[19:06:18.417]  Restarting SQL Server[SAWTOOTH]...
[19:06:21.435]  [SQL-DMO API Error]: Source: Microsoft SQL-DMO
Error Message: IDispatch error #20793

Description: [SQL-DMO]Unexpected parameter value or other condition.
[19:06:21.435]  SQL-DMO Error Code: 0x80045339

[19:06:21.435]  [SQL-DMO API Error]: Source: Microsoft SQL-DMO
Error Message: IDispatch error #20793

Description: [SQL-DMO]Unexpected parameter value or other condition.


[19:06:23.437]  Re-trying to start SQL Server [SAWTOOTH], please wait...
[19:06:26.439]  Waiting for server to start...
[19:06:29.442]  Waiting for server to start...
[19:06:32.444]  Waiting for server to start...
[19:06:35.446]  Waiting for server to start...
[19:06:38.449]  Waiting for server to start...
[19:06:41.451]  Waiting for server to start...
[19:06:44.454]  Waiting for server to start...
[19:06:47.456]  Waiting for server to start...
[19:06:50.458]  Waiting for server to start...
[19:06:53.461]  Waiting for server to start...
[19:06:56.463]  Waiting for server to start...
[19:06:59.466]  Waiting for server to start...
[19:07:02.468]  Waiting for server to start...
[19:07:05.470]  Waiting for server to start...
[19:07:08.473]  Waiting for server to start...
[19:07:11.475]  Waiting for server to start...
[19:07:14.478]  Waiting for server to start...
[19:07:17.480]  Waiting for server to start...
[19:07:20.482]  Waiting for server to start...
[19:07:23.485]  Waiting for server to start...
[19:07:26.487]  [SQL-DMO API Error]: Source: Microsoft SQL-DMO
Error Message: IDispatch error #20793

Description: [SQL-DMO]Unexpected parameter value or other condition.
[19:07:26.487]  SQL-DMO Error Code: 0x80045339

[19:07:26.487]  [SQL-DMO API Error]: Source: Microsoft SQL-DMO
Error Message: IDispatch error #20793

Description: [SQL-DMO]Unexpected parameter value or other condition.


[19:07:28.489]  Re-trying to start SQL Server [SAWTOOTH], please wait...
[19:07:31.491]  Waiting for server to start...
[19:07:34.494]  Waiting for server to start...
[19:07:37.496]  Waiting for server to start...
[19:07:40.498]  Waiting for server to start...
[19:07:43.501]  Waiting for server to start...
[19:07:46.503]  Waiting for server to start...
[19:07:49.506]  Waiting for server to start...
[19:07:52.508]  Waiting for server to start...
[19:07:55.510]  Waiting for server to start...
[19:07:58.513]  Waiting for server to start...
[19:08:01.515]  Waiting for server to start...
[19:08:04.518]  Waiting for server to start...
[19:08:07.520]  Waiting for server to start...
[19:08:10.522]  Waiting for server to start...
[19:08:13.525]  Waiting for server to start...
[19:08:16.527]  Waiting for server to start...
[19:08:19.530]  Waiting for server to start...
[19:08:22.532]  Waiting for server to start...
[19:08:25.534]  Waiting for server to start...
[19:08:28.537]  Waiting for server to start...
[19:08:31.539]  [SQL-DMO API Error]: Source: Microsoft SQL-DMO
Error Message: IDispatch error #20793

Description: [SQL-DMO]Unexpected parameter value or other condition.
[19:08:31.539]  SQL-DMO Error Code: 0x80045339

[19:08:31.539]  [SQL-DMO API Error]: Source: Microsoft SQL-DMO
Error Message: IDispatch error #20793

Description: [SQL-DMO]Unexpected parameter value or other condition.


[19:08:33.541]  Re-trying to start SQL Server [SAWTOOTH], please wait...
[19:08:36.543]  Waiting for server to start...
[19:08:39.546]  Waiting for server to start...
[19:08:42.548]  Waiting for server to start...
[19:08:45.550]  Waiting for server to start...
[19:08:48.553]  Waiting for server to start...
[19:08:51.555]  Waiting for server to start...
[19:08:54.558]  Waiting for server to start...
[19:08:57.560]  Waiting for server to start...
[19:09:00.562]  Waiting for server to start...
[19:09:03.565]  Waiting for server to start...
[19:09:06.567]  Waiting for server to start...
[19:09:09.570]  Waiting for server to start...
[19:09:12.572]  Waiting for server to start...
[19:09:15.574]  Waiting for server to start...
[19:09:18.577]  Waiting for server to start...
[19:09:21.579]  Waiting for server to start...
[19:09:24.582]  Waiting for server to start...
[19:09:27.584]  Waiting for server to start...
[19:09:30.586]  Waiting for server to start...
[19:09:33.589]  Waiting for server to start...
[19:09:33.589]  Failed to start SQL Server.
[19:09:33.589]  Waiting for SQL Server to start, please wait...
[19:09:33.589]  SnapManager failed to restart SQL Server during system database migration.

[19:09:33.589]  Deleting newly copied system database files after failure...
[19:09:33.589]  Deleting file:
[19:09:33.589]  I:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\model.mdf
[19:09:33.589]  Deleting file:
[19:09:33.589]  I:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\modellog.ldf
[19:09:33.589]  Database files are deleted.

[19:09:33.589]  Deleting newly copied system database files after failure...
[19:09:33.589]  Deleting file:
[19:09:33.589]  I:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\MSDBData.mdf
[19:09:33.589]  Deleting file:
[19:09:33.589]  I:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\MSDBLog.ldf
[19:09:33.589]  Deleting directory:
[19:09:33.589]  I:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA
[19:09:33.589]  Deleting directory:
[19:09:33.589]  I:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL
[19:09:33.589]  Deleting directory:
[19:09:33.589]  I:\Program Files\Microsoft SQL Server\MSSQL.1
[19:09:33.589]  Deleting directory:
[19:09:33.589]  I:\Program Files\Microsoft SQL Server
[19:09:33.589]  Deleting directory:
[19:09:33.589]  I:\Program Files
[19:09:33.589]  Database files are deleted.

[19:09:33.604]  Failed to migrate database. Error code: 0x80045339
[19:10:34.997]  Error Code 80040000
Description: SQL Server does not exist or access denied.
ConnectionOpen (Connect()).
[19:10:34.997]  [SQL-DMO API Error]: Source: Microsoft SQL-DMO (ODBC SQLState: 08001)
Error Message: Invalid OLEVERB structure

Description: SQL Server does not exist or access denied.
ConnectionOpen (Connect()).
[19:10:34.997]  SQL-DMO Error Code: 0x80040000

[19:10:34.997]  [SQL-DMO API Error]: Source: Microsoft SQL-DMO (ODBC SQLState: 08001)
Error Message: Invalid OLEVERB structure

Description: SQL Server does not exist or access denied.
ConnectionOpen (Connect()).
[19:10:34.997]  Failed to find the T3608 flag. Error code = 0x80040000
[19:10:34.997]  [SQL-DMO API Error]: Source: Microsoft SQL-DMO (ODBC SQLState: 08001)
Error Message: Invalid OLEVERB structure

Description: SQL Server does not exist or access denied.
ConnectionOpen (Connect()).
[19:10:34.997]  SQL Server (MSSQLSERVER) is in minimally configured mode. Please remove this flag via SQL Server Configuration Manager before migrating any database.
[19:10:35.013]  Failed to migrate SQL Server system databases.

[19:10:35.013]  Error occurred during system database migration.

[19:10:35.013]  ***ADD MSISCSI SERVICE AS A DEPENDENCY OF [MSSQLSERVER]
[19:10:35.013]
[19:10:35.013]  Adding service [MSiSCSI] as a dependency of [MSSQLSERVER]...
[19:10:35.013]  Service [MSiSCSI] was successfully added to the dependency list of the specified service.

[19:10:35.029]  Configuring the SQLServer Maximum Worker Threads Option...
[19:10:35.029]
[19:10:35.029]  *** SNAPMANAGER CONFIGURATION JOB ENDED AT: [04-14-2009 19.10.35]
[19:10:35.029]  [SQL-DMO API Error]: Source: Microsoft SQL-DMO
Error Message: IDispatch error #20793

Description: [SQL-DMO]Unexpected parameter value or other condition.


And the error message that pops up at the end:

smsql-error.JPG

1 ACCEPTED SOLUTION

netapp4mhipa
19,764 Views

Had the same problem. I added the account running sql server service and the account running snapdrive to the local admin group and it worked. I don't think you have to add the snapdrive account but for sure you have to add the sql service account.

View solution in original post

16 REPLIES 16
Public