1
vote
1answer
301 views

Find a farm's database server and instance in PowerShell

Through PowerShell, how can I find the SQL server name AND instance where my databases are stored? Assuming I am not using an alias and can't check cliconfg. In servers in farm, I can see the server ...
1
vote
2answers
73 views

Best practice for taking SharePoint data and putting it into an SQL database?

I need to do some reporting across site collections. In order to do this I intend on writing a service layer that crawls SharePoint and puts information about document libraries and files into an SQL ...
1
vote
2answers
1k views

Workflows and SQL Server Databases

Is it possible to create a workflow that is started by activity in a SQL Server database that is outside of SharePoint? Using a WebPart to put and modify data in a database isn't a problem. ...
0
votes
2answers
371 views

Problem with connectivity and OWSTIMER.exe

Our stagging environment is on a single server with 3 virtual servers, Database Server K2 Workflow Server WebFrontEnd Server Now time to time I am getting this exception for a webpart in event ...
1
vote
2answers
428 views

Migrate Sharepoint 2007 to 2010

So right now there's a SharePoint 2007 site filled with data. I have to migrate EVERYTHING properly from the SharePoint 2007 site to a new server that has SharePoint 2010 and Windows Server 2008 ...
8
votes
5answers
269 views

Should I use lots of SharePoint Lists or a SQL Database to store the data for my new bespoke application?

I am working on a project to create a new bespoke intranet website for around 50 users. The data volumes are relatively small, but in order to model the data I need to store (about the 100 or so ...
0
votes
2answers
3k views

SSIS Import Sharepoint 2010 List to SQL Server

Is there a way to do this via code? How so? I simply want to import data from a list in SharePoint 2010 to a SQL 2005 or 2008 server. I know there are several 3rd party plug-ins that work, but I ...
4
votes
2answers
2k views

Execution of code as Application Pool account

Here is what I'm currently trying to do - 1.Create a new instance of a timer job from a web part 2.Add a new site collection to the current web application again from a web part Each time the code ...
2
votes
2answers
251 views

Database migration problem

We have recently migrated our MOSS databases from MS SQL Express 2005 to MS SQL 2008 both intances running on the same Windows 2003 server. After "successful" migration we switched the 2005 server ...