Red Gate forums :: View topic - SQL Prompt cannot retrieve objects from . Possible Reasons
Return to www.red-gate.com RSS Feed Available

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

SQL Prompt cannot retrieve objects from . Possible Reasons

Search in SQL Prompt 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
cmcnear



Joined: 18 Dec 2013
Posts: 1

PostPosted: Wed Dec 18, 2013 10:19 pm    Post subject: SQL Prompt cannot retrieve objects from . Possible Reasons Reply with quote

Working in Visual Studio 2013 with SQL Server database projects. Now whenever I attempt to open a .sql file within the projects I get the error indicated in the title for the first time I open each file.

Interesting to note is the server/database name is .

Also looking at the SQL Prompt log using the Show Log menu item I see the following information
Code:
18 Dec 2013 20:13:00,810 [1] WARN  RedGate.SqlPrompt.Plugins.PromptPlugin - Automatic Refresh Suggestions plug-in disabled due to error
System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) ---> System.ComponentModel.Win32Exception (0x80004005): The system cannot find the file specified
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean withFailover)
   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.Open()
   at RedGate.SqlPrompt.Plugins.AutoRefreshPlugin.AutoRefresh.#Wjzc()
ClientConnectionId:00000000-0000-0000-0000-000000000000

Additionally looking in the Event Viewer I see the following information(from earlier in the day):

Code:
Log Name:      Red Gate Software
Source:        Ssms
Date:          12/18/2013 9:38:34 AM
Event ID:      32
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      cmcnear8770w7.int.appriss.com
Description:
RedGate.SIPFramework.Connect
#17:Failed to resolve assembly Microsoft.SqlServer.SqlEnum
System.ArgumentOutOfRangeException: Length cannot be less than zero.
Parameter name: length
   at System.String.InternalSubStringWithChecks(Int32 startIndex, Int32 length, Boolean fAlwaysCopy)
   at System.String.Substring(Int32 startIndex, Int32 length)
   at RedGate.SIPFramework.Connect.#gqdd(Object #Zsf, ResolveEventArgs #ead)

Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Ssms" />
    <EventID Qualifiers="0">32</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2013-12-18T15:38:34.000000000Z" />
    <EventRecordID>143</EventRecordID>
    <Channel>Red Gate Software</Channel>
    <Computer>cmcnear8770w7.int.appriss.com</Computer>
    <Security />
  </System>
  <EventData>
    <Data>RedGate.SIPFramework.Connect
#17:Failed to resolve assembly Microsoft.SqlServer.SqlEnum
System.ArgumentOutOfRangeException: Length cannot be less than zero.
Parameter name: length
   at System.String.InternalSubStringWithChecks(Int32 startIndex, Int32 length, Boolean fAlwaysCopy)
   at System.String.Substring(Int32 startIndex, Int32 length)
   at RedGate.SIPFramework.Connect.#gqdd(Object #Zsf, ResolveEventArgs #ead)
</Data>
  </EventData>
</Event>



I am currently using version 6.2 of SQL Prompt and have submitted this error on several ocassions as it has been occurring for several versions.
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 661
Location: Cambridge

PostPosted: Fri Dec 20, 2013 11:10 am    Post subject: Reply with quote

Sorry for the error.

I have logged a support ticket for you and will email you shortly.
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
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