.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

Mirroring fails (Error: 1418)

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :Sql Server
Our configuration: Two separate boxes running SQL Server 2008 R2.  On box A we have the principal database.  Box B holds both the mirror and the witness.  We are using the Mirroring Wizard.  Both boxes are on the same domain. We followed the following steps to try and establish the mirror: Backed up the database from  box A Backed up the transaction log from box A Restored the backup on box B using the RESTORE WITH NORECOVERY option Restored the transaction log on box B using the RESTORE WITH NORECOVERY option Run the mirrorring wizard on box A At this point I get an error message saying that the mirror database on box B cannot be reached (Error: 1481).  The mirror database on box B is in the "Recovering" state because we used the RESTORE WITH NORECOVERY option.  It's interesting to note that if we restore the database on box B using RESTORE WITH RECOVERY, we then get the same error message but this time it says that the principal database on box A cannot be reached. What gives?JC

View Complete Post

More Related Resource Links

How to Get Error Message from Job History if SQLAgent Job Fails

Hello, I am using "last_run_outcome" value = 0 (fail) or 1 (pass)  from sysjobsteps to identify if the job has failed. So if the job has failed, can I get the Error Message from SQL ? (which we can see in Job History). Thanks, Prabhat

SQL Server 2008 installation fails There was an error generating the XML document. Error code 0x84B

My system config: window XP - SP3 4 GB RAM, I have VS2008 with SP1, VS2010 Ultimate installed First when I tried to install SQL 2008 R2 Dev edition I got an error saying vs2008 SP1 was not installed, infact I had the SP1 installed in my m/c.  I did reinstalled the SP1 and tried to install SQL again. while in the final installation process I got the error  "Setup has encountered the following error: There was an error generating the XML document. Error code 0x84B10001." I uninstall the SQL server again to remove the files which were created from Unsuccessful installation I removed the register entry as suggested by this forum. reinstalled but no chance, I have tried all the option which I can get know in web. Please help me. here is the log files details  Exception type: Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastructureException 2010-08-26 14:54:53 Slp:     Message: 2010-08-26 14:54:53 Slp:         There was an error generating the XML document. 2010-08-26 14:54:53 Slp:     Stack: 2010-08-26 14:54:53 Slp:         at Microsoft.SqlServer.Chainer.Infrastructure.DataStoreService.SerializeObject(String rootPath, Object objectToSerialize, Boolean saveToCache) 2010-08-26 14:54:53 Slp:   &nb

Strange Problem - SSIS Fails with "Syntax error, permission violation, or other nonspecific error".

Hello, I have a strange issue while I am deploying a package to one of the environment server. I have 2 XML Source, in the DataFlow, and one will extracted based on a value of variable that is passed from run time (package is executed from a Job) and other will be extracted all time. The next Step I have is a Execute SQL Task in ControlFlow wihich will execute after DataFlow. This has 2 input parameters and some SQL query that uses the param. Now this one fail on the target environment with below error: failed with the following error: "Syntax error, permission violation, or other nonspecific error". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. I got the error when I did a SSIS Text File Log. Note: If I run the package in BIDS with the same XML files it work. Also when I deploy the package to my Dev Server it works. When I compare the Dev DB with the target environment DB - Both are same. The Service Acount has permission - as I can see the DataFlow task completed. Another Point: The XML Load Data Flow that executes based on the Variable Value does not execute on target environment, even if the value is passed as "True" (It is Boolean Type) But this variable is NOT an input for the Execute SQL task that fails. I am not sure w

Crawling fails with 404 error message, but the IIS log tell a different story

In our clean SP2010 install, crawling stops immediately, just logging a single error message:   The object was not found. ( Error from SharePoint site: HttpStatusCode NotFound The request failed with HTTP status 404: Not Found. )   Looking at the IIS log does, surprisingly, not  confirm this. Here are all the log entries related to crawling:   #Fields: date time s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status time-taken 2010-09-01 15:20:42 GET / - 80 - Mozilla/4.0+(compatible;+MSIE+4.01;+Windows+NT;+MS+Search+6.0+Robot) 401 1 2148074254 15 2010-09-01 15:20:42 GET / - 80 0#.w|global\cre-nhk Mozilla/4.0+(compatible;+MSIE+4.01;+Windows+NT;+MS+Search+6.0+Robot) 200 0 0 46 2010-09-01 15:20:42 GET /Pages/Forside.aspx - 80 0#.w|global\cre-nhk Mozilla/4.0+(compatible;+MSIE+4.01;+Windows+NT;+MS+Search+6.0+Robot) 200 0 995 937 2010-09-01 15:20:43 GET /_vti_bin/sitedata.asmx - 80 - Mozilla/4.0+(compatible;+MSIE+4.01;+Windows+NT;+MS+Search+6.0+Robot) 401 1 2148074254 0 2010-09-01 15:20:43 GET /_vti_bin/sitedata.asmx - 80 0#.w|global\cre-nhk Mozilla/4.0+(comp

sqlcmd - linkedserver - ALL queries fails after FIRST error from remote server - ANONYMOUS LOGON

Hello, I have very strange problem with sqlcmd , it stop working after first error returned from remote sql server (like permission denied), lets try show what I'm doing, configuration is quite simple C- client (windows 2003 x64, standalone sqlcmd client sp3) S1 - server1(windows 2003 x64, sql 2005 sp3) S2 - server2 (windows 2003 x64, sql 2005 sp3) I need connect via middle Linked Server (S1) from C to to S2, each machines have the same LOCAL Windows account C\LSUser, S1\LSUser, S2\LSUser with the same password, LSUser is not domain account, linked server is configured for Windows Account Impersonation (checked Impersonate) Example, query executed from client C: 1>exec [LS1].[DB].[dbo ].[ListTab1]; - works well, no problem 1>exec [LS1].[DB].[dbo ].[ListTab2]; - works well, no problem ok , now try modify permission on S2, I explicitly deny execute procedure [DB].[dbo ].[ListTab1] on S2 to S2\LSUser, 1>exec [LS1].[DB].[dbo ].[ListTab1]; Msg 229, Level 14, State 5, Server S2, Procedure ListTab1, Line 1 The EXECUTE permission was denied on the object 'ListTab1', database 'DB', schema 'dbo'. expected message :), but look now: 1> exec [LS1].[DB].[dbo ].[ListTab2]; Msg 18456, Level 14, State 1, Server S2, Line 1 Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. all remote queries STOP working from client C 1> select top 10 * from [L

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

EBS 2008 WSS 3.0 fails with Error 500

Hi all, I have problem with Essential Business Server (EBS) 2008 WSS. It was deployed and WSS was configured and working properly. After sometime, it returned an error " the page cannot be displayed" after some troubleshooting, I discovered that 2 applications were using same port. Following some steps I found online, i removed Binded ports on IIS. Now, anytime I tried to browse any of the sites on IIS. It returned "Error 500 - The page cannot be displayed". I cannot also have access to management page as well. Info: EBS is installed on 3 physical servers - HP Proliant DL 380 G5 Please help.  

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

Workflow project compilation fails with error 348: Compilation failed. Cannot execute a program.

Hi, I am trying to build a workflow project on a PC and I am getting the "error 348: Compilation failed. Cannot execute a program." error. This project is part of a bigger solution and it used to build just fine on my PC. Also, the project and the solution build OK on several other computers. I am sure that the problem is something on my PC. 1. I am not sure what changed to make the project start failing. 2. I tried to delete the project, source and all folders from the disk and sync to the source control again 3. Re-installed the .NET 3.5 framework 4. Uninstalled Visual Studio 2008, deleted the visual studio folder under program files, and reinstalled VS 2008 5. I noticed the the file referenced in the error "...Temp\8sl_helt.cmdline" does not exist under the Temp folder. An empty folder called "8sl_helt"however is created, but there is no file with the cmdline extension. I turned up the output log to "diagnostics", this is the output generated when the error happens. Have anybody seen this? Done building target "_ComputeNonExistentFileProperty" in project "QCReviewWorkflowLibrary.csproj". Target "CreateWorkflowManifestResourceNames" skipped. Previously built successfully. Target "WorkflowCompilation" in file "C:\Program Files\MSBuild\Microsoft\Windows Workflow Foundation\v3.5\Workflow.T

.Net Framework 2.0 SP1 fails to install with Error 0x641

We have a SBS 2003 server that has automatically installed updates just fine for several years.  Now it is failing to install Microsoft .Net Framework 2.0 Service Pack 1 (KB110806).  The only error that I can find is Error Code: 0x641The server's C: drive has 5.2 GB free and the other hard drive (D:) has 61 GB free.  It has 2 GB of RAM and a 3GB paging file.I posted this in Microsoft's "Windows Update Newsgroup" and I was told to come here.  I was told to download the collect.exe file to collect the .NET logs, but when I run that, I get the error "No log file exists."I would appreciate your help.

Opening a PowerPoint presentation fails with error "invalid path or file name".

When you go to a Document Library and try to open the presentation, PowerPoint opens, but then you get the error "The path or file name for "file URL" is invalid.  Please check that the path and file name are correct."I installed MOSS/WSS SP2 about 2 weeks ago, this happened once or twice before then, but I now know of about a half-dozen presentations that won't open.There is a way to get the file to open, if you hit the drop-down next to the file and select Send To and Download a Copy, you can save or open it from there.If you try browsing to if from within PowerPoint, it won't open either, and will also not open in Explorer View.  We have replaced the file, saved as a different name, etc. with no luck.Using both IE 7 and IE 8 and both XP Pro and Vista Business workstations.Any ideas out there?Thanks,Rusty

try to reinstall .NET 4, error I need to install WIC, that fails with error update.exe not valid


trying to do a clean install of .NET v4, installation starts then stops with a fatal error.  I look at the log file, this is where it hangs up:


Action start 13:48:30: CA_Block_WIC_NotPresent_x86.
MSI (s) (68:60) [13:48:30:593]: Product: Microsoft .NET Framework 4 Client Profile -- You must install the 32-bit Windows Imaging Component (WIC) before you run Setup. Please visit http://go.microsoft.com/fwlink/?LinkId=162643&clcid=0x409 to install WIC, and then rerun Setup.

You must install the 32-bit Windows Imaging Component (WIC) before you run Setup. Please visit http://go.microsoft.com/fwlink/?LinkId=162643&clcid=0x409 to install WIC, and then rerun Setup.
Action ended 13:48:30: CA_Block_WIC_NotPresent_x86. Return value 3.

So I follow the link in the log file, when trying to install WIC I get the "update\update.exe is not a valid Win32 Application".

I can not find any info on how to fix this. 

thanks for any asisstance.

Trying to recreate Help Desk site in SharePoint 2010 fails with an error


The site template requires that the Feature {af6d9aec-7c38-4dda-997f-cc1ddbb87c92} be activated in the site collection.

Troubleshoot issues with Microsoft SharePoint Foundation.

Correlation ID: 1c60c31d-cf82-47f0-a065-3673b4e16ca6

Date and Time: 8/27/2010 7:54:24 AM

I looked up the GUID using http://blogs.msdn.com/b/mcsnoiwb/archive/2010/01/07/features-and-their-guid-s-in-sp2010.aspx as my reference.  However, I cannot for the life of me figure out how to add this feature to the site collection.  When I go to the top-level site and go to add site collection features Web Analytics Customize Reports functionality is not there.

Clearly there is something I'm missing but since Microsoft is not redoing the Fabulous 40 site templates, any help in getting the old sites to work in a sharepoint database attach migration will be greatly appreciated.


Michael Caplan

People Picker fails to search or resolve and return an error message.



I got an error while trying to access the people picker from some specific locations. I'm experiencing those problems ONLY in the cental administration and also there, just on a few places. For example if I try to change the authorization settings of any service application there is a different people picker pop up than, for example, if I want to change the admins of any service application. Any other people picker window outside the central administration works for me.

So it seems to me, that there are two different types of people picker windows. The one which is not working for me also appears in the metadata service application which is the reason I can't use this service as I'm not able to define an owner of a keyset.

In the error log I found the following message: "Ausnahme im Forderungsanbieter 'Alle Benutzer' beim Aufruf von 'SPClaimProvider.FillHierarchy()': Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt." It basically says: An exception occurred in 'all users' claim provider when calling 'SPClaimProvider.FillHierarchy()': The object reference was not set on a object instance. This is event-id 8307 which you can find here: http://technet.microsoft.com/en-us/library/ff535778.aspx

bcp queryout using $PARTITION fails with Native Client error: Invalid Object $PARTITION


Using bcp queryout, in-line queries of the following form fail with the invalid object error on the $PARTITION keyword:

bcp "SELECT S.* FROM Support_Prod.ADSK.Session S INNER JOIN ##Session #S ON (S.SessionId = #S.SessionId AND S.LastInquiryId = #S.LastInquiryId AND $PARTITION.AdskInqPF(S.LastInquiryId) = $PARTITION.AdskInqPF(#S.LastInquiryId))" queryout I:\Data2\AdskBCPout\ADSK.Session.dat -fI:\Data2\AdskBCPout\ADSK.Session.format.xml -q -t\t -r\n -SINTDEVSQL1\DEV1 -T

Here, AdskInqPF is a well-formed partition function used to partition Support_Prod.ADSK.Session.  ##Session is a table of semi-joins derived from the former, but is not partitioned.  LastInquiryID is the partitioning key on the Session entity.

The resulting error is:

SQLState = S0002, NativeError = 208
Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name '$partition.AdskInqPF'.
SQLState = S0002, NativeError = 208
Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name '$partition.AdskInqPF'.
SQLState = 37000, NativeError = 8180
Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]Statement(s) could not be prepared.

The platform is SQL Server 2008 SP1 and the bcp is

BCP - Bulk Copy Program for Microsoft SQL Server.
Copyright (C) Microsoft Corporation. A

On Change:Prevent Evaluation fails with error Could not load file or assembly 'Microsoft.SqlServer.


Hi All,

I am facing a strange issue with Policy Based Management. Exact problem is as below

SQL Setups


I have Lenovo laptop having 3 SQL instances installed on it.

SQL Server 2005 (x86) Developer Edition 9.00.4053  -- Named Instance : SQL2K5

SQL Server 2008 (x86) Developer Edition 10.0.1600.22 -- Named Instance : SQL2K8

SQL Server 2008 R2 (x86) Developer Edition 10.50.1600.1 -- Named Instance : SQL2K8R2


I configured SQL2K8R2 instance as a Centralized Server and registed SQL2K8 & SQL2K5 under this. I configured a new condition by using facet: MULTIPART NAME. As per this condition Table Should start with TEST_ in database TEST . Evaluation Mode set to              On Change: Prevent. Idea is if some one logs to database TEST and tries to create table with name other then starting with TEST_ then it should fail.

I Imported this policy on registered servers thru Centralized Management Server Action, as expected policy got configured on Registred SQL2K8 instance

Web service's method GetListItems fails with error "'_', hexadecimal value 0x0B, is an invalid ch


We are developing ASP.NET web application that interacts with SharePoint via web services. At some our customers' systems we encountered the following problem.
Web method GetListItems throws an exception :
 ' ', hexadecimal value 0x0B, is an invalid character. Line 42, position 31.

Stack trace of exception you can see below:
   at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle, XmlDeserializationEvents events)
   at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at ITSMS.DAL.SPLists.Lists.GetListItems(String listName, String viewName, XmlNode query, XmlNode viewFields, String rowLimit, XmlNode queryOptions, String webID)

INNER MESSAGE: ' ', hexadecimal value 0x0B, is an invalid character. Line 42, position 31.

   at System.Xml.XmlTextReaderImpl.Throw(Exception e)
   at System.Xml.XmlTextReaderImpl.Throw(St

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