Where to find Database Logon details?

Scoobsheister · 2008-05-16, 22:26

Installed last Friday's SVN build, however i can't remember my logon details for the sql server! :<

Have tried 'sa' and 'MediaPortal' but that doesn't work. Could've sworn i didn't set a password but it didn't like it being blank. Where are the logon details stored in SQL? Is there somewhere i can view what the login should be?

VidarParry · 2008-05-17, 11:01

Hi,

I have the same problem - After installing SVN 19127, starting TV Server configurator prompts for database login, entering the password fails the test. Tried dbadmin, mediaportal.

I also couldn't work out where in SQL Server to see or change the password.

Cheers
...Steve

silver.fly · 2008-05-17, 15:45

To reset a SQL Server user password:
Log on as adminstrator on the pc with sql server, then open up SQL Server Management Studio Express.
Change Authentication to Windows and connect.
Under Security->Logins you should see "sa".
Open up the properties page and you should see the password fields to edit.

VidarParry · 2008-05-18, 03:15

Thanks Silver.Fly.

Had to install SQL Server Management Studio Express, and then it all becam clear:-))

Cheers
...Steve

2008-05-16, 22:26	#1 (permalink)
Scoobsheister Portal Member Join Date: Jun 2006 Posts: 60 Thanks: 2 Thanked 0 Times in 0 Posts	Where to find Database Logon details? Installed last Friday's SVN build, however i can't remember my logon details for the sql server! :< Have tried 'sa' and 'MediaPortal' but that doesn't work. Could've sworn i didn't set a password but it didn't like it being blank. Where are the logon details stored in SQL? Is there somewhere i can view what the login should be?

2008-05-18, 03:15	#4 (permalink)
VidarParry Portal Member Join Date: Feb 2007 Posts: 13 Thanks: 3 Thanked 0 Times in 0 Posts Country: My System	Thanks Silver.Fly. Had to install SQL Server Management Studio Express, and then it all becam clear:-)) Cheers ...Steve __________________ H/W: Silverstone LC17S \| Thermaltake XP550 NP 430W ATX PSU\| S775 DG965WHMKR Core 2 Duo VIIV MB\| S775 Core 2 Duo E6320 1.86GHz CPU \| 2GB DDR2-667Mhz RAM \| 80GB Seagate 7200rpm 8M SATA (System) \| Seagate 320GB IDE 7200RPM (Data) \| Pioneer DVR-212D DVD SATA \| Gigabyte 7300GT 256M PCIe Graphics \| Hauppauge Nova-T-500 MCE Dual-Digital TV Tuner PCI card \| MMC Remote Control \| Motherboard Integrated Sound SPDIF to AV \| Screen:32" LCD TV via DVI \| S/W: XP SP3 \| MP1 1.0.0.0 RC2 \| SVN 19843 \|

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Connection succeeded, but: "unable te create database;logon failed for user sa	jgevaert	Get Support	2	2008-03-11 13:30
Movie database update cannot find several movies on IMDB	Al_Capone	0.2.3.0 RC2 and SVN Builds	11	2007-10-10 16:27
Movie Database - Only tries to find 50% of files	rthomasnj	Support	2	2007-08-10 18:33
Can't logon to SQL server	Topher5000	Get Support	2	2007-06-30 21:16
Movie database scan hängt bei "downloading movie details"	spenca	Media Portal - Support	4	2007-05-16 08:06

2008-05-17, 15:45	#3 (permalink)
silver.fly Portal Member Join Date: Jan 2008 Posts: 8 Thanks: 0 Thanked 1 Time in 1 Post Country:	To reset a SQL Server user password: Log on as adminstrator on the pc with sql server, then open up SQL Server Management Studio Express. Change Authentication to Windows and connect. Under Security->Logins you should see "sa". Open up the properties page and you should see the password fields to edit.