BP2X does not connect to MSSQL
Submitted by emile on Thu, 16/08/2007 - 22:19.
I have installed bp2x and mssql both with no errors, but i can not get them to connect. your tutorial skips a step so i don't know if that is what is not allowing me to correctly set up the sql account.
thanx
Posted on behalf of user.
Re: BP2X does not connect to MSSQL
Once you have installed BP2X and MSSQL successfully, you need to run two executables in sequence before you get into the application.
1. RemotePlayerHost.exe
2. WinUI.exe
Installing BP2X using the installer does not create the database schema, nor does installing MSSQL.
When you run RemotePlayerHost.exe for the first time, it will attempt to connect to MSSQL and create the schema for you. RemotePlayerHost will use the configuration details you have entered while installing BP2X to connect to MSSQL. So, the MSSQL configuration you used to install MSSQL has to match the MSSQL configuration you used when installing BP2X. If they don't, then RemotePlayerHost won't be able to connect to MSSQL. You will either have to uninstall the application and reinstall with theh right MSSQL settings, or you can venture and open the file RemotePlayerHost.exe.config which contains the configuration data RemotePlayerHost.exe will use in XML format.
The main entry you are interested in to change is:
<add key = "Connection" value = "Password=password;User ID=sa;Initial Catalog=bp2x;Data Source=EMILE\sql1" />
Make sure the values there match what you used for installing MSSQL on your machine.
When you get RemotePlayerHost.exe to successfully run the first time and connect to MSSQL, it will prompt you to create the schema.
See this help file page: http://www.bp2x.com/bp2xhelp/howtostart.htm
You can test your MSSQL connection using the OSQL command from a DOS prompt. Use the values that successfully connect you to MSSQL for the configuration file mentioned above.
If you make changes to the RemotePlayerHost.exe.config file, please apply the changes to WinUI.exe.config file too.
Also, there may be other reasons why BP2X cannot connect to MSSQL.
1. The TCP port MSSQL uses is disabled in MSSQL or blocked by a firewall
2. The instance name is wrong
3. The sa password is wrong
You can check the log files generated when you run RemotePlayerHost.exe or WinUI.exe for the details of any error, like BP2X not connecting to MSSQL. These log files can be found in the directory, C:\Program Files\Media Bonza\Broadcast Power\2.5
The log file have the extension .txt but have the word Log in their name, example:
1. RPHLog.txt
2. WinUILog.txt
3. Plugins.logs.txt
I need more info
Ok, I re-installed the program as is. I followed your instructions: but the host just gives me a login error when I start it, and that's it. After that, nothing. Can you plase tell me how to get into the config file? It says "login failed for sa" but it does not give me any options after that, it just dies.
RE: I need more info
The config files are simply text files (XML to be exact). You can open them with any text editor (notepad, notepad++, etc...).
Also, did you check these other forum topics: http://www.bp2x.com/node/61
and
http://www.bp2x.com/node/7
First thing you need to do is make sure you can connect to the SQL instance you installed from the command prompt and them work your way to the config file settings.
If you used the defaults during installation, you shouldn't have to make any changes to the config files.
To reinstall the application, it is not enough to uninstall and then install again. You have to make sure that Microsoft SQL Server has uninstalled properly, or manually uninstall it and clean its directories.
A good guide to what you're doing are the log files. These again are text files that you can open with any text editor. Search for the word "Error". These will give you the details of the error messages you see when starting up the RemotePlayerHost application.