I'm installing gallery pro on a website hosted by CrystalTech.com.
I have Sql server 2005 on the host and can connect to it, however I had to use my admin account (w/ admin privileges). It had an odd error when attempting to create an account with reduced privileges (SQL server accounts, not Windows).
I chose to script the asp.net membership. I set up my server pro admin account
Then when creating the database -

Ready to Install

Click Next to update the database and configure Gallery Server Pro.

I got this error.... (below)... not sure what happened. Any idea?


Error executing SQL in InstallGalleryServerProSql2005.sql. Incorrect syntax near '0x0a0d'. Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Unclosed quotation mark after the character string ')) ਍䄀䰀吀䔀刀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀最猀开䄀氀戀甀洀崀 䐀刀伀倀 䌀伀一匀吀刀䄀䤀一吀 嬀䘀䬀开最猀开䄀氀戀甀洀开最猀开䄀氀戀甀洀崀ഀഀ '.

Error executing SQL: /********************************************************************** / ਍⼀⨀ 䤀渀猀琀愀氀氀䜀愀氀氀攀爀礀匀攀爀瘀攀爀倀爀漀匀焀氀㈀　　㔀⸀猀焀氀                                                   ഀഀ ਍ 䤀渀猀琀愀氀氀猀 琀栀攀 琀愀戀氀攀猀Ⰰ 猀琀漀爀攀搀 瀀爀漀挀攀搀甀爀攀猀Ⰰ 甀猀攀爀ⴀ搀攀昀椀渀攀搀 昀甀渀挀琀椀漀渀猀Ⰰ 愀渀搀 爀漀氀攀猀 渀攀挀攀猀猀愀爀礀 昀漀爀  ഀഀ core Gallery Server Pro operation. This script runs on SQL Server 2005 and later. ਍ 吀栀椀猀 猀挀爀椀瀀琀 猀栀漀甀氀搀 戀攀 爀甀渀 愀昀琀攀爀 琀栀攀 䴀攀洀戀攀爀猀栀椀瀀 匀儀䰀 猀挀爀椀瀀琀猀⸀ഀഀ ਍⨀⨀ 䌀漀瀀礀爀椀最栀琀 吀攀挀栀 䤀渀昀漀 匀礀猀琀攀洀猀Ⰰ 䰀䰀䌀 ㈀　　㠀⸀ 䄀氀氀 刀椀最栀琀猀 刀攀猀攀爀瘀攀搀⸀ഀഀ */ ਍⼀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⼀ഀഀ ਍⼀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⼀ഀഀ /* BEGIN SECTION 1 (AUTO-GENERATED OUTPUT) */ ਍⼀⨀ഀഀ SECTION 1: Create tables, stored procedures, and user-defined functions. The following script ਍眀愀猀 愀甀琀漀洀愀琀椀挀愀氀氀礀 最攀渀攀爀愀琀攀搀 戀礀 琀栀攀 䐀愀琀愀戀愀猀攀 倀甀戀氀椀猀栀椀渀最 圀椀稀愀爀搀 猀攀琀 琀漀 琀栀攀 昀漀氀氀漀眀椀渀最 漀瀀琀椀漀渀猀㨀ഀഀ All tables, stored procedures, and user-defined functions beginning with "gs_" were selected; ਍猀挀栀攀洀愀 漀甀琀瀀甀琀 漀渀氀礀㬀 琀愀爀最攀琀 搀愀琀愀戀愀猀攀 㴀 匀儀䰀 匀攀爀瘀攀爀 ㈀　　㔀㬀 搀爀漀瀀 漀戀樀攀挀琀猀 㴀 琀爀甀攀ഀഀ ਍一伀吀䔀㨀 吀栀攀 愀甀琀漀ⴀ最攀渀攀爀愀琀攀搀 猀挀爀椀瀀琀 椀渀挀氀甀搀攀搀 漀戀樀攀挀琀猀 眀栀漀猀攀 渀愀洀攀猀 猀琀愀爀琀攀搀 眀椀琀栀 愀猀瀀渀攀琀开Ⰰ 攀瘀攀渀 琀栀漀甀最栀ഀഀ they weren't selected in the wizard. These objects were manually removed from the script. ਍䄀氀猀漀Ⰰ 琀栀攀 䜀刀䄀一吀 匀䔀䰀䔀䌀吀 愀渀搀 䜀刀䄀一吀 䔀堀䔀䌀唀吀䔀 猀琀愀琀攀洀攀渀琀猀 眀攀爀攀 洀漀瘀攀搀 琀漀 猀琀攀瀀  ㈀Ⰰ 樀甀猀琀 愀昀琀攀爀 琀栀攀ഀഀ statement that creates the role gs_GalleryServerProRole.*/ ਍⼀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⨀⼀ഀഀ ਍⼀⨀⨀⨀⨀⨀⨀ 伀戀樀攀挀琀㨀  䘀漀爀攀椀最渀䬀攀礀 嬀䘀䬀开最猀开䄀氀戀甀洀开最猀开䄀氀戀甀洀崀    匀挀爀椀瀀琀 䐀愀琀攀㨀 　㤀⼀　㘀⼀㈀　　㜀 ㄀㠀㨀㐀㐀㨀㌀㤀 ⨀⨀⨀⨀⨀⨀⼀ഀഀ IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_gs_Album_gs_Album]') AND parent_object_id = OBJECT_ID(N'[dbo].[gs_Album]')) ਍䄀䰀吀䔀刀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀最猀开䄀氀戀甀洀崀 䐀刀伀倀 䌀伀一匀吀刀䄀䤀一吀 嬀䘀䬀开最猀开䄀氀戀甀洀开最猀开䄀氀戀甀洀崀ഀഀ

Call stack: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at GalleryServerPro.Web.gs.pages.install.ExecuteSqlInStream(Stream stream)

Check out this thread. It appears that somehow the encoding on the SQL script files is being changed.

I have used FileZilla to copy files to remote servers and then ran the SQL scripts without trouble, so it is more complicated than just blaming FileZilla.

I just did a test on my local system where I switched IIS to Classic mode, and everything still worked correctly, so I am not convinced there is an issue with Classic mode in IIS. Javascript errors are usually caused by a misconfigured web.config file which causes one or more required javascript files to be missing in the browser.

Have you tried sending a private message (PM) to the original poster (goinawry) to see if they got it working on your web host?

Another suggestion is to take the files on your hoster and see if they work on your local machine. That will tell you whether the issue is with the files (maybe a misconfigured web.config file) or something with the hoster.

OK, it's installed. I ftp'd to my crystal tech site and wiped out all the gallery server pro folders and files. I kept all my updated files, web.config and all on my PC, so I had all the SQL server updates and .net 3.5 config files ready to go. Using filezilla, I uploaded everything again, but I chose the type - binary (going windows to windows for me).
I started up the install - ... default.aspx?g=install and went through the instructions. I could not get gallery pro to create it's own sql server account/password... had to use an account I created (this may be a crystal tech thing? I dunno).
Anyhow... it all completed. I logged in, made an album and uploaded a pic.
Good stuff!

All working yay!!!!

My webhost also had .ashx missing from the ASP mappings so getmediaobject.ashx wasn't loading either. :) Everythings completely working now thanks for the suggestions.

That sounds like all of them but I could be missing something. You should use a tool to inspect the net traffic between the browser and the server. That will tell you if there are resources being requested that never get served. There are many to choose from - Firebug is easy to use if you have Firefox.