ERROR: PerformancePoint Database Rename

Jun 16, 2011 at 11:45 AM

PerformancePoint Database rename doesn't seem to be functioning!

I can connect to SQL server via an ODBC connection but for some reason I get the below error saying that the script cannot connect to the SQL server to rename the PerformancePoint DB.

SQL server is configured to allow remote connections so I am not sure what is wrong!

Any ideas???

::ERROR::

Script aborted!

Exception : System.Management.Automation.MethodInvocationException:

Exception calling "Open" with "0" argument(s): "A netw

ork-related or instance-specific error occurred while e

stablishing a connection to SQL Server. The server was

not found or was not accessible. Verify that the instan

ce name is correct and that SQL Server is configured to

allow remote connections. (provider: SQL Network Inter

faces, error: 26 - Error Locating Server/Instance Speci

fied)" ---> System.Data.SqlClient.SqlException: A netwo

rk-related or instance-specific error occurred while es

tablishing a connection to SQL Server. The server was n

ot found or was not accessible. Verify that the instanc

e name is correct and that SQL Server is configured to

allow remote connections. (provider: SQL Network Interf

aces, error: 26 - Error Locating Server/Instance Specif

ied)

at System.Data.SqlClient.SqlInternalConnection.OnErr

or(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAnd

Warning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Connect(ServerInf

o serverInfo, SqlInternalConnectionTds connHandler, Boo

lean ignoreSniOpenTimeout, Int64 timerExpire, Boolean e

ncrypt, Boolean trustServerCert, Boolean integratedSecu

rity, SqlConnection owningObject)

at System.Data.SqlClient.SqlInternalConnectionTds.At

temptOneLogin(ServerInfo serverInfo, String newPassword

, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlC

onnection owningObject)

at System.Data.SqlClient.SqlInternalConnectionTds.Lo

ginNoFailover(String host, String newPassword, Boolean

redirectedUserInstance, SqlConnection owningObject, Sql

ConnectionString connectionOptions, Int64 timerStart)

at System.Data.SqlClient.SqlInternalConnectionTds.Op

enLoginEnlist(SqlConnection owningObject, SqlConnection

String connectionOptions, String newPassword, Boolean r

edirectedUserInstance)

at System.Data.SqlClient.SqlInternalConnectionTds..c

tor(DbConnectionPoolIdentity identity, SqlConnectionStr

ing connectionOptions, Object providerInfo, String newP

assword, SqlConnection owningObject, Boolean redirected

UserInstance)

at System.Data.SqlClient.SqlConnectionFactory.Create

Connection(DbConnectionOptions options, Object poolGrou

pProviderInfo, DbConnectionPool pool, DbConnection owni

ngConnection)

at System.Data.ProviderBase.DbConnectionFactory.Crea

tePooledConnection(DbConnection owningConnection, DbCon

nectionPool pool, DbConnectionOptions options)

at System.Data.ProviderBase.DbConnectionPool.CreateO

bject(DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionPool.UserCre

ateRequest(DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionPool.GetConn

ection(DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionFactory.GetC

onnection(DbConnection owningConnection)

at System.Data.ProviderBase.DbConnectionClosed.OpenC

onnection(DbConnection outerConnection, DbConnectionFac

tory connectionFactory)

at System.Data.SqlClient.SqlConnection.Open()

at Open(Object , Object[] )

at System.Management.Automation.DotNetAdapter.Auxili

aryMethodInvoke(Object target, Object[] arguments, Meth

odInformation methodInformation, Object[] originalArgum

ents)

--- End of inner exception stack trace ---

at System.Management.Automation.DotNetAdapter.Auxili

aryMethodInvoke(Object target, Object[] arguments, Meth

odInformation methodInformation, Object[] originalArgum

ents)

at System.Management.Automation.DotNetAdapter.Method

InvokeDotNet(String methodName, Object target, MethodIn

formation[] methodInformation, Object[] arguments)

at System.Management.Automation.Adapter.BaseMethodIn

voke(PSMethod method, Object[] arguments)

at System.Management.Automation.ParserOps.CallMethod

(Token token, Object target, String methodName, Object[

] paramArray, Boolean callStatic, Object valueToSet)

at System.Management.Automation.MethodCallNode.Invok

eMethod(Object target, Object[] arguments, Object value

)

at System.Management.Automation.MethodCallNode.Execu

te(Array input, Pipe outputPipe, ExecutionContext conte

xt)

at System.Management.Automation.PipelineNode.Execute

(Array input, Pipe outputPipe, ArrayList& resultList, E

xecutionContext context)

at System.Management.Automation.StatementListNode.Ex

ecuteStatement(ParseTreeNode statement, Array input, Pi

pe outputPipe, ArrayList& resultList, ExecutionContext

context)

TargetObject :

CategoryInfo : NotSpecified: (:) [], MethodInvocationException

FullyQualifiedErrorId : DotNetMethodException

ErrorDetails :

InvocationInfo : System.Management.Automation.InvocationInfo

PipelineIterationInfo : {}

PSMessageDetails :

Jun 23, 2011 at 4:06 PM

Same issue. I posted my response here http://autospinstaller.codeplex.com/discussions/262183

Notes:

The Script uses integrated SSPI as the connection string

THe SP-Admin user does exist on the SQL Database as a windows authentication account

 

thanks for the support

-schuess

 

Coordinator
Jun 24, 2011 at 3:29 PM

I've posted my attempts to reproduce over here: http://autospinstaller.codeplex.com/discussions/262183 let's use that thread going forward.

Brian