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


Top 5 Contributors of the Month
ffttt
Post New Web Links

Error: The SQL Server Service account does not have permission to register the supplied URL on the e

Posted By:      Posted Date: November 02, 2010    Points: 0   Category :Sql Server
 

Hi,

I've developed a SQL webservice which works absolutely fine on the server but it doesn't work on my VMware. It generates following error:

"The SQL Server Service account does not have permission to register the supplied URL on the endpoint.  Use sp_reserve_http_namespace to explicitly reserve the URL namespace before you try to register the URL again. An error ('0x80070005') occurred while attempting to register the endpoint."

Here's my webservice:

CREATE ENDPOINT [SQL_Webservice] 
	AUTHORIZATION [DOMAIN\Administrator]
	STATE=STARTED
	AS HTTP (PATH=N'/TEST', PORTS = (CLEAR), AUTHENTICATION = (NTLM), SITE='192.168.xx.x', CLEAR_PORT = 80, COMPRESSION=DISABLED)	
	FOR SOAP (
WEBMETHOD 'GetCountries'( NAME=N'[TestDatabase].[dbo].[GetCountries]'
, SCHEMA=DEFAULT
, FORMAT=ALL_RESULTS), 
WEBMETHOD 'GetCities'( N


View Complete Post


More Related Resource Links

Configuring linked server for a service account - error authenticating

  

I am trying to run a report through SSRS 2008 web interface.  The credentials that are being used to execute the report are through a service account.  The point of using a service account was so that the subscriptions feature could be used.  However, two particular reports connect directly though a linked server to an excel workbook.  I get the following error when I try to execute the report:

 

  • An error has occurred during report processing. (rsProcessingAborted)
    • Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand)
      • The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "YTWCHECK" reported an error. Authentication failed. Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "YTWCHECK".

How can I correctly add my service account to the linked server?

 

 


ddd

RDL Rendering (500 Internal Server) Error at Sharepoint Integrated Reporting Service

  

I have a serious problem that cannot be solved by googling around the keywords below:
sharepoint, moss 2007, reporting service, ssrs 2008, rendering, internal server error, ....

The error is;

"An error occurred during client rendering. The remote server returned an error: (500) Internal Server Error. "

Everything is O.K.;

* When I render the report from the REPORTSERVER (http://localhost/ReportServer)
* When the reports are scheduled to be sent by the reporting service (planned via MOSS 2007) 

But if I open (render) the RDL file from the sharepoint REPORTS LIBRARY interface, all of the reports fail with that internal error message above. 

It is weird also that parametrized reports are displayed without errors although the parameters are queried from a sql dataset. But I got the error when rendering the report after I've chosen a parameter  and order "apply/report"...

Possible causes how I met that error may be;

After I have installed (then uninstalled) AJAX extensions
After I have re-configured IIS Web Service Extensions list items

Possible solution alternatives I've found;

I've found a solution on MSDN replying a similar issue with an ideal cause of the error but an evreka answer but no sol

Windows 7 CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 26

  
Hi I have migrated to a new computer using Windows 7, 6 gig memory, I7 chip (old machine had xp) and have installed Visual Studio 2008 and  SQL Server 2008 R2.  I get CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262) when I try to create a new database.  Other posts (example:http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/28fee0ed-c7e2-40df-8f79-f513c9848f09/) work for Vista but I cannot find how to grant permissions.  Run as administrator (vista fix) does not work. I have admin privaleges on my machine.  There are no other accounts.    What do I need to do to update privaleges? Thanks and have a nice day.    

Server ERROR: An error occurred during the parsing of a resource required to service this request.

  
I have created one asp.net 2.0 application and created a setup project. I run this setup in my local machine, the application run fine, but i uploaded into online server I met the following parser error.How to solve this error? Kindly help me. Very urgent.. Kamal....

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/

sql server start service error "The request failed or the service didn't respond in a timely fashio

  
I cannot start sql server 2008 after repair windows. sql server (MSSQLSERVER) not start dialog message "The request failed or the service didn't respond in a timely fashion.Consult the event log or other applicable error logs for details"  I open even log (control panel >> administration >> event viewer) find error log with sql server it notice Could not open error log file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG'. Operating system error = 5(failed to retrieve text for this error. Reason: 1815) I open file ERRORLOG.5 but I don't understand where I should fix?  I copy errorlog.5 on this webboard  Please help me! thank you   2010-08-20 08:16:52.89 Server      Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)  Jul  9 2008 14:43:34  Copyright (c) 1988-2008 Microsoft Corporation  Standard Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3) 2010-08-20 08:16:52.89 Server      (c) 2005 Microsoft Corporation. 2010-08-20 08:16:52.89 Server      All rights reserved. 2010-08-20 08:16:52.89 Server      Server process ID is 2248. 2010-08-20 08:16:52.89 Server      Authentication mode is MIXED. 2010-08-20 08:16:52.89 Server  &

Error while trying to register DLLs for Microsoft Jet on Windows Server 2008 R2 64bit

  
Hello! I'm having issues with importing Excel spreadsheets into Microsoft SQL Server 2005 on a Windows Server 2008 R2 64bit server.  After browsing the web, it appears that the problem is with the DLL's used by Microsoft Jet.  I've thus attempted to re-register these DLL's.  However, I am receiving the following results. c:\Windows\SysWOW64> regsvr32 c:\Windows\SysWOW64\msjetoledb40.dllSuccessful c:\Windows\SysWOW64> regsvr32 c:\Windows\SysWOW64\msjet40.dllSuccessful c:\Windows\SysWOW64> regsvr32 c:\Windows\SysWOW64\msjint40.dllThe module "msjint40.dll" was loaded but the entry-point DLLRegisterServer was not found c:\Windows\SysWOW64> regsvr32 c:\Windows\SysWOW64\msjter40.dllThe module "msjter40.dll" was loaded but the entry-point DLLRegisterServer was not found c:\Windows\SysWOW64> regsvr32 c:\Windows\SysWOW64\msjtes40.dllSuccessful c:\Windows\SysWOW64> regsvr32 c:\Windows\SysWOW64\mswstr10.dllThe module "mswstr10.dll" was loaded but the entry-point DLLRegisterServer was not found I've set the application pool for this site to use 32bit.  Please note that due to my role on the team, other options such as using ACE are not available to me, unless I can prove that I've exhausted all other options. Thoughts? Thanks,Mike

Service Account for SQL Server 2000 Cluster

  
Dear All, One of my customer is running a active/active SQL 2000 cluster in Windows 2003 and the service account for one of the instance is LocalSystem account. I am not sure how they changed the service account to localsystem because SQL Server doesn't allow LocalSystem account as your service account when you install it on a cluster and it doesn't allow to change the service account to LocalSystem account in Enterprise Manager when running in a cluster. I searched for documentation to findout whether Microsoft supports running SQL Server using LocalSystem account in a cluster but I am unable to find a documentation. Please help me to identify the documentation regarding the support or share your experience Regards BalajiRegards,Balaji, Please mark as answer if you think this answers your questions

1511 Error on AppPool service account

  
How do I resolve the following error in the Windows application event log? This error occurs on the Web Application (managed) service account. Event Type: Error Event Source: Microsoft-Windows-User Profiles Service Event Category: None Event ID: 1511 Date:  6/08/2010 Time:  4:01:41 PM User:  [domain]\svcSharePointAppPool Computer: [my SP server] Description: The description for Event ID ( 1511 ) in Source ( Microsoft-Windows-User Profiles Service ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: The event log file is corrupt..

Search server 2010 setup - error creating search service application

  
I am running in a very similar siutation as this post:
http://social.technet.microsoft.com/forums/en-us/sharepoint2010setup/thread/3215D0B3-1BEC-4AEE-844D-DECDE9DEA1D8

I am configuring a new Search Server 2010 production environment.

I used the search setup account to run the setup and run the SharePoint Products Configuration Wizard.

During the first run of the SharePoint configuration wizard (where the farm account and service applications are setup), the process failed because the search service application could not be created.  

Errors were encountered during the configuration of the Search Service Application.
System.Data.SqlClient.SqlException: User does not have permissiont to perform this action.

I was under the assumption that the setup account had securityadmin and dbcreator SQL Server roles.  However, this was not the case and I had them added.  My original thought was the setup failed because of this.  After those roles were added, I tried to recreate the search service application and I still get a failure.

I am pretty sure I have followed the prerequisites as prescribed by Microsoft in terms of account setup (

Error during installation of SQL Server 2005 when typing the domain account

  

I am installing SQL Server 2005 on a server (Windows Server Enterprise Edition 2003 SP2) that is not domain controller and on the screen "Service Account" I checked the box "Customize for each service account" and typed a domain account (it has permission to "logon as a service"), its password and domain, and when I click the "Next" button, I am getting the error below:

"SQL Server Setup could not validate the service accounts. Either the service accounts have not been provided for all of the services being installed, or the specified username or password is incorrect. For each service, specify a valid username, password, and domain, or specify a built-in system account. "

What's happening? Why is this error occurring? What I have to do for this error does not occur?

Thanks for any help me to solve this problem

(Note : Excuse me because my English isn't very good !)

 


Error during installation of SQL Server 2005 when typing the domain account

  

I am installing SQL Server 2005 on a server (Windows Server Enterprise Edition 2003 SP2) that is not domain controller and on the screen "Service Account" I checked the box "Customize for each service account" and typed a domain account (it has permission to "logon as a service"), its password and domain, and when I click the "Next" button, I am getting the error below:

"SQL Server Setup could not validate the service accounts. Either the service accounts have not been provided for all of the services being installed, or the specified username or password is incorrect. For each service, specify a valid username, password, and domain, or specify a built-in system account. "

What's happening? Why is this error occurring? What I have to do for this error does not occur?

Thanks for any help me to solve this problem

 


User does not have permission to perform this action( Microsoft SQL Server, Error:15247)

  

Hi,

I was able to do my work with ease on my Database server, until sometime Friday evening. Don't exactly know what transpired, only that I can now no longer run queries or even create new databases. Here is a sample of what happens when I try to create a database

Create Database PetitionSample

Msg 262, Level 14, State 1, Line 1

CREATE DATABASE permission denied in database 'master'.

I used to be able to create databases, create new users and so on. My Server is installed on a Vista machine and I am running Developer version and using Management studio 2008 to access it. Anyone have any idea what could be going on?


None

SQL Server 2005 permissions error. The EXECUTE permission was denied on the object "xp_instance_reg

  

I have a SQL Server host running SQL 2005 9.00.4294 x86 Standard Edition running on Windows build 2195 SP4.  My client workstation is running only SQL Server 2005 workstaion components.   When a user of the host who has db_owner access attempts to view the properties of a table by right-clicking the table and then clicking Properties, the following error mesage is displayed:  

"The EXECUTE permission was denied on the object "xp_instance_regread", database 'mssqlsystemresource', schema 'sys'

For security purposes, I do not want to grant execute on xp_instance_regread to these users. Does anyone know of a workaround that will allow members of db_owner to access table properties using the abovementioned method and does not require execute access to be granted?

 

 

 


Error : Unable to connect to the remote server, When using web service in window service

  
Hi All,

          I want to consume a web service in windows service but in windows service I am not able to access  web service. I have tried it in windows application and web application it is working fine but in windows service  it is not accessible.

 

i am getting error:-   at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
   at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)
   at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)--->   at System.Net.HttpWebRequest.GetRequestStream()
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at Testmachone.MachWebRef.SimCardWS.ProvisionImsiCard(String MsMin, String MsEsn, String CardId, String UserId, String Password, String MscId, String BId, String NewValue, ActionTypes Command, String MDN, String COS, String MIP_KEY, String MEID, String RADIUSPassword, String IMSI, Boolean PrePaid)

 any body can help me what could be issue

 
<

The SQL Server(2005 express) service failed to start. Error 29503

  

Product: Microsoft SQL Server 2005 Express Edition -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is  (1067) The process terminated unexpectedly.

Initially the SQL Server was running over there, later one day it stopped. When trying to start manually I got "The process terminated unexpectedly" error. Tthen I uninstalled it and tried to install again, but got "Error 29503. The SQL Server service failed to start" error while installation and installation rolled back. If I install it using Local System and without "Enable User Instance" I get same error but after multiple retry it started. However my desktop application is not running and giving error message "Failed to generate a user instance of SQL Server due to a failure process for the user instance. The connection will be closed".

I tried "sp_Configure .......... " and "Reconfigure" to enable user instance but still got "Failed to generate......" error.

Another problem is that SQL Server service starts in multiple retry.

I have tried most of the forum solutions however I am still getting the same error in my desktop application. Mos

Reuse XAML Declarative Workflow in Workflow Service (xamlx) Results in Server Error of System.Argume

  

We attempted to reuse a XAML (declarative activity workflow) in a few places within the same XAMLX and it doesn't appear to allow this.   On the WCF client side, it reported an obscure error of something to the effect of unknown message received and a communication error stating the service instance couldn't be used at this time and to ensure the call order is correct or order delivery guarantee is enabled.   However, this appears to mask the true issue which is on the server side.   Apparently, when the server side WCF end point is trying to start the workflow instance, it throws this error building a dictionary of workflow children...

System.ArgumentException: An item with the same key has already been added.
   at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
   at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
   at System.Activities.Debugger.InstrumentationTracker.InitializeUninstrumentedSubRoots()
   at System.Activities.Debugger.DebugManager.EnsureInstrumented(Activity activity)
   at System.Activities.Debugger.DebugManager.OnEnterState(ActivityInstance instance)
   at System.Activities.Debugger.DebugController.ActivityStarted(ActivityInstance activityInstance)
  

Categories: 
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