Q&A for How to Create a SQL Server Database

Return to Full Article

Coming soon

Add New Question

Question

Under the terms of hardware, how do you build a server?

Community Answer

A server is just like any other computer. Its hardware is just more suited for the rigours of a server environment and server tasks. Thus, server hardware may have lots of drives, dedicated network cards, redundant power supplies, and lots of RAM.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 5 Helpful 34
Question

Do laptops have the SQL software?

Community Answer

Usually not preinstalled, do a search for "Microsoft SSMS" and download, it's about a 700 mb file for the newest version.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 4 Helpful 18
Question

How do I access a new SQL database remotely from a newly built desktop?

Community Answer

It will works exactly the same. Unless you plan to buff it up later, you should do these exact tasks.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 7 Helpful 12
Question

Can I just do this in code with the create table option?

Community Answer

Yes, however you will end up with some very large dictionaries/dataframes that will quickly become challenging to update and edit.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 2 Helpful 0
Question

How can i connect my database to php file?

Community Answer

For this you need: Your favourite IDE (mine is PHPStorm). Some (small) knowledge of PHP. Some knowledge of XAMPP. A (localhost) database. Before you do the following steps, enable your local server with XAMPP (if you don't know how, look for a tutorial. 1. make a new file, called connection.php. 2. make, inside the tags, a variable, $link. 3. declare the $link like this: $link = mysqli_connect("DB_HOST", "DB_USERNAME", "DB_PASSWORD", "DB_NAME"); (e.g. $link = mysqli_connect("localhost", "root", "", "logindb"); 4. Your database is connected. if you want to check it, go to [localhost:/connection.php].

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 1
Question

Can I build my own server? Is it possible by connecting a hard drive to a network, e.g: a home network?

Anuj_Kumar1

Community Answer

Yes. You can install Microsoft SQL Server and setup your own server on a PC in your local home network. You can then setup login details and login via local network on the created server. There are also free versions of SQL-like servers you can install if you install Linux.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 0
Question

When I try step 2, I get an error "The system cannot find the file specified". Any suggestions? Thanks in advance!

Anuj_Kumar1

Community Answer

You may need to contact server administrator for the correct login credential. You can also install your own server (Microsoft SQL Server) on local PC. Local installed server allows you both login with credentials created via SQL server or Windows credential.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 0