What are the challenges you face when working across database platforms? Take the survey

Error message box always appears when opening a SQL Solution

Matthew.WilkersonMatthew.Wilkerson Posts: 45
edited March 14, 2011 5:47AM in SQL Prompt Previous Versions
We use SQL solutions in SSMS to access SQL code. Every time we open one we get the following error message by SQL Prompt:
SQL Prompt cannot retrieve objects from <database name>. Possible reasons:

-insufficient memory to cache objects
-invalid permissions for this database
-connection error
-corrupted database

The loading the the <database name> server failed because of Login failed for user'<user name>'.

The SSMS login dialog appears under it, but this one appears before we are able to log in. Is there a way to not show this message box when opening a SQL solution, or have it wait to see if it should show it until after the SSMS login dialog goes away?


  • Options
    Anu DAnu D Posts: 876 Silver 3
    Many thanks for your post and apologies for inconvenience caused.

    I am not able to reproduce the issue as it is working for me.

    I have emailed you so that you can reply to that email with the code and steps to replicate the issue so that I can replicate it at my end.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.