connection

[fmardani]

This is the connection string that I would like to use to connect to sql 2K
<add key="ConnectionString" value="server=(local);database=DCTKB;trusted_connection=true"/>

The error message is:
Login failed for user 'GBWS-00065768\ASPNET

In the query analyser I can log on to my local machine which is called GBWS-00065768 using windows authentication
How can i connect to the database using the above connectionstring?
Thanks

[tailz]

Had the same problem and I spent ages beating SQL server into submission the other day

I believe I had to add my user account 'domain\user' under EM>Security>Logins

You can add groups as well so adding 'domain\administrators' is mebbe what you want

[tailz]

clicked post, THEN thought about the answer.

I may have just assigned the aspnet user "public" access to my database

it was definetly summat I clicked in there lol

[fmardani]

I have that already.
Any thoughts?
Thanks

[tailz]

A couple. One involves going to pub.

The other being, do you have to use that connection string?

What happens if you use this one;

data source=(local);initial catalog=DCTKB;integrated security=SSPI;persist security info=False;packet size=4096

[Mike Hildner]

Have you added the user {DOMAINNAME}\ASPNET in both the instance of SQL Server and the database you wish to access?

[fmardani]

Thanks guys.
The problem was that I had to reset the sql server security to sql as well as windows.

[Mike Hildner]

heh, I didn't even think of that. FWIW, I guess you can log in as a specific user if you want to, or need to, rather than use integrated and end up being ASPNET.

[tailz]

not a problem, glad I was of no assistance

beer time.