The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [database-connection]

A database connection is the means by which a database server and its client software communicate with each other.

Filter by
Sorted by
Tagged with
0
votes
0answers
20 views

Sharepoint, Access, Excel two way connected database

I am trying to create a Database system that uses an Access Database of which can be updated from Excel, The Users (Multiple), Access Database & Excel spreadsheet are all on a Sharepoint company ...
1
vote
3answers
36 views

Sharepoint databases structure

I need to know how the structure of databases of Sharepoint works, what is any databases, when they are created and this kind of stuff... I'm using a Sharepoint 2016 on premises.
0
votes
1answer
23 views

AppFabric ConnectionString not updated after change of Database Server Name

I have used the command: stsadm -o renameserver -oldservername <oldServerName> -newservername <newServerName> to rename my SQL Database Server. When I run Get-SPServer after a restart ...
0
votes
1answer
39 views

change db server

What is the safest way to change SharePoint 2013 on premise DB Server from one name to another - I have alredy migrated all dbs from the old to the new I just want Sharepoint to now point to the new ...
0
votes
1answer
35 views

Sync a Sharepoint list from GCP

Is it possible to create a Sharepoint that has APIs to synchronise the data with data stored on Google Cloud Platform? I would ideally like to implement an API to keep the data in the Sharepoint list ...
1
vote
1answer
65 views

How can I connect SQL DB to SharePoint List without Business Data Connectivity

I have a table in a sql database that I'd like to use to populate (and regularly update) a List in SharePoint. I'm the manager for the site with this List, but not the installation (which includes ...
2
votes
1answer
46 views

Share Point Foundation 2010 - Configuration Failed

We got a Share Point 2010 farm here on my company but we were victims of a ramsonware and lost a server. I was incubated of prepare a new VM and reinstall the SP (I never had any kind of contact with ...
1
vote
1answer
355 views

SQL database login for 'ConfigDB' on instance ' failed. + Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

I know my question is very similar to this one; SQL database login for 'Config' on instance '' failed. Additional error information from SQL Server is included below However in my ...
1
vote
0answers
141 views

Sharepoint Linked Table Problems when using Microsoft Access

So here is my situation. I have 2 sharepoint sites which I am currently a member of the "Owners" permission group: https://mysite.sharepoint.com/ (root site, so I would like to avoid putting ...
1
vote
0answers
136 views

What do I need to set up a Entity Framework 6 Database on Sharepoint 2013?

I'm new to Entity Framework and Sharepoint so bare with me. I'm currently making a website for my work where users would be able to store entry information of their contacts and tasks. These entries ...
3
votes
1answer
155 views

Users get System.Data.SqlClient.SqlException whenever update

It is SP2010 enterprise farm. It is a 2 sharepoint servers (both are wfe) and 1 SQL topology. Whenever a user perform a update action (e.g. approve a task, delete a file) will get a generic ...
0
votes
2answers
92 views

Problems with database connection - SharePoint 2010 test environment

we made a copy of our current SP 2010 environment to run as a Mockup in a separated network area. (we had this running before, but needed an upgrade to get a similar status as the productive farm). ...
0
votes
1answer
4k views

How to query external SQL Server databases and displays the result in SharePoint list

I am trying to connect to external SQL database and want to show up select query data in SharePoint list. I did create External Content Type but that doesn't allow me to use custom query for the table....
1
vote
1answer
330 views

Check if App.config is well configured

I want to connect to sql DB, and I have in my Sharepoint project an App.config (with properties : Build "None", Copy to Output directory"Copy always"), I added a reference to System.Configuration.dll (...
1
vote
0answers
45 views

App Config not working

I have a sharepoint code, where I use connection to sql database, when I use a string to connect it works, string connstr = "Data Source=CH-SQLD;Initial Catalog=LOGS;User ID=***;Password=***"; ...
1
vote
1answer
32 views

Custom web part db connection string randomly disappears SP 2013

I have a custom web part which has a db connection string. It works fine for a while after deploying but suddenly begins to don't show any data. When I edit the page via UI, I see that db connection ...
1
vote
1answer
804 views

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

I want to connect my application page with the sql server so that I can read the data from the SQL server. TO create the connection string I have used: string cnn = ConfigurationManager....
0
votes
1answer
99 views

create connection string in application page so as to connect with SQL server databse [closed]

I have a SharePoint 2013 application where I want to display some of the data from SQL table on my page. I have created a connection string which is: string cnn = ConfigurationManager....
0
votes
1answer
844 views

Reading connection string from Sharepoint Web.Config

What is the proper way of accessing database connections string stored in a SharePoint Web.Config? The following is my entry in the web.config. <add name="TestConnection" connectionString="Server=...
2
votes
1answer
755 views

Simple Question - Is it possible to Edit SQL Tables from SharePoint form

The title about says it all. I've developed in Access for 20+ years. I've held off learning SharePoint because everything I've read seems to indicate restrictions on true data management. So... here ...
0
votes
1answer
681 views

Changing SharePoint Database and File location!

I create a SharePoint 2013 environment with SQL 2012. Issue is that SQL is installed on the OS driver (C drive). Now we want to move the location of SQL database and Log File from OS drive to Other ...
0
votes
1answer
49 views

WebPart/General Database access performance best practice

I'm looking for a way to improve my to access the database from WebParts. Right now, each and every single time i need to get/set some data from the database (either with linq or with System.Data....
0
votes
1answer
927 views

One of the Application server can not connect to DB server

We have a SharePoint 2013 Farm with 4 Application serves, 4 Web Front End Servers and 5 DB servers. Everything was running fine. Few days back we identified that the App-server on which Search was ...
0
votes
2answers
4k views

Using SQL Alias to change Database Server name for SP2013 Farm

I need a temporary workaround, I have a farm SharePoint configured and running, it's pointing to DNS name of a Database Server, let's say server01.domain.com. I need the farm to point temporarily to ...
0
votes
1answer
119 views

Creating a list-backed SQL Server database without using External Content Types

I'm trying to develop a list backed by a SQL Server database running on AWS in Sharepoint 2010 (also running on AWS), but I'm running into issues regarding authentication to the database. The only ...
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 ...
0
votes
0answers
34 views

Sharepoint with external database

We have a Sharepoint application which uses external database besides content database.we have stored connection string in a list to connect to that external database. everything works fine in a ...
0
votes
1answer
42 views

How to use data you've just filled before submitting it in an infopath form?

I have an infopath form binded with a list. In this infopath form there are several fields to fill. When the user press the submit button, I want the view to change if the values of the fields the ...
1
vote
1answer
6k views

SharePoint Designer SQL Server Connections, Connection Strings

Forgive me as I am new to SP Dev. I have a DB server that I use RDP to connect to via VPN from a local laptop. I know the name of the DB server. The DB (SQL Server 2008) is set up to use Windows ...
0
votes
2answers
52 views

Establish ConnectionString using a list as a source

I have a field named "classes". I need to fetch data from the database and bind it to the classes field. But the requirement is, instead of using connection string directly I need to store the ...
1
vote
1answer
1k views

SharePoint 2013 app connected to PostgreSQL

I want to create an app for SharePoint 2013 (Foundation so far, soon to be paid version). I would love to include SP lists filled with data from sql query to PostgreSQL. Sounds easy, right? I am ...
0
votes
1answer
286 views

Business Connectivity Services vs. ADO.NET

Why should I prefer Business Connectivity Services (BCS) over plain ADO.NET, if all I want are simple CRUD operations on an external database (e.g. remote Oracle Database), which are made from a ...
3
votes
3answers
415 views

Where to store dynamic connection string in provider-hosted app?

I have a Sharepoint 2013 provider-hosted app that gets installed (along with a custom WCF Sharepoint-hosted service) using a powershell script. This script also creates a SQL Server database that the ...
0
votes
3answers
5k views

display data in SharePoint 2013 through ODBC

We are two students doing our internship (meaning we work with SharePoint 2013) in a company where they are already using SharePoint 2007, they want to implement what they have in SP2007 into SP2013. ...
1
vote
0answers
3k views

Access keeps losing connection to Sharepoint list

I'm setting up an Access 2010 database to have a table that is linked to a Sharepoint list, and I'm experiencing connectivity problems. Whenever I edit a record in the linked table, and then press ...
2
votes
0answers
325 views

How do I change SQL connection from one server to another on an an External list

I have an external list that points to SQL Server A. Server A is being de-commission and the database is moving to SQL Server B. I need to change my connection for my lists. I created a new ...
1
vote
1answer
1k views

Accessing Entity Framework from Timer Job: connection string problem

I had a DB that normally I access from my SharePoint (2010) custom feature by Entity Framework. The connection string is stored in the web.config. If I do something like that from outside TimerJob: ...
3
votes
1answer
2k views

InfoPath Form Works Under Admin Account But Not Under Regular User

An InfoPath browser enabled form that has udcx connections from a connection library, code in C# and some rules, was created and tested on the SharePoint server and functions more or less as designed ...
2
votes
1answer
3k views

Service accounts for database connection

We have a SharePoint web application with multiple site collections under that. We have built a new site which will be hosted under the same web application but in a new site collection. It has some ...
1
vote
1answer
2k views

SharePoint 2010 - Force to use non-1433 SQL Port

In my farm, I was using the standard 1433 port for SharePoint to communicate with SQL. Our project lead came down with the order to change the SQL port to a non-standard port from 1433. I went ...
1
vote
3answers
16k views

Moving the Sharepoint 2010 configuration Database to a new DB server..?

We were using the database server "OldDBServer" and have copied all the databases on the new database server "NewDBServer". Now, all the reference (like CA admin content DB, content DBs & Service ...
0
votes
1answer
916 views

Connecting to Access Database with Sharepoint

i'm trying to connect to an Access Database which is located on the desktop's server. I tried this : DatabaseAcces dbSAP = new DatabaseAcces(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\...
0
votes
2answers
3k views

Cannot connect to the configuration database

I don't really know what to do. I was trying to get some bcs working, and because they were not, I've decided to restart the server. After it restarted I was unable to go on any site / page or on the ...
0
votes
2answers
496 views

How can I pass an argument to a FeatureReceiver during solution setup?

I have this Sharepoint 2010 solution containing 3 projects: Class Library with Model classes Class Library with LINQ to SQL data context Sharepoint 2010 project WCF REST service 3 Visual web parts 1 ...
1
vote
1answer
3k views

PerformancePoint 2010: Could not add an Analysis Service Data source in the Dashboard Designer

Environment: SharePoint 2010 on Windows 2008 R2 Standard + SQL Server 2008 R2, Dashboard Designer I was successfully able to add a standard SQL Table as a data source and create a Scorecard Dashboard ...
2
votes
1answer
2k views

Looking up a value in SQL to set a value on the InfoPath Form

Looking up a value in SQL to set a value on the InfoPath Form. I have a data connection setup in my form. If I use this connection alone, in a control by itself, it pulls in data from my SQL server. ...
5
votes
4answers
8k views

DB Planning: SQL Alias or CNAME Record?

When planning connectivity with the Database Tier, it's wise not to hard-code any specific database info into the SP client connection. I've gotten many recommendations to use SQL Alias on the client ...
1
vote
2answers
2k views

How to Bind Data to Traditional ASP.NET Controls in SharePoint Foundation 2010?

First off, my background is ASP.NET Web Forms. I'm sure this is very simple but I'm quite new to SharePoint. We're running SP Foundation 2010. I'm going to build a WebPart in VS.NET 2010 and deploy ...
0
votes
1answer
2k views

how can i get Web Analytics database name with Object Model?

First let me say, that all of we doing in sharepoint is base on the object model, so i can go to Central Administration and get my "Web Analytics Service Application" Database Name and Server Name, ...
2
votes
3answers
3k views

How to have settings per web part instance

We have developed a Sharepoint 2010 Visual Web Part. This web part adds some extra functionality to Sharepoint but depends on a custom database we've created to index some stuff in a scheduled job. ...