Hello everyone.help please.When tested on
my PCI builtwebHandler,Ideducedthatthe image inDetailsview.
Vserdriver run, but
when you transferthe projectto theserverdisplays an error
andIdo not
want to work. :
System.Data.SqlClient.SqlException: Login failed for user 'NIPI\KW105$'.
I understand
that this is dueto myConnectionString,but do not knowwhere
to change thelogin name?
Here is myconnectionstring:
I tried
Integrated Security = SSPI -the result is the
sameerror. The connection stringis in the sectionConnectionStrings.Moreover,
this connection stringisused to displayanothergridview
namelyHandle'enot work.
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?
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
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
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.
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
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.
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.
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.
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.
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?