connecting to db instance

Hi.
I am willing to install sql server express on a computer and after full installation, including SSMS when I try to connect to a base instance I am always getting the error telling me that I am unable to connect to the db instance, which puts me scratching my head.
I have verified user name (no password) and computer name.
Can anyone help?
Capturar-error.PNG
João serras-pereiraAsked:
Who is Participating?
 
Olaf DoschkeSoftware DeveloperCommented:
Using SQL Server Configuration Manager to enable named pipes:

In SQL Server Configuration Manager, in the console pane, expand SQL Server Network Configuration.

In the console pane, click Protocols for <instance name> (your database instance).

In the details pane, right-click named pipes, and then click Enable.

In the console pane, click SQL Server Services.

In the details pane, right-click SQL Server (<instance name>), and then click Restart, to stop and restart the SQL Server service.

Bye, Olaf.
1
 
João serras-pereiraAuthor Commented:
thanks!
0
 
Olaf DoschkeSoftware DeveloperCommented:
You're welcome.

Notice, this is by design and not just a setup glitch. You'll have to remember this is a necessary step for SQL Server configuration. Defaults also disable any network access for Express, Developer or Evaluation editions, at first. See TCP/IP column of https://technet.microsoft.com/en-us/library/ms190198(v=sql.105).aspx
1
 
João serras-pereiraAuthor Commented:
re-THANKS! This possibly why my forms on  machines either than the development one are crashing with 2467 error
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.