Trouble connecting to SqlServer database

I am trying to connect an existing database to NetSqlAzMan (Console Root) but get an error showing that my SQLEXPRESS instance needs configuration for multi-user access.

Trouble establishing connection to SQL server
I ran the script which creates the database...

Database exists
Do I need to change the configuration of the SQL instance?

Here are the instructions, which i have followed. Note the error in the first screen shot.


In order to use .NET Sql Authorization Manager, a NetSqlAzMan Storage DB must be created !
a) Open SQL Server Management Studio.
b) Create a Database with a name like 'NetSqlAzManStorage'.
c) Right click on Database created above and choose 'New Query'.
d) Load and execute script named 'NetSqlAzMan_SqlServer.sql' from the installation folder.

The current SQL Server Network Configuration for SQLEXPRESS is
Shared Memory (Enabled)
Named Pipes (Disabled)
TCP/IP (Disabled)
newbiewebSr. Software EngineerAsked:
Who is Participating?
 
YZlatConnect With a Mentor Commented:
first try enabling Named Pipes
0
 
Jason clarkConnect With a Mentor DBA FreelancerCommented:
In the right pane of split page you must try below changes:

Named Pipes - Enable.
TCP/IP - Enable.
VIA - Disable
0
 
Daniel JonesConnect With a Mentor Data Research AnalystCommented:
Try this:  
 
Go to control panel > search for services.
From your search results open Local services window
Restart your MSSQLSERVER service.

Or you can also take the help of this link: http://www.sqlserverlogexplorer.com/fix-error-message-40/
0
 
newbiewebSr. Software EngineerAuthor Commented:
thanks
0
All Courses

From novice to tech pro — start learning today.