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
Author
Message
Posted Saturday, June 22, 2013 6:22 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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: Today @ 1:48 AM
Points: 832, Visits: 2,684
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

@SeanPearceSQL

About Me


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

Add to briefcase

Permissions Expand / Collapse