What are the correct settings for user "sa" in MSSQL Express? (1 Viewer)

[etheesdad]

TV-Server Version: svn2075
MediaPortal Version: svn2075
MediaPortal Skin: monochrome
Windows Version: xp mce sp3
CPU Type: celeron 2.4
HDD: seagate 80 + WD 160
Memory: 1gb ddr
Motherboard: ga-8ig1000 pro
Video Card: radeon 9200 se
Video Card Driver: 8.252.0.0
Sound Card: soundblaster
Sound Card AC3:
Sound Card Driver: 5.1.260.5512
1. TV Card: hve-1100
1. TV Card Type: dvb-t
1. TV Card Driver: 2.122.2619.0
2. TV Card: dvt2000h
2. TV Card Type: dvb-t
2. TV Card Driver: 4.0.112.3113
3. TV Card:
3. TV Card Type:
3. TV Card Driver:
4. TV Card:
4. TV Card Type:
4. TV Card Driver:
MPEG2 Video Codec: k-lite
MPEG2 Audio Codec: k-lite
h.264 Video Codec: k-lite
Satelite/CableTV Provider:
HTPC Case: silverstone lc20
Cooling: custom
Power Supply:
Remote: imon
TV:
TV - HTPC Connection: s-video

Ive got a recurring error trying to start tv server, with login failling for user "sa". This is from a fresh install of tvserver and mssql express.

I have not changed anything from default settings, and followed the instructions here to do the install
TV-Server/install-SQL-Server - MediaPortal Manual Documentation

Firewall allows connection. (single seat setup). SQL Browser service is running.

---------

MEDIABOX5\SQLEXPRESS\Databases\MpTvDbRC2\Security\Users\

sa is not listed. Is this correct?

---------

MEDIABOX5\SQLEXPRESS\Databases\MpTvDbRC2\Security\Users\dbo

login name - sa

Owned schemas
(none)

Database Role Membership
- db_owner

MEDIABOX5\SQLEXPRESS\Security\Logins\sa

General
- enforce password policy is ticked
- default database = master

Server Roles
- public
- sysadmin

User mapping
:users mapped to this login
- master
- model
- MpTvDbRC2
- msdb
- tempdb

Database role membership
- db_owner
- public

Status
: permission to connect
- grant

:login
- enabled

(login is not "locked out")

-------------

Are there any other elements I should be looking at?

Thanks very much to anyone familiar with MSSQL who can help.

BTW, it would be really useful to have working settings for single-seat & multi-seat installations posted in the documentation for TV server....

 

[flokel]

Please try the latest RC4.

With the installer you do not have to install and configure the SQL server by hand,
it's done automatically.

 

[etheesdad]

wow. I didnt know it was out... will go away and try it. thanks!

 

[etheesdad]

Nope. didnt work. setuptv.exe came up with --config-db. selected MSSQL and it logged in. Was fine while I was setting up channels, then when I rebooted the machine it locked out user SA again.

Strangely, when I run setuptv.exe --configure-db, the test login works fine "test succeeded", so I hit save, then if I try to start the TV Server configuration, it chokes, & says "tv server not started"

2008-11-30 08:52:00.906250 [TVService]: Exception   :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=MpTvDbRC4;Data Source=mediabox5\SQLEXPRESS;Connection Timeout=300; ---> System.Data.SqlClient.SqlException: Cannot open database "MpTvDbRC4" requested by the login. The login failed.
Login failed for user 'sa'.
   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 Gentle.Provider.SQLServer.SQLServerProvider.GetConnection()
   --- End of inner exception stack trace ---
   at Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)
   at Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)
   at Gentle.Provider.SQLServer.SQL92Analyzer.Analyze(String tableName)
   at Gentle.Provider.SQLServer.SQLServerAnalyzer.Analyze(String tableName)
   at Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map)
   at Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type)
   at Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type)
   at Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator)
   at Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type)
   at TvDatabase.TvBusinessLayer.GetSetting(String tagName, String defaultValue)
   at TvLibrary.Implementations.TvCardCollection..ctor()
   at TvService.TVController.InitController()System.Data.SqlClient.SqlException: Cannot open database "MpTvDbRC4" requested by the login. The login failed.
Login failed for user 'sa'.
   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 Gentle.Provider.SQLServer.SQLServerProvider.GetConnection()
Exception   :The database backend (provider SQLServer) could not be reached.
Check the connection string: Password=MediaPortal;Persist Security Info=True;User ID=sa;Initial Catalog=MpTvDbRC4;Data Source=mediabox5\SQLEXPRESS;Connection Timeout=300;
  site      :Void FailWith(Gentle.Common.Severity, Gentle.Common.Error, System.Exception, System.String)
  source    :Gentle.Common
  stacktrace:   at Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)
   at Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)
   at Gentle.Provider.SQLServer.SQL92Analyzer.Analyze(String tableName)
   at Gentle.Provider.SQLServer.SQLServerAnalyzer.Analyze(String tableName)
   at Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map)
   at Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type)
   at Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type)
   at Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator)
   at Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type)
   at TvDatabase.TvBusinessLayer.GetSetting(String tagName, String defaultValue)
   at TvLibrary.Implementations.TvCardCollection..ctor()
   at TvService.TVController.InitController()

 

[etheesdad]

also, MSSQL Studio does this when it starts

How do I find out what the error is?