› Support Forums › Product Support › Can’t See Database Tables After Connecting Locally: What Could Be Wrong?
Tagged: Server SQL
- This topic has 7 replies, 3 voices, and was last updated 1 month ago by
Eben Monney.
- AuthorPosts
- March 26, 2023 at 1:39 pm #52918
I’ve connected to my local database on my machine as per the connection string, but I’m unable to see the tables described in the migration folders. What could be the reason for this, and am I making any mistakes?
March 26, 2023 at 1:44 pm #52920Im using the free Quick-Application Startup (Angular 15 & ASP .NET 7 Web Api) Project from Visual Studio Marketplace
March 26, 2023 at 1:47 pm #52924Interestingly, when I start the project, it runs without any errors! This adds to the confusion about not being able to see the tables after connecting to the local database.
March 26, 2023 at 7:43 pm #52936If you haven’t modified the connection string and you’re on Windows you can use this connection string to connect to the default Development database:
(localdb)\MSSQLLocalDB
March 27, 2023 at 7:59 am #52956Thanks you very much
May 2, 2023 at 9:20 am #53683My appsetting.json looks like this.
“ConnectionStrings”: {
“DefaultConnection”: “Server=(localdb)\MSSQLLocalDB;Database=QuickApp;Trusted_Connection=True;MultipleActiveResultSets=true”
},The project builds successfully but I can’t see the database and any tables in MySQL Server Management Studio.
Can you help me, please?
- This reply was modified 1 month ago by
Vict Man.
May 2, 2023 at 10:31 am #53686My appsetting.json looks like this.
“ConnectionStrings”: {
“DefaultConnection”: “Server=(localdb)\MSSQLLocalDB;Database=QuickApp;Trusted_Connection=True;MultipleActiveResultSets=true”
},The project builds successfully but I can’t see the database and any tables in MySQL Server Management Studio.
Can you help me, please?
The ConnectionString you specified points to an SQL Local Database and not a “MySQL” server.
You can connect to this using the “Microsoft SQL Server Management Studio” or any MS SQL database management tool of your choice using
(localdb)\MSSQLLocalDB
as the server name. - This reply was modified 1 month ago by
- AuthorPosts
- You must be logged in to reply to this topic.