October 8, 2015 at 2:01 pm
Has anyone seen this before and if so, what is causing it to behave like this?
SQL Express 2014 was installed to support reporting for an application. I can connect to the server using the server name without any issue. When I run “select @@version”, I get SERVERNAME\SQLEXPRESS, but I can’t connect to the server with SERVERNAME\SQLEXPRESS. This is throwing off one of my script when trying to connect to the server.
My script connects to the server using SERVERNAME for default instance or SERVERNAME\INSTANCENAME for named instance.
Thanks,
MC
October 9, 2015 at 9:46 am
Have you checked to see if the named instance is listening on TCP/IP ? By default, I dont think SQL Express is "connectable" over the network if thats what you are trying to do. I am pretty sure, however, that you can enable TCP/IP and connect over the network. Check SQL config manager and ensure that its listening on TCP/IP, disable shared memory and named pipes, and then try connecting locally using Servername\Instancename first to ensure its listening on TCP/IP. Once you are able to confirm this, then try connecting from the app. Keep in mind also that if you're connecting using TCP/IP and SQL browser service is not running, you'll need to specify port number in your connection string.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply