Sql Server 2012 Error --- can not connect.....

I just installed Sql Server 2012 and when I tried to access it via sql management studio, i get the following error:

Error
Any ideas?
LVL 5
IsaacSharePoint Client Side DeveloperAsked:
Who is Participating?
 
DcpKingConnect With a Mentor Commented:
If you install with Mixed Mode you'll be asked for a password for the sa login. Remember it!!!!!  :)

Then you can use that to log in and to create Windows Logins for users - yourself, for one - and grant them permissions as you see fit.

hth


Mike
0
 
DcpKingCommented:
On the same box? Add this to your hosts file (in C:\WINDOWS\system32\drivers\etc) :

127.0.0.1 localhost

Otherwise, is your server in the SOGUNRO domain? Trying to get in from another domain may well give you this problem. Check your Active Directory settings, and also check that your id is a valid logon for the instance of SQL Server.

hth

Mike
0
 
IsaacSharePoint Client Side DeveloperAuthor Commented:
Before I saw your message, I restarted the server and now when sql server comes up, it says this

Login failed for user 'Sogunro\Administrator'
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
Alpesh PatelConnect With a Mentor Assistant ConsultantCommented:
First try with "SA" give permission to that user and try again.

It will login for the user.
0
 
IsaacSharePoint Client Side DeveloperAuthor Commented:
Not sure how to do that.  It's my first time installing SQL Server
0
 
DcpKingCommented:
There's a point in the setup where you have to decide on the Authentication method - Windows, SQL Server, or combined ("Mixed-Mode").  Which did you choose? Hopefully the latter, which allows you to use Windows logons and also allows you to get in using the SA identity (for which you'll have been asked for a password.

Have you tried logging in using the sa identity yet?

Mike
0
 
IsaacSharePoint Client Side DeveloperAuthor Commented:
I chose Mixed-Mode...
Not sure I remember coming across anything about SA identity.

So, I uninstalled it and will try installing it all over again
Hopefully, I do it right this time.
0
 
IsaacSharePoint Client Side DeveloperAuthor Commented:
Sorry for the late response.  I've been busy with a project.
I plan on taking care of this during the 3 day weekend.
I will give an update.

Thanks again!
0
 
DcpKingCommented:
ok - I'll be watching out for cries for help!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.