i installed on SQL studio manager and attach database but i am not able to connect through SQL authentication only through Windows autantication

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

do i have to set user sa in the proxy account? see print screen
or else? because i tried to connect after i set there and i received error when connection with SQL autentication the error saying that success to establish connection but there is error with user
Screenshot-2013-10-21-15.29.50.png

Scott Pletcher

The native SQL (non-Windows) logins have a different sid on the new machine, so SQL can't automatically link the database user and the SQL login -- the problem is commonly called "orphaned user".

You need to re-link each SQL Server login with its appropriate login. Run the command below for every native SQL Server login to re-sync it:

USE [db_name_with_affected_users]
EXEC sp_change_users_login 'UPDATE_ONE', '<user_name>', '<login_name>'
EXEC sp_change_users_login 'UPDATE_ONE', '<user_name2>', '<login_name2>'
--...
--NOTE: Don't use the 'AUTO_FIX' option, since it can be flaky.

ASKER

so the line that i will have to run in the query should be:

USE [wf10]
EXEC sp_change_users_login 'UPDATE_ONE', 'sa', 'sa'

is that correct? i do not need to set password? the password is as it define in the machine?

Scott Pletcher

Sorry, I misunderstood the problem.

You don't need to reset 'sa', since it has a fixed sid. I thought you were having issues with other native SQL logins.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

this is what i have in tcp/ip see print screen

what to set there, how do i config it?

ASKER

i forgot to attach the picture
Screenshot-2013-10-21-16.22.42.png

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

here is print screen of the error
and how protocol is set in SQL server manager

please advice

Thanks
Screenshot-2013-10-22-09.59.41.png
Screenshot-2013-10-22-09.57.52.png

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

where i can find - "Get the detailed error log from SQL Server instance error log" the log file?

one more things i see that SQL Agent process is not coming up, is it mean that something is wrong? because in the old machine it was running

second in the Old machine the SQL user was "sa" and pass "15848" and now i am on new machine Windows server 2012 and in order to pass validation password i change the password to new one however i tried to log in with both password unsuccessfully

please advice

Thanks
Gvilbis

ASKER

here is print screen of the error in log file
how i can correct it

Thanks
Screenshot-2013-10-22-12.42.51.png

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.