Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 95
  • Last Modified:

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)
0
newbieweb
Asked:
newbieweb
3 Solutions
 
YZlatCommented:
first try enabling Named Pipes
0
 
Jason clarkDBA FreelancerCommented:
In the right pane of split page you must try below changes:

Named Pipes - Enable.
TCP/IP - Enable.
VIA - Disable
0
 
Daniel JonesData 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
 
newbiewebAuthor Commented:
thanks
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now