October 15, 2017 at 5:03 am
Just set up SqlServer 2014 Express called SERVER\SQLEXPRESS
There is a Firewall on with standard settings
I have also put in exclusions for the 2 ports and Sqlserver.exe and SqlBrowser.exe
If I try to access form the server, all is fine , with a connection string including SERVER\SQLEXPRESS
However, I could not access from a PC on the LAN without turning off the Firewall . If I turned off the Firewall,I could then access form a PC on the LAN
After trying lots of stuff, I removed the \SQLEXPRESS from the connection string, hey presto, I can access fine
I have noitced this on 2 separate installations.
I would have though with a wrong connection string (Just the SERVER part) I should not have access at all
Any idea why I need to remove the \SQLEXPRESS bit to gain access form a PC on the Lan
October 16, 2017 at 2:45 pm
xxx-593414 - Sunday, October 15, 2017 5:03 AMJust set up SqlServer 2014 Express called SERVER\SQLEXPRESS
There is a Firewall on with standard settings
I have also put in exclusions for the 2 ports and Sqlserver.exe and SqlBrowser.exeIf I try to access form the server, all is fine , with a connection string including SERVER\SQLEXPRESS
However, I could not access from a PC on the LAN without turning off the Firewall . If I turned off the Firewall,I could then access form a PC on the LANAfter trying lots of stuff, I removed the \SQLEXPRESS from the connection string, hey presto, I can access fine
I have noitced this on 2 separate installations.
I would have though with a wrong connection string (Just the SERVER part) I should not have access at allAny idea why I need to remove the \SQLEXPRESS bit to gain access form a PC on the Lan
It almost sounds like this could be due to have a default instance and a named instance installed on the server. Did you check for that in services, SQL Server Configuration Manager on the server?
Sue
October 17, 2017 at 2:24 am
Hi Sue. Thanks for replying
Not sure what you mean by default instance or named instance.....don't really know what to check for......could you point me in the right direction
October 17, 2017 at 8:15 am
A quick and dirty check if you're running a named instance or default instance would be, on the server, open SSMS and connect to your SQL instance and run the following two queries:select @@SERVERNAME
select @@SERVICENAME
If the first returns something like "servername\something," then it's a named instance. If it just returns "servername" it's a default instance. The second query will return the name of the instance, either "something" or "MSSQLSERVER" (which is the default name.)
Another thing to check, and I've been burned by this recently, is to check in the SQL Server Configuration Manager -> Network -> Protocols, and verify that TCP/IP is enabled. It seems with SQL2014+ the default is disabled. I don't think this is going to be the case, as you say you can get to the server with the firewall completely disabled, but it's an easy thing to check.
October 17, 2017 at 8:45 am
xxx-593414 - Tuesday, October 17, 2017 2:24 AMHi Sue. Thanks for replying
Not sure what you mean by default instance or named instance.....don't really know what to check for......could you point me in the right direction
You can have an instanced that is the default - which is referenced by server name.
In services or SQL Server Configuration Manager, they display as SQL Server(MSSQLSERVER)
You can have named instances which display as SQL Server(NAMEDINSTANCE)
You have said you connect to both SERVERNAME as well as SERVERNAME\SQLEXPRESS which sounds like you could have both a default instance as well as a named instance on that server. Turning off a firewall and then being able to connect to SERVER\SQLEXPRESS indicates that the ports are not opened for a named instance. But you could connect to SERVER and said you opened two ports - so likely 1433 and 1434. So that also sounds like ports aren't open for a named instance, just the default instance.
You execute a query to see what you are connected to but it could be that you need to figure out if you have more than one instance.
Sue
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply