Red Gate forums :: View topic - The loading of the .\SQLEXPRESS server failed because...
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 5
SQL Prompt 5 forum

The loading of the .\SQLEXPRESS server failed because...

Search in SQL Prompt 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
oezoezoe



Joined: 16 Feb 2012
Posts: 2

PostPosted: Thu Feb 16, 2012 3:44 pm    Post subject: The loading of the .\SQLEXPRESS server failed because... Reply with quote

I have added a local SQL Server database to my project in Visual Studio.

I want to add a stored procedure via de server explorer in visual studio 2011 to the local database. When the editor for the stored procedure opens Prompt is comming up with a bunch of the same error message boxes. And every time the editor gets focus another set of the same error boxes is poping up.

"SQL Prompt cannot retrieve object from .\SQLEXPRESS. Possible reasons:"...

In the details window the following message:
The loading of the .\SQLEXPRESS server failed because of Invalid object name 'sysdatabases'.


I think SQL Prompt is looking for stuff in the SQLEXPRESS instance of my local machine, but the database cannot be found there, because it is local SQL Server database created by visual studio.

Please advice

I am using SQL Prompt version 5.2.2.1
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6670

PostPosted: Fri Feb 17, 2012 5:47 pm    Post subject: Reply with quote

Hi,

SQL Prompt usually connects to a server only when you request a database from that server. If you downloaded and installed Visual Studio 2010, then it usually installs an instance of SQL Server Express. So when you say you installed the SQL Server from Visual Studio, that tells me that you are probably using SQL Express.

At any rate, the error message implies that you did connect to the server, just the sysdatabases view seems to be missing. As this is part of the information schema of SQL Server, it would be really odd if this view did not exist in the master database schema. You may not have the right permissions to open the master database.
Back to top
View user's profile Send private message
oezoezoe



Joined: 16 Feb 2012
Posts: 2

PostPosted: Mon Feb 20, 2012 7:33 am    Post subject: Reply with quote

The database that is in my project is not attached to the ./sqlexpress instance. It is a database whitch I added via visual studio (add new item and select a new sql database). Since it is not attached to the ./sqlexpress instance there is also no master database and therefor no sysdatabasesview.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6670

PostPosted: Mon Feb 20, 2012 10:18 am    Post subject: Reply with quote

Sorry, I don't know and this doesn't seem to make sense to me. If you *did* have a SQLEXPRESS instance, or any other Microsoft SQL Server, you would have a master database as it's the metadata catalog for the whole server and it wouldn't work without it.

SQL Prompt should only try to gather information about databases that you attempt to connect to.

Have you got any other information about this message that might be relevant?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6670

PostPosted: Mon Feb 20, 2012 5:56 pm    Post subject: Reply with quote

SQL Prompt only works in VS database projects, and it connects to whatever server you have put in the connection string you find in project properties -> Database.
Back to top
View user's profile Send private message
POTOOLE



Joined: 09 May 2013
Posts: 2
Location: Dublin, Ireland

PostPosted: Wed Oct 23, 2013 1:16 pm    Post subject: Reply with quote

I'm still experiencing this bug even after upgrade to SQL Prompt 6.1
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group