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
1answer
30 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. ...
0
votes
0answers
13 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 2014 is not a supported combination, but not ...
1
vote
1answer
19 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 ...
0
votes
0answers
11 views

Blocking the standard SQL Server ports and installing share point 2013 for Internet sites is good idea?

We have plan to deploy our organization internet portal , -our all sharepoint 2013 and SQL SERVER s are in DMZ zone for sql server security i am following Configure SQL Server security for ...
0
votes
0answers
38 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
19 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 ...
2
votes
2answers
80 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
34 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?
0
votes
2answers
20 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
0answers
15 views

Sharepoint Backup plan

Regarding the backups in SP. I know that there are a few important backups that we need to do, however what is the difference between the backup in Central Admin (farm) and SQL server backups. Isn’t ...
0
votes
1answer
26 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
38 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 ...
0
votes
0answers
20 views

Install the ADOMD.NET setup on SharePoint Database server

One question related to the PerformancePoint feature: If I install the ADOMD.NET 10 setup file on the SQL Server 2012 connected with our SharePoint 2013 farm... it will cause any error in the web ...
0
votes
0answers
12 views

Will enabling “Extended Protection for Authentication” on my SQL server, break anything with Sharepoint?

We did an AppDetective Scan on my SQL Server for my Farm, and we got a Medium level issue saying, The Extended Protection for Authentication is not enabled in the server. Description they give: ...
1
vote
1answer
53 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
48 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
20 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
60 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 ...
0
votes
0answers
82 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 ...
0
votes
0answers
78 views

SharePoint 2013 configuration Wizard - Step 3 Issue

I am trying to create a SharePoint Farm for production environment. DB and App servers are setup properly but when I add another computer into the Farm (as Web Front), during the configuration wizard ...
1
vote
1answer
446 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
215 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
538 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
435 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
47 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
67 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
193 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
954 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
461 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. ...
3
votes
0answers
489 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 was ...
0
votes
1answer
54 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
47 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
853 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
98 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
61 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 ...
2
votes
1answer
1k 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
453 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
341 views

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

I have Share Point 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
637 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
58 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
135 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
37 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 ...
3
votes
1answer
2k 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 ...
4
votes
2answers
3k 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
376 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
128 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
80 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
4k 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
930 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?