Welcome to the Geeks & God Static Archive. Read more »

Sql Database Users In Asp.net

Joined: 11/28/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!

~Andrew~

Joined: 11/28/2008
Nexonen @ Aug 25 2008,
QUOTE(Nexonen @ Aug 25 2008, 11:37 AM)
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

SQL Server Logins

Did you ever figure out how to do this? I just browsed this forum and saw your post. If you still need help with this, I can give you some pointers.

Try windows integrated

Try windows integrated authentication. and run as administrator while management studio. this will help you accessing with windows integrated authentication.