| Author |
 Topic  |
|
|
DBAndrew
Starting Member
9 Posts |
 Posted - Mar 04 2010 : 08:51:55 AM
|
I just upgraded to windows 7 and I'm having issues getting SqlSpec working.
I tried downloading the SMO x64 .msi installer but when I run it, it gives me an error saying I'm missing the SQLServer2005 CLR files. I've re-installed SQL Server on my system twice and patched to SP3 and still happens...
Microsoft.SqlServer.Management.Smo.FailedOperationException
Microsoft.SqlServer.Smo
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ScriptImpl(ScriptingOptions so)
at a3.a(IScriptable A_0)
------------------------
Script failed for Database 'DB001'.
Microsoft.SqlServer.Management.Smo.FailedOperationException
Microsoft.SqlServer.Smo
at Microsoft.SqlServer.Management.Smo.Scripter.ScriptWithList(DependencyCollection depList, SqlSmoObject[] objects)
at Microsoft.SqlServer.Management.Smo.Scripter.Script(Urn[] urns, SqlSmoObject[] objects)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ScriptImpl(ScriptingOptions so)
------------------------
Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
System.IO.FileNotFoundException
Microsoft.SqlServer.ConnectionInfo
at Microsoft.SqlServer.Management.Common.ServerConnection.GetStatements(String query, ExecutionTypes executionType, Int32& statementsToReverse)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Smo.ExecuteSql.ExecuteImmediate(String query)
at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult result)
at Microsoft.SqlServer.Management.Smo.Environment.GetData()
at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req, Object ci)
at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.InitChildLevel(Urn levelFilter, ScriptingOptions so, Boolean forScripting)
at Microsoft.SqlServer.Management.Smo.SmoCollectionBase.InitializeChildCollection(Boolean refresh)
at Microsoft.SqlServer.Management.Smo.SmoCollectionBase.get_Count()
at Microsoft.SqlServer.Management.Smo.Database.ScriptCreate(StringCollection createQuery, ScriptingOptions so)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ScriptCreateInternal(StringCollection query, ScriptingOptions so)
at Microsoft.SqlServer.Management.Smo.Scripter.ScriptWithListWorker(DependencyCollection depList, SqlSmoObject[] objects)
at Microsoft.SqlServer.Management.Smo.Scripter.ScriptWithList(DependencyCollection depList, SqlSmoObject[] objects)
Andrew Pfeiffer
Database Administrator
Bodybuilding.com
|
|
|
Jesse
Forum Admin
463 Posts |
Posted - Mar 04 2010 : 09:27:25 AM
|
>> I've re-installed SQL Server on my system twice
when you did so, did you install the client tools? if so that should install SMO. You shouldn't need to install SMO separately if you install the SQL Server client tools (like Management Studio, etc). |
 |
|
|
DBAndrew
Starting Member
9 Posts |
Posted - Mar 04 2010 : 09:54:01 AM
|
Yes, I installed the client tools. This is the only way I know of to get SQL Server Management Studio (SSMS). One thing I find odd is Windows 7 gives errors and complains about this version of SQL Server during installation but it will install Client tools aka SSMS. I'm wondering if I need to remove SSMS 2005 and install the SSMS 2008 client tools?
In my environment all my server are running 2005. I hear the 2008 tools are backwards compatible. The only reason I didn't upgrade sooner was, I heard horor stories from friends telling me how they removed functionality from the 2008 tools. Like you cannot open a table and change the column order with the 2008 tools.
I'm installing from a SQL Server 2005 x64 Standard Edition DVD.
I'm running Windows 7 Professional x64
Andrew Pfeiffer
Database Administrator
Bodybuilding.com
|
Edited by - DBAndrew on Mar 04 2010 10:01:18 AM |
|
|
|
Jesse
Forum Admin
463 Posts |
Posted - Mar 04 2010 : 10:16:15 AM
|
does SSMS work normally on the machine where you are running SqlSpec? if so is it SSMS 2005 or 2008? My reading of the above is 2005, but just making sure.
As a test, can you try to script a table in SSMS and see if it works? just right click on any table in object explorer and do script as->create->to new query window |
|
|
|
DBAndrew
Starting Member
9 Posts |
Posted - Mar 04 2010 : 11:05:00 AM
|
SSMS 2005 works normally. The scripting of objects works, tested on table, index, stored procedure.
Andrew Pfeiffer
Database Administrator
Bodybuilding.com
|
|
|
|
Jesse
Forum Admin
463 Posts |
Posted - Mar 04 2010 : 11:14:19 AM
|
| maybe it's a permissions issue. Are you running SSMS as an admin, and SqlSpec not? If so the non-admin user may not have rights to load Microsoft.SqlServer.BatchParser, which is the assembly that fails to load, causing the failure |
|
|
| |
Topic |
|
|
|
SqlSpec on Windows 7 ?
