Reply to thread

Message

Hmm, it partially worked. I got SQL server installed OK, and I ran setuptv with the configure-db param, and that seemed to work in that I selected MS SQL Server and clicked Test and it succeeded - but it doesn't appear to have created the database. If I try and start the TV service it fails with:

2012-12-18 09:38:18.209544 [TVService(6)]: TvService OnStart failed : Error: DatabaseUnavailableUnclassified
Gentle.Common.GentleException: The database backend (provider SQLServer) could not be reached.
Check the connection string: Password=MediaPortal;Persist Security Info=True;User ID=sa;Initial Catalog=MpTvDb;Data Source=pvr\SQLEXPRESS;Connection Timeout=30; ---> System.Data.SqlClient.SqlException: Cannot open database "MpTvDb" requested by the login. The login failed.
Login failed for user 'sa'.

Is there some step I've missed which creates the database?

Jon.

<blockquote data-quote="jonm" data-source="post: 945294" data-attributes="member: 87159">Hmm, it partially worked. I got SQL server installed OK, and I ran setuptv with the configure-db param, and that seemed to work in that I selected MS SQL Server and clicked Test and it succeeded - but it doesn't appear to have created the database. If I try and start the TV service it fails with:&nbsp;2012-12-18 09:38:18.209544 [TVService(6)]: TvService OnStart failed : Error: DatabaseUnavailableUnclassifiedGentle.Common.GentleException: The database backend (provider SQLServer) could not be reached.Check the connection string: Password=MediaPortal;Persist Security Info=True;User ID=sa;Initial Catalog=MpTvDb;Data Source=pvr\SQLEXPRESS;Connection Timeout=30; ---&gt; System.Data.SqlClient.SqlException: Cannot open database &quot;MpTvDb&quot; requested by the login. The login failed.Login failed for user 'sa'.&nbsp;Is there some step I've missed which creates the database?&nbsp;Jon.</blockquote>

[QUOTE="jonm, post: 945294, member: 87159"] Hmm, it partially worked. I got SQL server installed OK, and I ran setuptv with the configure-db param, and that seemed to work in that I selected MS SQL Server and clicked Test and it succeeded - but it doesn't appear to have created the database. If I try and start the TV service it fails with: 2012-12-18 09:38:18.209544 [TVService(6)]: TvService OnStart failed : Error: DatabaseUnavailableUnclassified Gentle.Common.GentleException: The database backend (provider SQLServer) could not be reached. Check the connection string: Password=MediaPortal;Persist Security Info=True;User ID=sa;Initial Catalog=MpTvDb;Data Source=pvr\SQLEXPRESS;Connection Timeout=30; ---> System.Data.SqlClient.SqlException: Cannot open database "MpTvDb" requested by the login. The login failed. Login failed for user 'sa'. Is there some step I've missed which creates the database? Jon. [/QUOTE]