errors while deploying

Topics: User Forum
Dec 1, 2008 at 5:40 AM
Hello,

I am getting following error while deploying (I am using sql server 2005 standard edition and .Net 2.0 installed)

D:\SQLSpat\MsSqlSpatial-0[1].1.1>msscmd -deploy -server=myserver -db=somedb

Unhandled Exception: System.ApplicationException: Exception occured executing script:

IF (@@TRANCOUNT > 0)
                AND NOT EXISTS (SELECT name FROM sys.assemblies WHERE name=N'MsSqlSpatialLibrar
y')
BEGIN
EXEC sp_executesql N'
        CREATE ASSEMBLY [MsSqlSpatialLibrary] AUTHORIZATION [public]
                FROM N''D:\SQLSpat\MsSqlSpatial-0[1].1.1\MsSqlSpatialLibrary.dll''
                WITH PERMISSION_SET = SAFE'
IF (@@ERROR <> 0)
                ROLLBACK TRANSACTION

END
 ---> System.Data.SqlClient.SqlException: CREATE ASSEMBLY failed because it could not open the
physical file "D:\SQLSpat\MsSqlSpatial-0[1].1.1\MsSqlSpatialLibrary.dll": 3(The system cannot f
ind the path specified.).
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnecti
on)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean break
Connection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDa
taReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String met
hodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Deployment.RunScript(String script, SqlCommand command)
   --- End of inner exception stack trace ---
   at Deployment.RunScript(String script, SqlCommand command)
   at Deployment.DeployAssembly(String assemblyFilename, String connectionString, String databa
se, String deployPermission)
   at MsSqlSpatialConsole.Program.DeployAssembly(String connectionString, String database, ArgP
arser arg)
   at MsSqlSpatialConsole.Program.Main(String[] args)

Any help
Dec 1, 2008 at 5:49 AM
well well well

I should have read error message properly.

sql server is expecting that command is executing from the same box and then failing to find the dll at d:\xxxx which is in my workstation.

ANSWER/SOLUTION: "I moved all files to a folder withing the sql server box and deployed successfully"