cannot set up a local SQL server
i have been trying to set up a sql server so i can get started on learning asp.net but have failed time and time again. i have tried lots of ways to make it work & still have 0 idea on how to fix it. everytime i try create a new instance it just says that Database Engine Services have failed. pls anyone help
14 Replies
If everything else fails and you just need some sql database to start learning, you could consider using SQLite.
And then just try this again later on.
Also you probably should post the complete problem details
i tried to uninstall and reinstall like 10x times still not working
does SQLite work the same as that?
The big details part in your first image seems to be scrollable and contains a section "Error details".
It also mentions some server logs.
Those may be needed for anyone here to help you with that (I can't, never set up an SQL server)
There are probably some differences between how SQL Server and SQLite work, but the main one is that an SQLite database is just a file.
the details just say read the log but the log just says is " Use the following information to resolve the error, uninstall this feature, and then run the setup process again."
will it still work basically the same tho?
If you use something like EFCore to access the Database it should work the same.
are either of them complex to set up?
In the end both are relational SQL based databases.
cus ive legit just started on asp.net so its all a bit confusing haha
Yeah it is. Databases are frustrating at times.
If you work with a Database you probably should use some kind of ORM. Entity Framework (EF) being one of the more popular ones. Dapper is another one I have heard about, but never used.
It mostly abstracts away the SQL. There are a lot of tutorials on how to get started with EFCore.
ok thank you! its just so annoying cus i felt like i tried everything and it still wouldnt work.
so i should try EFCore & SQLite, do they have to get accessed differently or can call the data be accessed the same?
Maybe to clarify further.
SQLite is a database technology. Like SQLServer or PostgresSQL.
EFCore is an Object Relational Mapper (ORM) that helps you to work with your database inside of C#.
EFCore can be used with all kinds of different databases.
ah okay, does SQLServer come with a built in ORM?
No again they are unrelated. An ORM is basically a Nugget Package / C# library that helps you to work with some database.
This website explains what it is and how to get started.
https://www.entityframeworktutorial.net/entityframework6/what-is-entityframework.aspx
What is Entity Framework?
Entity Framework is an ORM that enables developers to work with relational data as domain-specific objects.