Unable to connect to SQL Server 2012

I am attempting to connect to a server after 3 failed attempts to install SQL Server Management Studio 2012.

See attached for error message.

I confirmed on another machine that I am able to log into the correct server using windows authentication.  My IT department has reinstalled the software 3 times and on the first attempt it was discovered that my new machine had several failed update installs on it, after this was recified, the software appeared to install correctly.  but still failed to be able to log into the server.

Looking for suggestions to pass on to my IT department.

Thanks,

KarenError Msg
Karen SchaeferAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Karen SchaeferConnect With a Mentor Author Commented:
Turns out the problem is with the local system not recognizing the computer name , so it worked when I use the ip address instead. My local IT guy said since the computer is new it may take a few more days for the server to recognized the the new computer.  Thanks for your input.

Karen
0
 
John_VidmarCommented:
Three things come to mind:

1.

Is there a database-alias on the older/working workstation where you successfully connected? (windowkey-R, sqlconfg)

2.

If you right-click on the shortcut for SQL Server Management Studio (SSMS) and click run as administrator, does that help?

3.

Does your older/working workstation have a fixed IP-address, which may be used in a firewall-rule allowing you access to the database server?
0
 
RayConnect With a Mentor Data AnalystCommented:
IF you or others can connect via mgmt studio from another remote computer (computer besides the machine that acutally hosts the DB server), then the issue is either port blocking from your machine or some other actual connectivity issue.  Can you ping that server by name from your workstation?  Have you tried connecting via it's ip (obtained via a ping command).?
0
 
Karen SchaeferConnect With a Mentor Author Commented:
Ray
Yrs to all the above.

Pinged successfully

Uninstalled ssms reinstd checked firewalls

Still having same issuem.
0
 
Karen SchaeferAuthor Commented:
Found solution on my own - award points for input.

thanks,

Karen
0
All Courses

From novice to tech pro — start learning today.