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

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

SQL Server database permission problem in SharePoint 2007

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

Hi All,

I created few users from "Computer Management" --> "Local Users and Groups" --> "Users" --> "New User" as my login user in SharePoint 2007

Then I having a custom page where store the data into SQL Server Database.

below is how my connectionstring look like:

<add name="XXConnectionString" connectonString="Data Source=XXX;Initial Catalog=YYY;Integrated Security=True" providerName="System.Data.SqlClient"/>

however I hit error when browse to the custom page by the users.


Cannot open database "XXX" requested by the login. The login failed. 

Login failed for user 'xx\user1'.   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) 

It was fine if I login as System Account.
Can anyone help me in this? thank you in advance.

View Complete Post

More Related Resource Links

Sharepoint 2003 + Windows Terminal Server 2008 + Office 2007 problem?

Hi, We have a customer where some users runs Windows Terminal Server 2008 with Office 2007. They open documents from a Sharepoint 2003 site. When they open an excel sheet they get a button in the document which says "Server workbook: Click edit workbook to edit this workbook" and there is a button: "edit workbook" The users clicks "edit workbook" but get an error message saying there is no connection to the server.  They are able to edit the document, but not save it back to the sharepoint site. Most other users work on their local computer with Office 2003. Here, everything works fine and there are no button/message stating its a server workbook.   Is this caused due to some compatability issues between Sharepoint 2003 and Office 2007?   Best regards, Thomas Hansen ErgoGroup AS

Problem create a web application on SharePoint 2007 (Project Server 2007)

I installed a Project Server 2007 in a 3 server structure (all Win 2003 sp2; one for App server hosting Central Admin, Project Server service & Search service; one for web server; one for database server).  They are only in the same domain and I use the same network account for the installation as well as the WSS service account.  The same network are local admin for those 3 servers. All installation & patches seem ok (at least I don't get error messages) until I attempt to create my first Web Application.  After I filled out the web appliction and try to click OK, the page does not change and i saw the java error at the right bottom corner from my IE browser (version 6). The message is .... Line: 1686 Char: 1 Error: 'WebForm_PostBackOptions' is undefined Code: 0 URL: http://myservername:28804/_admin/extendvs.aspx On my SP log, below are the portion of the log when the error happen. 09/09/2010 12:28:29  1  INF        Entering function UserInterface.ShowCentralAdmin 09/09/2010 12:28:29  1  INF          The show central admin command has been chosen 09/09/2010 12:28:29  1  INF          Searching for registry key Software\Microsoft\Shared Tools\Web Server Extensions\12.0\WSS\CentralAdministrati

Problem configuring SSRS 2008 with sharepoint 2007 on Windows server 2008

Hi All - I am unable to integrate SSRS 2008 with sharepoint 2007. I am new to this part please correct em if am wrong. I have 2 servers one for SQL and one for MOSS MOSS server. Windows server 2008 MOSS 2007 .Net 2008 with basic sql 2005 which comes default WSP builder Everything is working fine SQL server: Windows Server 2008 SQl server 2008 and configured SSRS BIDS. When I am trying to install SSRS plugin for MOSS it is not accepting on both the machines. Please help me if am missing something here. I configured sucessfully on one server but havent done on multi server environment. please help me.   Thanks Saritha    saritha k

Sharepoint Server 2007 Document Library permission question


Is there a way to set permissions on document library where HR can see all documents but employees can only see the documents that they uploaded?

I am trying to configure permission level but can't find anything that will solve the purpose.

HR is hoping to do online enrollment and remove paper format.

unable to save data in SQL Server database through Sharepoint 2007


Hi All,

I have created dummy database, Table in SQL Server 2005 with some values.
Iam able to pull data from the SQL database to sharepoint dataview webpart through data connection using sharepoint desigher.

Now i have to enter new record in to SQL table through sharepoint. i have checked with sharepoint designer but unable get it done.

Can some one have idea on this. Please help me to get it done

Thanks in Advance.

Database server migration - renaming database server in SharePoint 2007


We are migrating our SharePoint databases to a new database server.  This new database server will have a new name for SharePoint to reference.  How do I go about pointing SharePoint 2007 from the old database server name to the new name?

It seems like there should be a simple solution, but I have yet to find a solid procedure.

Thank you,

- Tom


SharePoint Server 2007 Database


Hi Guys,

I'm done with the installation of our new SharePoint Server 2007 but i was not able to find its config database. Can you please help me locate it? We are running SQL Server 2005.

Best Regards,

Albie Bokingkito
Systems Administrator

How to Backup Single Server (Database on same server )Extra-net SharePoint Site MOSS 2007 SP1? and H



I have to create Test Server (Single server with Database on Same Server).

What Kind of Backup should i be asking  to Hosting Company,SharePoint MOSS 2007 SP1 Extra net site Hosted by 3rd Party.

How to restore it to Test Server and Has any one documented this process and has anyone had sucess in doing similar work ?

I do not have any access to Production server.How to make sure i have same server setup & configuration as Production Server.


I have to customize this site and do some development work so i thought this would be best approach ?


Please let me know..thanks..



Sharepoint 2007 Email problem


I've used Sharepoint 2007 to create my website. Within my web pages I've included Forms in order to capture people's contact details, so that when they 'Submit' the form their details are emailed to my email account. The problem is that when I go to Form Properties and insert the email address to which I want the data sent, I receive this message: "This form cannot be configured to send results via email. The web site may be based at a disk-based location, or a location that has not been configured to send email. Contact your system admin or ISP for more info. Would you like to remove the email recipient Yes or No"   

I am satisfied that the settings within the webhosting service are correct. Is this functionality available with Sharepoint 2007 or do I need to switch to alternative software.



Problem when installing Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint


I have configured the SharePoint Production Server(Standalone) with WS 2008 64 bit version, SQL Server 2005 with SP3 , Visual Studio 2008 and MOSS 2007(SP3). I have configured SSRS 2005 in SharePoint integration mode. Everything works fine till the last step. Now, i am trying to install Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies feature and failed. I am getting below error message.

Product: Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies -- You must first install SharePoint Server before installing SQL Server 2005 Reporting Services Add-in for SharePoint Technologies

Any help will be very appreciated!


sharepoint 2007 permission


Hi all
1- when i create group in shrepoint 2007 i ned to determine permission for this group like users of this group have permission for specific folders and when any user login from this group the configuration of welcome page is differ
like new links appeare other not ....

2-The customer can ask to be notified when new information is updated

3- user can place files in specific folders by emailing them to specific addresses


Deploying custom Web Parts on SharePoint 2007 production server

I would like to develop a custom SharePoint 2007 Web Part for a client. Currently I'm using Visual Studio to deploy my solution to a test environment (since it's a SharePoint Project I choose just Build -> Deploy from the menu). What are the appropriate steps to deploy it to the production server?

I'd like keep it simple and safe (i.e. use the principle of least privilege). Therefore (if possible) avoid using stsadm, achieve this through web interface, or avoid using administrative rights.

Also, can I specify the scope of my Web Part, i.e. choose on which Web Application or Site Collection will it be installed?

sharepoint 2007 server needs to be restarted twice a day???



our sharepoint server needs to be restarted twice a day now - always around 9.30am and 14.30pm.  this has only started in the last 2 weeks.  its working along fine then all of a sudden it goes to a dead page.

i have spent the last week trying to identify what it is.  i have set the logging to verbose and put plenty of the messages in there into google but can not see anything relevant.  the event viewer shows nothing.

i have sp2 installed but no cumalitve updates.  i am wary of installing these at the mo and wreaking the whole thing.  if noone has any suggestions ill install them.  ill list soem details about the problem below. 

it doesnt happen on weekends so it must have something to do with users using the system so im thinking something to do with the database (SQL Server 2000).  NB users dont use our sp2007 on weekends. 
if i restart iis, the layout of the page comes back but some of the webparts are dead so that doesnt work. 
if i resart sql server, that doesnt work either. 
there is plenty of room on drives and the task manager is at 20-30% when i check it when the site is down.
only a server resart seems to work.

there are just so many messages in the sp logs that i cant identify what it could be.  is there any other loggi

Problem accessing Sharepoint 2007 MySite


My users are having an issue accessing their mysites.  When they go to the main portal page or any other site and click the link at the top right of the page to go to their Mysite they are thrown into an endless authentication loop.  If they cancel out of the loop the URL in the address bar is for http://mossserver/_layouts/MySites.aspx

For a user to successfully get to their myself they need to enter the full url like http://mossserver/personal/username/default.aspx

Now, I know somewhat how this happened.  It resulted from me trying to delete a user's mysite and I apparently did it wrong but I'm not sure what I did.  It almost seems like I deleted a redirect page or something...

Looking for any ideas.



Sharepoint 2007 View Problem

I have a document library in Sharepoint 2007 in which I have seet up a number of different views so that the users who work with the information in that library can filter down to the specific area that they work with.  The view itself works great, and they are able to see their data quite easily.  The problem comes when they actually go in and edit any of the items.  Unlike most software in the civilized world for the past 30 years, the user is not returned to the view that they were working with, but to the defult view.  This means that any task where they are required to do many edits at a time becomes a frustrating nightmare and waste of time.  Is there any setting I can change, or anything else at all that I can do to give my users a little relief by making the site navigation such that they are returned after an edit to the same view that they were in before the edit?  Ideally, it would be nice if the same scroll position within the view were returned as well, but I suspect that I may be asking for too much by pushing that issue.  HELP! HELP!  Any and all constructive assistance is appreciated.

OpenSearch Descriptor File Generator for SharePoint Server 2007 Sites

Learn about the OpenSearch Location Builder Tool, which you can use to create an OpenSearch Description (.osdx) file to connect SharePoint Server 2007 sites to the Windows Client via the OpenSearch protocol.

OpenSearch Location Builder Tool for SharePoint Server 2007

Download the tool and start using it to create an OpenSearch Description (.osdx) file to connect SharePoint Server 2007 sites to the Windows Client via the OpenSearch protocol.
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