Help Please

08/07/2012 21:33 [Admin]Death#1
Hello everyone i need someone to help me change the PWs on my Database from shaiya123 i look at the tutorials and all but it wont work i dont know why but i put the new PW in and put it in all the .ini files but still cant start them game. Please PM me on here if you can help me

Thanks for reading ,[Admin]Death
08/07/2012 21:56 TeddyBear94#2
did u used ps_passwordEnc to change ur pw?
08/08/2012 06:19 [Admin]Smile.jpg#3
Not only in ini. You must also change them on Mgr, and as Teddy said the passwords are those codes. On Mgr you put the password, on ini you put the code. You can get a code from ps_passwordEnc just as Teddy said. If you did so, don't forget linked servers.

Code:
if exists(select *
from master..sysservers
where isremote=1 and srvname='game')
begin
exec sp_dropserver 'game','droplogins'
end
exec sp_addlinkedserver 'game','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'game','false',null,'Shaiya','Shaiya123'

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_NCASH')
begin
exec sp_dropserver 'PS_NCASH','droplogins'
end
exec sp_addlinkedserver 'PS_NCASH','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_NCASH','false',null,'Shaiya','Shaiya123'

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_USERDB')
begin
exec sp_dropserver 'PS_USERDB','droplogins'
end
exec sp_addlinkedserver 'PS_USERDB','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_USERDB','false',null,'Shaiya','Shaiya123'

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_USERDB01')
begin
exec sp_dropserver 'PS_USERDB01','droplogins'
end
exec sp_addlinkedserver 'PS_USERDB01','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_USERDB01','false',null,'Shaiya','Shaiya123'

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_DEFINEDB')
begin
exec sp_dropserver 'PS_DEFINEDB','droplogins'
end
exec sp_addlinkedserver 'PS_DEFINEDB','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_DEFINEDB','false',null,'Shaiya','Shaiya123'

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_GAMEDB01')
begin
exec sp_dropserver 'PS_GAMEDB01','droplogins'
end
exec sp_addlinkedserver 'PS_GAMEDB01','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_GAMEDB01','false',null,'Shaiya','Shaiya123'
Replace Shaiya and Shaiya123 with your SQL name and password.
08/09/2012 00:49 [Admin]Death#4
any chance you could get on teamview and help me out with this??
08/09/2012 01:13 Bаne#5
Quote:
Originally Posted by [Admin]Death View Post
any chance you could get on teamview and help me out with this??

[Only registered and activated users can see links. Click Here To Register...]!


Seems legit.