.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Restrict access to SharePoint 2007 test farm

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :C#

Hello all,

I feel like this should be simple and hopefully I'm over looking something.  We have our production SharePoint 2007 environment.  We also have a test farm.  There have been several occasions where I've needed to copy a production content database over to the test farm.  Is there an easy way to deny access to the test farm?  I don't want users accidentally logging into the test farm and updating content not realizing it's test.  We've had this happen on occasion and depending upon how much content they update, it can make moving that content to prod difficult.  Unfortunately, it's not possible to simply restrict by IP.  I basically want to deny all users except for domain admins and possibly our designers.


View Complete Post

More Related Resource Links

SharePoint 2007 Access Error


Hi everybody!

I´d like to verify if somebody see this scenario:

* I create a site, using te meeting site template;

* I give Full Control access to an user;

* When this user try to upload an item in a library, in this site, it was showed the message "Acces Denied".

* If the user press "back" in the Internet Explorer tool bar and press "F5" to refresh, the file is there.

* The same problem is ocurring, when he try to create a meeting.

Somebody ever see this error!?

Thanks a lot


FeatureInfo... Failed SiteOrphan... Failed in SharePoint 2007 SP2 migration test


Hi All,

I've just execute the C:\>stsadm -o preupgradecheck command to check my upgrade / migration process, however it come back with the following two error: 
FeatureInfo... Failed 
SiteOrphan... Failed

how shall i proceed with the migration then ?

all of the other result seems to be fine so far.


C:\>stsadm -o preupgradecheck  

Administrator and Developer Guide to Code Access Security in SharePoint Server 2007

Explore configuration options, get best practices for managing CAS in SharePoint environments, and walk through a complex CAS scenario.

SharePoint 2007 Expiration Policy Not working : Access denied for the site


I have a SharePoint 2007 List with Expiration Enabled in Information and Policy Management. I have a datatime column ExpiryDate which i used in Expiration. On Expiration I have chose to delete the item. Through Central Admin I run the expiration by clicking "Process Expired Items now" button. I got the following error in the Windows event viewer.

Expiration Service for site http://md-rmanimaran failed.

Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

EventID: 5016

Category: Information Policy Management 

Where I need to specify the login details to get rid of this error? Anybody Please help..




SharePoint 2007 to Access 2007 - Issues grouping by "Person or Group" field type/column

We are on SharePoint 2007 and using Access 2007.  The SharePoint list contains a column called Assigned Person, column type: Person or Group, single selection, displaying only the name 1) When we Open with Access and Export a copy of the data, then create a report from that table, we do not have the option to group on Assigned Person.  2) When we Open with Access and Link to data on the SharePoint site, then create a report from that list, when we group by Assigned Person... The same person has 2 groups - there are is no other grouping or sorts on the list, and i can't locate a correlation to another field to show why they would have to collections for the same person The Person or Group column sorts "from smallest to largest" as though it is a number field. The list is a task/activity tracking system we created custom for our needs.  We want to pull a weekly report, grouped by Assigned Person, but cannot get access to work.  We do not want to resort to anything more complex, as it takes a much longer process to have reports pulled by Chrystal or one of those types of applications.  And we cannot change out the field for something like a Choice column as the list already has a very large amount of content.  Can anyone assist? Is there a setting hiding somewhere that is causing the problem? 

How to link SharePoint List with MS Access 2007 programmatically

Hi, can anybody tell me how to link SharePoint List with MS Access 2007 without opening Access environment. I want to do it programmatically through C#/VB.net doesn't matter. Your help will very much appreciated. Thank you so much! -Jarexs

Link Access 2007 to SharePoint 2007 Survey

So here is my problemo. I am trying to organize site requests into a system that will let us easially see what requests have come in and who are the particular owners or users associated with the requests. Currently we use a SharePoint 2007 Survey to collect all the requests. I was hoping to upgrade things by linking the Survey list to an Access 2007 db so we can manage the data better. However, whenever I attempt to link the Access DB to a SharePoint list, none of the survey lists show up. I was wondering if there was a way to make it so whenever someone completes a survey, it updates the Access DB. I have figured out a way to get this to work with InfoPath but I would rather use the surveys that already exist. Thank you, Jeb G.

Access Denied while using Sharepoint designer 2007 to create a work flow

I am using Sharepoint Designer 2007 to create a work flow that sends emails to different people in a group depending on status of a record. For example, when some one reports a problem, an email is posted to concerned person and as soon as he/she checks the problem and updates the status an email is sent to next department and so on. Starting the work flow creation wizard is no problem but as soon as I press 'Finish' to create workflow I get 'Access Denied' message box. Any Ideas? I am using WSS 3.0 on 2003 Server.

Edit in Datasheet view does not work on one SharePoint 2007 farm, works on another.

The ability to edit in datasheet view on one of our environments no longer works.  I've tried different client machines on different builds and regardless of the install every library, list, etc. when attempting to edit in datasheet view shows as read only.  Our other environments those systems work as intended with those same clients. I've searched all over and haven't found anything that helped.  Any ideas?

SharePoint 2007 to 2010 Upgrade AND Farm Merge


Hello all,

I'm curious to see if anyone has done this.  Currently, my environment has 3 seperate SharePoint 2007 server farms.  I'm currently evaluating SharePoint 2010 and so far like what I see.  I'm wondering though what would be the steps I would need to go through to actually upgrade and then merge them all to one SharePoint 2010 farm?  The steps I can think of are the following:

1. Make sure all 2007 farms are on the lastest (or at least similar) version

2. Upgrade each farm to SharePoint 2010

3. Create new 2010 farm

4. Copy upgraded farms' site collections to NEW 2010 farm.

OR can I do this:

1. Make sure all 2007 farms are on the same version

2. Create a copy of each current SharePoint 2007 site collection that I want

3. Create NEW 2007 Farm

4. Copy content to new farm

5. Upgrade new farm to 2010


Any and all help would be greatly appreciated, thanks!


External Sharepoint 2007 Personal Site Access



I would like to have our current Sharepoint 2007 Personal Sites accessible externally to the end users via https and forms based authentication.

Can anyone advise the steps/best way to achieve this?






can i access sharepoint 2007 'Document Library' items into WPF directly. or iwant to use any WCF o


please suggest me.

and give the proper coading..

thanks for any help

How can I access my sharepoint 2007 website from another machine ?


Hi all,

At the moment i cannot connect sharepoint 2007 server from other machine. Basically Sharepoint 2007 server is up and running an my virtual machine.It works well and I can access it very well from my virtual machine. However i cannot access this sharepoint site from my base machine.

When i enter the address http://moss.mysite.com/Docs/default.aspx it showed this error :

"Internet Explorer cannot display the webpage"

The same address would work in my virtual machine.

What configuration needs to be made for this server to be available to everybody ?


Furthermore i can access other applications of the virtual machine.

For example i can access the K2 workspace from my base machine. The K2 workspace is located in the same virtual machine as the one

for sharepoint.


What could be the issue here ?


How to add a Database Connection on Sharepoint Designer 2007 to access SQL 2005 tables?


I've tried and looked on many sites with different solutions for which non of them resolved my issue. I've a blank Sharepoint site and want to view data from an SQL DB. It says that a Server Error occurred and that the Data Retrieval Service didn't worked out while listing the DB's.

I tried using the 3 methods... using the also the connection string in different ways... when I do it using VB, Office and Java... I can see the data from that DB... why on Sharepoint Designer it doesn't? It supposed to be more easier than other tools.

I'm really desperate. Any help is very welcome.



Granting external non-domain users SharePoint 2007 access?

Hello all,

As you can well surmise, I've installed SharePoint 2007 on a server and require assistance. We have two sites. The primary site is for internal use only and the other site, a sub-site, is for communications and collaboration with select colleague organizations who are not members of our domain. How can I add these users to allow them access to this sub-site without giving them user accounts in our domain?

What I have done so far is enable SSO and add our users to have rights on the root site. That all works. I then created the sub-site. As a test from a thread I found, I added my GMail account username as a local user account on the SharePoint server. This did, indeed, allow me to add that user and give him rights to login, but I discovered that there is no way to modify the user's profile and, thusly, cannot specify an email address. What good is SharePoint is you can't get email notifications from it?

It then occured to me to create a new user group in the DC and create accounts for them there while at the same time limiting their access to only the SharePoint server and not have any local or remote login rights. Interestingly, the accounts will login after three tries, and then shows blank pages.

Anyway, what I need is to get these users in, have enough profile information that they can receive email from the server as neede

Cannot access SharePoint 2007 site after moving data to another AD domain



We are setting up a staging farm on a test domain. For this we took a copy of the data from production and attached them to staging. In the test domain I created user with same user name as in production but they cannot login. I tried making the user site admin still he cannot access. I hope there is a problem when we move sharepoint data between domains.

I ran the stsadm migrateuser comman with ignoresidhistory and it ran successfully, but still user get access denied message. Is there someway this can be fixed?

For example, we have 2 domains, prod and test. I setup SharePoint farm (same patch level as prod) in domain test and copied all my content databases and attached in test domain sharepoint. The system account in test domain is “test\spadmin”. Now only he can access the new site in test domain.

There was a user “user1” in prod domain and I created a similar user in test domain - “test\user1”. Even after giving him full control on the sites, he gets Access Denied error. I tried creating a new user in test domain that does not exist in prod domain, even he cannot access the site because of Access Denied exception. Is it a limitation of SharePoint that we cannot move data between domains.

PS: We are running MOSS 2007 Ent 64 bit SP1 and SQL Server 2005 SP3. We use NTLM authentication.


How to check (login Credentials) user name and password to access sharepoint server 2007 programmati

my issue is...

while user entered his/her Username:xyz
i need to check programmatically either username & password exists ot not in sharepoint server 2007 from windows form application.

and i know how to check username,but i don't know how to check password.

you can check username in below ways..

 SPSite SharepointSiteObj = new SPSite(SiteUrl);
 SPWeb SharepointWebObj = SharepointSiteObj.OpenWeb("/");

 SPUserToken token=SharepointWebObj.AllUsers[userName]

from this i can get user name..




ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend