0
I upgraded to Windows 10 on my laptop. I have opened SQL Server Management Studio, but it can't connect to the server.
I have looked at a few other questions, but nothing seems to work. I get the same error message as in this post
I also went to Control Panel > Admin Tools > Services and made sure SQL Server Browser is running.
Not sure what to do.
mHelpMe
Posted 2015-12-03T19:27:14.773
Reputation: 101
0
Have you checked the shared memory in SQL Server protocols? If it is disabled, you will not be able to connect to SQL Server in Windows 10.
On contrary, in Windows 7, 8 and 8.1 enabling the shared memory was often causing the same effect, so it is by the rule that it is often disabled. After upgrading to Windows 10 you might hit the issue as now it is required to be enabled... not sure why MSFT made this mess, but I have seen this issue quite often after upgrading to Windows 10
Run SQL Server Configuration Manager and then navigate to SQL Server Native Client Configuration
Check Shared Memory and if disabled, enable it
Try to connect SQL Server again
Nikola Dimitrijevic
Posted 2015-12-03T19:27:14.773
Reputation: 3 363
What does this have to do with C# or programming in general? – None – 2015-12-03T19:30:54.437
sorry thats a mistake – None – 2015-12-03T19:31:22.443
1Anything to do with a firewall or closed ports? Try disabling your firewall for an attempt. – None – 2015-12-03T19:42:19.593
I have the standard windows 10 firewall. I switched it but didn't fix the issue – mHelpMe – 2015-12-04T09:56:17.400