 |  |  |  |  |  |  |  |
"System.Data.SqlClient.SqlException: Login failed for user 'VASANT\ASPNET'."
Please support our ASP.NET advertiser: Intel Parallel Studio Home
Thread Solved |
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..?
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..?
•
•
Join Date: Oct 2007
Posts: 1,296
Reputation: 
Solved Threads: 67
Re: "System.Data.SqlClient.SqlException: Login failed for user 'VASANT\ASPNET'."
0
#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?
Computers are man's attempt at designing a cat: It does whatever it wants, whenever it wants, and rarely ever at the right time.
Re: "System.Data.SqlClient.SqlException: Login failed for user 'VASANT\ASPNET'."
0
#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....
after restoring it into my pc i changed the conn string to match my settings....
•
•
•
•
Originally Posted by majestic0110 
Is your username VASANT\ASPNET ? if so, then is that the same username that was used to create the original database?
•
•
Join Date: Oct 2007
Posts: 1,296
Reputation:
Solved Threads: 67
Re: "System.Data.SqlClient.SqlException: Login failed for user 'VASANT\ASPNET'."
0
#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)
Computers are man's attempt at designing a cat: It does whatever it wants, whenever it wants, and rarely ever at the right time.
•
•
Join Date: Oct 2007
Posts: 1,296
Reputation:
Solved Threads: 67
Re: "System.Data.SqlClient.SqlException: Login failed for user 'VASANT\ASPNET'."
0
#5 Mar 31st, 2008
just a thought, post your conn string:
Does it include?
Does it include?
•
•
•
•
Integrated Security=SSPI;
Last edited by majestic0110; Mar 31st, 2008 at 11:19 am.
Computers are man's attempt at designing a cat: It does whatever it wants, whenever it wants, and rarely ever at the right time.
Re: "System.Data.SqlClient.SqlException: Login failed for user 'VASANT\ASPNET'."
0
#6 Mar 31st, 2008
this is the connection string i'm using currently:
ASP.NET Syntax (Toggle Plain Text)
•
•
Join Date: Oct 2007
Posts: 1,296
Reputation:
Solved Threads: 67
Re: "System.Data.SqlClient.SqlException: Login failed for user 'VASANT\ASPNET'."
0
#7 Mar 31st, 2008
try changing "true" to "SSP1" let me know how it goes
Computers are man's attempt at designing a cat: It does whatever it wants, whenever it wants, and rarely ever at the right time.
 |
Other Threads in the ASP.NET Forum
- Previous Thread: how to refresh the page automatically in asp.net 2005 [even used meta tag also]
- Next Thread: Master Page Links Problem
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Latest ASP.NET Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
.net 2.0 activexcontrol advice ajax alltypeofvideos appliances application asp asp.net bc30451 beginner bottomasp.net box browser button c# cac checkbox click commonfunctions css dataaccesslayer database datagridview datagridviewcheckbox datalist development dgv dialog dropdownlist dynamically edit expose feedback fileuploader fill flash form formatdecimal formview google grid gridview gudi iframe iis image javascript listbox login microsoft mono mouse mssql multistepregistration news numerical opera panelmasterpagebuttoncontrols parent radio redirect registration relationaldatabases reportemail rotatepage save schoolproject search security select sessionvariables silverlight smartcard smoobjects software sql-server sqlserver2005 suse textbox tracking treeview unauthorized validatedate validation vb.net video videos view virtualdirectory vista visualstudio web webapplications webdevelopemnt webprogramming webservice xsl youareanotmemberofthedebuggerusers
