Help creating user account with which to access my DB from my App

[Kobojunkie]

I need to create a role that allows me to log in from my application, carry out basic DML manipulations and SELECT without compromising the security of my database. Is there a tutorial or walk through that can help with this please? Thanks in advance

Login failed for user 'username'. The user is not associated with a trusted SQL Server connection.


Additional Information on what I have actually done here to help. I created a Login and then a Role account. I then created a User account and assigned the Login and the Role to it. I still get the above error message when I try to connect.

CREATE LOGIN MagicCoaster WITH PASSWORD = 'SpaceCoaster';

CREATE ROLE [PublicDBUser] AUTHORIZATION [main_dbuser]

USE SpeakersBoxOffice;

CREATE USER MagicCoaster FOR LOGIN MagicCoaster
WITH DEFAULT_SCHEMA = PublicDBUser;

GO

 

[Kobojunkie]

I am still unable to create a good login to use with my database. Anyone know what could be wrong with the above please?

 

[mrdenny]

Your SQL Server appears to be setup for Windows Auth only. You'll need to change it from Windows Auth only to Windows and SQL Auth.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog