x

Local database problem

I installed sql server 2016 sp1 and sql server management studio on my windows 10 pc. When i write "sqllocaldb versions" i get "Windows API call "RegGetValueW" returned error code: 0.".

When i write "sqllocaldb create "locall"" i can find the 'locall' directory under the C:\Users\'user'\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances but i cannot see locall in sql management studio. How can i fix that?

more ▼

asked Feb 16 at 10:15 AM in Default

avatar image

esege
1

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

you may enable TCP/IP or Named pipes for named connections if not enables then enable it then try ..

more ▼

answered Feb 17 at 05:03 AM

avatar image

jason_clark03
425 3 7

(comments are locked)
10|1200 characters needed characters left

In SQL Server Configuration Manager (type in Start menu). Click on SQL Server Services. Instance name is in parenthesis inline with SQL Server service. If it says MSSQLSERVER, then it's the default instance. To connect to it in Management Studio, just type . (dot) OR (local) and click Connect. In your condition as your instance name is different, then use .[instance name] to connect to it (.\locall). Also, check SQL Server and SQL Server Browser services are running, you won't be able to connect of they are not running

more ▼

answered Feb 20 at 05:45 AM

avatar image

jason_clark03
425 3 7

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x295
x14
x9

asked: Feb 16 at 10:15 AM

Seen: 106 times

Last Updated: Feb 20 at 05:45 AM

Copyright 2016 Redgate Software. Privacy Policy