Cannot connect to (LocalDB)\MSSQLLocalDB -> Login failed for user 'User-PC\User'
I am getting an error, While I am trying to connect (LocalDB)\MSSQLLocalDB through SQL Server management studio. I also tried to login with default database as master the error is same.
Here is the Server details.
Solution
Warning: this will delete all your databases located in MSSQLLocalDB. Proceed with caution.
The following command through sqllocaldb utility works for me.
sqllocaldb stop mssqllocaldb
sqllocaldb delete mssqllocaldb
sqllocaldb start "MSSQLLocalDB"
After that I restarted the sql server management studio, and it is successfully established connection through (LocalDB)\MSSQLLocalDB
- In a standard MS Access SQL query output that does not have any aliases, how do I replace the full names by their "first-letters" aliases?
- Convert SQL containing GROUP BY and SUM() to active record in CodeIgniter
- output sql data to html with hyperlink
- Update all column names to be lowercase
- SQL Server pivoting on data without an aggregate
- replace or remove characters and then cast to decimal
- Export specific rows from a PostgreSQL table as INSERT SQL script
- Query to get only numbers from a string
- SQL grouping result to half hour
- table is specified twice both as a target for INSERT and as separate source of data
- SQL to JSON Need Bracket for Array that can have multiple rows
- Find all occurrences of Substring and replace it with a special characters
- Oracle Merge statement 'ON' vs 'UPDATE' conditions performance on target table
- How to do aggregate raw sql with julian date in sqlite (with django)
- SQL Merge SOURCE order and OUTPUT order
- Notepad++/Eclipse sql code auto-indent option?
- Output of update statement does not show correct row number
- Map table to exactly one of three
- PostgreSQL - ERROR: column does not exist SQL state: 42703
- How to force evaluation of subquery before joining / pushing down to foreign server
- SQL SELECT TOP 1 FOR EACH GROUP
- Convert a date to timestamp in a join with interpolation
- How To CAST substring as a DATE
- batch update a column using sql
- Firebird SQL add empty rows in resultset
- How do I cast a timestamp column as a MM/DD/YYYY in BigQuery
- Parsing JSON with Oracle SQL without knowing incoming field names
- Selecting from random column in PL/SQL
- Simple Query to Grab Max Value for each ID
- How to programmatically check if row is deletable?