Add this tag,When Your issue pertain to SQL Server 2012 or error occured at SQL server 2012

learn more… | top users | synonyms

3
votes
3answers
18 views

Content database recovery model rather than Full recovery importance in sharepoint

SharePoint Content Database are configured to run with a different recovery model than Full Recovery,is it important to configure content database recovery model to full recovery. We have 3 TB size of ...
1
vote
1answer
35 views

Hybrid SharePoint 2010 On-Premise with AWS EC2 (manage DB SQL Server 2012) [duplicate]

We have requirement one of client to maintain that SharePoint 2010 Server on our local Server instead of AWS EC2 and SharePoint Databases (Like SP_Config,WSS_Content, Service application databases) ...
1
vote
1answer
17 views

Restoring site collection on different sql server version

I am planning to restore a SP2013 site collection from a farm running on MSSQL 2008r2 into a different farm which runs on 2012 MSSQL. Is it possible? Is there any issue? thanks in advance
0
votes
0answers
20 views

SharePoint 2013: Access Services - Best practice & configuration questions

I'm looking to configure Access Services on a fresh 2013 SharePoint farm. I have a couple questions that I'm hoping you all can help me with. Is it a best practice to have a separate SQL server for ...
0
votes
1answer
20 views

Reconfigure SharePoint to a new Sql Server box

I am having SharePoint 2013 installed and configured on a Windows Server 2012 machine without Sql Server enterprise edition[ I mean,inbuilt sql server express edition]. Now, I would like to configure/...
0
votes
1answer
77 views

SQL database login for 'Config' on instance '' failed. Additional error information from SQL Server is included below

In our internet farm in search server I saw below errors in event viewer. How to solve these issues. SQL database login for SPL_Config' on instance 'SQL123_SQL' failed. Additional error ...
0
votes
3answers
25 views

Non sharepoint databases in same sharepoint sql server instance and issues?

we have a SharePoint 2010 farm and sql instance for this farm in a sql farm, and if create non-SharePoint related databases in same instance for SharePoint farm, is any danger / issues to ...
0
votes
0answers
41 views

SSRS report and performance point filter issue in sharepoint 2013

Deployed a dashboard in a sharepoint site this dashboard it has a Performance point filter which is get data from report database and it has a performance point report it is connected with a report ...
0
votes
2answers
150 views

SharePoint 2013 and SQL Server 2012 Service Pack 3

Our DBA wants to apply Service Pack 3 on SQL Server 2012, has anyone installed SQL Server 2012 SP3 on a SharePoint 2013 farm? Any catch outs? Any articles that show it is supported?
0
votes
1answer
26 views

what is the maximum size limit for a sharepoint content database when it configured with RBS

what is the maximum size limit for a sharepoint content database when it configured with RBS . i mean max limit for content database .mdf file and rbs san / nas folder
0
votes
0answers
27 views

while upgrading sharepoint 2007 to 2010 errors

hi my upgrade fail from sharepoint 2007 to 2010 this is the log most of them are sql errors what can i do? [powershell] [SPContentDatabaseSequence] [INFO] [4/19/2016 2:41:58 PM]: ...
0
votes
0answers
37 views

Sharepoint Server 2013: SSRS Reports always keep refreshing on iphone

Scenario: I have added report viewer web part on page and displaying RDL report. Report working fine on desktop and on android devices as well as on ipad tablets also. Problem: Whenever i open ...
1
vote
1answer
17 views

SharePoint accounts being created in SQL with $ at the end

I'm getting the following error: (EVENT ID 3760) SQL Database 'WSS_Content' on SQL Server instance 'SQLSERVER01' not found. Additional error information from SQL Server is included below. Cannot open ...
0
votes
0answers
29 views

How to integrate sql server reporting services in sharepoint?

how to integrate SQL SERVER REPORTING Services in sharepoint 2013, I have a sharepoint test farm with one app server , one wfe server and one sql server. I prepared a new windows server 2012 R2 ...
1
vote
0answers
37 views

How big size of File stream folders created automatically in RBS folder for a content database

There is a content database configured with RBS , and this RBS folder size is 2 TB, and web application has used to upload documents mostly and working fine but in the last weekend there is no ...
5
votes
1answer
287 views

RBS on SharePoint 2013 file size limit

I read the MSDN article (https://technet.microsoft.com/en-us/library/bb933993(v=sql.105).aspx) where it says that enabling FILESTREAM storage will allow to overcome the limitation of 2GB file sizes. ...
0
votes
0answers
23 views

How to control view audit log events from search service content access account?

I enabled the audit log events Edit and delete like in below image I found there is huge number of rows creating every day in audit table daily, now its size 40 GB. Now I am running Audit log ...
0
votes
1answer
76 views

Failure to Configure New Farm (Keyset does not exist)

I'm trying to set up a SharePoint Foundation 2010 farm on my local Windows 10 machine in order to make a dev copy of our production site. I have SQL Server 2012 installed, and I point the ...
4
votes
1answer
26 views

MIgrate sql 2008 to 2014 with sp 2010

I have a customer with SP 2010 Foundation and Sql Srver 2008, now they want to migrate only the DB Server to SQL 2014, I am looking for detailed explanation so I can give an estimate, but cant find ...
0
votes
0answers
38 views

SharePoint 2013 fail over option

What are the options available for setting SharePoint 2013 fail over plan which have two tier architecture. Following servers in farm: SharePoint 2013 web front end SQL 2012 database Both servers ...
1
vote
1answer
52 views

Not able to create External Content Type in SharePoint Designer 2013 using Stored Procedure

I want to create the external content type using stored procedure but it is giving me error such that, when I right click on routines in Data Source Explorer and then select New Read Item Operation ...
1
vote
0answers
32 views

How to create multiple RBS stores for a single content database

I have a sharepoint content database and one RBS store configured with this content db. and it can be possible to create one another RBS store for the same contet database. this sharepoint web ...
1
vote
0answers
17 views

Sharepoint 2013 only to use cubes for dashboards or tables as well?

We have some SSRS reports pulled directly from datamart tables, we are not using SSAS cubes. This is SQL Server 2012. Now we are implemented a Sharepoint 2013 solution and we will use it for ...
1
vote
1answer
126 views

How to solve error with comments paging on blog site?

We have a news functionality in SP2013 based on the blog site template. The problem occurs when a post receives more than 10 comments: SharePoint adds a paging button (the left and right arrows) in ...
1
vote
1answer
48 views

Configure SSRS with SharePoint 2010 Complete Server without AD

Is it possible to configure SharePoint 2010 in claims mode on an all-in-one development box with SQL Server 2012? If so, how? To be clear, this is a development box that is NOT attached to a domain. ...
0
votes
0answers
33 views

RBS SharePoint 2013 - The migration process blobs work fine, but not released data in DataStream Table

RBS is installed, configured and successfully moved the data from SQL to BlobStore I set to migrate files larger than 1 MB $database.RemoteBlobStorageSettings.MinimumBlobStorageSize=1048576 Blob ...
0
votes
0answers
44 views

SharePoint Using all available SQL memory

Background We have two environments for SharePoint: Test 1 WFE, 1 APP server, 1 OWAP server and 1 SQL Server with 32 GB RAM All servers are Windows Server 2012 Tier 3 SAN disk (slower) ...
0
votes
0answers
63 views

Impact of having not the best allocation unit size of the HDD?

While reading about performance of SharePoint and SQL Server settings, I found various blogposts which state that the best allocation unit size of a disk is 64K. Having this not set might result in 1/...
0
votes
1answer
55 views

Unable to connect to SQL on aspnet_regsql.exe

I have a standalone environment, and I am trying to configure FBA on my local machine, I ran aspnet_regsql.exe, and it said it's unable to connect to SQL. The account am using is the sp_admin ...
1
vote
1answer
51 views

Any possible problems when migrating SharePoint 2007 databases from SQL 2005 to 2012

Due to SQL Server 2005 EOL, we plan to migrate all SharePoint 2007 and 2010 content databases to SQL Server 2012 (or SQL 2008). I wonder if it will be safe to migrate, and any possible points to be ...
1
vote
0answers
178 views

Removing SQL Server reporting services from Sharepoint 2013

I installed SQL server reporting services on one of our front ends and everything stopped working -- images stopped displaying, users got permissions errors. I tried to remove it from installed ...
0
votes
0answers
106 views

Post SQL Server 2012 data to Update SharePoint 2013 List using ODATA

I've seen articles about creating SharePoint lists from a spreadsheet to ODATA. But I need to post SQL 2012 data to a SharePoint 2013 list. I'm using SSIS. You can install an ODATA addin for SSIS ...
0
votes
0answers
9 views

Unable to start SQL Server service [duplicate]

Recently I changed my account's domain and password. Now, when I try to start the SQL Server service and I get the error whose code is 17058. The system cannot find the path specified. How can I ...
0
votes
1answer
398 views

RBS Enabled Database Migration SharePoint 2010 to 2013

How can we do migration of SharePoint 2010 to 2013 RBS enabled database. We are using SQL database Attach & Detach method. With normal database we are able to do this. But RBS enabled database We ...
0
votes
1answer
265 views

Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. in application server

we have a medium share point farm , recently in application servers i found below errors in event viewer. Log Name: Application Source: Microsoft-SharePoint Products-SharePoint Foundation ...
0
votes
1answer
367 views

A network-related or instance-specific error occurred while establishing a connection to SQL Server. when use sqlalias and try to connect sql server [closed]

i have an asp.net web application that connected to sql server 2012 from a server ( windows server 2012 R2) its a fresh installed server and installed oracle 32 bit client . its SharePoint wfe server. ...
1
vote
1answer
94 views

Running SharePoint 2010 on SQL Server 2014 with Compatibility Level 110?

Can anyone confirm if it is supported to run SharePoint 2010 on SQL Server 2014 with Compatibility Level 110? Have seen SQL Server 2014 and SharePoint 2010 is not a supported combination, but not ...
1
vote
1answer
27 views

SQL SERVER 2012 high availability and cluster for deploy share point 2013 Internet portal

We have plan to deploy a huge SharePoint 2013 internet portal and we are using sql server back end. The daily have 500 to 1000 concurrent users and for sql server cluster and high availability and ...
1
vote
0answers
426 views

Failure in connecting to SQL Server Workflow Manager Configuration

So I am Configuring workflow manager 1.0 using the wizard. When I test connection of SQL Server Instance, I receive a red error "Failure in connecting to SQL Server". I am using "machine name\instance ...
0
votes
1answer
73 views

how to assign data files path in sql server when creating new web application in share point

recently we migrated storage of all sql server databases to diffrent storage. and mounted back all content databases , and now sharepoint farm is working fine but, when i try to create new web app i ...
3
votes
2answers
5k views

Create External Content Type - Access denied by Business Data Connectivity

Following the technet articles on how to get external data into SharePoint 2013 (for testing purposes) I've created: Business Data Connectivity Service with Metadata Store Permissions Secure Store ...
1
vote
2answers
368 views

How i can load data from sql server to office 365 list with ssis

Please help. OData connection load data from Office 365 to sql server. How i can load data from sql server to office 365 list with ssis?
1
vote
2answers
818 views

SharePoint 2013 backup from Central Administration Errors?

I have 2 Servers in one server I have installed SharePoint 2013 and in another server I have installed MS Sql server 2012 us back end for my SharePoint When I want to backup my farm from Central ...
0
votes
1answer
234 views

Problem connect to SQL server

I try to connect from webpart to database server. Error happen in the line: conn.Open() Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, ...
0
votes
1answer
225 views

Data Source in a connection-string for connecting to SQL Server in Always On Availability configuration

I am writing a custom web-part in SP 2013 environment. We have 3 SQL 2012 servers in Always On Availability group. Where one is Primary and other two are secondary. They are configured for failover ...
1
vote
1answer
145 views

How to install Sharepoint 2013, AD and SQL Database separately

I have a ISO with SharePoint 2013 Standard Edition and Microsoft SQL Server 2012 and want to make a SharePoint environment with Active Directory on 3 virtual Machines (using Hyper-V). Instead of ...
1
vote
0answers
173 views

How to execute a SQL Agent Job on a button click in a Web Part page of a SharePoint 2013 site?

I have a SharePoint 2013 on-premises site. The requirement is to add a button to one of the Webpart pages and on click of that button, a sequence of 3 consecutive SQL Server Agent jobs will be ...
0
votes
1answer
57 views

can not add a new value in a custom list

I running: - Windows server 2012 - Sharepoint 2013 - Visual studio 2013 I created a custom list in visual studio and when i'm trying to add a new value inside I got "unexpected response from ...
0
votes
1answer
379 views

Restoring the Existing Sharepoint farm using different SQL server instance

How to change the Database server instance of the the existing sharepoint 2013, when its current SQL server database instance is corrupt? Explanation; ->Sharepoint 2013 server lost all the ...
1
vote
0answers
212 views

Error while creating external content type using SharePoint Designer 2013 against a SQL server 2012 Table

I am trying to create a external content type for my SharePoint 2013 environment using SharePoint designer 2013. The content type will be against a SQL Server 2012 table. The SQL instance is the same ...