September 30, 2015 at 8:40 am
I installed MS SQL 2014 Standard. In the Data Tools in 2013 with the connection setup I do not see any server names. When calling sqlcmd -L all servers are visible. In SQL Configuration Manager Network Configuration I set the TCP / IP, Shared Memory and Named Pipes have set enabled.
I installed all the server components.
Can anyone help?
September 30, 2015 at 8:51 am
Hi
Please check if there a SQL Server Browser Service is running.
Br.
Mike
September 30, 2015 at 8:56 am
SQL Server Browser Service has state "running", start mode - automatic and status active
September 30, 2015 at 9:05 am
Can you connect with localhost or .?
September 30, 2015 at 9:12 am
I can connect with server only by Management Studio. I see all servers when I set ODBC connection.
September 30, 2015 at 10:28 am
I'm not clear what you are seeing here.
You can connect with SSMS. What are the credentials?
In Data Tools, do you mean SQL Server Data Tools? SSDT? Can you enter the same server name here as from SSMS and connect?
September 30, 2015 at 3:28 pm
I'm having the same problem, but with both SSMS and when trying to connect to a database using VS 2015. I haven't tried an "Data Tools".
I've been trying off and on for over a month to resolve this, with no luck so far.
I've enabled everything, and even turned off my firewall, since we have a hardware firewall installed. The SQL database is installed locally, but I can't see anything when I click the dropdown for server name in the add connection window.
As mentioned above I ran the sqlcmd -Lc command and it showed all instances of a sql server within my domain.
If I paste the host/server name of my local server in the server name box it connects ok, but I should not have to do that if everything was working as I expect.
BTW, not sure if it makes a difference, but I'm running a development edition of SQL Server 1014.
Thanks.
Marshall
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply