Connection string username and password with WCF service

Dec 18, 2009 at 4:26 PM

Hello Andrea,

I got a new machine and while installing .NET SQL Azman, I noticed that I had in the Wcf Service connection string the following:

Data Source=LGONZAL-9321P2C\MSSQLSERVER08;Initial Catalog=NetSqlAzManStorage;User ID=appuser0;Password=******

Which was working fine in my previous machine, that machine is gone now.

I don't remember how this I set this user (appuser0) and neither I can find the documentation of what I did to set it up. I would appreciate if you point me in the right direction on how to set this user so that my WCF service can access the .NET SQL Azman store and provide authorization information to the applications consuming the service.

Thank you in advance Andrea

Cordially,

Luis

 

Coordinator
Dec 19, 2009 at 7:16 AM

Hi Luis,

appuser0 should be a member of NetSqlAzMan_Readers SQL Role (at least).

- NetSqlAzMan_Administrators (full control)

- NetSqlAzMan_Managers (can manage Store/Application permissions)

- NetSqlAzMan_Users (only reading and delegate permission on Item with Allow with delegation permission)

- NetSqlAzMan_Readers (read only – minimum permission to perform a CheckAccess)

Regards,

Andrea.

__________________________________
Andrea Ferendeles
NetSqlAzMan Project Coordinator  
E-mail aferende@hotmail.com Web http://netsqlazman.codeplex.com

Dec 21, 2009 at 1:40 AM
Thank you Andrea,

I thought this was part of a script that was provided, but I already added the user.

Thank you very much

Cordially,

Luis



From: [email removed]
To: [email removed]
Date: Sat, 19 Dec 2009 00:16:12 -0800
Subject: Re: Connection string username and password with WCF service [netsqlazman:78574]

From: aferende

Hi Luis,

appuser0 should be a member of NetSqlAzMan_Readers SQL Role (at least).

- NetSqlAzMan_Administrators (full control)

- NetSqlAzMan_Managers (can manage Store/Application permissions)

- NetSqlAzMan_Users (only reading and delegate permission on Item with Allow with delegation permission)

- NetSqlAzMan_Readers (read only – minimum permission to perform a CheckAccess)

Regards,

Andrea.

__________________________________
Andrea Ferendeles
NetSqlAzMan Project Coordinator
E-mail aferende@hotmail.com Web http://netsqlazman.codeplex.com

Read the full discussion online.
To add a post to this discussion, reply to this email (netsqlazman@discussions.codeplex.com)
To start a new discussion for this project, email netsqlazman@discussions.codeplex.com
You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe on CodePlex.com.
Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at CodePlex.com


Hotmail: Free, trusted and rich email service. Get it now.