[PCTech]

@JD, what can I say, your the best!

I found 2 solutions, I can either get an Sql Administrator program to add permissions to users, as I can't find the Enterprise manager that "supposedly" was installed with SQL2k5 beta, (i swear it aint there), I am going to google for a free msde administrator progam so I can add permissions to different users like "machinename\aspnet"

then I found the below which I will try using the computer administrator and password

Quote:

Check your web.config file.

Looks like your SQL server is not set up for the correct trusted
connection. What you can do is be specific with the connection string

Change the line in the web.config file from:

<add key="ConnectionString"
value="server=localhost;Trusted_Connection=true;da tabase=portal" />

to:

<add key="ConnectionString" value="server=localhost;user
id=username;password=yourpassword;database=Portal" />

where username is a valid SQL username and yourpassword is the password
for the username.

You can use sa as the username or whatever you need.