.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

Network share backup with SQL service running as Network Service account

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :

Is that possible?

I have tried to create a network share on window server 2008 R2 machine with advancing sharing granting full control permission to Network Service, but i get the access error when doing the backup in SQL management studio. How to backup to network share without using a domain user account?

View Complete Post

More Related Resource Links

Does Cube Synchronization Support Network Service Account



We are doing Cube Sync between 2 servers. Analysis Service on Both Machines are running under built in Network Service account. When i do cube sync i get following error;

Executing the query ...
Errors in the OLE DB provider. The server returned the following error:  (Either the user, DOMAIN\MACHINE$, does not have access to the Country database, or the database does not exist.).
Backup and restore errors: An error occurred while synchronizing the 'Country' database.
Execution complete

Does SSAS Sync supports using Network Service Account?

If Yes then how do i do this. I tried creating a role in SSAS database and Give Full Rights to Network Service account of source server but i keep getting error DOMAIN\MachineName$ not found.

Please advise.



MVC application problem when running out of Network Service.



I am hosting an ASP.NET MVC 2 application on its own application pool.

Everything works fine if the application pool is running on Network Service with Full Control.

If I make the application pool to run on its application pool identity, even with full control, the web site runs ok but on every page with a form I get the following error:

"Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that <machineKey> configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.HttpException: Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that <machineKey> configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster."

Any idea how to solve this problem?

Thank You,


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

AD Network Service vs. workgroup NetworkService

I am developer using, and therefore in need of understanding and configuring, SQL Server 2008 R2 + ASP.NET/IIS in workgroup.  SQL Server 2008 R2 BOL in Setting Up Windows Service Accounts section states: "Network Service Account The Network Service account is a built-in account that has more access to resources and objects than members of the Users group. Services that run as the Network Service account access network resources by using the credentials of the computer account. The actual name of the account is "NT AUTHORITY\NETWORK SERVICE" While the answer to my question [1] insists: "Configuring a service as "Network Service" or "NT Authority\NetworkService" tells the service to log on to the domain as that machine's domain account, and will have access to Domain resources. The Windows XP Service Configurator does not have the ability to select "Network Service" as a login type. The SQL Setup program might. "Network Service" can do everything "Local System" can, as well as access Domain resources. "Network Service" has no meaning in a Workgroup context" Is this answer correct thatNetworkService has meaning/use only in AD (Active Directory) domain?? And why do I have "NT Authority\Network Service" available for services LogOn on my workgroup Windows XP P

PassThrough authentication fails: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'

I've tried it with every AuthenticationMode! But no one seems to work correctly in my case. I thought that PassThrough should work with a preset User ID and password. This would be enough for the moment, but even this doesn't work!! With WindowsCredentials I get the following error: The Property with name 'SsoApplicationId' is missing on the LobSystemInstance. SsoApplicationId I tried to set this with the SharePoint SSO but I've no such services. How can I set this just for the current WindowsCredentials (of the current Sharepoint user)? With RevertToSelf I get the following error: "An error occurred while retrieving data from MyLOBInstance. Administrators, see the server log for more information." The server log contained no useful information for me. With PassTrough I get the following error: "Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. [CLIENT: <local machine>]" Why are the lines <Property Name="RdbConnection User ID" Type="System.String">MyDomain\Administrator</Property><Property Name="RdbConnection Password" Type="System.String">mYpAssWoRd</Property> being ignored? Everything (MOSS, SQLServer,...) is on a single machine, so I don't need to activate Kerberos, do I? <LobSystemInstance Name="SEPInstance1207">   <Properties>    <Property Name="DatabaseAccessProvider" Type="Micros

Install a wcf as a windows service and copy files from a network location



I need to intall a WCF as a windows service. In side this WCF , I need to copy files from a network location to the local machine and run them.

I tried to give a specific user account ( which has access to the shared location)for the windows service processinstaller and install the service. but this account cant host the WCF since it does not have admin rights.

Is there a way to host the WCF using local account.. and then to access network location in side the wcf using a specific account. ( impersenation??/ )

Thanks in advance.





Problem Accessing a Web Service Outside of Local Network


I've created a simple web service and tested it on my local machine and it worked perfectly. Another machine in the same local network tested using the web service and it worked fine as well. However, when I try to access the web service from outside of our local network, it returns a HTTP status 400: Bad Request error message. Any clues as to what might be causing this behavior?

It's my understanding that port 80 is for web services and that is not being blocked by a firewall or anything, so that is not the issue. Any help would be appreciated.

Windows Server Backup fails when SQL VSS Writer service is running


Hello. On one of our SQL servers, we have SQL Server 2008 Express installed. Whenever is the "SQL Server VSS Driver" service running, backing up the computer with Windows Server Backup will always fail. If I stop SQL VSS writer service, then it the backup will finish successfully, although apparently backup of the SQL DBs is not consistent.


- backup is executed with "wbadmin start backup -allcritical -backuptarget:d: -vssfull -quiet"

- root of the SQL Server instance (and all DBs, trans. logs etc) are located on a volume E:

- once the backup command is executed, it's stuck on the creating volume shadow copies operation for several minutes, failing afterwards

- SQL VSS Writer has status 8 (failed), last error is "non-retryable"

- eventlog contains myriad of messages since the backup is started (SQL server has hundreds of DBs on it), with variations of these 3 repeating:

  a) SQLVDI: Loc=TriggerAbort. Desc=invoked. ErrorCode=(0). Process=1304. Thread=15788. Server. Instance=SQLEXPRESS. VD=Global\{A4C1E365-459A-4D41-B3D0-1A76DB8E56F6}517_SQLVDIMemoryName_0. Source: SQLVDI, EventID: 1. This is repeated numerous times, where thread id varies and number (517 in this case) in the VD identifier

  b) BACKUP failed to complete the command BACKUP DATABASE

WCF hosted in a Windows Service is not available over network


I have WCF service which is hosted using Windows Service.

Also I have a client (Windows Forms) which communicates with my WCF.

When I test it on my PC (using localhost) it works fine, but when I try to test it over network it doesn't work: I receive the following error: "TCP error code 10060: A connection attempt failed because the connected party did not properly respond after a period of time..."


When I use Windows Forms for hosting my WCF, it works fine.


Here is source code of the service:


var throottling = new ServiceThrottlingBehavior
       MaxConcurrentCalls = Int16.MaxValue,
       MaxConcurrentSessions = Int16.MaxValue,
       MaxConcurrentInstances = Int16.MaxValue

var address = string.Format("net.tcp://{0}", Settings.ServerAddress);
var binding = new NetTcpBinding(SecurityMode.None) { HostNameComparisonMode = HostNameComparisonMode.Exact };


Need Help in this 'Login failed for user 'NT AUTHORITY\NETWORK SERVICE'


Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.]
  System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5009598

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



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?



c# windows service - check network folder exists



I developed a windows service running as local system, which will search for some files / folders in specified locations.

The problem is when i specify the Path to a Shared folder in Network it will return "Path Not Found"

how can i fix this.




Develop a Web Service: Up and Running with the SOAP Toolkit for Visual Studio


The new Simple Object Access Protocol (SOAP) Toolkit for Visual Studio 6.0 provides the infrastructure for developers to build, expose, and consume Web services. With a few exceptions that are outlined in the toolkit, the SOAP Toolkit complies with the SOAP version 1.1 specification. It includes the Remote Object Proxy Engine (ROPE), a Service Description and Code Generation Wizard, and code that provides ASP and ISAPI reference implementations of SOAP listeners. This article describes the tools and the object model of the SOAP Toolkit, and then demonstrates ASP and ISAPI implementations of a functional Web service using this toolkit.

Rob Caron

MSDN Magazine August 2000

SQL Reporting Service 2005 - share schedule report performace T-SQL query?

Hi, I have SQL 2005 reporting services Shared Schedules and each schedule has its own subscribed report. I would like to have T-SQL 2005 to find out performance loading on each schedule. i.e. MySchedule_1 has 10 reports in it and AVEGARE report eaxecutiontime is like 3mins 5sec      MySchedule_2 has 7 reports in it and AVEGARE report eaxecutiontime is like 4mins 9sec Pls can I have T-SQL 2005 on ReportServer database to find out load on each schedules (and more drill-down to each report level for execution time)?

SQL Agent - service account permissions - SQL Server 2008

Hi @ all   I installed two SQL Server 2008 on Server 2008 R2 Std (principal and mirror) and an AD Server 2008, with sperate service accounts, connect as SA, localy all works fine. I created some agent tasks (PowerShell, T-SQL), but I get some Error massages in the history, that service account of SQL Agent didn't have the permission to query a remote machine(access denied for wmi (HRESULT: 0x80070005 (E_ACCESSDENIED)) and linked database(SQLSTATE 42000 Error(7314)). The simple query with SA permissions on the remote machine works and the powershell scripts with the local domain user works too. But not with the SQL Agent. WHY?? Where ist the different between the user account permisions and service account permissions? Which settings are needed? Example: get-wmiobject -class win32_service -computername 192.168.xxx.xxx| where {$_.name -like '*SQL*'} Powershell Console: works                                     SQL Agent Job: access denied I tried some solutions with user rights, group policies and security permissions but nothing works. like: Configuration -Service Accounts, SQL Server or SQL Server Agent service account http://support.microsoft.com/kb/283811/en-us http://msdn2.microsoft.com/

Get Service Account Details of the SQL Agent Service

Hello, How can I get the Service Account name for the SQL Agent service for a particular SQL Server (SQL 2005). Is that possible to get using SQL statements? Thanks, Prabhat

Change the Timer Service Account

I did an install with Sharepoint 2010 RTM and have it working well but when I checked the Monitoring - Review Problems and solutions it states a security concern that the Farm Account should not be used for other services.  At this stage I have to change out the timer service since it is using the farm account.  But I don't see the timer service in the "Security - Manage service Accounts" location.  I created a timer account with no problems but how does one go about changing the timer service to use this account?  I know I can go to services and change it there but I am wondering if there is a need to do this within Sharepoint?  Am I missing a credential management piece that did not show up in the list of services? Any help would be appreciated Workerbee09  By the way, The problem points to a failing service SPTimerService (SPTimerV4) but its started and working cause I can see services being started and history of the service where it was successfull. 
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