User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the ASP.NET section within the Web Development category of DaniWeb, a massive community of 373,375 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,813 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our ASP.NET advertiser: Lunarpages ASP Web Hosting
Views: 942 | Replies: 6 | Solved
Reply
Join Date: Oct 2006
Posts: 6
Reputation: spring_patel is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
spring_patel spring_patel is offline Offline
Newbie Poster

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

  #1  
Mar 31st, 2008
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..?
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Oct 2007
Location: Bristol, UK
Posts: 1,122
Reputation: majestic0110 is on a distinguished road 
Rep Power: 3
Solved Threads: 46
majestic0110's Avatar
majestic0110 majestic0110 is offline Offline
Veteran Poster

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

  #2  
Mar 31st, 2008
Is your username VASANT\ASPNET ? if so, then is that the same username that was used to create the original database?
If you have a quality, be proud of it and let it define you. Add it to the world!
If you got your answer, please mark the thread as Solved. It saves time when people are looking to contribute threads or for answers!
Reply With Quote  
Join Date: Oct 2006
Posts: 6
Reputation: spring_patel is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
spring_patel spring_patel is offline Offline
Newbie Poster

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

  #3  
Mar 31st, 2008
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....


Originally Posted by majestic0110 View Post
Is your username VASANT\ASPNET ? if so, then is that the same username that was used to create the original database?
Reply With Quote  
Join Date: Oct 2007
Location: Bristol, UK
Posts: 1,122
Reputation: majestic0110 is on a distinguished road 
Rep Power: 3
Solved Threads: 46
majestic0110's Avatar
majestic0110 majestic0110 is offline Offline
Veteran Poster

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

  #4  
Mar 31st, 2008
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)
If you have a quality, be proud of it and let it define you. Add it to the world!
If you got your answer, please mark the thread as Solved. It saves time when people are looking to contribute threads or for answers!
Reply With Quote  
Join Date: Oct 2007
Location: Bristol, UK
Posts: 1,122
Reputation: majestic0110 is on a distinguished road 
Rep Power: 3
Solved Threads: 46
majestic0110's Avatar
majestic0110 majestic0110 is offline Offline
Veteran Poster

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

  #5  
Mar 31st, 2008
just a thought, post your conn string:
Does it include?

Integrated Security=SSPI;
Last edited by majestic0110 : Mar 31st, 2008 at 10:19 am.
If you have a quality, be proud of it and let it define you. Add it to the world!
If you got your answer, please mark the thread as Solved. It saves time when people are looking to contribute threads or for answers!
Reply With Quote  
Join Date: Oct 2006
Posts: 6
Reputation: spring_patel is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
spring_patel spring_patel is offline Offline
Newbie Poster

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

  #6  
Mar 31st, 2008
this is the connection string i'm using currently:
<add key="ConnectionString" value="Data Source=VASANT;Initial Catalog=MillTown;Integrated Security=True"/>
Reply With Quote  
Join Date: Oct 2007
Location: Bristol, UK
Posts: 1,122
Reputation: majestic0110 is on a distinguished road 
Rep Power: 3
Solved Threads: 46
majestic0110's Avatar
majestic0110 majestic0110 is offline Offline
Veteran Poster

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

  #7  
Mar 31st, 2008
try changing "true" to "SSP1" let me know how it goes
If you have a quality, be proud of it and let it define you. Add it to the world!
If you got your answer, please mark the thread as Solved. It saves time when people are looking to contribute threads or for answers!
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

DaniWeb ASP.NET Marketplace
Thread Tools Display Modes

Other Threads in the ASP.NET Forum

All times are GMT -4. The time now is 3:03 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC