Hot answers tagged

5

This is completely unsupported! Do not read or write data to SharePoint databases. You need to go through the SharePoint Object Model, namely using SPWeb.EnsureUser which will add the entry if it does not exist.


4

You must use cliconfg.exe on each SharePoint server to point the 'old' SQL Server name (and instance if applicable) to the new SQL Server name (and instance if applicable). So if you had an old SQL Server name of OLDSQL and a new one of NEWSQL, you would run cliconfg.exe on each SharePoint server, go to the Alias tab, add an alias named OLDSQL. Set it to TCP/...


4

You can detach the content database from central admin and then reattach using the correct SQLCluster Name. You dont need to delete anything. Attach or detach content databases in SharePoint 2013


4

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

Do not remove the site collection from the database! Just remove it via the GUI (Site settings -> Delete site) or use the PowerShell cmdlet Remove-SPSite (outlined here). This will make sure it is deleted the right way


2

If your database is SQL, then there is a built in feature to achieve this. Follow the link For other databases you have to write a custom wcf web service. see here


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 ...


2

You can use the script to give specific users the db_owner role. Don't forget to dd all users to users.txt. [System.Reflection.Assembly]::LoadWithPartialName(‘Microsoft.SqlServer.Smo’) | out-null $Users = get-content c:\users.txt Foreach ($User in $Users){ $InstanceName = "" $NewOwnerLoginName = $user; $smosvr = New-Object (‘Microsoft....


2

SharePoint API has class and function SPContentTypeUsage.GetUsages that returns all content type usages in site collection. Is MSDN article there is an C# sample too. Also look at the accepted answer in this question . The answer is in PowerShell.


2

I would also like to add that you can also accomplish this with SQL Table Views. So if you create a custom view within your SQL DB, you can connect to it in BCS using SP Designer as if it was a regular table. My understanding is that if the View is update-able as defined here, you will also be able to add Update controls to it. To add a view as an ECT ...


2

The name of a content database is just a random generated name that does not have any type of function more than that you can't have 2 databases with the same name. (Every database has it owns unique ID, the display name is just there to make administration easier.) However you should name your content databases to something relevant to make it easier for ...


1

We are using the same way, we have DNS entry which points to SQL server. We prefer the DNS entry upon SQL alias. For DNS entry, in case of failover down timer is higher then sql alias. You can go either SQL Alias or DNS entry. You can read the below blog for nice comparison: https://junfengzhang.com/2014/08/16/dns-alias-vs-sql-server-alias/


1

My answer for the question is simply NO. Your SharePoint Server is no more live. As you have already mentioned in the question that you have uninstalled the SQL server from Windows Server 2012, then all databases deleted from the server. As we all know that, SharePoint works on SQL server database as it's a back-end. So in your case SharePoint is ...


1

I recommend you start with this book, "Inside Microsoft SharePoint 2010". The first 4 chapters can be read online at MSDN this link: Book landing page: Inside Microsoft SharePoint 2010 There are versions of this book for 2007 and 2013 too.


1

You can shrink a SharePoint SQL Server database just like any other SQL Server database using SQL Server Management Studio. This is fine in a development environment, since you are likely the only person using it (might want to give a heads up to the team if there's more than one of you). Of course, there will be a performance impact on SharePoint itself ...


1

For a development environment, no I don't see any reason you couldn't shrink it (though you should never shrink databases in production, unless you're going to gain back 40%+ space and you need it -- shrinks fragment the indexes). I would say for your dev environment, you probably want to disable most usage logging, unless you need it for a specific purpose....


1

I know you get the answer, here is my 2cetns on it. why i will get different content database when i create a new web application? and from where i can check this content database? Christoffer already explained it. SharePoint when create a content DB it puts guid in front of it, make it unique, you cant have two database with same name / id in the same farm....


1

There are many ways how to add items to SharePoint lists and the approach that you want to take is definitely not on the list. Using C# (server object model) - code needs to be run on SP server. Using C# (Client object model) - add items to SharePoint List using CSOM. SharePoint PowerShell. SharePoint Web Services (jQuery). Query Ajax function is used to ...


1

You can use the stored procedures with BCS, so instead of a single table, you can gather information (Read only) from a result of a query. You need to create the stored procedure in SQL first, then connect to BCS through SHarePoint Designer, then you will be able to create a External Content Type based on that stored procedure. Here is an article that ...


1

I am on the same SKU with patch level October 2015 CU. I can't reproduce the behavior with the second page you mention. With regards to the requested ordering of comments, I was able to change the ordering by using SharePoint designer. I navigated to post.aspx within the list that contains the blog items and changed the XsltListViewWebPart webpart that is ...


1

User profiles must be created initially from an LDAP (or other approved directory) this does not include SQL. You have to have a domain account to match the Profile to. This can also happen when a user hits a SharePoint site for the first time. Once the Profile is created you can update it in a number of different ways. If you want to use a SQL data source ...



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