review.exe has the blues

May 19, 2009 at 7:53 PM

I'm a native apps guy with little prior experience with SQL Server or web services, so I'm hoping that the solution to this is obvious and easy for someone with greater powers in these areas.

Setup:

  • Server is running on a Win7 Virtual PC (DOX-CRT).
  • Shared Memory, Named Pipes, and TCP/IP are enabled in the SQL Server 2005 Network Configuration
  • Windows Firewall has exceptions for both instances of sqlserver.exe and for sqlbrowser.exe

Web connections to Malevich succeed.

review tool fails like so:

>review 124883  reviewer names redacted --database DOXCR-CRT/DOXMALEVICH

Unhandled Exception: System.Data.SqlClient.SqlException: A network-related or in
stance-specific error occurred while establishing a connection to SQL Server. Th
e server was not found or was not accessible. Verify that the instance name is c
orrect and that SQL Server is configured to allow remote connections. (provider:
 Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception
, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObj
ect stateObj)
   at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternal
ConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Bool
ean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection
owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo
serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire,
 SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host
, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject
, SqlConnectionString connectionOptions, Int64 timerStart)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnecti
on owningObject, SqlConnectionString connectionOptions, String newPassword, Bool
ean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdent
ity identity, SqlConnectionString connectionOptions, Object providerInfo, String
 newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOp
tions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
 owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConn
ection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owning
Object)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection o
wningObject)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection ownin
gObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection ow
ningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection ou
terConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at System.Data.Linq.SqlClient.SqlConnectionManager.UseConnection(IConnectionU
ser user)
   at System.Data.Linq.SqlClient.SqlProvider.get_IsSqlCe()
   at System.Data.Linq.SqlClient.SqlProvider.InitializeProviderMode()
   at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider
.Execute(Expression query)
   at System.Data.Linq.DataContext.ExecuteMethodCall(Object instance, MethodInfo
 methodInfo, Object[] parameters)
   at DataModel.CodeReviewDataContext.AddChangeList(Nullable`1 sourceControl, St
ring userClient, String cL, String description, Nullable`1 timeStamp, Nullable`1
& result)
   at review.Program.ProcessCodeReview(CodeReviewDataContext context, ISourceCon
trol sd, Int32 sourceControlInstanceId, String changeList, List`1 reviewers, Lis
t`1 invitees)
   at review.Program.Main(String[] args)

Coordinator
May 20, 2009 at 2:27 AM

I think it's the slash in your instance name that is your problem: DOXCR-CRT/DOXMALEVICH => DOXCR-CRT\DOXMALEVICH and it will work.

 

May 20, 2009 at 5:26 PM

Thanks Sergey! That simple tweak did the trick. Now we're off to the races!