December 28, 2010 at 10:19 pm
Hi,
i've installed SQL Server 2008 R2 in my system and after that i've updated the 'sa' account using the script
USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N'blah' MUST_CHANGE
GO
and after the restart of services, i tried to login as 'sa' user. Unfortunately it is giving me some error:
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (.Net SqlClient Data Provider)
Server Name: XYZ\SQLEXPRESS
Error Number: 233
Severity: 20
State: 0
i've enable namedpipes in Sql Server configuration manager. Could anyone pl. tell me how can i fix this issue.
Thanks&Regards,
Anilkumar M.S
December 28, 2010 at 10:22 pm
as it is mixed mode authentication, you can login with domain admin or if your windows id have enough permission on server and domain then connect the sql server with your/domain_Admin account.
Login with that account and fix sa id.
----------
Ashish
December 28, 2010 at 10:23 pm
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (.Net SqlClient Data Provider)
Server Name: XYZ\SQLEXPRESS
Error Number: 233
Severity: 20
State: 0
Is this exactly the name under which your SQL service is running if you look at computer services (start, run, services.msc).
Why did you choose to "MUST CHANGE" after login?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply