lookuo the syntax for “CREATE USER” and create the user in the database in question, then you can look at granting permissions after.

See this is what I...

• This reply was modified 3 years, 2 months ago by  spectra.
• This reply was modified 3 years, 2 months ago by  spectra.

Try this link

Okay. But is there anything I missed on your solution ? I followed the same suggestion.

I checked this also

https://blog.sqlauthority.com/2008/11/04/sql-server-fix-error-4064-cannot-open-user-default-database-login-failed-login-failed-for-user/

• This reply was modified 3 years, 2 months ago by  spectra.

Have you given the user any type of permission to any databases ?

How do you do that ?

other than those two sql query execution , I did...

Change the database.

It did not work....same error

• This reply was modified 3 years, 2 months ago by  spectra.

You may need to hit "Refresh" for your new login to appear.

That already showing there !

Error comes even after that.

No. Neither one of you are even close.

Yes. I can go there as per the screenshot.

I don't see anything significant there.  Its just couple of tabs e.g ...

Spectra, you can use the GUI to set permissions, and use the "SCRIPT to Query window" option and SQL will put the commands in a new query...

>What are the DEFAULT options when connecting to a server with SSMS?

I'm not sure which DEFAULT options you are talking about.

I get many lists ......are you talking...

One is to change the options of how the user connects,

User will use Windows Authentication login in SSMS. No change here.

the other is to...

• This reply was modified 3 years, 2 months ago by  spectra.

You missed the first step

USE [master]
GO
CREATE LOGIN [TheLogin] FROM WINDOWS WITH DEFAULT_DATABASE=[YourDatabase]
GO

User is unable to login now  with Windows Authentication after doing this .

login failed . error...

• This reply was modified 3 years, 2 months ago by  spectra.
• This reply was modified 3 years, 2 months ago by  spectra.