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

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

MOSS 2010 Web Front End Server (off the domain) and SQL Authentication

Posted By:      Posted Date: October 25, 2010    Points: 0   Category :SharePoint

Hi Guys,

I am trying to use SQL authentication on my moss portal server (to be my web front end) and I am unable to connect.

When I run:

PSConfig -cmd -configdb
-server servername\sqlinstance
-database SharePoint_Config
-admincontentdatabase SharePoint_AdminContent database name
-user domain\SPExternalAdmin
-password password
-dbuser SPExternalUser
-dbpassword password

it tells me that the username is invalid.  the account must be a valid domain account.

am I able to use a domain account for this (keep in mind the moss server is not on the domain)

I can run the scrip differently (see below)

PSConfig -cmd -configdb
-server servername\sqlinstance
-database SharePoint_Config
-admincontentdatabase SharePoint_AdminContent database name
-user local admin
-password password
-dbuser SPExternalUser

View Complete Post

More Related Resource Links

Search Server Gatherer - Custom hierarchical protocol handler ISearchProtocol for MOSS 2010



Search server gatherer calls CloseAccessor() and shutdown() on ISearchProtocol after GetChunk() even if the FILTER_E_END_OF_CHUNKS is not returned. After calling shutdown() it stops calling the createaccessor() with new URL. I want to create a hierarchical indexing but I am not gatherer is not suporting this. The same piece of code is working fine in MOSS 2007, I am facing this issue in MOSS 2010 only. Is there anything changed in MOSS 2010 which is creating this issue?



SharePoint 2010 Server: Cannot manage all user profiles from upgraded MOSS SSP database

I have upgraded an SSP database to SharePoint 2010 and successfully performed User Profile Synchronization with Active Directory, however I cannot manage ALL of the user profiles in the database. I go to "Manage User Profiles" in Central Administration and perform a filtered search (i.e. I want all DOMAIN accounts beginning with "j" so I search for "DOMAIN\j" in Manage User Profiles), but I don't receive ALL the user profiles back. I receive about 8 in return when I know there are about 20 starting with "j". If I create a new AD account beginning with "j" it is successfully synched with SharePoint 2010 and I see it in the Manage User Profiles. I ran an stsadm -o sync to clear any old synchronization information, and the Forefront Synchronization Service appeared to pull in many changes to existing accounts (including ones I can't currently manage), but I still cannot manage them using "Manage User Profiles". I really need to be able to manage all the profiles so I can manually edit some fields. Can anyone please help? Thanks in advance.

Sharepoint 2010 Web Server/Domain Controller ratio

Is this number the same 3:1 as it was in with Sharepoint 2007?

Upgrade from MOSS 2007 Trial to Sharepoint Server 2010

I have a client who setup MOSS 2007 Trial and are coming up on the expiration.  Instead of buying a key for MOSS 2007 they purchased Sharepoint 2010.  I'm having some problems upgrading because its the trial.  What are my options for upgrading/migrating over to Sharepoitn 2010?

MOSS 2007 to SharePoint Server 2010 Hybrid Upgrade Approach on Windows Server 2003 x64

There's some guidance circulating about upgrading to 2010 with a mix of In-Place and Database Attach upgrade methods. My Central Admin and SharePoint Web App are on a 64 bit server, but it's running on Windows server 2003 x64 and not on Windows Server 2008 or 2008 R2. SharePoint Team Blog says Server 2008 or 2008 R2 is required for SP2010. If I want to do the hybrid upgrade approach, is it possible to first upgrade the OS to Server 2008 R2 on the server where my Central Admin and SP Web App runs?  Or will this break MOSS 2007?

How to replace SSO in MOSS 2007 with external server authentication

I want to use an external server to authenticate my users and retrive encryption keys and place it in a landing page. Is it possible I tried with Pluggable SSO but i coudn't interact with the server suggest me plz

SOS: Cannot connect to SQL Server 2005 locally by Windows Authentication DOMAIN \ myname. But networ

Cannot connect to SQL Server 2005 locally by Windows Authentication DOMAIN \ myname. But network connection is successful.   But SQL Server Logins contain   BUILTIN \ Administrators, and                                                    BUILTIN \  Administrators contain DOMAIN \ Domain Admins, and                                                    DOMAIN \ Domain Admins contain DOMAIN \ myname.   Creating SQL Server Login with DOMAIN \ myname entail successful local connection.   Removing SQL Server Login with DOMAIN \ myname and creating SQL Server Login with DOMAIN \ Domain Admins do NOT entail successful connection. Cannot connect! System:   Windows Server 2008. Error 18456

Migrate MOSS 2007 to a new Web Front End Server


I have a MOSS 2007 WFE that on a VMWare virtual machine that has extreme lag.  The SQL backend is reporting no issues.  Just accessing the VM to move around in the OS (start, run, etc) takes 2-5 minutes, and as a result the users are seeing extreme delays in accessing pages, search results populate 30+ secs rather than sub-second, if at all, clicking links take forever to respond, if at all, etc.

i'd like to move the a new VM because attempting to work in that VM is maddening.  Whats the proper procedure to migrate all the pertinent configs etc for the WFE to another machine?  NOTE:  The second VM has been created and already has a different name and IP.

Upgrade from MOSS 2007 to SharePoint Server 2010 but with a catch...


... and the catch is that the MOSS 2007 Site Collection is contained in the SharePoint Central Administration v3 Web Application and therefore the SharePoint_AdminContent_... database which is used by Central Administration (not my doing btw).  Please let me know how to copy it to a new 2010 server farm and then upgrade just our sites and content while removing all of the 2007 Central Administration stuff.



FAST Search Server 2010 Config Error - ValidationException 1034: Username or domain is incorrect.



I've seen other related threads and I've tried all the tricks in getting through the post-setup configuration, but I can't get by the "ValidationException 1034: Username or domain is incorrect." error message taken from the FAST psconfig log. I've tried both the wizard and the psconfig, but get the same results. I'm attempting to deploy the single server (stand-alone) on a single x64 box, under ws2008 SP2, w/SP2010, the server is also the domain controller, and i've been passing the FQDN to the post-setup script as described in the FAST deployment document (see log below):

Verbose [1] PostSetupUI - Displaying next panel :Enter the user name and password
Verbose [1] PostSetupUI - Displaying button set to the default settings
Verbose [1] PostSetupUI - Next button clicked
Verbose [1] PostSetupUI - Starting to process form data of panel :Enter the user name and password
Verbose [1] PostSetupUI - Collecting input parameters from the text input controllers.
Verbose [1] PostSetupUI - Collecting value:dev.devnet.com\fastuser of input parameter: userName
Verbose [1] PostSetupUI - Adding config parameter: userName for the next validation parameter batch
Verbose [1] PostSetupUI - Collecting value of input parameter: password
Verbose [1] PostSetupUI - Adding config parameter: password for the ne

Which Domain Controller is SQL Server using for trusted windows authentication?


We are migrating from Windows Server 2003 domain controllers to Server 2008 Domain controllers.  I want to be able to know which domain controller a SQL server is using for authentication, so I can verify that the 2008 Domain Controllers are working, before we take down the 2003 domain controllers permanently.

I also read something about possibly setting a preferred DC?

Please advise



Issues after moving SP 2010 server to new domain


We moved our SP 2010 Foundation server from one domain to another. We ran through all of the commands mentioned in KB934838 here and all of the sites seemed to work without issue, however there are some areas throughout the Central Admin page we now can no longer access. One of the main areas is Configure service accounts. When navigating to this page, we get the following error:


Some or all identity references could not be translated. 

Troubleshoot issues with Microsoft SharePoint Foundation. 

Correlation ID: f8fd7cbd-3f10-47d2-a44e-23c198ab5b56 


Looking this correlation ID up in the logs returned this:


04/14/2011 15:07:06.83 	w3wp.exe (0x11FC)      	0x113C	SharePoint Foundation   	Logging Correlation Data  	xmnv	Medium 	Name=Request (GET:http://fal-demoserver9:34442/_admin/FarmCredentialManagement.aspx)	f8fd7cbd-3f10-47d2-a44e-23c198ab5b56
04/14/2011 15:07:06.84 	w3wp.exe (0x11FC)      	0x113C	SharePoint Foundation   	Logging Correlation Data  	xmnv	Medium 	Site=/	f8fd7cbd-3f10-47d2-a44e-23c198ab5b56
04/14/2011 15:07:06.86 	w3wp.exe (0x11FC)      	0x113C	SharePoint Foundation   	Configuration     	bmf2	High 	SID |0 cannot be resolved. Using old name: |1. |2	f8fd7cbd-3f10-47d2-a44e-23c198ab5b56
04/14/2011 15:07:06.8

how to connect remote sql server on non domain network using SQL Server authentication



i m newbie on sqlserver.I had manage to build a database (MS SQL SERVER 2005 standard) with a vb.net 2008 and tested well with local machine. and wanted to put a software on client. and   some-how manage to stucture a security model on server authentication. but still not clear on user management. and others.

will anybody help me step by step how to connect remote sql server on non domain network using SQL Server authentication


Thanking you advance



Accessing SharePoint 2010 Data with Server-Side APIs

Accessing SharePoint data in server-side solutions is one of the most common tasks that you will perform as a SharePoint developer. SharePoint 2010 provides powerful server-side APIs that enable you to retrieve, add, edit, and delete SharePoint data programmatically. SharePoint 2010 also includes the new LINQ to SharePoint technology that enables you to work with SharePoint data efficiently and easily.

Configuring User Profiles in SharePoint Server 2010

Note: I've added the necessary links relating to SharePoint Server 2010 prerequisites, along with instructions for configuring the user profile synchronization service, at the end of this

sql server 2010 && visual studi 2010


hi guys

I am using sql server 2010 for a project.I need to know if there is a property about the ON DELETE CASCADE option or i must write triggers???

Another problem is that i am using visual studio 2010 to write the aspx page but when i try to import the tables from the database it just imports the tables  but not the relations between them (i mean it doesn't import the primary/ foreign key property.) 

Any idea??? 


How to authenticate local user usin ldap or non domain authentication



I created one application, and I need to authenticate local user. This user is the user who is login to his/her Personal Computer.. Main thing his that he/she does not in any DOMAIN... I want NON-DOMAIN authentication.. any how.... please help...

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