Hi,
I have a website with mssql data base recently I got this error:
it's showing error as 'Microsoft OLE DB Provider for SQL Server error '80040e4d'
Login failed for user
/includes/connect.inc, line 23
As I am a new to this data base I dont know how to Log in to my data base and rectify it can any one help me in this I am a naive in this....recently I got this error...So, where you able to log in previously, and now suddenly you can't? Or have you never made a connection with this database server before?
Who is the DBA for the server?|||KBA http://support.microsoft.com/default.aspx/kb/222828 fyi.|||So, where you able to log in previously, and now suddenly you can't? Or have you never made a connection with this database server before?
Who is the DBA for the server?
Till now i have not made a connection with this data base server as everything was done by my developer now he is not seen|||KBA http://support.microsoft.com/default.aspx/kb/222828 fyi.
I dont know how to open that control panel and do that as I dont know anything about this pls can you guide me ?|||No, back up way further than that.
Who administers the database server?
Have you been granted access to the server either through your network login or a specified SQL Server login and password.|||KBA http://support.microsoft.com/default.aspx/kb/222828 fyi.
I used this now and rectified but the problem still excists I think I have to try doing this :
http://support.microsoft.com/kb/292644/en-us
I am not sure how to do it Can any one help me ?|||No, back up way further than that.
Who administers the database server?
Have you been granted access to the server either through your network login or a specified SQL Server login and password.
I have the user id and password to log in before my developer did it after that he left not seen around so to safe guard the data base and ftp i asked my hosting company to change my password after which this i get this error message.|||that explains that. you changed the password to the sql server without updating the one the application uses in the sourcecode.|||Yes I recently asked my hosting company to change the password Now kindly let me know how should i rectify the error using this ?
http://support.microsoft.com/kb/292644/en-us
wishes|||you probably have to go into your application sourcecode and update the password in your connection string(s).|||you probably have to go into your application sourcecode and update the password in your connection string(s).
Yes I know I have to do this :
http://support.microsoft.com/kb/292644/en-us
But I dont know How to do this as I tried many ways but I dont know how to do it|||I had not clicked on the link. Are you using the sa account for your application? If so you have bigger problems. That is a ginormous security no-no.
As for how to change the password in the application, I guess you need to hire a computer programmer.|||Could be in a config file...|||This happend only after i changed the data base password from the hosting side I dont know how to solve this problem|||Julie,
The password for your application is either in a config file or embedded in the application code. You will need the original application code, or you will need to contact the application developer. Other than that, there is not much help we can give you.|||From the original error message, go to the file at:
/includes/connect.inc
Open this up with notepad. Look for the old password on line 23 or before. Change that out with the new password, and test.|||From the original error message, go to the file at:
/includes/connect.inc
Open this up with notepad. Look for the old password on line 23 or before. Change that out with the new password, and test.
I went to the /inlcudes/connect.inc and I dont see the password I just see the following:
Function Login
'StrUsername = cint(Request.Form("username"))
'StrPassword = Trim(Request.Form("password"))
Dim conn, rs, sql
Set conn = Server.CreateObject("ADODB.Connection")
conn.open Strpro
Set rs = Server.CreateObject("ADODB.Recordset")
'SQL = "SELECT ID,Password FROM register WHERE ID= ('"& Replace(StrUsername,"'","''") &" ') AND password ('"& Replace(StrPassword,"'","''") &" ') OR Email= ('"& Replace(StrUserid,"'","''") &" ') "
sql = "SELECT * FROM admin_login WHERE username= '" & Replace(Request.Form("Username"),"'", "''") & "' AND password = '" & Replace(Request.Form("Password"),"'", "''") & "' "
Kindly advice what should I do in this ?|||you want the password that will be set in this variable "Strpro". The password you are looking at in this code is for the application. The one set in "Strpro" is for the server.
The code you need will look like...
Set Strpro = "some stuff in here"|||you want the password that will be set in this variable "Strpro". The password you are looking at in this code is for the application. The one set in "Strpro" is for the server.
The code you need will look like...
Set Strpro = "some stuff in here"
ok let me try to find out but Even if you see this is for the Application we dont see any password ?|||under all probability the connection details are there in the file /includes/connect.inc somewhere near line 23 and the application is an ASP application. open that file (download it from the server if needed) and you will find the connection string where the password is written.|||sorry for the misleading late post...i missed the 2nd page...|||I tried my level best but I was not able to get connected so I just went back to my old password :(|||I tried to change my password from the Host Once again I get the same problem.
I get a error report :
Microsoft OLE DB Provider for SQL Server error '80040e4d'
Login failed for user
/includes/connect.inc, line 23
Kindly help me in this|||Line 23 in the Connect.inc file is where the connection object is having the Open method invoked. However, there are several ways to supply all the required parameters. Do you see the word "Password" in the code before line 23? Or does (oh the horror) the connect.inc require other files?|||Hire someone who know what they are doing?|||Hire someone who know what they are doing?
...about the same solution I arrived at a week ago:
Julie,
The password for your application is either in a config file or embedded in the application code. You will need the original application code, or you will need to contact the application developer. Other than that, there is not much help we can give you.
