Questions tagged [sql-server-2012]

Add this tag, when your issue pertains to SQL Server 2012 or an error occurred in SQL server 2012.

Filter by
Sorted by
Tagged with
1
vote
1answer
169 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
1k 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
1answer
1k 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
970 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
1k 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. ...
2
votes
1answer
484 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
34 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
1k 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
118 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
3answers
16k 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
2k 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?
2
votes
2answers
3k 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
518 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, Version=...
0
votes
1answer
1k 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
248 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 ...
2
votes
0answers
406 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
96 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 ...
1
vote
1answer
930 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
481 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
2k 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 ...
1
vote
2answers
2k views

How to update to Sharepoint 2013 SP1 and SQL Server SP2

I have, on my developer machine, a SharePoint 2013 with SQL Server 2012(Sp1 + CU6), mainly I focus on BI features. How to upgrade SharePoint to SP1 and SQL Server to SP2? Which Service pack should ...
1
vote
1answer
3k 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 ...
1
vote
1answer
2k 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
127 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
3answers
230 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 ...
1
vote
1answer
1k 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?
2
votes
1answer
4k 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 ...
1
vote
0answers
1k views

Sandbox Solutions on a SharePoint VM that also acts as a Domain Controller

I have dozens of 'Microsoft SharePoint Foundation Sandboxed Code Execution Worker Process Proxy' processes running. A new one seems to appear every 10-15 seconds until my memory is completely spent. ...
8
votes
1answer
2k views

The UPDATE permission was denied on the object 'AllListsAux', database 'spContent', schema 'dbo'

Insufficient SQL database permissions for user 'Name: NT AUTHORITY\IUSR SID: S-1-5-17 ImpersonationLevel: Impersonation' in database 'spContent' on SQL Server instance '###' The UPDATE permission ...
0
votes
1answer
529 views

addcontentdb command missed something

So I have built a new sql 2012 server and SharePoint 2013 server. I have added the new SharePoint server to the farm and made it the default central admin site. I have moved all the content ...
0
votes
1answer
1k views

Custom message for those who don't have access

How can I provide a custom message to a user who doesn't have access to a folder in Microsoft Online SharePoint? Appreciation in advance.
3
votes
4answers
1k views

Should we install SP2013 on Server 2012 R2

This is a doublon of this post. But since this post was answered, windows server 2012 R2 was released, and SP2013 SP1 (re)release. We are about to set up a new SP environment for intra/extra net. ...
0
votes
2answers
149 views

Migrate sharepoint database from SQL Server 2012 R2 evaluation to SQL Server 2012 Standard

My sharepoint is using SQL Server 2012 R2 Express as a database Server, and I already have reached the limit of 10GB. However I have a SQL Server 2012 Standard with proper license. Would it be ...
0
votes
1answer
83 views

Apply SQL Server CU on the SharePoint database instance?

I'm aware that meddling with SharePoint databases is a big-no. Is applying SQL Server cumulative updates to the SharePoint database instance (where sharepoint_config, content and service databases ...
4
votes
1answer
8k views

Limits of Running of SQL express for SharePoint 2013

What are some of the major limitations of using SQL 2012 Express with SharePoint server 2013, is there any Sharepoint 2013's functionnality or service that doesn't running in using Sql Express and ...
2
votes
2answers
1k views

SharePoint Document Library Subscription Errors

I have SSRS 2012 setup in SharePoint Integrated mode. I am receiving the following error when trying to setup a subscription to a SharePoint Document Library. A delivery error has occurred. ---> ...
0
votes
1answer
543 views

How can I install `SQL Server PowerPivot For SharePoint` for `SharePoint 2013`?

I have SharePoint 2013 and SQL Servere 2012 SP1 in my serever. I want install SQL Server PowerPivot For Sharepoint. I run SetUp of SQL Server 2012 SP1 and in Setup Role I Select SQL Server ...
0
votes
1answer
1k views

Error while deleting list item 0x80131904

We are getting below error on production server,on development and test server its working fine.There is Application page to fill employee goals for appraisal,when user tries to save in draft they are ...
1
vote
1answer
65 views

how to install sql server cluster between two servers windows 2012 without external storage

Can anyone please help me on installing sql server 2012 on cluster mode between two servers running windows 2012 server without external storage? I will use the sql for sharepoint 2013 installation ...
3
votes
3answers
156 views

Should “BI Center Site” be used for any areas that will include a mixture of data content

We have a SP farm set up and it is in it's infancy. Our department is BI. There are 10 products within our company, each with different management and BI needs, therefore we'd like to create a site ...
2
votes
1answer
46 views

Copy of Test Phase to Production Phase

If you have two phase, test and production phase and test phase has a database with 40 table + 55 views + all cubes from analysis service. The production phase is a reflection of test phase. Is it ...
6
votes
1answer
10k views

SharePoint showing different time zone

I have created a SharePoint application which has a specific time zone. The Windows server where SQL Server and SharePoint are installed are using same time zone. When I create a new item in list in ...
5
votes
2answers
8k views

What are the risks of changing SharePoint_Config db recovery model to Simple?

My SharePoint_Config database log file grows to the extent that it reserves very much disk space for seemingly no good reason. In my development environment I changed its recovery model to simple to ...
0
votes
1answer
1k views

Unable to view SQL RS Services on Server or add new SQL Service Application

I have the following SharePoint 2010 Environment: 2 - WFE 3 - SharePoint Application Servers 1 - SharePoint Database Server with 2008R2 One of the Application Servers has SQL2012 SP1 installed ...
0
votes
1answer
148 views

Sharepoint 2010 and SQL server 2012 in separate servers, need to use powerview

I am trying to setup a reporting environment and would like to use powerview features. Can someone let me know if this will work? Install sharepoint 2010 in a separate web server Install SQL server ...
0
votes
1answer
147 views

Reinstalling SQL Server where SP Config Database resides

My SharePoint Farm is a stand-alone farm and I want to reinstall the SQL Server. Will SharePoint exist after uninstalling SQL Server? Because the config database resides in this SQL Server and I ...
2
votes
2answers
7k views

How to change Native Mode to SharePoint Integrated Mode in SQL Server 2012

I have installed SQL Server 2012 in Native Mode. How can I change it to SharePoint Integrated Mode? In the Reporting Service Configuration Manager Tool I found that there is no option to change Native ...
1
vote
1answer
1k views

What benefits do I get by upgrading to SQL Server 2012 Enterprise?

With SharePoint Server 2010 Enterprise edition, what additional benefits do I get using SQL Server 2012 Enterprise edition as opposed to SQL Server 2008 R2 Enterprise edition?

1
2