Requesting Simple Help with this.

[Burdenz2007]

 Spoiler

2013/06/14 15:50:27
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','19'
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [2].
2013/06/14 15:50:27
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','19'
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]OLE DB provider "SQLNCLI" for linked server "RANKING" returned message "Login timeout expired".
2013/06/14 15:50:27
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','19'
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]OLE DB provider "SQLNCLI" for linked server "RANKING" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".

I think thats the problem thats why when everytime i Create a Guild, after i Relog-in the Guild is Invisible. Totally BUG!

Using the Adeilson Source 3.

Any Comment's will do. Thanks in advance.

[WooTheFck]

delete Linked RANKING

then execute this

exec sys.sp_addlinkedserver 'RANKING', '', 'SQLNCLI', 'SQL SERVER INSTANZNAME', null, null, 'RANKING_DBF'

exec sys.sp_serveroption @server='RANKING', @optname='rpc', @optvalue='true'
exec sys.sp_serveroption @server='RANKING', @optname='rpc out', @optvalue='true'


and write your SQL instance name
then execute

[Burdenz2007]

@WooTheFck - Ok ok. I will try this. Is this gonna fix the Guild Bug? The Guild Invisible?
If im going to execute this, it should be "master"? or what?

[WooTheFck]

yes it will be fix, i tried this procedure and its work and fixed.

[Burdenz2007]

@WooTheFck - LOOK!



****. How can i fix this? :|

[WooTheFck]

you have TeamViewer?

[Burdenz2007]

Yes. Here: User: 857 427 380 Pass: 8119

My Teamviewer is Online now.

[xTwiLightx]

....

Try one of the two options that I provided in the guide.