June 29, 2016 at 12:02 pm
I'm now to this and installed SQL server on my PC yesterday. Everything seemed to go well and I was able to log in and access a sample database. However, when I try to use SQL Server Management Studio today I'm getting the following error. Can anyone please assist? Thanks,
Cannot connect to PC2014 (which is my PC). It says that the server was not found or was not accessable and I should check to see if the server is configured for remote connectios. This is the PC that the software is installed on. A strange thing about this is that I am able to connect to Analysis Services using the same ID PC2014.
June 29, 2016 at 1:07 pm
Go into SQL Server Configuration Manager and make sure that TCP/IP is enabled under SQL Server Network Configuration / Protocols ...
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
July 4, 2016 at 5:42 am
Consider as well that if you have a named instance installed and not a Default instance you Need to Suffix the Server Name with the instance.....
In SQL2014 TCP/IP is enabled by Default....
July 4, 2016 at 6:22 am
sometimes the easiest things...
do you have checked if the database engine service is running?
Do you have changed the TCP Port?
Have you changed any configuration in db Config?
Windows Firewall / different Firewall?
July 4, 2016 at 6:25 am
NorthernDBA (7/4/2016)
sometimes the easiest things...do you have checked if the database engine service is running?
Do you have changed the TCP Port?
Have you changed any configuration in db Config?
Windows Firewall / different Firewall?
Add to this list a check to ensure the SQL Server Services are running.......
July 5, 2016 at 4:51 pm
Do you know if you installed a named instance or the default?
Take a look at sql server configuration manager, and post a screenshot if you're unsure how to tell.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply