Tag Info

Hot answers tagged

4

Nico, I found a source that may help you immensely. The following link walks you through how to use a PowerShell script to import a list of users from Excel and create them for FBA. Importing and Exporting Data in Extranet Collaboration Manager (ExCM) 2010 You can also download the PowerShell source code from this link. It looks like the code creating ...


3

Depending on your specific requirements, the easiest way is probably to use BCS to create external content types that link to your MySQL data. Your SharePoint hosted app can then read/write that data more or less as if it was a standard SharePoint list. The benefit of this approach is that it is quite quick and easy to set up. The downside is that it may be ...


3

For SP 2010, you can use Web Analytics feature built in SharePoint: http://blogs.msdn.com/b/ecm/archive/2010/03/21/introducing-web-analytics-in-sharepoint-2010.aspx For SP 2013 things have changed a bit, so you have to use Usage reports: http://technet.microsoft.com/en-us/library/jj715890.aspx


2

It is not possible. You need Microsoft SQL Server. More info in Hardware and software requirements for SharePoint 2013. Technet.


2

RBS isn't configured correctly. You need to have master key in your SharePoint Content database. Use the following command to add it: use [ContentDbName] if not exists (select * from sys.symmetric_keys where name = N'##MS_DatabaseMasterKey##') create master key encryption by password = N'Admin Key Password !2#4' Source


2

Has nothing to do with SharePoint. If you configure the server your MYSQL database runs on to accept Cross Origin requests you can access it from any environment. A https connection is preferred, but not required when you manually instruct your browser to allow mixed content. A REST middle-tier like ArrestDB in your stack simplifies access. You are ...


1

Pre-Requisites You must be a member of the Farm Administrators SharePoint group. You must be a member of the Administrators group. On the database server you must be a member db_backupoperator fixed database role and db_owner fixed database role Steps Close all open SharePoint Management Shell windows. Stop all services that are related to SharePoint ...


1

I was in a similar situation, and what I did was to use Nintex Workflow to do an "execute SQL" action to write new form submissions out to a database I use purely for reporting purposes. If you don't have Nintex Workflow, ilovesharepoint has an "Execute SQL" SPD add-in for SP2010. The only issue I found is, because of how workflows work; you cannot easily ...


1

Yes it is possible, here is a basic example: protected void Page_Load(object sender, EventArgs e) { const string ConnectionString = @"Persist Security Info=False; Integrated Security=SSPI; Server=hercules\sqlexpress;Connect Timeout=30;Database=TestDB;"; SqlConnection con = new SqlConnection(ConnectionString); SqlCommand cmd = new ...


1

It is not possible to run it using MySQL server. You can use express edition for simple tasks but if your databases go more than 4GB I suggest you use many web apps instead (divide the work). For big companies it will be impossible to use SQL express edition so you would have to buy SQL Server. MySQL is not an available solution.


1

You can use Powershell script to export External list to Sql on nightly basis(Task Scheduler) Please look into following URL which will be helpful to you for getting power shell scripts http://www.terrymarshall.com.au/Blog/tabid/162/EntryId/165/SharePoint-2010-Exporting-Lists-To-SQL-Server-Part-2.aspx ...


1

SharePoint lists consist of rows and columns that store data in a similar fashion to a traditional relational database management system such as SQL Server. However, a benefit of lists is that SharePoint includes Web Parts that provide simple methods for managing the data. If the data was stored in a database, it would require custom user interface ...


1

Thanks for your reply. I managed to sort this yesterday. I had to edit the versions of the database due to a Schema mismatch error. After that I was able to create a new Site Collection and add the restored database as the Content Database for that site.


1

Yes you can leverage the same database server across multiple installs. The only thing you should take care of is to use unique "Database" names so it will not conflict with each other. For example: Append "SP2010" to all databases that are created for SharePoint 2010. Also you should increase the server capacity to support both. Sharepoint 2010 and ...


1

Here is a guidance to rename the Usage and Health Data Collection service application: http://technet.microsoft.com/en-us/library/jj219726(v=office.15).aspx Stop your Service with: $usage = Get-SPUsageApplication $usage.ServiceInstances | % {Stop-SPServiceInstance $_.ID} In your SQL Management Tool Rename the database. I had problems doing this because ...


1

You need to rename one of the Databases. Is the Usage database the only one with a conflicting name? You can try: Removing the service application without deleting the database Using SQL Management Studio to rename the database to a new, non-conflicting name Provision the service application pointing to the renamed database Step by step: ...



Only top voted, non community-wiki answers of a minimum length are eligible