How to set Sql Authentication? (1 Viewer)

[Tazan]

I had an existing sql server 2008 instance so I installed everything (1.2.2) on the first machine and everything is fine there.

On the second machine I did a client install, selected advanced and was never asked for the sa password. How do I set the SA password on the client?

When the time comes that I have to change the SA password in SQL how do I change it on the clients?

 

[wiiremote]

To change security authentication mode​

1. In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties.
2. On the Security page, under Server authentication, select the new server authentication mode, and then click OK.
3. In the SQL Server Management Studio dialog box, click OK to acknowledge the requirement to restart SQL Server.

​

To restart SQL Server from SQL Server Management Studio​

• In Object Explorer, right-click your server, and then click Restart. If SQL Server Agent is running, it must also be restarted.

​

To enable the sa login by using Transact-SQL​

• Execute the following statements to enable the sa password and assign a password.
  ALTER LOGIN sa ENABLE ;
  GO
  ALTER LOGIN sa WITH PASSWORD = '<enterStrongPasswordHere>' ;
  GO
  
  To enable the sa login by using Management Studio
  
  
  1. In Object Explorer, expand Security, expand Logins, right-click sa, and then click Properties.
  2. On the General page, you might have to create and confirm a password for the sa login.
  3. On the Status page, in the Login section, click Enabled, and then click OK.

​

 

[Tazan]

That would change the password in SQL. I don't need to do that. If I did that then my existing installation of Media Portal on box #1 would stop working.

I need to change the password that Media Portal is using.

 

[psykix]

Edit it in the config file in your client's tv server folder...

Should be something similar to : <DefaultProvider name="SQLServer" connectionString="Password=MediaPortal;Persist Security Info=True;User ID=sa;Initial Catalog=MpTvDbRC1;Data Source=(MY IP);" />

It will only need SQL if you are using the client as a TV server also.

 

[Tazan]

I'm not using it as a server, so maybe I'm on the wrong track. I don't have much of anything in the server folder. I've done a search in files for "SQL" in the program and data folders hoping to find a config file w/o any luck.

If I don't need SQL for a client, something else is going wrong because when I went to the tv guide, it wanted me to open port 1433 to the server for SQL. After I opened the port I'm getting a message the connection to the tV server is good, ports are good, but it can't connect to SQL. If it needs a connection to SQL, then I'm sure it needs the password as I never entered it. If it doesn't need a connection to SQL, then I guess I have something set up wrong somewhere else.

 

[Tazan]

OK, figured it out. You can see the SQL connection string the client is trying to use in a file called gentle.config. I was able to figure out the problem from there.

I have to say though, we're off to a pretty rocky start when I have to download the source code to figure out how to install it.

Also, I'm less than excited about having my SA password in plain text files all over my lan. WMC is looking better and better.