Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Enabling sql server 64 bit for network use -- configuration manager blank

Tags:

sql

sql-server

I have a sql server instance on a machine that I want to open up to being accessible over the network. However, I think there's multiple issues at play here and I'm not sure which one is the real contributing factor.

The version I'm using is:

select @@version

Microsoft SQL Server 2014 - 12.0.2269.0 (X64) Jun 10 2015 03:35:45 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 (Build 14393: )

I believe I need to enable network configuration in the SQL Server Configuration Manager, but when I look into my manager, I don't see anything of use:

enter image description here

Is there anything that clearly leaps out as to why this would be blank? Am I going about this the right way?

like image 367
AI52487963 Avatar asked May 12 '17 18:05

AI52487963


Video Answer


1 Answers

Re-install SQL Server and/or OS as necessary.

See similar questions here and here. What version is your OS? This is possibly an architecture mismatch - 64-bit SQL on 32-bit machine? Or version mismatch. SQL Enterprise installed on Windows Home edition?

Yes, you may be able to troubleshoot and fix, but SQL installs do some heavy lifting. The best and most thorough solution here is clean up and start fresh. It will provide you peace of mind.

like image 145
Troy Witthoeft Avatar answered Oct 06 '22 19:10

Troy Witthoeft