Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Dec 21, 2012 04:00 AM by ReSonance
Dec 19, 2012 07:19 AM|LINK
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$'.
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"
As can be seen,
that the login is
not explicitly NIPI \ KW105 $.
Who knows where can I change it?
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:
Dec 19, 2012 07:44 AM|LINK
already on the settings of Mixed Mode
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
Dec 19, 2012 08:01 AM|LINK
Integrated Security = SSPI - the result is the
The connection string is in the section
this connection string is used to display
namely Handle'e not work.
Access to this database
is open to all users
Dec 19, 2012 08:06 AM|LINK
Please provide connection timout in connection string.
like : ".............Initial Catalog=WEBNIPI;Connect Timeout=100"
Dec 19, 2012 08:32 AM|LINK
Unable to find the requested .Net Framework Data Provider. It may not be installed.
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.
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" />
Dec 19, 2012 09:38 AM|LINK
I deleted everything works as before.
And what should it