January 7, 2018 at 9:28 am
I just installed SQL Server 2017 and Management Studio 17.4 on a development laptop
I tried to create a login - the way I did on 2014 versions
no luck - when I connect from the desktop I get a no named pipes error and when I connect after connecting with Windows Authentication I get login failed with 18456 error
TITLE: Connect to Server
------------------------------
Cannot connect to DESKTOP-CRHIFAA.
------------------------------
ADDITIONAL INFORMATION:
Login failed for user 'PowerHouse_owner'. (Microsoft SQL Server, Error: 18456)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
January 7, 2018 at 4:41 pm
hey guys
I found my problem
earlier versions ask if you want mixed mode
SQL Server 2017 just defaults to Windows Authentication so I had to manually fiddle with settings, even though a warning panel said don't
if you are adding a userid / password (and when would anyone NOT?) you need to right click on the server -> Properties -> Security
then change one radio button
go into Services, find SQL Server Stop then Start
B-I-N-G-O
https://stackoverflow.com/questions/2474839/unable-to-login-to-sql-server-sql-server-authentication-error-18456
January 8, 2018 at 2:22 am
This was removed by the editor as SPAM
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply