"public" role in SQL 2005 Not available

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
User avatar
robreil
Captain (CAPT)
Captain (CAPT)
Posts: 340
Joined: Fri Jun 10, 2005 1:22 pm
Location: Kennesaw, Ga. USA
Contact:

"public" role in SQL 2005 Not available

Post by robreil » Sun Aug 02, 2009 7:00 pm

In following the 7.0 setup on Installation Readme it says:
Create a Database

These steps are not required if you have installed and are using the included SQL 2005 Express database file.

1. Create a new blank database. (only for Microsoft SQL Server 2000 or 2005)
2. Create a new user login, or use an existing login (username and password) and give this user access to the database.
3. Make sure the Permitted Roles are "public", "db_accessadmin", "db_securityadmin", "db_dlladmin", "db_datareader", "db_datawriter"
Using EMS SQL Manager 2008 for SQL server I was able to do step 3 but it did not list "public" as a role.

Where can I find a way to associate that role to the user SA that I created?

User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:

Re: "public" role in SQL 2005 Not available

Post by mazhar » Mon Aug 03, 2009 8:33 am

On management studio go to security menu and locate your user then right click and open properties dialog. Go to user mapping select database for user and then select desired roles from bottom pane.

User avatar
robreil
Captain (CAPT)
Captain (CAPT)
Posts: 340
Joined: Fri Jun 10, 2005 1:22 pm
Location: Kennesaw, Ga. USA
Contact:

Re: "public" role in SQL 2005 Not available

Post by robreil » Mon Aug 03, 2009 9:51 am

Thanks.. Got it....

Post Reply