.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SQLServer2008 job created by Copy DataBase Wizard fails - cannot determine if job owner has server a

Posted By:      Posted Date: September 23, 2010    Points: 0   Category :Sql Server

Trying to copy a SQL2000 database on server TUNA to destination server MOJITO which runs default instance of SQL2008 (at ServicePack1) via the CD Wizard. Resulting job fails on MOJITO with this in application log:

SQL Server Scheduled Job 'CopyDatabaseWizard_TUNA_MOJITO_1' (0x64AB69F2880A7E4DA3708546C33DFF40) - Status: Failed - Invoked on: 2010-09-23 17:05:04 - Message: The job failed. Unable to determine if the owner (CBMIWEB\johna) of job CopyDatabaseWizard_TUNA_MOJITO_1 has server access (reason: Could not obtain information about Windows NT group/user 'CBMIWEB\johna', error code 0x5. [SQLSTATE 42000] (Error 15404)).

There is a credential on MOJITO defined for CBMIWEB\johna. There is a proxy on MOJITO that uses that credential. The job has one step and in the properties I have set the RUN AS value for the job to be the name of the Proxy. The proxy is established for SSIS jobs.

The "owner" of the job is also CBMIWEB\johna which is a domain userid in the local Administrators group of each machine (both TUNA and MOJITO). This userid has been granted the permission to Logon as a Batch Job on both servers.

TUNA is a Windows 2000 standalone server; MOJITO is Windows 2003. I can logon to each server as CBMIWEB\johna.

I don't know what else to do.

View Complete Post

More Related Resource Links

SQL Server 2005/2008 COPY Database Through Wizard



Let's start a very intresting thread here:

As you all know moving the database from one server(2000, 2005, 2008) to (2000, 20005, 20008) is not a big deal and can be done in many ways  like backup-restore, attcah-detach, and most easy (some time very complex:-)).

Here i wanna discuss an issue which i have faced.

I have two instances of SQL server 2008, i have created a new database Test in one instance, created few logins and mapped to  Test database with some permissions for this Test database.

Now i used copy database wizard to copy this test database to other instance, i sucessfully went through the wizard and selected SQL server object method to copy the Test database in other instance then i followed the remaing wizard, i selected the logins which i have created for the Test database and finnaly i reached the finish button i clicked finished and the copy of database completed sucessfully. I verified that Test dabase was there in other instance with the logins which i have created. So easy i was happy:-)

Problem: Some other day i wanted to copy AdventureWork database to the other instance of SQl server i was happy that its a very easy task i followed the same steps above(to copy the Test database ) and every thing went in the same way and i clicked finish to complete the wizard it took some time

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008.

Below is the complete step by step guide of this process.

Database Export Wizard for ASP.net and SQL Server

A step wizard for ASP.net to export database objects to CSV, TXT, HTML, XML, or SQL. it guides users through a few simple steps to choose a database object (table, view, or query), select columns, and export the data in any of the standard formats CSV, HTML, XML, or SQL.

SQL Server to SQL Server Compact Edition Database Copy

I recently switched from XP to Win 7 and am getting an error when using the SQL Server to SQL Server Compact Edition Database Copy wizard from johnnycantcode.com (link). I suspect that the problem is with the configuration of the path for the DQL CE dll. 1) Does anyone know where the configuration is set? It isn't in the GLT.SqlCopy.exe.config file in the local directory. 2) Has anyone got the program to run under Win 7? Thanks marc  

SQL Server 2008 Windows Authentication Mode fails for Database Engine, error 18456

I installed SQL Server 2008 Developer Edition (10.0.1600.22.080709-1414) on a Windows Vista 32-bit development machine with Windows Authentication Mode only (no SQL Server Authentication).   Since this is a development machine, I saw no need for Mixed Mode when I did the install.  The SQL Server Management Studio allows me to login to Analysis Services, Integration Services, Reporting Services, BUT NOT the Database Engine!Windows Authentication for the Database Engine gives the following error: EventID: 18456Login failed for user MYDOMAIN\MYLOGIN'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>]The 'fix' I have found online is to login as SA in SQL Server Authentication mode & add MYDOMAIN\MYLOGIN as a administrator for the Database Engine.  Unfortunately, I can't since I didn't install SQL Server Authentication mode (only Windows Authentication Mode).  It appears my only recourse is to uninstall, then reinstall in Mixed mode, then to login as SA in SQL Server Authentication mode & add MYDOMAIN\MYLOGIN as a administrator for the Database Engine. Before I do so, does anyone know of a better approach?Scott D Duncan

SQL Server 2008 R2 rebuild master database fails with error -2068643838

I want to change the server collation setting for SQL 2008 R2.  I'm using the command: Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MyServerName /SQLSYSADMINACCOUNTS="MyDomain\Special Account Group" "NT AUTHORITY\SYSTEM" "NT SERVICE\MSSQLSERVER" "NT SERVICE\SQLSERVICEAGENT" sa /SQLCOLLATION=Latin1_General_CI_AI The setup program starts, runs a while, then exits with a return code: Error result: -2068643838 Result facility code: 1203 Result error code: 2 The final lines of the Detail.txt file in the ...\Setup Bookstrap\Log\<specific timestamp>\ directory are: 2010-07-12 14:54:58 Slp: Running Action: ProduceStatusLogsBeforeFinishPage 2010-07-12 14:54:59 Slp: Completed Action: ProduceStatusLogsBeforeFinishPage, returned True 2010-07-12 14:55:00 Slp: Received request to add the following file to Watson reporting: C:\Users\<MyLoginName>\AppData\Local\Temp\2\tmpDAAF.tmp 2010-07-12 14:55:00 Slp: The following is an exception stack listing the exceptions in outermost to innermost order 2010-07-12 14:55:00 Slp: Inner exceptions are being indented 2010-07-12 14:55:00 Slp: 2010-07-12 14:55:00 Slp: Exception type: Microsoft.SqlServer.Setup.Chainer.Workflow.NoopWorkflowException 2010-07-12 14:55:00 Slp:     Message: 2010-07-12 14:55:00 Slp:         The state of your

C# Database created but does not show up in Server Management Studio unless I manually attach it.


I used C# Linq to Sql to create a database. I look on the hard drive and the database .mdf and .ldf files are there. I open Server Management Studio 2008, attach to SQL express and the database is not there unless I actually attach the database.


First, is this correct behavior?

Second, is it possible to create a Sql Express database that is automatically registered(?) in Management Studio? If so, please give pointer.


Thanks very much.



Cannot determine how to set owner to install database design

My compatibility settings are fine. Anyone know how to to this?

SQL Server Express R2 Database Engine fails to install on XP Home (SP3)


I have had multiple failed attempts at installing SQL Server 2008 R2 Express on an elderly but reliable machine running XP Home with SP3. 
The support files and management tools loaded OK when I de-selected the database engine.  I was installing as a user with administrator rights. 
I wanted to start the DB as a service following boot without a user logged on.

The failure appeared as a message a 'Library not registered' at stage Slp_Config_SQLEngine_ADHlpr_Cpu32.  I cancelled at this point (although in other attempts I let it run on with similar, unsuccessful results).

Other posts covering failed installation do not appear to cover the same problem.  If they do, I am afraid it is my limited understanding!

The summary log file is below and what I think are the relevant lines from the detail are given after. 

Can anyone help identify the cause and suggest what I need to do to rectify it?

Many thanks.

Summary Log File
Overall summary:
  Final result:                  User cancelled
  Exit code (Decimal):    

Error ID 208 Unable to Determine if the Owner has Server Acccess


Hi - We are running SQL 2008 Standard and have an issue that I need help resolving.   When I try some items such as the DBCC I get an Error ID 208  with the description -   "Unablel to determine if the owner (domin\Administrator) of job BMC: Check Integrity (database name) has server access (reason: Could not obtain information about Windows NT group/user 'DOMAIN\Administrator', error code 0x5. [SQLSTATE 42000] (Error 1504)).

Thanks! for the assist -  NC Beach Bum

NC Beach Bum

Copy from one database to another on the same server.



I have a sql server 2005 express edition.(Windoes 7 PC)

I have a database TrManager.
Now i created a new database named TrManagerTest. i  want to copy the data from the TrManager to TrManagerTest
What are teh steps to be followed for this?
Can i do it from a backup file or is there any other way to do it?


Error when configuring Report Server Database - Wizard is trying to create Database on a non existen


I'm trying to setup SSRS using the Reporting Services Configuration Manager.  Everything seems to be working except the database creation.  When I click on the Database (3rd option down) then Change Database I run through the wizard.  Put in proper SA credentials.  Accept the defaults clicking next through and when it gets to running the script to create the data base I get the Error I pasted below.  We do not have a G drive so I went into SSMS and changed the Default Database settings to point to the F drive (where our other DBs reside) - I got that tip off of this forum but it didn't fix my issue. Any ideas what to try next?  Do I need to stop and restart a service or something?  Thanks for any help you guys can offer.

System.Data.SqlClient.SqlException: Directory lookup for the file "G:\mssql\data\ReportServer.mdf" failed with the operating system error 3(The system cannot find the path specified.).

CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateO




I am using copy wizard in sql server 2008 machine to copy a database to another sql server 2008 machine. Here is the log file.


#Fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message
OnPreValidate,NL-DEVXP95,NT AUTHORITY\SYSTEM,CDW_NL-DEVXP95_MSSQL2008_NL-DEVXP95_MSSQL2008R2_3,{65EB1D9A-DC17-4649-90B7-B3292DFE1ADE},{01BB97DA-C96C-4216-BD10-026F14D1BC7C},11/15/2010 3:05:12 PM,11/15/2010 3:05:12 PM,0,0x,(null)
OnPreValidate,NL-DEVXP95,NT AUTHORITY\SYSTEM,192_168_3_144_MSSQL2008_192_168_3_144_MSSQL2008R2_Transfer Objects Task,{5231CE89-011F-4E2F-8B23-3DC5809CCB86},{01BB97DA-C96C-4216-BD10-026F14D1BC7C},11/15/2010 3:05:12 PM,11/15/2010 3:05:12 PM,0,0x,(null)
OnPostValidate,NL-DEVXP95,NT AUTHORITY\SYSTEM,192_168_3_144_MSSQL2008_192_168_3_144_MSSQL2008R2_Transfer Objects Task,{5231CE89-011F-4E2F-8B23-3DC5809CCB86},{01BB97DA-C96C-4216-BD10-026F14D1BC7C},11/15/2010 3:05:12 PM,11/15/2010 3:05:12 PM,0,0x,(null)
OnPostValidate,NL-DEVXP95,NT AUTHORITY\SYSTEM,CDW_NL-DEVXP95_MSSQL2008_NL-DEVXP95_MSSQL2008R2_3,{65EB1D9A-DC17-4649-90B7-B3292DFE1ADE},{01BB97DA-C96C-4216-BD10-026F14D1BC7C},11/15/2010 3:05:12 PM,11/15/2010 3:05:12 PM,0,0x,(null)

Sharepoint Server 2007 configuration wizard fails on step 6


I am installing Shareoint Server 2007 on a 2003 R2 server with 4Gb  Ram. the install works okay and ends with opening up of the Configuration Wizard. All goes smooth till Step 6 where is throws an exception error: Failed to register SharePoint services.

An exception of type System.ArgumentNullException was thrown. Addition exception information: Value cannot be null.
Parameter name: path

Copy Database Wizard: Cannot choose databases, checkboxes are missing



I try to move databases from one SQL 2008 R2 to another SQL 2008 R2 Server with the copy database wizard.
On the page where I should choose the databases to move or copy the checkboxes are missing. The databases are listed but no way to choose one of them.

I searched a lot but did not find out what the reason could be for this.
Any hints are appreciated, thank you!

how do you determine if a user is connecting to your SQL database with built in SQL server driver ve

An upgrade to our company's software requires SQL Native Client & I want to see if anyone is still not using the SQL Native Client. Didn't know if there was a way to monitor this server side

MS SQL Server: Disconnect Users From Database - Kill User Session

If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend