• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 692
  • Last Modified:

Getting 4064 doing SQL Server Autentication connect to SQL Server 2005

I am trying to connect to SQL Server 2005 and I am getting a 4064 error. I can't figure out why. I am using an Sql Server authentication login. This login has a default database specified. What do I need to look at?
0
jmarkfoley
Asked:
jmarkfoley
  • 3
  • 3
1 Solution
 
dqmqCommented:
That error suggests to me that the account logging in does not have access to the default database assigned to it. Login as SA and check the user mappings for the login that is failing. Make sure there is a user assigned to the default database and that the assigned user has access permission.
0
 
jmarkfoleyAuthor Commented:
Further note: If I try to log into SQL Server Management Studio interactively using this SQL Server authentication login, it fails and I get the message:

Cannot connect to SERVER\TRAVERSE105.
Additional Information:
A connection was successfully established with the server, but then an error occured during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)(Microsoft SQL Server, Error: 233)

Does this help? Would it be reasonable to assume that if I can't log in this way, then I'm not going to be able to create a connection from another host?
0
 
jmarkfoleyAuthor Commented:
The login does specify a default database and that database exists. When I check Security->Users under that database, this user is listed. What am I missing? This is the first time I've configured a user.
0
Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

 
dqmqCommented:
>What am I missing.

Not sure.  Try recreating the user.
Right click: Database->YourDB-->Security->Users->YourUser
Left click: Delete; Press: OK
 
Right click:  Security->Logins->YourLogin
Left click: Properties
Select: User Mapping  tab;  Check the box for YourDB.



0
 
jmarkfoleyAuthor Commented:
YES! That was the answer! I hadn't done the User Mapping Tab before. Now I connect OK.

Thanks, if you want another quick 500 points, go to the below link and post the same answer:

http://www.experts-exchange.com/Programming/Languages/Java/J2EE/JSP/Q_22888936.html
0
 
dqmqCommented:
So glad to help.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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