'Videos' Plugin Development

[tvshowman]

Hi!

ok here is where I am at...

I installed a fresh copy of Windows XP/wsp2

installed required files for gbpvr net 2.0 vsd and latest gbpvr up and running with cards configured.
installed cs3
installed .net3.5 and sqlexpress 2005.
ran the videos installer bam blue screen. did not make it to any config screen in the installer

logged into safe mode disabled all non M$ services which allowed me to enter normal without bsod.

installing sp3 4 xp as we speak and will continue from there

off to look for any service packs for sql

will post updates as they become available. my pvr hates sql server for some reason.

EDIT
For easy access to those in need.
Microsoft SQL Server 2005 Service Pack 2
Brief Description
Download Service Pack 2 for Microsoft SQL Server 2005.
Quick Details
Version: 9.00.3042
Knowledge Base (KB) Articles: KB921896
Date Published: 3/6/2007
Language: English
Download Size: 282.4 MB - 392.4 MB*
download
http://www.microsoft.com/downloads/detai...laylang=en

EDIT 2
Microsoft SQL Server 2005 Service Pack 3
Quick Details
Version: 9.00.4035
Knowledge Base (KB) Articles: KB955706
Date Published: 12/15/2008
Language: English
Download Size: 326.0 MB - 1135.7 MB*
*Download size depends on selected download components.
http://www.microsoft.com/downloads/detai...laylang=en

[tvshowman]

UPDATE:

Ok installing just the Windows XP Service pack 3 cured the BSOD plague and I am able to use the installer but get stopped at the login details.

I have entered the following info.

192.168.1.101\sqlexpress
VideosDB
blank
blank

error - failed to create database.

Decided to password my windows login and tried again
192.168.1.101\sqlexpress
VideosDB
pvrmachine
password
error - failed to create database.

tried both compact and server settings and tcp check and unchecked...

any ideas?

[reven]

you wont be able to use windows credentials, you'll need to either use blank which would be the user you are currently logged in as (but then the file watcher service, the thing that constantly scans your locations for new files) would try to access the db using a windows service account user and more than likely be denied.

so you should pass in a sql login. usually
username: sa
password: password
but you may need to configure sql server to use that.

if you have sql management studio express (or full) try the following if sa/password fails
1. open sql management studio express (or full)
2. connect to localhost\sqlexpress
3. select your db from the left tree, {machinename}\sqlexpress (SQL Server 9.xxx) (10 for 2008)
4. right click go to properties
5. go to the "Security" page
6. set "Server Authentication" to "SQL Server and Window Authentication mode"
7. click "ok"

sql server now will be using both modes, try the sa/password again in the installer, if it fails still, we need to add a user.

back in management studio
1. on the {machinename}\sqlexpress node on in the left tree, expand it, then "Security" and "Logins"
2. right click "Logins" and select "New Login"
3. Login name: "user" (or whatever you want)
4. choose "SQL Server authentication" and choose your password, uncheck "Enforce password policy"
5. we're done with that page, choose the "Server Roles" on the side and tick "dbcreator"
6. click "ok"

now try that user in the 'Videos' setup wizard.
hopefully that will work.

dont worry in later versions, perhaps the next release, you will be able to user sql server ce, which wont require any extra downloading or configuring.
just to get this release out quickly i just got sql server working.

[tvshowman]

Tried it all including add new user...

could it be my local host?

I tried local ip - 192.168.1.101\SQLExpress

tried machineid\SQLExpress

tried machineid\user\SQLExpress

failed to create database....

[reven]

what were the connection settings in sql management studio?
Server Name: ???
Authentication: ???
Username : ???
Password: ???
(you dont need to tell me your username/password )

those are the settings the videos install wizard should use.
and try connecting to the sql server using managment studio with the user you created.

[tvshowman]

what were the connection settings in sql management studio?
Server Name: machinepvr\SQLEXPRESS
Authentication: Windows integraded
Username : pvrmachine
Password: password
those are the settings the videos install wizard should use.
and try connecting to the sql server using managment studio with the user you created.

It is importat to note that I started management again and changed the login to sl server and inputed the data I created on the account and logged in fine to the server

could it be the firewall?

I am installing sql sp2 as we speak and see if anything changes

EDIT

what a pain ... in the sql update it says to select what components you want to update but it won't let me select sqlexpress and database lmao.

all the others are checked.

[reven]

authentication needs to be "SQL Server Authentication" to correctly test the new user you created.

it could be tcpip, open the "SQL Server Configuration Manager" (it should be in your start menu somewhere).

expand
SQL Server Configuration Manager \ SQL Server 2005 Network Configuration \ Protocols for SQLExpress

and then enable, "Shared Memory", "Named pipes", "TCP/IP". via can be left disabled.

then go back to the "SqL server 2005 services" node, and right click "SQL Server (SQLEXpress)" and click restart.

then try connecting again via the install wizard.

sorry im making you jump through all these hoops, i forgot how difficult sql server could be to setup if your not familiar with it i use it every day and just take it for granted ill make sure sql server CE works in the next release

[tvshowman]

hi reven

enabled as suggested still no love.

I can't think of anything that will make it work...

even disabled the xp firewll

heheh don't worry about the hoops this is more fun then watching tv literally. it's like a cool hobby and I learn alot about things and the payoff is well worth it.

Thanks so much for helping me figure things out.

[reven]

lets just concentrate on connecting via the sql management studio.

can you connect using the settings
Server Name: machinepvr\SQLEXPRESS
Authentication: SQL Server Authentication
Username : pvrmachine
Password: password

also in the %temp% directory (just type %temp% into the windows explorer address bar) there should be a log file for the dbcreator, cant remember what its called exactly but it should be in there (on a mac atm)

[tvshowman]

Hi I wasn't sure if you were going to be right away but sounds lik you are live.

Here is what I have found by using the date shuffle.
VideosDatabaseWizard.log

Code:

rgument: -createdb
Argument: Data Source=192.0678.1.101\SQLEXPRESS;Initial Catalog=VideosDB;Network Library=DBMSSOCN;User Id=pvr172010;Password=1111;
Creating Database
CreateActualDatabase: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   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 Reven.GBPVR.DAL.DatabaseCreator.CreateActualDatabase(String ConnectionString, String DatabaseName) in C:\Users\John\Documents\Source Code\GBPVR\Videos\Reven.GBPVR.DAL\DatabaseCreator.cs:line 207
Failed to create actual Database

There is no dbcreator.log and the rest are java or old before the sql install stuff

hope that has some info

EDIT
What is Data Source=192.0678.1.101?

Seems close to the machines IP on the network? drawng straws

EDIT 2
can you connect using the settings (yes in server management)
Server Name: machineID\SQLEXPRESS
Authentication: SQL Server Authentication
Username : pvrmachine
Password: password