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

learn more… | top users | synonyms

0
votes
2answers
18 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
22 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
17 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
14 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
15 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
23 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
33 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
178 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
20 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
38 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
22 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
37 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
49 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
25 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
16 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
89 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
42 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
22 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
36 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
45 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 ...
0
votes
1answer
44 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
33 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 ...
0
votes
0answers
120 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
87 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
309 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
222 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
311 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
83 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
26 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
361 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
66 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
4k 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
262 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
545 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
182 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
161 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
133 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
150 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
52 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
314 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
175 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 ...
1
vote
1answer
1k views

Unknown SQL Exception 18452 occurred

I am not sure if this is a SP problem or not. So I am posting here because the problem occurs to the SP server. Well, I have three servers: a Domain server, an SQL server and a server dedicated to ...
0
votes
2answers
754 views

How to update to Sharepoint 2013 SP1 and SQL Server SP2

I'm having on my developer machine, an SharePoint 2013 with SQL Server 2012(Sp1 + CU6), mainly I am focus on BI features. How to upgrade SharePoint to SP1 and SQL Server to SP2, which Service pack ...
1
vote
1answer
2k views

cant shrink a log file in an always on configuration

I have a sql server 2012 configured with always on replication, the WSS_Logging_log is about 400GB and SharePoint_Config_log is over 600GB and is slowing down performance and space is almost over. I ...
0
votes
1answer
1k views

Error configuring PowerPivot 2012 on SharePoint 2013. New-PowerPivotSystemServiceInstance - The PowerPivot System Service does not exist in the farm

Hi I'm hoping that someone can help me out here. I have a Multi-server dev farm that I am unable to provision PowerPivot correctly. It worked fine on the standalone farm. Any help would be ...
1
vote
0answers
90 views

Partial Search Returns no results for alphanumeric Items

The Search feature is indexed and running very well for foundation 2013. Using continuous crawl on SQL Server 2012 Standard. 2008R2 OS x64. I am having one issue. When the users are for searching for ...
0
votes
2answers
114 views

SharePoint SQL Server Databases are “Suspect” on every shutdown or reboot

I'll use this article: http://sharepointchips.com/recover-sharepoint-2013-databases-from-suspect-mode/ As a reference point. What is happening is as described in the article, my SharePoint 2013 SP1 ...
0
votes
1answer
468 views

SQL Server Developer edition and SharePoint

Can you use SQL Server Developer Edition with SharePoint 2013? Would each service account need a license? Has anyone done this before?
1
vote
1answer
2k views

Can I migrate Sharepoint 2010 databases from a SQL 2008R2 server to SQL 2012 server?

I'd like to migrate my SharePoint 2010 Foundation databases from a SQL 2008 R2 server (running on Windows Server 2008 R2) to a server running SQL 2012 (on a Windows Server 2012 box), and would like to ...