Sunday, May 21, 2017

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

Leave a Comment

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?

1 Answers

Answers 1

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 piece of mind.

If You Enjoyed This, Take 5 Seconds To Share It

0 comments:

Post a Comment