Post reply

connection failed sqlstate 37000 SQL error: 4064

  • June 22, 2013 at 6:22 am

    #395017

    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.

  • June 24, 2013 at 2:25 am

    #1626687

    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[/url]

    @SeanPearceSQL

    About Me[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply