Questions tagged [database-connection]
A database connection is the means by which a database server and its client software communicate with each other.
51
questions
0
votes
1
answer
1k
views
How do I set up relationships between items in different lists?
I'm working on an application which tracks and stores employee certifications and education levels.
As it stands, I have one SP list for the general employee info (Hire date, years of professional ...
- 1
1
vote
3
answers
414
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
1
answer
210
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 ...
- 301
0
votes
1
answer
212
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 ...
- 301
0
votes
1
answer
1k
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 ...
- 101
1
vote
1
answer
287
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 ...
- 113
2
votes
1
answer
54
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
1
answer
1k
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 ...
- 653
1
vote
0
answers
355
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 ...
- 11
1
vote
0
answers
176
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 ...
- 11
3
votes
1
answer
312
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 ...
- 4,065
0
votes
2
answers
187
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
1
answer
6k
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....
- 508
1
vote
1
answer
697
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 (...
- 303
1
vote
0
answers
53
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=***";
...
- 303
1
vote
1
answer
43
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
1
answer
1k
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....
- 886
0
votes
1
answer
126
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....
- 886
0
votes
1
answer
2k
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=...
- 11
1
vote
1
answer
2k
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 ...
- 11
0
votes
1
answer
924
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 ...
- 1,204
0
votes
1
answer
50
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....
- 3
0
votes
1
answer
1k
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 ...
- 901
0
votes
2
answers
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 ...
- 127
0
votes
1
answer
134
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 ...
- 101
0
votes
1
answer
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 ...
- 901
0
votes
0
answers
36
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 ...
- 3,364
0
votes
1
answer
49
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 ...
- 31
1
vote
1
answer
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 ...
- 13
0
votes
2
answers
59
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
1
answer
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 ...
- 111
0
votes
1
answer
294
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 ...
- 381
3
votes
3
answers
495
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 ...
- 761
0
votes
3
answers
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. ...
- 352
1
vote
0
answers
4k
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 ...
- 413
2
votes
0
answers
419
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 ...
- 59
1
vote
1
answer
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:
...
- 1,987
3
votes
1
answer
3k
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 ...
- 107
2
votes
1
answer
5k
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 ...
- 23
1
vote
1
answer
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 ...
- 346
1
vote
3
answers
17k
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 ...
- 2,548
0
votes
1
answer
1k
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:\\...
- 185
0
votes
2
answers
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 ...
- 185
0
votes
2
answers
502
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 ...
- 761
1
vote
1
answer
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 ...
- 141
2
votes
1
answer
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
4
answers
10k
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 ...
- 203
1
vote
2
answers
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 ...
- 243
0
votes
1
answer
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, ...
- 811
3
votes
3
answers
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.
...
- 761