Error 233 sql server 2014

Question

Navigation

#1 by (3 votes)

0

How can I solve this problem: try from server administrator

sql sql-server

asked by Marco Eufragio 24.10.2018 в 17:34

source

1 answer

Is it correct to have the ajax script in the same html form? Check input with 2 selectors

score 3 · Accepted Answer

One option is that the connection settings are incorrect:

On the start menu, find the MS SQL Server group.

Open SQL Server Configuration Manager > > SQL Server Network Configuration .

Choose the option TCP/IP and enable it with right click (select Enable ).

Another option is that the Shared Memory Protocol is not enabled, which is required by MS SQL:

Go to Start → All Programs → MS SQL Server → Configuration Tools → SQL Server Configuration Manager.

Select SQL Server Network Configuration .

In the window that appears, right click on the option Shared Memory → select Enable .

Another option is that there are messes in the configuration of the account that tries to login:

Open SQL Server Management studio and log in with "Windows Authentication"

Expand the directory Security of the tree

Expand the logins directory

Right click on the account that does not connect, select Propiedades .

Solution - Make sure there is a database assigned in the "Default Database" field.