.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

Looking for examples on WCF for Web-Services, and database use.

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :.NET Framework


I am looking for an example of WCF, and Web-Services use.

(VS 2010, Windows 7, Framwork 4),


Thanks :)

View Complete Post

More Related Resource Links

SQL Data Services: The Relational Database of the Azure Services Platform


This article shows you the new face of SQL Data Services, explores its architecture, and shows how it is truly an extension of SQL Server in the cloud.

David Robinson

MSDN Magazine August 2009

Metadata: Create a Database Schema Repository with Meta Data Services in SQL Server 2000


SQL Server 2000 Meta Data Services is a repository technology that stores and manages metadata for SQL Server. Instead of building database schemas over and over, Meta Data Services allows you to freeze an entire schema for use in other projects. You can also use these schemas for training, testing, or debugging. In this article, the authors will review the various components of Meta Data Services and show how it can be programmed using a Visual Basic client, XML, and XSLT. They will also show you how to manage and manipulate your metadata by generating a simple database schema using a SQL Server repository.

Alok Mehta and Ricardo Rodriguez

MSDN Magazine May 2003

Unable to install SP3 on SQL 2005 due to Database Services language being blank

Hi all,   I have an issue that requires me to upgrade to a later SP (currently on RTM), but when I try to install SP3 Database Services cannot be ticked. Upon inspection I see that its reporting "This update requires language ENU.  The language for this product instance MSSQLSERVER is . Download the upadte for langage .", when I check teh Language field to the right it is blank, other parts however are fine and can be upgraded. Can you advise please as I don't know how to manually set the language (which is reported inside SQL itself as English (United Kingdom)) and I cannot un/reinstall. Thanks, John

Reporting Services Add-In for MOSS2007 : Unable to connect to the database Error at "Set Server Defa

Dear Expert, I've succesfully install the Add-In + configure the reporting services (integrated mode) + activate the features on my MOSS2007. As we know by activating this at my Central Admin, i'm able to see "Reporting Services" under my Application Management as below:   1) Manage Integration Setting   ---> My report url : http://servername:808/ReportServer (Trusted Account) 2) Grand Database Access --->  My setting : <servername> with default instance  3) Set Server Defaults ---> Area that i receive an error "Unable to connect to database" Anybody here have a same experience? please assist me, Thanks in Advanced My Note: OS : Windows Server 2008 Enterprise x64bit (SP2) SQL : SQL 2005 with latest Service Pack (SP3)  My Error Log: <Header>   <Product>Microsoft SQL Server Reporting Services Version 9.00.4035.00</Product>   <Locale>en-US</Locale>   <TimeZone>Malay Peninsula Standard Time</TimeZone>   <Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__08_04_2010_10_51_59.log</Path>   <SystemName>SEINE</SystemName>   <OSName>Microsoft Windows NT 6.0.6002 Service Pack 2</OSName>   <OSVersion>6.0.6002.131072</OS

Database Access Using SOAP and REST Web services

Hi Guys, Can anyone post the links regarding DATABASE ACCESS USING BOTH WEB SERVICES. How to query the database using the web service. Suppose i have SQL statement like " Select empID,empName,CName from employee,company where empID=CID;".  How to  send this sql query to database server using REST and SOAP web Services?  Thank You

Windows SharePoint Services v3.0 Database Error

Hi Below is the error from event viewer on the server based on the Above Event Type:     Error Event Source:  Windows SharePoint Services 3 Event Category:          Database Event ID:         3758 Date:               3/18/2009 Time:               4:38:40 PM User:                N/A Computer:       FIB-PORTAL Description: Database full error on SQL Server instance 'FIB-PORTAL\OfficeServers' in database 'WSS_Content'. Additional error information from SQL Server is included below.   Could not allocate space for object 'dbo.EventCache'.'EventCache_Id' in database 'WSS_Content' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.   For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.   Event Type:     Error Event Source:  MSSQL$OFFICESERVERS Event Category:          (2) Event ID:         1827 Date:               3/18/2009 Time:               4:38:40 PM User:                FIRSTINLAND\sharepointadmin Computer:       FIB-PORTAL Description: CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database.Any ideas on the Solution to the Above Issue...Best Regards,Adeoye...

"The Database Engine instance you selected is not valid for this edition of Reporting Services" erro

Hi there, I have developed some reports using Visual Studio and everything worked fine in the office. Now I'm trying to deploy them on my customer PCs but this process keeps failing. These reports can be built and even previewed within Visual Studio but they cannot be deployed. Here is the error message I get: ----------------------------------------- The feature: "The Database Engine instance you selected is not valid for this edition of Reporting Services. The Database Engine does not meet edition requirements for report data sources or the report server database." is not supported in this edition of reporting services. ---------------------------------------- The versions of the software on my customer machines are: SQL Server Enterprise 9.0.3282 SQL Server 2005 Management Studio 9.00.4035 SQL Server 2005 Reporting Services Designers 9.00.4035.00 Visual Studio 2005 8.0.50727.42 I believe that changing the edition of the Reporting Services from Designers to Enterprise should fix the deployment error but I did not find a way or setup files to do so. Many thanks in advance for your help!

Reporting Services doesn't connect to database automatically

Hello. I use Windows 2003 R2 x64 and SQL Server 2005 x64.  The problem is: if the Reporting Services Service were doesn't start automatically, despite the set up parameter "Restart Automatically" every 1 minute in the service Recovery property. So every minute after Service stopped i recieve an error in Event Viewer: Report Server (MSSQLSERVER) cannot connect to the report server database However, after starting it manually from Computer Management->Services or Reporting Services Configuration Tool it starts normally without any error. I use local system admin account to start Services and to connect to Database. Both parameters are set using RS Configuration Tool. Will be thankful for any advice.

How to configure Sharepoint 2007 Reporting Services 2005 with NLB sharing same RS database

Hello, I'm trying to configure RS using two FE and a single SQL database in sharepoint integrated mode. At first i was getting an error about version of reporting server wouldnt support scale-out configuration, so i upgraded RS Instances in both FE's to 2005 Ent Ed. and re-installed sharepointRS_Addin in both FE servers and successfully initialized both with the reporting services configuration tool. after successfully granted database access to both FE's using CAS.  if i browse to                    http://WFE1:port/ReportServer/                    or                    http://WFE2:port/ReportServer/                    the database content is listed in browser.   if i browse to:                    http://NLB-sitename:port/ReportServer                    the database content gets listed also, tho it seams to list random conten

Excel Services to Oracle database

  We've set up a Sharepoint 2010 system on Windows Server 2008 R2. I'd like to set up Excel Services, so we can create dashboards to our back-end databases, which are Oracle. I'm struggling to get the data connection to work. To do this, should I be setting up my DSN with the 32-bit ODBC Oracle drivers, or the 64-bit ODBC Oracle drivers? Looking at the Excel Services setup, I think that the the list of trusted data sources provided are the 32-bit ODBC drivers. I did install the 32-bit ODBC oracle drivers, and set up the DSN I needed. When I log in to the Sharepoint server via RDC and load the Excel spreadsheet, the data connection works fine. But, when I use Excel Services to create a dashboard, and refresh the data connection, I get "Unable to refresh data for a data connection in the workbook." Looking at the Sharepoint log files, I see (password removed): The Connection Information is invalid: ConnectionString: DSN=nifoem;UID=sp_oem;PWD=[XXX];SERVER=nifoem;, CredentialsMethod: Integrated, SSOApplicationId: , QueryType: Odbc bd9d6ef3-6097-4ed5-9b8a-ffafc3997d26 Any idea what I might be doing wrong here? Thanks, John  

Analysis Services 2008 R2 Deployment - very frequent database overwrites

When regularly deploying an Analysis Services project from Visual Studio / BIDS to Analysis Services 2008 R2, the database must frequently be overwritten - on almost any change. For example, after a successful deploy and process, a seemingly minor change is made (e.g. changing the FormatString property for an existing Measure, or Arrange Tables in the Data Source View), and the next deploy and process attempt triggers the message: The 'ZZZ' database on 'ZZZ' has changed since the last time the project was deployed. If you proceed with deployment, the database will be overwritten. Would you like to continue? With earlier versions of SQL, this only occurred rarely, e.g. when deploying to a stale server. The impact is that testing almost any change requires a complete re-process of the database. Is anyone else striking this issue?  Thanks Mike

Full Farm Backup Fails on Windows Sharepoint Services Search Database

I am just now starting to us central administration to backup the entire sharepoint farm.  All content backups fine except for the Search Database.  In looking through the backup log, it appears that the search database may not exist.  How can I determine if the search database actually does exist and if it does not can it be recreated?

Migration / Export of Analysis Services 2000 database without affecting the source database

Hi! I´m am currently initating a migration of a 300GB Analysis Services database containing approx 50+ cubes. My issue is that the database is somewhat critical, and I just want to get a couple of answers and feedback before i press Go. My plan is to use the "Analysis Services Migration Wizard" to migrate the database to a new (test environment) server. Q1: I just want to migrate the structure, the metadata, is this what the migration wizard does? I don´t have 300GB disk space at the test server to accomodate all the data. We will start off with just a subset Q2: Since the data is 300GB+, it might take a very long time using the migration wizard. If that is the case, can I make a copy of the database in analysis manager 2000 and paste it with a different name, and the migrate this, empty, database? Would you see any trouble with this approach? Any other thoughts on this, somewhat massive, migration project? How would you do it? The most important this is that the old database cannot be touched, since this would mean a reprocess of 300GB data, on a server from the nineties... Cheers,

Same Role provider (ASP.NET Services database) for various WCF services


Hi there,

Service Authetnication

Have configured WCF service to implement authentication using AD(Active Directory), when a request comes from the client it is authenticated aginst active directory and either allow access or deny based on the credentials passed to the service.

Authorization using ASP.NET Role provider

Have implemented the method level authorization using SecurityPermission attribute, which checks the role data in ASP.NET Services database( in other words Membership database) against aspnet_roles, aspnet_Users_InRoles tables to allow / deny access to particular method.

It works well with single instance of service, where the request is from mutliple client applicaitons.

In the above implementation, WCF service is configured to use ASP.NET Membership database to implement authorization to authorize access to particular methods.


Would like to know if it is feasible/best practice to utilise the same instance of ASP.NET Membership databse to implement Role based authorization on number of WCF services.

[PrincipalPermission(SecurityAction.Demand, Role = <

SQL Server Analysis Services Backup error "Errors in the metadata manager. Either the database with


I get the following error when this perl script tries to backup the database using ASCMD.exe 2008 command line tool

<return xmlns="urn:schemas-microsoft-com:xml-analysis"><root xmlns="urn:schemas-
microsoft-com:xml-analysis:empty"><Exception xmlns="urn:schemas-microsoft-com:xm
l-analysis:exception" /><Messages xmlns="urn:schemas-microsoft-com:xml-analysis:
exception"><Error ErrorCode="3239313412" Description="Errors in the metadata man
ager. Either the database with the ID of &#39;xyz_old&#39; does not exi
st in the server with the ID of &#39;ABCD\Sql_AS&#39;, or the user doe
s not have permissions to access the object."
Source="Microsoft SQL Server 2008
Analysis Services" HelpFile="" /></Messages></root></return>

I have tried using different account for impersonation but everything fails.

Any help would be really appreciated.


Installation failed in database engine service and other services



im trying to install sql server 2008 r2 (x86) on my laptop. and im getting this failed (DATABASE ENGINE SERVICES AND SQL Server Replication)

can anybody help me with this?.....thank you

and this is the overall summary


Overall summary:
  Final result:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
  Exit code (Decimal):           -2061893608
  Exit facility code:            1306
  Exit error code:               24
  Exit message:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
  Start time:                    2010-09-23 23:58:25
  End time:     &n

'GDR 3080 for SQL Server Database Services 2005 ENU (KB970895)' could not be installed



When installing patch under KB970895, I receive the following erorr:

'GDR 3080 for SQL Server Database Services 2005 ENU (KB970895)' could not be installed. Error code 1651.

Here is part of the log for reference:

MSI (s) (38:DC) [12:26:53:220]: TRANSFORM: Modifying 'File' and 'Patch' rows added by this patch transform to have appropriate 'Sequence' values.  Offsetting values by 6677
MSI (s) (38:DC) [12:26:53:220]: TRANSFORM: Modifying 'PatchPackage' table row added by this patch transform to use 'Media_' value 101.
MSI (s) (38:DC) [12:26:53:220]: TRANSFORM: Modifying 'Media' table row added by this patch transform to use 'DiskId' value 101 and 'Source' values MSPSRCAB73742EF66144DF86520B13191943ED.
MSI (s) (38:DC) [12:26:53:220]: Transforming table MsiFileHash.

MSI (s) (38:DC) [12:26:53:220]: Note: 1: 2262 2: MsiFileHash 3: -2147287038
MSI (s) (38:DC) [12:26:53:230]: Transforming table MsiFileHash.

MSI (s) (38:DC) [12:26:53:231]: Transforming table MsiFileHash.

MSI (s) (38:DC) [12:26:53:231]: Note: 1: 2262 2: MsiFileHash 3: -2147287038
MSI (s) (38:DC) [12:26:53:231]: Transforming table MsiFileHash.

MSI (s) (38:DC) [12:26:53:231]: Transforming table MsiFileHash.

MSI (s) (38:DC) [12:26:53:231]: Note: 1: 2262 2: MsiFileHash 3: -2147287038
MSI (s) (38:DC)

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