SQL Server user configuration when MOSS 2007 and SQL Server 2005 are on different servers?
Hi, I have installed MOSS 2007 in one of Windows 2008(Server1) server and after installation, i run "Sharepoint Products and Technologies Configuration wizard" and now need to provide database and its user name, password. But ! my SQL server is installed in another Windows 2008(Server2) server and created a database for this MOSS 2007. When I am trying to give Server2's user name which is mapped to Sql server, it is not taking. I don't understand why it is not taking, could someone tell me what user i have to use here. Should it be of Server1's user or Server2's user ? If so, how ? Regards, Suresh
February 23rd, 2010 2:57pm
Hi,
Your scenario is a typical farm installation, so domain environment is required.
This account is used on the local and SQL Server side, therefore you could not use a local account.
I know you could run "PSCONFIG -configdb create" to connect to another existing shared SQL Server with SQL Authentication for your scenario, but it is not suggested.
See Command-line reference for the SharePoint Products and Technologies Configuration Wizard (Office SharePoint Server) (http://technet.microsoft.com/en-us/library/cc263093.aspx) for more information.
One of the limitations discussed in this thread: http://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/8fd09cd3-cafc-47fc-bea9-bc1e6986f1aa
In all, I suggest you to build a Window domain environment and then perform the Sharepoint Products and Technologies Configuration wizard.
-lambertSincerely,
Lambert Qin
Posting is provided "AS IS" with no warranties, and confers no rights.
Free Windows Admin Tool Kit Click here and download it now
February 25th, 2010 9:28am