August 25, 2008 - 1:43pm
Nexonen @ Aug 25 2008,
I am finally trying out ASP.NET. I'm using SQL Server Express, with IIS on my local machine running XP. I'm trying to install dash commerce. I have used Management Studio Express to create a database. The problem I'm having is I don't understand this thing about users and logins!
I'm getting an error: "The user is not associated with a trusted SQL Server connection." Question is - how do I create a user for the database, and a login? A step-by-step would be much appreciated!
In the SQL Management Studio create a user and give it permission on the database , 'owner' should be enough you can do this under SECURITY|LOGINS in this panel also setup the User Mappings for the database you want to give 'owner' permission.
Gavin
May 12, 2009 - 11:34am
I am finally trying out ASP.NET. I'm using SQL Server Express, with IIS on my local machine running XP. I'm trying to install dash commerce. I have used Management Studio Express to create a database. The problem I'm having is I don't understand this thing about users and logins!
I'm getting an error: "The user is not associated with a trusted SQL Server connection." Question is - how do I create a user for the database, and a login? A step-by-step would be much appreciated!
~Andrew~