Setting up SQL Server problem

[Ac Bigornia]

TITLE: Connect to Server
------------------------------


Cannot connect to Bigornia.


------------------------------
ADDITIONAL INFORMATION:


A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)


For help, click: http://go.microsoft.com/fwlink?ProdN...2&LinkId=20476


------------------------------
BUTTONS:


OK
------------------------------



Anyone who could help me about this error pls?

[MentaL]

[Terrified]

i presume you are using a different pc from one you installed mssql server. for this reason, you may not be able to connect on that server using port 1104 right? you may install mssql remote browser, then enable the tcp/ip in your mssql server. and in the settings, check the info that allows remote network to accept connection. i also presume you already know how to use mssql studio express so under the server mode, right click it and then properties, check the allow network connection.

i suggest you use mssql 2012 advance and mssql 2012 studio express. it is easier and clearer to understand.

[Ac Bigornia]

Problem solved! Thanks Terrified! Now my problem is when I buy items in npc, i got DCed. :3 Could you help me with this?

[alan110]

Hi Bigornia.

Your problem is that you need to match your Client to your server.

Eidit your tantraparam to your needs then using converter tools make a client tpa and a server tpa .

add the new client tpa to your client system folder and GMTool folder.

Add the new server tpa to all your zones Tantraparam_sv.tpa delete the _sv after adding it to the zones.

if you have a good clientres you may be lucky to have all the items you want if not you will need to edit the clientres.xml as well.

regards Alan110

[Ac Bigornia]

Problem solved again! Thanks alan110. Next problem is the itemserver :3 how to set it up?

[Lunatic]

Ac Bigornia Next problem is the itemserver :3 how to set it up?

Ans:

Just configure the itemserver with those IP and then kindly put the SQL password in config.txt