I am extremely new to Microsoft SQL Server. I know a good level of MySQL but now I'm wanting to extend my knowledge to SQL and I want to practice writing out queries on the SQL Server Management Studio. I have downloaded and installed the free SQL Server 2008 free on the microsoft website, and then I have done the same for the Server Management Studio 2008. However, to start practising I need to create my database, and to do that, I need to connect to a server. This is where I'm confused, I tried writing out the server name as 'sqlserver'.. something random like that, then I receive this error as shown below:
TITLE: Connect to Server
Cannot connect to sqlserver.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)
I've spent hours now looking up what I have been doing wrong, I've tried reinstalling the software, running the Management Studio as an administrator and I've also created rules in my Windows Firewall so that it allows the ports for 1433 and 1434. I still keep on getting the same error message.
I'm not sure if I'm doing anything completely stupid in this scenario, all that I know is that I'm desperate to getting this working so I can just start practising and learning the language.