.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

Unattended Install leads to Single User Mode and Access Denied

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :

Hi everyone,

I'm trying to install SQL 2008R2 (full) with an answerfile.. in my answerfile I have specified a local group that should be SQLAdministrators.. in the log I see that the group is validated

2011-04-07 23:06:27 Slp: Sco: Attempting to get sid for user account ZEW-V-913BC072\SSPSQLAdmins
2011-04-07 23:06:27 Slp: Sco: GetSidForAccount normalized accountName ZEW-V-913BC072\SSPSQLAdmins parameter to SSPSQLAdmins
2011-04-07 23:06:27 AS: Data: SID = S-1-5-21-2763175129-1897282573-4278807499-1019
2011-04-07 23:06:27 AS: Result: Success
2011-04-07 23:06:27 AS: Result: Valid

The only thing i see in the log is:

2011-04-07 23:43:59 Slp: Message: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding..
2011-04-07 23:43:59 Slp: Inner exception:
2011-04-07 23:43:59 Slp:  Exception: System.Data.SqlClient.SqlException.
2011-04-07 23:43:59 Slp:  Source: .Net SqlClient Data Provider.
2011-04-07 23:43:59 Slp:  Message: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding..
2011-04-07 23:43:59 Slp: Error: Action "SqlEngineDBStartConfigAction_install_configrc_Cpu64" failed during execution.

I also noticed that it takes at least two connections before th

View Complete Post

More Related Resource Links

Access denied when user clicks refresh BDC column button

Access denied occurs with any non Site Collection Administrator regardless of rights.  It only occurs in this site collections, others they are able to refresh.  In this particular collection they can add a BDC column to a list, edit an item and place/resolve a value in the bdc col; but when they refresh they are given an acess denied.  Any thoughts on what they need read access to?  This goes away if I give site admin privs (dont want to do that) or give them read only access on the web application (dont want to do that either).

SQL 2008 R2 clustered instance does not start in single user mode

Hi I am testing the startup of a SQL 2008 R2 clustered instance (Windows 2008 R2) using single user mode but it fails with : Error: 17058, Severity: 16, State: 1. initerrlog: Could not open error log file ''. Operating system error = 3(The system cannot find the path specified.) - I am running the following command from the default sql installation : C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQL01\MSSQL\Binn>sqlservr.exe -c -m -s SQL01 - The cluster service on the passive node has been shutdown. - The SQL Server and SQL Agent services have been set to offline in Failover Cluster Manager. Any assistance greatly appreciated. Regards, PK    

Can you install SharePoint 2010 and User PerformancePoint in a single server enviroment?

Hi I Installed SharePoint 2010 in a single server farm and I configured a Performance Point service aplication. Whenever I run dashboard designer it seems to work but it eventually crashes. I don´t know if I have any configuration errors. I read this Run the Secure Store Service on a separate application server that is not used for any other service. Create the secure store database on a separate application server running SQL Server. Do not use the same SQL Server installation that contains content databases. Here http://technet.microsoft.com/en-us/library/ee806889.aspx I believe this service is necesary to run connect to data sources does this mean it all cannot be run in the same server.

Object Cache set with Portal Super User accounts. Access denied to site.

I have the same issue on multiple farms. In this example i'll outline this problem for a three tier farm. SharePoint web server SharePoint Application server (hosts central admin) Sql server After installation and configuration i have created two web applications (claims based auth with NTLM). https://portal.contoso.com https://mysite.contoso.com The client connects on the URLs to the web server (1st tier). All is working correctly and they can access the portal and their mysite. The log file keeps reporting that i need to configure the user accounts for the Object Chache. So, i looked up the required steps and executed these conform mcrosoft guidelines (http://technet.microsoft.com/en-us/library/ff758656.aspx) All the steps run seccesfully. But when i connect to the URL i now get an access denied (even with the administrator who is site collection administrator) In the log file i get the following to lines when i connect to the site. Unknown SPRequest error occurred. More information: 0x80070002 Unknown SPRequest error occurred. More information: 0x80070005 I have exact the same issue on two other farms. Marc

SS2K8RS in MOSS 2K7 Integrated Mode; Customers are getting Access Denied

Hello             I have SQL Server 2008 Reporting Services Running in SharePoint 2007 Integrated Mode. I have created and successfully deployed many reports to the server and as the admin I can view the reports with no problems. Initially my customers who have read access were also able to access the reports with no problem. As of two days ago the customers are receiving “Access Denied” errors and being asked to request access. For one customer I gave him contribute rights and they still received the “Access Denied” error. The only real configuration change made it that I ran the “SharePoint Products and Technologies Configuration Wizard”.             I have been floundering around a couple of days trying to find a solution; I hope someone will be able to assist.

stsadm Install feature command - Access Denied

Our sharepoint farm consists of 2 servers - app and database

I am administrator on the app server and I am DBowner of the shrepoint databases.

I am farm administrator.

I run the stsadm installfeature command, but I get the error ACCESS DENIED.

Help much appreciated


coming out of single user mode



How to come out of single user mode in sql server


Access Denied error when attaching VS2008 workflow debugger to 64-bit IIS if VS2008 user differs fro

I am trying to attach VS2008 to debug a workflow hosted in IIS (using the workflow debugger option so I can step through the visual workflow designer breakpoints, not the managed code debugger).  It is actually a WF 3.5 WCF workflow service hosted in IIS but I don't think that is the issue.  When I attach from VS2008 I always get the error "Unable to attach to process.  Access is denied."

I can attach for managed code debugging no problem.  Also, if I configure the IIS worker process app pool to use the same account as the account I am running VS2008 under I can attach not problem and debug using the workflow debugger.

So my remaining problem is that I would like to be able to attach while running VS2008 as my normal user account and leave the w3wp.exe app pool running as the usual networkservice account so that my debugging represents how the w3wp.exe will act in production.  I'm on Vista SP1 64-bit with .Net 3.5 SP1 and VS2008 SP1. 

Q: Is there a special privilege I can grant the worker process account so that I can debug while using a different user account?

I saw a very old post here http://blogs.msdn.com/sonalic/archive/2006/05/10/594703.aspx that hinted there is something special for 64-bit.  Does anyone know if there is something special about 64-bi

Access Denied while user logs out sharepoint 2010 FBA site




I've sharepoint 2010 site configured as forms based authentication having my custom membership provider. 

On this site, i've a simple webparts that basically contains a asp.net login status control to allow users to login/logout. it works fine .. when user is not logged in it shows Login link that redirects users to the login page and when user is logged in, it shows Logout link. 

but when i click logout link, user is not logged out completely. I get this error - Access denied and when i go back to the page (by clicking on the link provided on error page or just refresh the page) - the user is still logged in on the site !!

Here's the code snippet of my webpart:

This exact same functionality is working fine MOSS but it doesn't seem to work here !!


protected override void CreateChildControls()
LoginStatus loginStatus = new LoginStatus();
loginStatus.LoginText = "Log in";
loginStatus.LogoutText = "Log out";
loginStatus.LogoutAction = LogoutAction.RedirectToLoginPage;


Database Corrupted - Can't get db in single user mode

I have two SQL 2008 R2 databases running on a 64-bit development Machine :
I have created Synonyms in MyDatabase (Table1, Table2, Table3) for three tables in the IMS database.
I am experiencing very poor performance using these Synonyms from my application so I am trying to troubleshoot the problem.
I tried to run "DBCC CHECKDB (IMS,  REPAIR_ALLOW_DATA_LOSS)" by performing the following steps
  1. Used Services to stop the processes (Instance, Agent, Browser, Integration Services 10.0, VSS Writer)
  2. Ran cmd.exe "As Administrator"
  3. cd C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Binn
  4. ran sqlservr.exe -m -s SQLEXPRESS (output says it started in single user mode)


  1. Ran cmd.exe "As Administrator"
  2. cd C:\Program Files\Microsoft SQL Server\100\Tools\Binn
  3. ran sqlcmd.exe -S D

How to customize Access denied page for single Site Collection?


Hi All,

I want to customize Access denied page and that is for only a single Site Collection on my server.

I have tried to custozied content placeholder of AccessDenied.aspx under LAYOUT folder which applicable to all site collection on that server.

Please, guide me.

Thanks in Advance.

Regards, Kaushal

SQL Server 2000 Database in "single user mode"


Hi all,

I've an old production database server with SQL Server 2000 SP4, that runs from 6 years. Now sometimes I find that the production database goes in "single user mode". Why? My error logs don't help me.

Is realtime SQL Server Replicated database usable realtime (not offline / single user mode)


Is SQL Server replicated (destination) database replicated by SQL Server Replication fully usable? Meaning it's not just for Disaster Recovery but is fully usable from various say BI / Reporting purposes.

In the essence it is exactly same as other replication engines and the destination database is very much usable and not just offline / single user mode.



SMO Database in Single User mode issues


I am trying to use the SMO library and setting the single user mode. Here is a simple example illustrating my issue.

The below code will fail the first time. Saying "Invalid object name TestTable". Eventhough that table does exist and so does the DB. However, if you run it again (now the DB is already in single user mode) everything works fine. Also, if you remove the code that alters the db user mode everything works fine. I am assuming the problem must exist with the single user mode and utilizing the correct db connection. I have tried flipping the AutoDisconnectMode and NonPooledConnection but that hasn't help. Any help would be appreciated.

Sample code

SqlConnectionStringBuilder sb = new SqlConnectionStringBuilder(); 

sb.Password = "P@ssword!"; 

sb.UserID = "testuser"; 

sb.DataSource = @".\mssql2008"; 

sb.InitialCatalog = "TestDB"; 

ServerConnection serverConn = new ServerConnection(); 

//serverConn.AutoDisconnectMode = AutoDisconnectMode.NoAutoDisconnect; 


Access to report file denied. Another program may be using it.


Migrated from Windows 2000 ASP.NET 1.1 to Windows 2003, ASP.NET 2.0 and had this error. All the forums/MSDN/Blogs says to give Read/Write Access to C:\Windows\Temp folder. Why should we give Full Access to some folder in Production server?? In windows 2000, ASP.NET 2.0 development machine, no files are created when we run crystal reports from aspx pages. Then why in Windows 2003 servers, we need to give rights to temp folder?? It is a simple code


And the code is not storing anything on the disk. Then why should it store the GUID.rpt file in Temp file in Windows 2003 server?? Any alternative is there not to store anything on the disk when Crystal Reports are opened in aspx page??


IE closing when user try to access the document library

<!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> IE closing (crashing) when user try to access the document library in share point site.  here we are using WSS2.0.  this problem for not accursed all the users , this problem happening on some users. 

"Access is denied. Check that the Default Content Access Account has access to this content"


Our search is not working. The crawl log indicates following error: "Access is denied. Check that the Default Content Access Account has access to this content, or add a crawl rule to crawl this content. (The item was deleted because it was either not found or the crawler was denied access to it.)".


If I check the event viewer, it indicates following error: "Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. [CLIENT: <local machine>]"


My default content access account is another one than this NT AUTHORITY\NETWORK SERVICE account. The content access account password is correct. Apparently this content access account is translated to the NETWORK SERVICE account upon a crawl. And this network service account doesn't has the appropriate rights on database level. How can I fix this?


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