Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

connection failed sqlstate 37000 SQL error: 4064 Expand / Collapse
Posted Saturday, June 22, 2013 6:22 AM


Group: General Forum Members
Last Login: Sunday, June 8, 2014 7:15 AM
Points: 12, Visits: 44
MS-Access Front End and SQL 2008 in a Server 2008 Domain.

Microsoft SQL server Login
Connection failed:
SQL State: '37000'
SQL Server Error: 4064
[Microsoft ODBC SQL Server Driver][SQL Server] Cannot open user default database. Login failed.

Seems like I have not set up the Security Logins and Server Roles correct.

Post #1466453
Posted Monday, June 24, 2013 2:25 AM

SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 1:37 AM
Points: 997, Visits: 3,089
The Login Properties window allows you to select a default database for a sql server login. This database must exist, be online and the login must have permission to access this db.

The SQL Guy @ blogspot


About Me

  Post Attachments 
DefaultDb.png (26 views, 56.21 KB)
Post #1466628
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse