Link to home
Start Free TrialLog in
Avatar of cancerkats
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
Avatar of Programming_Gal
Programming_Gal

You have SQL Server set up to use Windows Authentication. Unless you are using Windows Authentication exclusively throughout your web site, you should have SQL Server set up to authenticate using mixed mode - this allows support for Windows Authentication AND passing credentials via clear text (e.g. a connection string from ASP). To make sure SQL Server is set up to be in mixed mode:

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
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?

Avatar of cancerkats

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.
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
ASKER CERTIFIED SOLUTION
Avatar of Programming_Gal
Programming_Gal

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thanks programming_gal and luani for suggestions.

it was of great help.

regards,
karthik