Solved

Trouble connecting to SqlServer database

Posted on 2016-11-18
4
29 Views
Last Modified: 2016-11-19
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)
0
Comment
Question by:newbieweb
4 Comments
 
LVL 35

Accepted Solution

by:
YZlat earned 250 total points
Comment Utility
first try enabling Named Pipes
0
 
LVL 7

Assisted Solution

by:Jason clark
Jason clark earned 125 total points
Comment Utility
In the right pane of split page you must try below changes:

Named Pipes - Enable.
TCP/IP - Enable.
VIA - Disable
0
 
LVL 3

Assisted Solution

by:Daniel Jones
Daniel Jones earned 125 total points
Comment Utility
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
 

Author Closing Comment

by:newbieweb
Comment Utility
thanks
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now