MP TV/SQL Error (1 Viewer)

[craigparris1]

Hi clarkey,

Did you get around to checking the actual SQL Server itself? Your best bet would be to install the SQL Server Express Management Studio - you can get it here (Microsoft downloads site).

You'll need to try and connect to your local SQL Server instance (usually this will be called (local)\SQLExpress). The username will be "sa" and the password should be "MediaPortal" (don't include the double-quotes, and the password is case-sensitive). Obvioulsly, if you know you've changed the sa password to something else, then you'll need to use that).

You should also take a look in your Windows Event Viewer - check the "Application" and "System" logs and see if there are any errors/messages logged in there by SQL Server that might indicate why it's having problems.

I do work with SQL Server, so I'll be happy to assist, but there's not quite enough info from you at the moment to work out exactly what the problem is.

Cheers,
Craig

 

[clarkey2r]

Hi clarkey,

Did you get around to checking the actual SQL Server itself? Your best bet would be to install the SQL Server Express Management Studio - you can get it here (Microsoft downloads site).

You'll need to try and connect to your local SQL Server instance (usually this will be called (local)\SQLExpress). The username will be "sa" and the password should be "MediaPortal" (don't include the double-quotes, and the password is case-sensitive). Obvioulsly, if you know you've changed the sa password to something else, then you'll need to use that).

You should also take a look in your Windows Event Viewer - check the "Application" and "System" logs and see if there are any errors/messages logged in there by SQL Server that might indicate why it's having problems.

I do work with SQL Server, so I'll be happy to assist, but there's not quite enough info from you at the moment to work out exactly what the problem is.

Cheers,
Craig

Hello

Right, last night I did a complete uninstall and reinstall of SQL Express2005 and MP.
Media Portal install was fine and so was the SQL, but when I click on the MP TV Configuration shortcut I get to test the connection (passes this fine, it didnt pass this before the reinstall) and then get an error 'unable to create database'???

If you can tell me exactly what you want log-wise (and where to look for the SQL logs) I will get it later!

Thanks in advance
Clarkey

 

[fromaron]

Right, last night I did a complete uninstall and reinstall of SQL Express2005 and MP.
Media Portal install was fine and so was the SQL, but when I click on the MP TV Configuration shortcut I get to test the connection (passes this fine, it didnt pass this before the reinstall) and then get an error 'unable to create database'???

If you can tell me exactly what you want log-wise (and where to look for the SQL logs) I will get it later!

Thanks in advance
Clarkey

From my memory you need to delete the old Tv database.

 

[craigparris1]

Hi clarkey,

Fromaron is probably right - if the previous databases are still there, then trying to create a new database will fail. Although, you have said that you did an uninstall, then re-install, of SQL, so if that is actually the case, you should haven't have had old databases still there.

Anyway, first task is to download and install SQL Server Express Management Studio (via the link I provided earlier). Management Studio doesn't get installed by default with SQL Server Express Edition - you have to download and install it separately.

Once you've done that, you'll need to log on to the SQL Server, through Management Studio, and verify what databases current exist on the server.

You should also check the Tv-Server logs - I'm not sure if the configuration utility logs details of database-related errors, but it's worth checking. Otherwise the actual Windows event logs may have some pointers.

Cheers,
Craig

 

[Marvman]

Hello

Right, last night I did a complete uninstall and reinstall of SQL Express2005 and MP.
Media Portal install was fine and so was the SQL, but when I click on the MP TV Configuration shortcut I get to test the connection (passes this fine, it didnt pass this before the reinstall) and then get an error 'unable to create database'???

If you can tell me exactly what you want log-wise (and where to look for the SQL logs) I will get it later!

Thanks in advance
Clarkey

Isn't that what i told you 4 days ago?

Hi Clarkey,

i meant with SQL Administrator the MSSQL Admin Tool, i don't know the exact name of it, cause i use MySQL.

Similiar tools can you find at MS SQL Tools - MSSQL Admin Tools - SQL Server Tools - MSDE Tools by SQL Maestro Group

But i don't know if you can repair your DB with this tools, with MySQL you can

Maybe you can attach logs?

The easy way would be, to delete your DB and re-install MP, BUT its not a guaranty that MP works after this.

 

[clarkey2r]

Hello

Right, last night I did a complete uninstall and reinstall of SQL Express2005 and MP.
Media Portal install was fine and so was the SQL, but when I click on the MP TV Configuration shortcut I get to test the connection (passes this fine, it didnt pass this before the reinstall) and then get an error 'unable to create database'???

If you can tell me exactly what you want log-wise (and where to look for the SQL logs) I will get it later!

Thanks in advance
Clarkey

Isn't that what i told you 4 days ago?

Hi Clarkey,

i meant with SQL Administrator the MSSQL Admin Tool, i don't know the exact name of it, cause i use MySQL.

Similiar tools can you find at MS SQL Tools - MSSQL Admin Tools - SQL Server Tools - MSDE Tools by SQL Maestro Group

But i don't know if you can repair your DB with this tools, with MySQL you can

Maybe you can attach logs?

The easy way would be, to delete your DB and re-install MP, BUT its not a guaranty that MP works after this.

Yep, I only got 'round to looking at it last night!

 

[clarkey2r]

Right, I have installed the management studio and can confirm that the database is there!

Where should I go from here? If logs need attaching, which ones where can i find them?

I have sorted it!!!

I found the old db's renamed them .old, let MP create new ones and then renamed the old ones back to how they were

Thanks for all the help!!!