cancerkats
asked on
Error 18456 SQL Server login failed for user
Hello all,
Thank you for viewing this query. My query is as follows:
I have a SQL Server which was replicated from Server 1 to Server 2(as we want the website to be moved on to the 2nd server which runs on windows 2000). So, now in the second server the replicated SQL server is available. I have moved the webpages to the new server and am trying to create a DNS.
While i try to create the system DNS, it asks me for the dns name and server name, now which server must i choose? been given 3 options:
local, server 1, server 2.
must i choose local??
i tried choosing local (as the sql server is already in the server 2) and clicked next, and chose
"with sql server authetication using a login and password entered by user"
and entered the same login and password that was used for dsn in server 1 ......and i get the error
connection failed, sql state 25000
SQL Server Error : 18456
Login failed for the user "the login name i used"
(i had also changed the security authetication from "windows only" to "windows and sql server" . well, was asked to stop and resatrt sql server for this ...and i reight clicked on sql server (in enterprise manager to stop and start...is that all i must do for that?))
what must i do to be able to create dns successfully? are there anything else i must take into consideration? please help.
thanks
regards,
karthik
Thank you for viewing this query. My query is as follows:
I have a SQL Server which was replicated from Server 1 to Server 2(as we want the website to be moved on to the 2nd server which runs on windows 2000). So, now in the second server the replicated SQL server is available. I have moved the webpages to the new server and am trying to create a DNS.
While i try to create the system DNS, it asks me for the dns name and server name, now which server must i choose? been given 3 options:
local, server 1, server 2.
must i choose local??
i tried choosing local (as the sql server is already in the server 2) and clicked next, and chose
"with sql server authetication using a login and password entered by user"
and entered the same login and password that was used for dsn in server 1 ......and i get the error
connection failed, sql state 25000
SQL Server Error : 18456
Login failed for the user "the login name i used"
(i had also changed the security authetication from "windows only" to "windows and sql server" . well, was asked to stop and resatrt sql server for this ...and i reight clicked on sql server (in enterprise manager to stop and start...is that all i must do for that?))
what must i do to be able to create dns successfully? are there anything else i must take into consideration? please help.
thanks
regards,
karthik
1.
You should use "server 2" cos' Replication does not support naming local
2.
"and entered the same login and password that was used for dsn in server 1 ......and i get the error "
have transfered/opened the login/users same as in server 1 on server 2?
You should use "server 2" cos' Replication does not support naming local
2.
"and entered the same login and password that was used for dsn in server 1 ......and i get the error "
have transfered/opened the login/users same as in server 1 on server 2?
ASKER
Thanks for you comments.
programming_gal, I had already clicked on SQL Server & Windows for security authentication.
Luani, how do i transfer/open the login/users from server 1 to sever 2?
I am sorry, I am quite new to SQL server and replication of SQL server was done by someone else. how can i check if teh users\login name have been tranferred aswell? if not...how can i do so.
Please advice.
Thank you.
regards,
karthik.
programming_gal, I had already clicked on SQL Server & Windows for security authentication.
Luani, how do i transfer/open the login/users from server 1 to sever 2?
I am sorry, I am quite new to SQL server and replication of SQL server was done by someone else. how can i check if teh users\login name have been tranferred aswell? if not...how can i do so.
Please advice.
Thank you.
regards,
karthik.
ASKER
hello all,
the problem is solved....i was using a wrong user login. :( and wasted hours to figure out the problem.
anyways, i set up a dsn for sql on the replicated sever and tried accessing the webpage....
while accessing the .asp pages i get this error:
MS VBScript runtime error(0x800A01B6)
Object doesnt support this property or method: 'localMatch'
abc/include/include1.inc
similarly another asp page which sends mail....works fine on server 1 but on server 2 says
permission denied..
i am not sure if its problem with iis server .....as i had tested another simple asp page which i had created and it works.
the same page works just fine in server 1 from which i had replicated.
please advice as to whats going wrong?
thanks
regards,
karthik
the problem is solved....i was using a wrong user login. :( and wasted hours to figure out the problem.
anyways, i set up a dsn for sql on the replicated sever and tried accessing the webpage....
while accessing the .asp pages i get this error:
MS VBScript runtime error(0x800A01B6)
Object doesnt support this property or method: 'localMatch'
abc/include/include1.inc
similarly another asp page which sends mail....works fine on server 1 but on server 2 says
permission denied..
i am not sure if its problem with iis server .....as i had tested another simple asp page which i had created and it works.
the same page works just fine in server 1 from which i had replicated.
please advice as to whats going wrong?
thanks
regards,
karthik
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks programming_gal and luani for suggestions.
it was of great help.
regards,
karthik
it was of great help.
regards,
karthik
Open Enterprise Manager;
Expand a server group;
Right-click a server, and click Properties;
Click the Security tab;
Under Authentication, click SQL Server and Windows.
Now, make sure you have a valid user set up to access your tables, views and procedures
http://www.aspfaq.com/show.asp?id=2138