EDIT: Fixed.. read a different thread and just copy pasted the config from my tvserver folder, changed comp name to my ip. I'm still getting failed on the TCP thing... not sure why. Any ideas?
Alright I'm trying to set this up so I can connect to my TvServer from outside my home, over the internet. I can't get it to connect. In the cconfig file, I have this line..
<DefaultProvider name="SQLServer" connectionString="Password=MediaPortal;Persist Security Info=True;User ID=sa;Initial Catalog=MpTvDbRC1;Data Source=(MY IP);" />
When I hit connect in the client exe, I get a FAILED on MS SQL (TCP), everything else is OK. If I go to the Database Settings within the exe, and hit test I get "..... (provider: Named Pipes Provider, error : 40 - Could not open a connection to SQL server)"
In the hostname field, it's just my IP listed. Shouldn't it add \SQLEXPRESS?? or Should I add that myself? When I do, I get "Cannot open database "MpTvDbRC1" requested by the login. The login failed. Login failed for user "sa"". I'm 100% sure the pass I used was MediaPortal, and the username was sa. What I DONT know is the "schema name".. database name. I don't think I changed it, I'm pretty sure it's whatever the default was. I just don't know what that is. How can I figure out what my database/schema name is??? Btw, I don't think it's a port problem with the TCP error, as my comp's in the DMZ, no firewall. I'm on x64 vista btw.
Alright I've been googling and I am now trying to change the port that the MPTV client tries to connect on.. I changed it in the mysql server but how do I change it in the client?
Alright I'm trying to set this up so I can connect to my TvServer from outside my home, over the internet. I can't get it to connect. In the cconfig file, I have this line..
<DefaultProvider name="SQLServer" connectionString="Password=MediaPortal;Persist Security Info=True;User ID=sa;Initial Catalog=MpTvDbRC1;Data Source=(MY IP);" />
When I hit connect in the client exe, I get a FAILED on MS SQL (TCP), everything else is OK. If I go to the Database Settings within the exe, and hit test I get "..... (provider: Named Pipes Provider, error : 40 - Could not open a connection to SQL server)"
In the hostname field, it's just my IP listed. Shouldn't it add \SQLEXPRESS?? or Should I add that myself? When I do, I get "Cannot open database "MpTvDbRC1" requested by the login. The login failed. Login failed for user "sa"". I'm 100% sure the pass I used was MediaPortal, and the username was sa. What I DONT know is the "schema name".. database name. I don't think I changed it, I'm pretty sure it's whatever the default was. I just don't know what that is. How can I figure out what my database/schema name is??? Btw, I don't think it's a port problem with the TCP error, as my comp's in the DMZ, no firewall. I'm on x64 vista btw.
Alright I've been googling and I am now trying to change the port that the MPTV client tries to connect on.. I changed it in the mysql server but how do I change it in the client?