System.Data.SqlClient.SqlException: Login failed RSS

• • Reply
  

  ReSonance

  Member

  10 Points

  84 Posts

  System.Data.SqlClient.SqlException: Login failed

  Dec 19, 2012 07:19 AM|LINK

  Hello everyone. help please. When tested on my PC I built webHandler, I deduced that the image in Detailsview. Vser driver run, but when you transfer the project to the server displays an error and I do not want to work. :
  

  System.Data.SqlClient.SqlException: Login failed for user 'NIPI\KW105$'.

  I understand that this is due to my ConnectionString, but do not know where to change the login name? Here is my connectionstring:

  <add name="Chaos" connectionString="Provider=SQLOLEDB;Data Source=KW200;Password=111111;User ID=www;Initial Catalog=WEBNIPI"
              providerName="System.Data.OleDb" />

  
  As can be seen, that the login is not explicitly NIPI \ KW105 $. Who knows where can I change it?
  

• • Reply
  

  furry

  Member

  584 Points

  108 Posts

  Re: System.Data.SqlClient.SqlException: Login failed

  Dec 19, 2012 07:29 AM|LINK

  Configure your SQL Server to run in "Mixed Mode" which is "SQL Server and Windows Authentication Mode"

  you can find it in Properties of your Server in Management Studio under Security tab.

  for more info:

  http://msdn.microsoft.com/en-us/library/aa215470(v=sql.80).aspx

  Please mark it as Answer, if it answers your question.
• • Reply
  

  ReSonance

  Member

  10 Points

  84 Posts

  Re: System.Data.SqlClient.SqlException: Login failed

  Dec 19, 2012 07:44 AM|LINK

  I'm already on the settings of Mixed Mode

• • Reply
  

  sameer_khanj...

  Contributor

  7060 Points

  1378 Posts

  Re: System.Data.SqlClient.SqlException: Login failed

  Dec 19, 2012 07:47 AM|LINK

  1) You need to grant access to your user to your WEBNIPI database.

  2) Try using just Integrated Security=SSPI in your connectiong string and see if it connects instead of user name and password.

  3)Make sure connection string in the ConnectionStrings section of web.config

  
  sameer.khanjit@gmail.com 
  View Blog
  Click "Mark as Answer" on the post that helped you.
  • Edited by sameer_khanjit on Dec 19, 2012 07:48 AM
• • Reply
  

  ReSonance

  Member

  10 Points

  84 Posts

  Re: System.Data.SqlClient.SqlException: Login failed

  Dec 19, 2012 08:01 AM|LINK

  I tried Integrated Security = SSPI - the result is the same error.
  The connection string is in the section ConnectionStrings. Moreover, this connection string is used to display another gridview namely Handle'e not work.
  
  Access to this database is open to all users

• • Reply
  

  sameer_khanj...

  Contributor

  7060 Points

  1378 Posts

  Re: System.Data.SqlClient.SqlException: Login failed

  Dec 19, 2012 08:06 AM|LINK

  Please provide connection timout in connection string.

  like :  ".............Initial Catalog=WEBNIPI;Connect Timeout=100"

  
  sameer.khanjit@gmail.com 
  View Blog
  Click "Mark as Answer" on the post that helped you.
• • Reply
  

  ReSonance

  Member

  10 Points

  84 Posts

  Re: System.Data.SqlClient.SqlException: Login failed

  Dec 19, 2012 08:32 AM|LINK

  Error ...

  Unable to find the requested .Net Framework Data Provider.  It may not be installed.
  
  

• • Reply
  

  furry

  Member

  584 Points

  108 Posts

  Re: System.Data.SqlClient.SqlException: Login failed

  Dec 19, 2012 08:36 AM|LINK

  Have you tried connecting you application server to DB server using "Data Sources (ODBC)" (inside administrative tools)

  try to connect using ODBC wizard using SQL Authentication, if you haven't and hit the applications.

  in my experience, it does the trick sometimes.

  in addition, can you provide us the error code.

  Please mark it as Answer, if it answers your question.
• • Reply
  

  sameer_khanj...

  Contributor

  7060 Points

  1378 Posts

  Re: System.Data.SqlClient.SqlException: Login failed

  Dec 19, 2012 08:37 AM|LINK

  Please remove dataprovider in Coonection string 

  and your connection stirn should be like this 

  <add name="NAME" connectionString="connectionstring without provider"  providerName="System.Data.SqlClient" />

  
  sameer.khanjit@gmail.com 
  View Blog
  Click "Mark as Answer" on the post that helped you.
• • Reply
  

  ReSonance

  Member

  10 Points

  84 Posts

  Re: System.Data.SqlClient.SqlException: Login failed

  Dec 19, 2012 09:38 AM|LINK

  OK, I deleted everything works as before. And what should it be given?