Can not get access to localDb
karenpayne
Posts: 5 Bronze 1
in SQL Backup
When attempting to install server components for localDb, I get could not find (shows my machine name) which is the machine I'm on and zero problem when doing the same for SQLEXPRESS (which works).
So step 1 fails and I am a admin on this machine, step 2 validates, never get to step 3 but selected windows authentication.
So step 1 fails and I am a admin on this machine, step 2 validates, never get to step 3 but selected windows authentication.
Tagged:
Best Answer
-
Eddie D Posts: 1,802 Rose Gold 5Hi, Thank you for your forum post.
When you refer to LocalDB, is this the special developer-optimized edition low impact version of the SQL Server engine, that is not installed as Windows Service but launched on demand by an ADO.NET client (intended for single user scenarios)?
Or do you mean a full SQL Server installation using the default instance name (local)?
I ask the above questions, as SQL Backup does not support LocalDB.
SQL Backup does support a full SQL Server installation where the instance uses the default name (local). In my experience when connecting the user either specifics just the host name in your case KKNJML3 or by adding (local) as the instance name to the hostname, for example FKNJML3\(local).
Many Thanks
Eddie