Database Access Using SOAP and REST Web services

hi,

i created a service like this

  [OperationContract (Name = "GetAllCustomer")]
        [WebInvoke(ResponseFormat = WebMessageFormat.Json,
            BodyStyle = WebMessageBodyStyle.Wrapped,
            UriTemplate="/View/Data?format={fr}",
            Method="GET"
            )]
        Customer[] GetAllCustomer();


 public class Customer
    {
        [DataMember]
        public int CNo { get; set; }
        [DataMember]
        public string CName { get; set; }
      }

  and access my db in service.svc.cs

 List<Customer> lstEmp = new List<Customer>();

 String connString = ConfigurationManager.ConnectionStrings["connWebOrdering"].ConnectionString;
            SqlConnection sqlConn = new SqlConnection(connString);
            sqlConn.Open();

           SqlDataAdapter da = new SqlDataAdapter("Select [cid], [cname] from [CustomerDB].[dbo].[contact] ", sqlConn);
            DataSet ds = new DataSet();
       &

Hello,

I need to grant access to the database (under Analysis Services).  I have a few questions.  Can I use an account that I created under the database engine (sql account) to have access to a database under the Analysis services?

I did some reading on MS below.  It seems to show only a domain account access under membership in Role.

http://technet.microsoft.com/en-us/library/ms175421%28SQL.100%29.aspx

Please advice.

Tntrac

Hi.,

I created a new database with the help of Database Configuration Assistant !

I created with the scott account

Now i'm not able to connect to the database with the connect identifier with the scott account

The error i get is.,

Plz help !

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

In this article, the author delves into some commonly used ways of writing data access code and looks at the effect they can have on performance.

Bob Beauchemin

MSDN Magazine August 2009

In this article the author looks at two versions of the same application--one consuming an on-premise Data Service, and one consuming an Azure Table Data Service to illustrate data access in the cloud.

Elisa Flasko

MSDN Magazine May 2009