[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 286
  • Last Modified:

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?
0
Isaac
Asked:
Isaac
  • 4
  • 4
2 Solutions
 
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
 
Alpesh PatelAssistant ConsultantCommented:
First try with "SA" give permission to that user and try again.

It will login for the user.
0
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
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
 
DcpKingCommented:
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
 
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now