Sony's comments on similar issues;
1. Verify the Microsoft SQL Server Desktop Engine is installed.
Also, Sony Technical Support has a new diagnostic tool they can send you if you call and explain the problem you're having.

I have uninstalled and reinstalled a few times and even reinstalled version 6.0a from the original CDs to see if that would help.

I have verified that both the SQL Desktop Engine and the Media Manager are installed and I have successfully started the SQL Engine service. The problem manifests itself when I try to to creat a new media library since it errors when it tries to create the default one.

The is what the .log file shows.

*Start*

[Log Started]
2005-06-19 07:59:57,437 [2000] FATAL Sony.MediaSoftware.MediaMgr.AssemblyLoad [] - Failed to open last active library.
Exception: Sony.MediaSoftware.Kernel.Database.GenericSqlException
Message: Line 1: Incorrect syntax near 's'.(class 15 number 170)
Source: Sony.MediaSoftware.MediaMgr
at Sony.MediaSoftware.MediaMgr.DataAccess.SqlServerUtil.CreateSqlServerDatabaseUsingWorker(MediaLibrary newLib, MediaLibrary templateLib)
at Sony.MediaSoftware.MediaMgr.SqlMediaLibraryMgr.CreateFromTemplateAndOpen(String libraryName, String libraryDir, MediaLibrary templateLib, MediaLibrary& newLib)
at Sony.MediaSoftware.MediaMgr.SqlMediaLibraryMgr.OpenLastActiveLibrary()
at Sony.MediaSoftware.MediaMgr.AssemblyLoad.OpenLastActiveLibrary()

Nested Exception

Exception: System.Data.SqlClient.SqlException
Message: Line 1: Incorrect syntax near 's'.
Source: .Net SqlClient Data Provider
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Sony.MediaSoftware.MediaMgr.DataAccess.SqlServerUtil.CreateSqlServerDatabase(MediaLibrary newLib, MediaLibrary templateLib)


2005-06-19 08:00:32,968 [2000] FATAL Sony.MediaSoftware.MediaMgr.AssemblyLoad [] - UI thread had an unhandled exception!
Exception: Sony.MediaSoftware.Kernel.Database.GenericSqlException
Message: Line 1: Incorrect syntax near 's'.(class 15 number 170)
Source: Sony.MediaSoftware.MediaMgr
at Sony.MediaSoftware.MediaMgr.DataAccess.SqlServerUtil.CreateSqlServerDatabaseUsingWorker(MediaLibrary newLib, MediaLibrary templateLib)
at Sony.MediaSoftware.MediaMgr.SqlMediaLibraryMgr.CreateFromTemplateAndOpen(String libraryName, String libraryDir, MediaLibrary templateLib, MediaLibrary& newLib)
at Sony.MediaSoftware.MediaMgr.SqlMediaLibraryMgr.CreateNewAndOpen(String libraryName, String libraryDir, MediaLibrary& newLib)
at Sony.MediaSoftware.MediaMgr.UI.UILibraryNewForm.btnOK_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Nested Exception

Exception: System.Data.SqlClient.SqlException
Message: Line 1: Incorrect syntax near 's'.
Source: .Net SqlClient Data Provider
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Sony.MediaSoftware.MediaMgr.DataAccess.SqlServerUtil.CreateSqlServerDatabase(MediaLibrary newLib, MediaLibrary templateLib)

*Stop*

I am running no other applicationis which require SQL.

A couple of questions:

1. What are you trying to name your new media library?
2. Do you have any files in My Documents\Sony Media Libraries? Did you manually rename any of those files?

Vegas 6.0b has some important fixes and I would definitely recommend downloading and installing it.

To prevent the Media Manager from finding and trying to load your last active library, try renaming your My Documents\Sony Media Libraries folder temporarily and then launch Vegas.

The other way to troubleshoot this is to enable more verbose logging by the Media Manager component. With notepad you could edit c:\program files\sony\vegas 6.0\vegas60.exe.config and near the bottom look for this line:

<level value="ERROR" />

and change the "ERROR" value to "ALL". Then re-create the problem and post the vegas60.log file. Just remember to put this back as it definitely slows things down by logging such verbose information all the time.

I have tried renaming the new media library to Default (since it never created the default), new and test with no success.

The only file in the library directory was AutoTag.xml file.

I have tried this with both version A and B.

I checked my event log and this entry is created everytime I start Vegas.

http://www.hellshock.net/helo/sony/sql_error.gif


I enable the full logging and started Vegas and attempted to create a media library with both A and B versions.

http://www.hellshock.net/helo/sony/sony_log.txt

The message in the Windows event log is a red herring according to Microsoft:
http://support.microsoft.com/default.aspx?scid=kb;en-us;303411

The root problem is that we are not handling correctly the folder where you are trying to create your library:

C:\Bobby's Documents\Sony Media Libraries

The apostrophe in Bobby's is causing a parsing error in some SQL statements. We have entered this as a bug. As a workaround with the current version, try creating a media library in any folder path that does not contain '. Sorry for the inconvenience this has caused you.