.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

IIS7 access rights to SQL Express 2008 (both use Network Service)

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server


I have IIS7 and SQL Express 2008 running on Windows Server 2008.  IIS7's application pool that my app belongs to is configured for Network Service account.  The SQL Server also uses the same account.  I noticed that MS no longer discourages use of Network Service account for SQL 2008 (as it used to for 2005).

In IIS5 I used to give ASPNET account selected rights to my app's database.  With IIS7/SQL 2008 - both using the same Network Service account - giving access rights to the database does not seem to be necessary.  All app's running in the pool that uses Network Service account have full access to all resources in the database.

Is this expected?  If yes, what are the risks?



View Complete Post

More Related Resource Links

Problem connecting to SQL Server 2008 R2 Express from Access 2007

I have a problem with SQL Server 2008 R2 Express with MS Access 2007. I am running Windows 7 with 8 gigs memory. I installed SQL Server 2008 R2 Express. Do I now need to install SP1 because I am running with Windows 7? I can open SQL Server using the Management Screen but I cannot connect to MS Access 2007 using SQL Server Express as the database. When trying to connect to SQL Server from Access 2007, I keep getting the message that SQL Server 2005 cannot be found. It will not allow me to sign onto sql server 2008 stating that it cannot be found. Do I have to now run the SQL Server 2008 R2 Express SP1? Is there an upgrade to MS Access 2007 which will allow me to use SQL Server 2008 R2 Express?

Search Server Express 2010 - Access Denied when attempting to manage Search Service Application or P

I first noticed this error with the Search Service Application when I was no longer able to use the search portal, but have since noticed the issue with the PowerPoint Service Application.  When I navigate in Central Administration to either the "Farm Search Administration" or the "Manage service applications" pages and attempt to manage the "Search Service Application", I get this error: Error: Access Denied  Current User You are currently signed in as:  WHEELERS\MyUserName   Sign in as a different user    I have tried removing the service application and re-adding it, changing the application pool to running under an existing application pool as the farm administrator, as another application pool with the same identity as the primary web application, and as another application pool running under the SP-SearchService identity. The big recent change with SharePoint, aside from fixing the previous issue where I was incorrectly using CNAMEs with Kerberos, was to switch the main web application to claims authentication. That site correctly works with claims based authentication and Kerberos.

SQL Server 2008 express SQL Server Service won't start

Could really use some help. Am running XP Pro SP3.  Had 2005 Express running fine previously.  Installed 2008 Express but cannot get the SQL Server service to start.  SQL Server Agent does start though.  In log (below) it seems to be trying to access an E:\ drive that doesn't exist (did default install to C:\Program Files) - plus other issues.  Have 5gig+ free, so not sure why it's saying not enough space.  Have RTFMd the problem for a whole day with no luck.  Any advice much appreciated.   Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86)  Apr  2 2010 15:53:02  Copyright (c) Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.1 <X86> (Build 2600: Service Pack 3) (Hypervisor)   Error: 17054, Severity: 16, State: 1. The current event was not reported to the Windows Events log. Operating system error = 1502(The event log file is full.). You may need to clear the Windows Events log if it is full. (c) Microsoft Corporation. All rights reserved. Server process ID is 4988. Authentication mode is WINDOWS-ONLY. Logging SQL Server messages in file 'c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Log\ERRORLOG'. This instance of SQL Server last reported using a process ID of 3232 at 9/4/2010 9:36:12 AM (local) 9/4/2010 1:36:12 PM (UTC). This is an informational

Unable to Backup Service Master Key on SQL 2008 Express

Hi I am attempting to do a backup of the Server Master Key but it fails. The error message I am receiving is as follows: Msg 15240, Level 16, State 1, Line 1 Cannot write into file 'C:\Users\harvey norman\Documents\SQL Server Management Studio Express\SQLEXPR2008ADV_ServerMasterKey'. Verify that you have write permissions, that the file path is valid, and that the file does not already exist. The PC I am running SQL 2008 Express (64 bit) is running on Vista Ultimate (64-bit) SP2. The SQL I wrote is as follows: BACKUP SERVICE MASTER KEY TO FILE = 'C:\Users\harvey norman\Documents\SQL Server Management Studio Express\SQLEXPR2008ADV_ServerMasterKey' ENCRYPTION BY PASSWORD = '??' GO Note that the ?? represents the password but is not actually the password for obvious reasons. I am logged in to the PC as a user with Admin permissions.  I had a look at the destination folder, and it shows I have full control. So, I am mystified. If somebody could advise me I would really appreciate it. Many thanks in advance. Kind regards Ross Ross

Unable to start SQL Express 2005 service as a network user

I am trying to start ms sql server 2005 express as a network user from originally starting as local system. I cannot start the service.I have given this network user administrator access to sql express from the sql server surface area configuration "Add New Administrator". I have went into the local users/groups and added this network user to the 3 security groups SQLServer2005MSSQLServerADHelperUser$SQL1SQLServer2005MSSQLUser$SQL1$SQLEXPRESSSQLServer2005MSSQLBrowserUser$SQL1I receive one alert int he event logs/applicationEventID: 26010The server could not load the certificate it needs to initiate an SSL connection. It returned the following error: 0x8009030d. Check certificates to make sure they are valid.I receive five errors in the event logs/applicationEventID: 26014Unable to load user specified certificate. The server will not accept a connection. You should verify that the certificate is correctly installed. See "Configuring Certificate for Use by SSL" in Books Online.EventID: 17182TDSSNIClient initialization failed with error 0x80092004, status code 0x80EventID: 17182TDSSNIClient initialization failed with error 0x80092004, status code 0x1EventID: 17826Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately prceding this one in the error log.EventID: 17120SQL Serve

Does SQL Server 2008 R2 Express Reporting Service support Shared Datasets?

I have spent a few hours trying to get this to work. I am using Report Builder 3.0 (locally), with SQL Server 2008 R2 Express Edition on a remote web server. I am running Report Builder as an Admin under Win7 64bit. All is OK until I attempt a Save of a newly created shared dataset. The error message is: Failed to save dataset "mydataset.rsd" The feature "Shared dataset" is not supported in this edition of Reporting Services. Details: The feature: "Shared dataset" is not supported in this edition of Reporting Services. ---> Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException: The feature: "Shared dataset" is not supported in this edition of Reporting Services. I have researched the web, and the list of features for Express Edition does not list this feature as not being supported, although it does list "Shared component library" as being missing. Could anyone please confirm the situation please. If it is  a bug, is there any fix or workaround?  John Walton  

SQL 2008 Express with Reporting Service

My internal url for reporting service works on my SBS 2003 server, but I cannot access this url via the internet. Could anyone help?

Upsizing Database from Access 2007 to SQL Server Express 2008

I have recently downloaded and installed SQL Server Express 2008 on to my Windows XP SP3 machine, I have a large MS Access 2007 database (.accdb) I wish to export out to SQL Server. I am using the 'upsizing wizard' that is found on the 'Database Tools' tab of Access 2007. Clicking on the 'Database Tools' tab and then on the 'SQL Server' button starts the Upsizing wizard. On the first page of which I select the 'Create new database' option, the next page asks 'What SQL Server would you like to use for this database?' it already has '(local)' entered into the text box, so I leave that unchanged, I tick the trusted connection box and name the new SQL Server database and then click 'Next'. But I get the following error (it appears in a Windows information message box):

Title: Microsoft SQL Server Login
Message Text:
Connection failed:
SQLState: '01000'
SQL Server Error: 2
[Microsft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen(Connect()).
Connection failed:
SQL State: '08001'
SQL Server Error: 17
[Microsft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.

PS. I have successfully used the upsizing wizard to export the same Access database into SQL Server Express 2005 on another machine.

What am I doing wrong this time?

upgarde accdb (access 2007) files to SQL EXPRESS 2008 R2


Is there a program that I can download that aids in converting an access (accdb) file to sql express 2008 R2?

Thank you


SQL Express 2008 R2 service cannot log on


I just installed SQL Express 2008 R2 on an hp computer running Windows 7. The install reported no errors but when I configured the database service

log on I selected the log on to use my account (has Administrator privileges) and password. When I try to start the service I get the message "The parameter is incorerect. (0x80070057). Any advice will be appreciated.

Sigsby Rusk

Trouble installing SSRS 2008 R2, XP Pro SP3, can't access Web Service or Report Manager URLs


I found a great thread by Uday titled "SQL 2008 Reporting Services Win XP SP2" and worked through it, but I am still stumped.

I am using port 8080 cause this was default.  I tried changeing to 80, but it didn't help, so changed back.  IIS is using port 80 and is currently stopped.

I see both databases in SQL Server and can query while logged in as Account that is used for the service account.  SSRS is running. 

URL reservations look good in the rsreportserver.config file.  In Native mode.

While in RS Config Manger I can test database connection and it is good.  When I click the webservice URL or the Report Manger URL in the Config Manager I get errors "Web site can not be found" and "Website can not display page"  I just upgraded to IE 8.  Can't figure out what to do next.

When I use httpcfg.exe I see a URL for http://+:8080/ReportServer/   and http://+:80/Reports/.  This could be the problem.  How can I chages seconfd to port 8080?

Any help would be appreciated.



access an SQL server2008 database from a VWD 2008 express GridView


 I am trying to access an SQL server2008 database from a VWD 2008 express GridView.  I create the SqlDataSource and connect it to the gridview and thenn run the page and it is not rendered on the page. Visible is set to true.

Can SQL 2008 Express communicate thru Win2K network?


Is it possible to have :

  • SQL Server Express 2008 R2 running on a XP prof. SP3 machine,
  • in a Windows2000 network,
  • and remotetly connect to the data with Access2003 on XP prof. SP3 ?

Do I need to install anything on the remote client to connect to the sql server?

Just spend the day trying to get this -above described- working, with no success. I'm able to make this connection locally on the server itself but when I try to remotely connect it fails.
I have allowed TCP/IP connections and have allowed the used portnumber in the servers Firewall.

Any ideas...


Patrick Delisse

WCF service IIS7 Server 2008 custom User Name Authentication performance



I have WCF service. Nothing special. Everithing from "best-practice".

  • WCF Service hosted on Server2008(64)\IIS7
  • Application pool - integrated\.NET 4.0
  • binding: basicHttpBinding; security:TransportWithMessageCredential
  • transport clientCredentialType="None"
  • message clientCredentialType="UserName
  • custom class inherited from UserNamePasswordValidator provide simple validation.

Everything works as designed. But I have a performance issue.

I traced and logged the server and WCF class and figured out that there is no new "http request" in process until previous one passed "Verification". It looks like concurrent calls do not have any sense because UserName Password Validator may serve them one by one only.

It can't be a true. I hope I just missed some settings.

I will appreciate any help.


Defining required access rights for a service with ServiceController




I'm pretty sure this is straight forward I just can't seem to get it working.


I have a service called serviceX and I want to control it from another application.  The "control" is simply checking the ServiceController.Status field and calling ServiceController.Start().


The exception i get is:-

System.InvalidOperationException: Cannot open serviceX service on computer '.'. ---> System.ComponentModel.Win32Exception: Access is denied

--- End of inner exception stack trace ---

at System.ServiceProcess.ServiceController.GetServiceHandle(Int32 desiredAccess)

at System.ServiceProcess.ServiceController.Start(String[] args)

at SnippetCompiler.ServiceMonitor.StartService()


In Win32 I would specify SERVICE_QUERY_STATUS and SERVICE_START as the required access in the OpenService API call.  How do I do this in managed code?  I can only assume I need to use a ServiceControllerPermission object but I can't figure out how.



Trying to add a linked server - SQL Server 2008 Express Edition to Access 2007

OS: Vista SP1
SQL Server 2008 Express Edition installed locally
Office 2007 installed locally

I'm trying to add a linked server to a named instance of the SQL Server 2008 that links to an Access 2007 database.

I've spent a couple of hours trying this now - many, many different ways.

Always seem to end up back at Error 7303 - http://msdn.microsoft.com/en-us/library/aa226395(SQL.80).aspx

I've tried all versions of Access database file 2000, 2002-2003, 2007
I've tried to use different drivers -

Office 12 for Access driver

I've tried to use the upsizing wizard from Access - no good, cannot get it to connect to the SQL Server 2008 Express Edition instance

Whichever way I try it I end up with this message/error:

the upsizing wizard only works with microsoft sql server versions 6.50 sp5 or higher

I've read: http://support.microsoft.com/default.aspx/kb/838594 and followed it - same error.

I really want this to just work. Like it should already.

Any suggestions appreciated.

Matt Haddon
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