Sql Server username and password

zhshqzyc
zhshqzyc used Ask the Experts™
on
Hi, I have a SQl Server 2008 R2, but I have not used it for a long time.
I don't remember whether it has an username or password.
Is "sa" a default built-in username?
Or it may have one I totally forget it.

Need help to dig up it.
Thanks.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
depends on how you set up security.

if you set it up with mixed mode security, then you will have an SA account within SQL but you will need to know the password.

Do you remember the user account you used for the install as that account may have admin rights within SQL.  You can also try the local administrator account.
You can always try windows authentication...

Author

Commented:
I didn't remember the user account. How can I find it? It also may not exist at all.
If there is not admin account, can I create a new one?
Top Expert 2012

Commented:

Author

Commented:
Because all the third party software is not free, just for demo. So I followed the first link to reset the new password for "sa". However when I login with "sa" and the password I just set. An error message:
TITLE: Connect to Server
------------------------------

Cannot connect to (local).

------------------------------
ADDITIONAL INFORMATION:

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.) (Microsoft SQL Server, Error: 233)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Open in new window

Author

Commented:
By enable tcp/ip in configure manager. It turns out another error
mssqlserver error 18456

Open in new window

Author

Commented:
log file:
ERRORLOG
Top Expert 2012

Commented:
The reason is "Server is configured for Windows authentication only"

Try logging in with Domain Admin

Author

Commented:
Totally mess up. I wanted to uninstall entire sql server 2008 r2 but failed several times from control panel. sqlIt gave me the successful message but the program is still there.
Top Expert 2012

Commented:
So, now you are trying to uninstall?

Author

Commented:
I tried to manually uninstall SQL Server with the following resources:

http://support.microsoft.com/kb/955404

http://social.msdn.microsoft.com/Forums/en/sqlexpress/thread/4d6158a1-b601-428c-aad4-a1716e76de1a 

http://support.microsoft.com/kb/909967 

However it seems no lucky and complicated. If there is no further advice by 3:00 pm, I am going to format C drive and reinstall everything. It is painful but it is worthful.

Top Expert 2012

Commented:
To be honest with you I can get it removed but if you are having this much issues I would just format

Author

Commented:
The problem is that
Instance Name MSSQLSERVER for product Microsoft SQL Server doesn't exist

Open in new window

I don't remember the instance name and now sql server is not working since I removed something.
Top Expert 2012
Commented:
There is ways to remove but again I would format

Author

Commented:
Thanks, point sfor your nice help. Let me do it now.
FORMAT C:

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial