Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
Web Platform Installer Issue
Options
Previous Topic Next Topic
chrisdoan
#1 Posted : Thursday, 2 June 2011 10:21:51 PM(UTC)
Rank: Advanced Member

Joined: 21/12/2009(UTC)
Posts: 82
Location: San Diego
I've been trying with no luck migrating GSP to another server using Web Platform Installer. If I tried to create a new db, it said login fail for user sa. I then created the db GalleryServerPro using SSMS then chose the option to install using the existing db, it kept saying login fail for user GalleryServerPro_user!!! I'm the admin of the server and SQL Server 2008 R2.

What's the easiest way to migrate GSP from one server to another without using Web Platform Installer since it became a pain for me in the last couple of days?

Thanks
Back to top
WWW
Roger Martin
#2 Posted : Friday, 3 June 2011 9:25:26 AM(UTC)
Roger Martin

Rank: Administration

Joined: 3/08/2007(UTC)
Posts: 3,300
Location: Fort Atkinson, WI
The Admin Guide has a section called Migrate Gallery Server Pro to a new location.
Roger Martin
Creator and Lead Developer of Gallery Server Pro
Back to top
WWW
chrisdoan
#3 Posted : Saturday, 4 June 2011 12:03:39 PM(UTC)
Rank: Advanced Member

Joined: 21/12/2009(UTC)
Posts: 82
Location: San Diego
I followed the migration instructions and gave the folder "c:\inetput\wwwroot\gallery" full acess for the NETWORK SERVICE account but when I tried to launch GPS, it gave me the error:

An error occurred.
We are sorry, but Gallery Server Pro encountered an error. It has been logged and, if error reporting is enabled, an email describing the problem has been sent to the administrator.
Error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

Can you offer any help to get GSP migrated to the a new location?

Thanks
Back to top
WWW
Roger Martin
#4 Posted : Sunday, 5 June 2011 8:35:58 PM(UTC)
Roger Martin

Rank: Administration

Joined: 3/08/2007(UTC)
Posts: 3,300
Location: Fort Atkinson, WI
To see error details the next time it happens, set debug to "true" in web.config. Then refresh the web page. Once we know the actual error message, we can go from there...
Roger Martin
Creator and Lead Developer of Gallery Server Pro
Back to top
WWW
chrisdoan
#5 Posted : Tuesday, 7 June 2011 9:30:55 AM(UTC)
Rank: Advanced Member

Joined: 21/12/2009(UTC)
Posts: 82
Location: San Diego
I set debug=true, tried again and got the detail error message below:


HelpLink.ProdName: Microsoft SQL Server

HelpLink.EvtSrc: MSSQLServer

HelpLink.EvtID: 18456

HelpLink.BaseHelpUrl: http://go.microsoft.com/fwlink

HelpLink.LinkId: 20476

Error Handling Exception: The following error occurred while handling the exception: System.Data.SqlClient.SqlException - Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Stack trace: at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at GalleryServerPro.Data.SqlServer.Util.GetSqlVersion()
at GalleryServerPro.Data.SqlServer.Error.Save(IAppError appError)
at GalleryServerPro.ErrorHandler.Error.Record(Exception ex)
at GalleryServerPro.Web.Controller.AppErrorController.HandleGalleryExceptio n(Exception ex)
Back to top
WWW
Roger Martin
#6 Posted : Tuesday, 7 June 2011 10:13:06 AM(UTC)
Roger Martin

Rank: Administration

Joined: 3/08/2007(UTC)
Posts: 3,300
Location: Fort Atkinson, WI
The error message is pretty self explanatory. Your connection string is using Windows Authentication and SQL Server won't let the IIS identity (NT AUTHORITY\ANONYMOUS LOGON) log on. Add this user to SQL Server or modify the authentication info in the connection string.
Roger Martin
Creator and Lead Developer of Gallery Server Pro
Back to top
WWW
chrisdoan
#7 Posted : Wednesday, 8 June 2011 9:15:13 PM(UTC)
Rank: Advanced Member

Joined: 21/12/2009(UTC)
Posts: 82
Location: San Diego
Now, I'm getting another permission error with "NT AUTHORITY\NETWORK SERVICE"

Exception Data
Error Handling Exception: The following error occurred while handling the exception: System.Data.SqlClient.SqlException - Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Stack trace: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

I've added "NT AUTHORITY\NETWORK SERVICE" to SQL Server and gave it access to the folder "C:\inetpub\wwwroot\gallery"

I'm not sure what else to check to get this working again!
Back to top
WWW
Roger Martin
#8 Posted : Thursday, 9 June 2011 8:56:19 AM(UTC)
Roger Martin

Rank: Administration

Joined: 3/08/2007(UTC)
Posts: 3,300
Location: Fort Atkinson, WI
Permissions issues can be difficult to figure out, and it is even harder for me since I don't know your network architecture. The error message is making it clear, though, that user 'NT AUTHORITY\NETWORK SERVICE' is not able to log on to SQL Server.

In addition to adding the account to SQL Server, have you given it permission to the gallery database?
Roger Martin
Creator and Lead Developer of Gallery Server Pro
Back to top
WWW
chrisdoan
#9 Posted : Thursday, 9 June 2011 9:28:59 AM(UTC)
Rank: Advanced Member

Joined: 21/12/2009(UTC)
Posts: 82
Location: San Diego
The Map checkbox for the security database inside "User mapping" of "Security" for 'NT AUTHORITY\NETWORK SERVICE' was unchecked! I checked it and it worked now. Thanks for pointing me to the right direction.
Back to top
WWW
Rss Feed  Atom Feed
Users browsing this topic
Guest
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF 1.9.5.5 | YAF © 2003-2011, Yet Another Forum.NET