"System.Data.SqlClient.SqlException: Login failed for user 'VASANT\ASPNET'."

[spring_patel]

hi guys,

i'm upgrading a web application designed in visual studio 2003 to visual studio 2005.
i want to start from the scratch.

I've restored the database from the older application in sql server 2000 from another machine.

now whenever i try to execute that application an error is displayed stating

"System.Data.SqlClient.SqlException: Login failed for user 'VASANT\ASPNET'."

my sql server uses windows authentication mode,and i've made changes in the connectionstring accordingly...

but still it shows this error...

can ny body help me get rid of it..?

[majestic0110]

Is your username VASANT\ASPNET ? if so, then is that the same username that was used to create the original database?

[spring_patel]

well no 'VASANT' is the server name, and in original conn. string 'sa' login was used with a blank password,

after restoring it into my pc i changed the conn string to match my settings....

Is your username VASANT\ASPNET ? if so, then is that the same username that was used to create the original database?

[majestic0110]

I understand that VASANT is the server name what I am trying to get at is:is the username the same when the db was created as the username you are now using? (Ie. username = sa at both times)

[majestic0110]

just a thought, post your conn string:
Does it include?

Integrated Security=SSPI;

[spring_patel]

this is the connection string i'm using currently:

<add key="ConnectionString" value="Data Source=VASANT;Initial Catalog=MillTown;Integrated Security=True"/>

[majestic0110]

try changing "true" to "SSP1" let me know how it goes