September 8, 2009 at 5:21 am
Hello
when i want t o connet to SQL , when i use (Sa Password )
this message is appeared
A connection was successfully established with the server,
but then an error occured during the login process.
(provider:Shared Memory Provider , error :0- No process is in the
other end of the pipe)(Microsoft SQL Server , Error :233)
please help me
September 8, 2009 at 5:23 am
How are you connecting? SSMS or SQLCLI (comman line).
Adam Zacks-------------------------------------------Be Nice, Or Leave
September 8, 2009 at 5:25 am
Is the SQL service running? The error suggests that it is not.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 8, 2009 at 5:26 am
from Management Studio , File Connetion Object Explorer...
then i type IP and Sa and pass...
September 8, 2009 at 5:32 am
Assuming (as Gail suggested) that SQL is running, follow the instructions in http://dbaspot.com/forums/sqlserver-server/357071-sql-server-2005-login-connection-error-233-a.html and ensure that you can logn to the server.
I'm guessing your not using SSMS on the server itself.
Adam Zacks-------------------------------------------Be Nice, Or Leave
September 8, 2009 at 5:41 am
i should say that i forgot my password, and i tried to change it when i use new pass this error is occured ,i think i did not chane Sa Password correctly..... so how should i doo for change it correctly...
September 8, 2009 at 5:47 am
nazaninahmady_sh (9/8/2009)
i should say that i forgot my password, and i tried to change it when i use new pass this error is occured ,i think i did not chane Sa Password correctly..... so how should i doo for change it correctly...
Use this command:
sp_password NULL, 'NewPasswordGoesHere', 'sa'
As a side note, it's not a good idea to use 'sa' as a login to your database. You should create yourself a seperate login and leave the 'sa' well alone...
September 8, 2009 at 5:48 am
Are there any other SysAdmin accounts created?
If you have forgotten the SA password and dont have any other SysAdmins, I'm not sure what you can do, other then rebuild. Its not a large production system i hope.
Speaking for myself, i would never use the SA account and other then to set the password when the server is built (which goes in a password safe), the account would neve be used again other then a dire emergency.
Adam Zacks-------------------------------------------Be Nice, Or Leave
September 8, 2009 at 5:49 am
Clive Strong (9/8/2009)
nazaninahmady_sh (9/8/2009)
i should say that i forgot my password, and i tried to change it when i use new pass this error is occured ,i think i did not chane Sa Password correctly..... so how should i doo for change it correctly...Use this command:
sp_password NULL, 'NewPasswordGoesHere', 'sa'
As a side note, it's not a good idea to use 'sa' as a login to your database. You should create yourself a seperate login and leave the 'sa' well alone...
That wont work if he doesnt already have SysAdmin rights.
Adam Zacks-------------------------------------------Be Nice, Or Leave
September 8, 2009 at 5:49 am
thanks alot
but wher i should write this command? and how?
September 8, 2009 at 6:37 am
Schadenfreude-Mei (9/8/2009)
If you have forgotten the SA password and dont have any other SysAdmins, I'm not sure what you can do, other then rebuild. Its not a large production system i hope.
There is a backdoor. It's not easy to do. Before we go that far though....
Try logging in with windows authentication when logged in as a member of the local administrators group. Pre Vista/Server 2008, The windows group Builtin\administrators is by default sysadmin.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 8, 2009 at 6:39 am
- Is your sql instance using Mixed authentication ?
- did you check for the password with your peers ?
- I would try a remote desktop connection, making sure you get logged in to the windows box using a local administrator account.
Then use SQL Server Configuration Manager to check on the instance.
Then use SQLCMD or SSMS (prefered if available) to connect windows authenticated - and hope you get into the sqlinstance.
Then you can just provide sa with a new password. Keep in mind to inform your peers.
- We do not use the sa account for connecting to the instance. All sqladmins are member of their sqladmins windows domain group. They login into the sqlinstance using windows authentication.
- If applications need sqlauthentication, they are getting their own. (on a per application basis)
sql accounts have different passwords on every sqlinstance.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 8, 2009 at 10:55 am
GilaMonster (9/8/2009)There is a backdoor. It's not easy to do. Before we go that far though....
You are not talking about the backdoor using single user are you...:-D
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 8, 2009 at 2:13 pm
how do you do back door..to get sa pwd..i got a few copies of SQL on laptop but i forgot sa ...
so i can't get in....i was just going to rebuild it but if there a way would save me doing three installls of sql instances
September 8, 2009 at 6:17 pm
Silverfox (9/8/2009)
GilaMonster (9/8/2009)There is a backdoor. It's not easy to do. Before we go that far though....
You are not talking about the backdoor using single user are you...:-D
Yup.
I've had to use it before, after someone cleverly removed the last sysadmin login (sa disabled) on a test server.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply