problem connecting to the server

i am trying to make my own personal use pserver
i did changed the setting and enabled the connection and changed the port to 1433
like this picture
[Only registered and activated users can see links. Click Here To Register...]
and this for ports
[Only registered and activated users can see links. Click Here To Register...]

and i am sure that is the server name and password are correct
and i faced no errors in installation
but i still this connection error
[Only registered and activated users can see links. Click Here To Register...]
i have edited folder in directory
C:\Windows\System32\drivers\etc
by adding this line
127.0.0.1 cadb.nflavor.com
although i tried without the line but still the same error

i have a router
if that is may cauze the problem

the whole information in the file etc is here :
# Copyright (c) 1993-2009 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host

# localhost name resolution is handled within DNS itself.
# 127.0.0.1 localhost
# ::1 localhost
0.0.0.0 80-239-228-33.customer.teliacarrier.com
0.0.0.0 fra07s27-in-f15.1e100.net
0.0.0.0 193-45-10-160.customer.teliacarrier.com
0.0.0.0 api.mywot.com
0.0.0.0 149.20.54.15
0.0.0.0 a23-36-149-163.deploy.akamaitechnologies.com
127.0.0.1 cadb.nflavor.com

any suggestion would be appreciated
Thanks for reading

You should follow the guide and use mixed authentication, so you can log on to the SQL server using your windows authentication.

All of the servers when you run them will use SQL authentication which will be configured using the opt files.

Quote:

Originally Posted by thndr You should follow the guide and use mixed authentication, so you can log on to the SQL server using your windows authentication. All of the servers when you run them will use SQL authentication which will be configured using the opt files.

i followed the guide and used mixed authentication
and when trying to log i used sql authentication i think but it is like the photo i took

Log in to your SQL instance using windows authentication.

Quote:

Originally Posted by thndr Log in to your SQL instance using windows authentication.

Tried and failed the same exact problem
[Only registered and activated users can see links. Click Here To Register...]

could u tell how to display the photo right away
without having to go to the link + under spoiler maybe it goes ? ?

Well it does not look like you have followed the guide properly to configure a named instance that you can connect to.

Try starting from the beginning and make sure you read through all of the instructions.

Quote:

Originally Posted by thndr Well it does not look like you have followed the guide properly to configure a named instance that you can connect to. Try starting from the beginning and make sure you read through all of the instructions.

i did that on my own ~~

i reinstalled and installed again about 4 times

Quote:

Originally Posted by OROCHIMARU99 i did that on my own ~~ i reinstalled and installed again about 4 times

But you are not doing it correctly...

So somewhere in the guide

1. You are missing some important step

2. You are reading some step incorrectly and following it wrong.

3. You are not opening some spoiler somewhere that contains important instruction.

You have not even gotten an SQL server to connect to enough to restore the databases.

That is pretty early on in the guide that you are miss stepping.

The issue is I can not say what you are doing wrong, because I can not watch you do it.

But you should be able to connect to your own SQL instance and object explorer.

#moved