I'd really like to prepare development environment for Sharepoint 2010. This is what I did:
New-SPConfigurationDatabase in previously opened powershell using this command:
New-SPConfigurationDatabase -DatabaseName "Sharepoint2010Config" -DatabaseServer "developer.mydomain.pri" -AdministrationContentDatabaseName "Sharepoint2010Admin" -DatabaseCredentials (Get-Credential) -Passphrase (ConvertTo-SecureString "%h4r3p0int" -AsPlainText -Force)
When I run it, I'm prompted for database credentials and I enter
mydomain\SPF_DATABASE and password
Then it runs for a few seconds and fails with this message:
New-SPConfigurationDatabase : Cannot connect to database master at SQL server a t developer.mydomain.pri. The database might not exist, or the current user does not have permission to connect to it. At line:1 char:28 + New-SPConfigurationDatabase <<<< -DatabaseName "Sharepoint2010Config" -Datab aseServer "developer.mydomain.pri" -AdministrationContentDatabaseName "Sharepoint 2010Admin" -DatabaseCredentials (Get-Credential) -Passphrase (ConvertTo-SecureS tring "%h4r3p0int" -AsPlainText -Force) + CategoryInfo : InvalidData: (Microsoft.Share...urationDatabase: SPCmdletNewSPConfigurationDatabase) [New-SPConfigurationDatabase], SPException + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell. SPCmdletNewSPConfigurationDatabase
What am I missing? Is there something else I should configure?
I've also tried disabling firewall, antivirus and UAC but with no luck.
Typically when I start, I'm using more than just two accounts. Different services should be on different accounts, and you will want at least one account for the app pools. It is also best practice to use a separate account while running the setup process.
When running the New-SPConfigurationDatabase script, try providing the mydomain\spf_database credentials when prompted. That prompt threw me as well, but it worked when the account I used had access to the sql server.
The account that you are running the cmdlet with must have the dbcreator and securityadmin roles on the SQL Server.
Enabled named pipes on SQL Server 2008 R2
Why Named Pipes and not TCP/IP?
I never had any problems on W7 using either SP Foundartion or SP Server against SQL 2008 as long as I enabled TCP/IP on the SQL Server. Never tried Named Pipes or Shared Memory though.
As for the Hotfix: You're right, SQL 2008 R2 doesn't require any additional hotfixes.
I'm having problems installing development machine for SharePoint (Foundation) 2010. This is what I did so far on the same machine: Installed a clean Windows 7 x64 with 4GB of RAM without being part of any domain. Just a simple standalone machine. Enabled IIS related features as described here except IIS6 related ones (two of them) Installed SQL Server 2008 R2 Development Edition (DB Engine and Writer being enabled but not SQL Agent) Installed Visual Studio 2010 Premium Started installing SharePoint Foundation 2010 with first extracting files, changing config to enable Windows 7
My HOST PC is Windows 7 and using VirtualBox I have setup a Virtual Machine having: Windows 2008 Server R2 Enterprise (Standalone - there is no AD/DC) SQL Server 2008 R2 Express SharePoint 2010 Server Enterprise Trial Now, I want to install SPS 2010 and make use of the existing SQL Server 2008 R2 Express. During the Installation, I selected Server Farm and then Complete option. So far, so... a Farm in such environment? 2) The StandAlone option creates its own SQL Server Express Instance. I want to avoid this and reuse the "already" installed SQL Server 208 R2 Express. Are the above tasks
I want to create a new SharePoint 2010 farm using PowerShell. I use the following command: New-SPConfigurationDatabase When issuing this command (and providing the needed parameters) I get the following error: New-SPConfigurationDatabase : This SharePoint farm currently has pending upgrades. The cmdlet New-SPConfigurationDatabase cannot be executed until the upgrade is completed. When running the "SharePoint 2010 Products Configuration Wizard" I'm able to create a farm. I have a freshly installed Windows Server 2008 R2 with SQL 2008 R2 on the same box (it's a demo box
On a single Windows 2008 Server I'm running SharePoint 2007 Enterprise (SP2, December 2009 CU) and SQL Server 2005 (SP3, CU 7). Authentication is NTLM. I've been trying to get SharePoint Reporting... service accounts domain administrator and local administrator permissions enabled Named Pipes and TCP/IP networking within SQL Server followed Troubleshooting Server and Database Connection Problems.... The Reporting Services URL has been set within Central Administration. When I fill in the "Grant Database Access" form with a user account and click OK, the following message displays: 'A connection
I'm having a problem with SharePoint 2010 Foundation in German. I've Windows Server 2008 R2 Enterprise Host and virtual machine with same system. In that virtual machine right after starting... any ideas? Server is only 2nd Domain Controller with DNS and SQL Express R2 installed. Nothing else. ... if it's correct translation. The funny thing is I've downloaded english version of SharePoint 2010 Foundation and it shows up some gui (prerequisites) correctly, so there's clearly something wrong
for each stage of ILM certificate creation failure). The system is a multi (3) server farm: WFE Windows 2008 64Bit SharePoint 2010 APP (UPS and UPS Sync Running Here) Windows 2008 64Bit SharePoint 2010 SQL (Default Instance) SQL Server 2008 R2 64 Bit All the necessary steps in Spence's guide (domain accounts, permissions, rights, etc.) have been followed. The two FIM services on the APP...After following Spence Harbar's Rational Guide to implementing SharePoint Server 2010 User Profile Synchronization (http://www.harbar.net/articles/sp2010ups.aspx) exactly (and having it work several
v3 to Sharepoint Foundation 2010 and then installed Search Express 2010 on top of it. Update 3: Yes the farm admin acct is the member of the local admin. What services are required to start to have... like to create a Search Service Application after installing Search Server Express 2010. Do I need to run the Farm Configuration Wizard and install the below if I can create a Search Service... and Health data collection This service collects farm wide usage and health data and provides the ability to view various usage and health reports. Update 1: I'm running Windows 2008 R2. I
. Which one will make itpossible to create a rich user interface? Develop on Sharepoint Foundation 2010 or Sharepoint Server 2010? I've seen differences in services they support, but since I don't have...I'm about to start developing a custom business application on top of Sharepoint 2010. I haven't done anything on this product but client insists on it so I don't have a choice. Application info I have to build a complex business application that will use its own DB on MS SQL 2008 R2. Authentication will be done using client certificates and will connect to AD FS on the server side
` -owneremail "<user email>" ` -sitetemplate "STS#1" ` -ownerlogin "<domain\user.name>" (Sidenote: I'm in Powershell with an alias set up for stsadm.) When I run the command, at the Powershell prompt I get only the following output: User cannot be found. If I look into the ULS logs, I see the following related logs (truncated a bit for clarity): Creating site http... to contact the global catalog server If I create a site collection through Central Administration, using the same <domain\user.name> credentials, the site collection is created fine. Any ideas