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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy