0
votes
1answer
71 views

how to work with form based authentication in SharePoint 2010 three tier architecture?

I am working on SharePoint2010 site created on three tier architecture. I want to use the form based authentication method. I have prepared the form based authentication on web application but ...
0
votes
1answer
309 views

Event Receiver Item Added for Multiple Files uploaded

I am trying to add few details for a item that is added to a list to SQL database table using a stored procedure, it works perfectly but when I upload multiple files it adds all of the items into the ...
0
votes
0answers
342 views

Passing parameters to stored procedure in data view web part

I have a stored procedure which accepts 2 parameters. The stored proc is executed as EXEC MySP N'Val1, Val2', N'A,B,C' I inserted a Data View Web-Part and tried to get data from stored procedure. ...
8
votes
5answers
229 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 ...
1
vote
1answer
865 views

Mysterious Error 3355 - SQL machine not available every day at the same time

One my users reports that he cannot access our Sharepoint MOSS 2007 installation at midnight each night. I look in the Event Viewer and every day this error appears at 12:25:20 am: I'm confused by ...
0
votes
3answers
1k views

Dataview Web part and SQL - Way to use trusted connection?

As I'm sure you're already aware one of the biggest weaknesses of the data view web part is that it exposes connection strings for SQL Server connections. Instead of using a web service to pass my ...
0
votes
1answer
98 views

Problems faced for a VPC

UPDATE : Original question was solved by giving proper authentication method to the current user in IIS. Would like to change my question like this: When I browse my site I am getting following ...
1
vote
0answers
124 views

Dataview Web Part only works when pulling 110 lines or less of SQL

I recently started playing with the data view web part in SharePoint Designer. I've added a new data source and added a custom query. Unfortunately my queries appear to be limited to returning 110 ...
1
vote
2answers
461 views

Update a list via SQL with MOSS2007?

How can I go about applying an update statement to a on MOSS2007 deployment? Essentially I'd like to write something similar to the following across it: update <list_name> set ...
0
votes
1answer
88 views

Always Sync Form Library Columns data with SQL Server 2008

How do I set a "always-sync" connection between a Form Library and a Database (in SQL server 2008)? Scenario: I have a Form library that use InfoPath form. In the form library, there are multiple ...
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 ...
1
vote
1answer
472 views

SharePoint Dropdown Vaue not updating in to Dataview webpart with SQL backend

I have a data view webpart and its source is a sql server database table(2005). I have the data view setup to be able to edit some of the fields inside the dataview. Instead of providing the user ...
1
vote
1answer
552 views

MOSS 2007 SP2 DB index maintanance

I've read in the "About Service Pack 2 for SharePoint Products and Technologies" paper that SP2 includes an update for the Update Statistics Timer Job that causes SharePoint to run SQL Server's online ...
0
votes
2answers
493 views

Trimming audit events

We'd enabled all types of audit events for our production web-application and ended up with an issue with DB as auditData table grown to 50GB. Now, we want to reduce the size of the AuditData table. ...
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 ...
2
votes
2answers
621 views

(De)Commission SharePoint Database Servers

In our SharePoint Farm, We are running with 2 Database Servers and on which we have 20+ Databases.Now, due to some issues we would like to decommission the existing database servers and commission 2 ...
2
votes
1answer
439 views

Why does Reporting Services in SharePoint integration mode require a minimal install of SharePoint?

I have a two machine set-up, with MOSS 2007 installed on one server (Machine A), and SQL Server 2008 installed on the other (Machine B). In order to run SS Reporting Services in SharePoint ...
7
votes
5answers
5k views

SQL Server 2005 vs SQL Server 2008 on SharePoint 2010

I'm writing a recommendation for an upgrade scenario from SharePoint 2007 to SP2010. Customer is currently running x64 SQL Server 2005 SP3 on Windows 2003 Server. Does anyone have pros/cons for ...