[TUTORIAL] Setup Server and Client EU 1.69

[Gizli içerik]


Sunucu Kurulum Kılavuzu(AB/TW/ABD)​



Sunucu-İstemci Dosyaları:
[Gizli içerik]




Önkoşullar
Başlamadan önce sunucunuza aşağıdakileri indirin ve yükleyin:

  • SQL Sunucu Ekspresi - - ("Özel" kurulumu seçin)
  • SQL Server Yönetim Stüdyosu (SSMS) - - (Yalnızca çekirdek bileşenler)
  • XAMPP - - (Web sunucusu için)
  • SQLite için DB Tarayıcı - - (.db3 dosyalarını düzenlemek için istemcide de gereklidir)
  • Görsel C++ Yeniden Dağıtılabilirler 2012 - - (hem x86 hem de x64)





VM'MI KULLANMAK:

Gerekli Süre: 0,5-1 saat | Test Edildi: Windows 10 Pro​



Vindictus Private Server - Hızlı Kurulum (Önceden yapılandırılmış VM)

Önceden yapılandırılmış VM görüntüsüyle kullanım için. Sadece IP değişiklikleri gerekli.
Bu yapılandırma GUEST (VM SERVER) içindir ve HOST (CLIENT GAME) aynı bilgisayardadır
​




Başlamadan Önce

Yerel IP adresinizi alın. Buna telefon edeceğiz SENIN_IP.

  1. Komut İstemi'ni açın
  2. Türü ipconfig
  3. Için ara IPv4 Adresi (örneğin, 192.168.1.100)





SUNUCU (VM)​


[Gizli içerik]



DOSYALARIMLA SIFIRDAN:

Gerekli Süre: 2-3 saat | Test Edildi: Windows 10 Pro​



Önemli: Sunucu IP Adresinizi Alın


Bu kılavuz boyunca LAN IP adresinize ihtiyacınız olacak. Hatırlasana!.

Bulmak için:
  1. Komut İstemi'ni açın
  2. Türü ipconfig
  3. Için ara IPv4 Adresi (örneğin, 192.168.1.100)



Not: IP'lerden bahsederken LOCALHOST (127.0.0.1), LAN(örneğin 192.168.1.200) veya WAN(örneğin 142.7.123.34)'e başvuracağım.



[Gizli içerik]


Ekstralar ve Düzeltmeler:

(thx j84c3)
[EMBED içeriği="9441318 sonrası"]https://forum.ragezone.com/threads/tutorial-setup-server-and-client-eu-1-69.1258258/post-9441318[/EMBED]
(thx memvoicam)
[EMBED içeriği="9440078 sonrası"]https://forum.ragezone.com/threads/tutorial-setup-server-and-client-eu-1-69.1258258/post-9440078[/EMBED]

(thx extazy20)
[EMBED içeriği="9073584 sonrası"]https://forum.ragezone.com/threads/how-change-server-rate.1192097/post-9073584[/EMBED]

Sorun Giderme
  • SSMS'de SQL Server Kimlik Doğrulama modunu etkinleştirin (Sunucu Özellikleri > Güvenlik)
  • SA şifresinin yapılandırma dosyalarıyla eşleştiğini doğrulayın
  • SA hesabını etkinleştirin: Güvenlik > Girişler > sa > Özellikler > Durum > Giriş: Etkin

  • SQL Server servisinin çalıştığını doğrulayın
  • SQL Configuration Manager'da TCP/IP'nin etkin olduğunu kontrol edin
  • Bağlantı noktası 1433'ün IPAll'de ayarlandığını onaylayın

Adım 8'de PowerShell komutlarını çalıştırın.

  • EndPoint.txt dosyasının LAN/WAN ip ile yapılandırıldığını doğrulayın
  • Ana bilgisayar dosyasının istemcide doğru şekilde yapılandırıldığını doğrulayın
  • Windows Güvenlik Duvarı'nın bağlantıları engellemediğini kontrol edin
  • IP'nin tüm yapılandırma dosyalarında doğru olduğunu onaylayın

ArtykWolf tarafından derlenen kılavuz. Topluluk katkılarına ve benim katkılarıma dayanmaktadır.

Sunucunuzun tadını çıkarın!
​
tanklar
[Hidden content]


Server Setup Guide(EU/TW/US)​



Server-Client Files:
[Hidden content]




Prerequisites
Before starting, download and install the following in your server:

  • SQL Server Express - (Choose "Custom" installation)
  • SQL Server Management Studio (SSMS) - (Core components only)
  • XAMPP - (For web server)
  • DB Browser for SQLite - (For editing .db3 files, also needed in client)
  • Visual C++ Redistributables 2012 - (both x86 & x64)





USING MY VM:

Time Required: 0.5-1 hour | Tested On: Windows 10 Pro​



Vindictus Private Server - Quick Setup (Pre-configured VM)

For use with the pre-configured VM image. Only IP changes required.
This configuration is for GUEST (VM SERVER) and HOST (CLIENT GAME) are in the same PC
​




Before You Start

Get your local IP address. We'll call this YOUR_IP.

  1. Open Command Prompt
  2. Type ipconfig
  3. Look for IPv4 Address (e.g., 192.168.1.100)





SERVER (VM)​


[Hidden content]



FROM SCRATCH WITH MY FILES:

Time Required: 2-3 hours | Tested On: Windows 10 Pro​



Important: Get Your Server IP Address


You will need your LAN IP address throughout this guide. Remember it!.

To find it:
  1. Open Command Prompt
  2. Type ipconfig
  3. Look for IPv4 Address (e.g., 192.168.1.100)



Note: When speaking of IPs I will refer to LOCALHOST (127.0.0.1), LAN(e.g., 192.168.1.200) or WAN(e.g., 142.7.123.34).



[Hidden content]


Extras and Fixes:

(thx j84c3)
(thx memvoicam)
[EMBED içeriği="9440078 sonrası"]https://forum.ragezone.com/threads/tutorial-setup-server-and-client-eu-1-69.1258258/post-9440078[/EMBED]

(thx extazy20)
[EMBED içeriği="9073584 sonrası"]https://forum.ragezone.com/threads/how-change-server-rate.1192097/post-9073584[/EMBED]

Sorun Giderme
  • SSMS'de SQL Server Kimlik Doğrulama modunu etkinleştirin (Sunucu Özellikleri > Güvenlik)
  • SA şifresinin yapılandırma dosyalarıyla eşleştiğini doğrulayın
  • SA hesabını etkinleştirin: Güvenlik > Girişler > sa > Özellikler > Durum > Giriş: Etkin

  • SQL Server servisinin çalıştığını doğrulayın
  • SQL Configuration Manager'da TCP/IP'nin etkin olduğunu kontrol edin
  • Bağlantı noktası 1433'ün IPAll'de ayarlandığını onaylayın

Adım 8'de PowerShell komutlarını çalıştırın.

  • EndPoint.txt dosyasının LAN/WAN ip ile yapılandırıldığını doğrulayın
  • Ana bilgisayar dosyasının istemcide doğru şekilde yapılandırıldığını doğrulayın
  • Windows Güvenlik Duvarı'nın bağlantıları engellemediğini kontrol edin
  • IP'nin tüm yapılandırma dosyalarında doğru olduğunu onaylayın

ArtykWolf tarafından derlenen kılavuz. Topluluk katkılarına ve benim katkılarıma dayanmaktadır.

Sunucunuzun tadını çıkarın!
​
hahaha
 
[Hidden content]


Server Setup Guide(EU/TW/US)​



Server-Client Files:
[Hidden content]




Prerequisites
Before starting, download and install the following in your server:

  • SQL Server Express - (Choose "Custom" installation)
  • SQL Server Management Studio (SSMS) - (Core components only)
  • XAMPP - (For web server)
  • DB Browser for SQLite - (For editing .db3 files, also needed in client)
  • Visual C++ Redistributables 2012 - (both x86 & x64)





USING MY VM:

Time Required: 0.5-1 hour | Tested On: Windows 10 Pro​



Vindictus Private Server - Quick Setup (Pre-configured VM)

For use with the pre-configured VM image. Only IP changes required.
This configuration is for GUEST (VM SERVER) and HOST (CLIENT GAME) are in the same PC
​




Before You Start

Get your local IP address. We'll call this YOUR_IP.

  1. Open Command Prompt
  2. Type ipconfig
  3. Look for IPv4 Address (e.g., 192.168.1.100)





SERVER (VM)​


[Hidden content]



FROM SCRATCH WITH MY FILES:

Time Required: 2-3 hours | Tested On: Windows 10 Pro​



Important: Get Your Server IP Address


You will need your LAN IP address throughout this guide. Remember it!.

To find it:
  1. Open Command Prompt
  2. Type ipconfig
  3. Look for IPv4 Address (e.g., 192.168.1.100)



Note: When speaking of IPs I will refer to LOCALHOST (127.0.0.1), LAN(e.g., 192.168.1.200) or WAN(e.g., 142.7.123.34).



[Hidden content]


Extras and Fixes:

(thx j84c3)
(thx memvoicam)

(thx extazy20)

Troubleshooting
  • Enable SQL Server Authentication mode in SSMS (Server Properties > Security)
  • Verify SA password matches config files
  • Enable the SA account: Security > Logins > sa > Properties > Status > Login: Enabled

  • Verify SQL Server service is running
  • Check TCP/IP is enabled in SQL Configuration Manager
  • Confirm port 1433 is set in IPAll

Run the PowerShell commands in Step 8.

  • Verify EndPoint.txt file is configured with LAN/WAN ip
  • Verify hosts file is configured correctly on client
  • Check Windows Firewall isn't blocking connections
  • Confirm IP is correct in all config files

Guide compiled by ArtykWolf. Based on community contributions and my own.

Enjoy your server!
​
ty
 
[Hidden content]


Server Setup Guide(EU/TW/US)​



Server-Client Files:
[Hidden content]




Prerequisites
Before starting, download and install the following in your server:

  • SQL Server Express - (Choose "Custom" installation)
  • SQL Server Management Studio (SSMS) - (Core components only)
  • XAMPP - (For web server)
  • DB Browser for SQLite - (For editing .db3 files, also needed in client)
  • Visual C++ Redistributables 2012 - (both x86 & x64)





USING MY VM:

Time Required: 0.5-1 hour | Tested On: Windows 10 Pro​



Vindictus Private Server - Quick Setup (Pre-configured VM)

For use with the pre-configured VM image. Only IP changes required.
This configuration is for GUEST (VM SERVER) and HOST (CLIENT GAME) are in the same PC
​




Before You Start

Get your local IP address. We'll call this YOUR_IP.

  1. Open Command Prompt
  2. Type ipconfig
  3. Look for IPv4 Address (e.g., 192.168.1.100)





SERVER (VM)​


[Hidden content]



FROM SCRATCH WITH MY FILES:

Time Required: 2-3 hours | Tested On: Windows 10 Pro​



Important: Get Your Server IP Address


You will need your LAN IP address throughout this guide. Remember it!.

To find it:
  1. Open Command Prompt
  2. Type ipconfig
  3. Look for IPv4 Address (e.g., 192.168.1.100)



Note: When speaking of IPs I will refer to LOCALHOST (127.0.0.1), LAN(e.g., 192.168.1.200) or WAN(e.g., 142.7.123.34).



[Hidden content]


Extras and Fixes:

(thx j84c3)
(thx memvoicam)

(thx extazy20)

Troubleshooting
  • Enable SQL Server Authentication mode in SSMS (Server Properties > Security)
  • Verify SA password matches config files
  • Enable the SA account: Security > Logins > sa > Properties > Status > Login: Enabled

  • Verify SQL Server service is running
  • Check TCP/IP is enabled in SQL Configuration Manager
  • Confirm port 1433 is set in IPAll

Run the PowerShell commands in Step 8.

  • Verify EndPoint.txt file is configured with LAN/WAN ip
  • Verify hosts file is configured correctly on client
  • Check Windows Firewall isn't blocking connections
  • Confirm IP is correct in all config files

Guide compiled by ArtykWolf. Based on community contributions and my own.

Enjoy your server!
​
Nice
[Hidden content]


Server Setup Guide(EU/TW/US)​



Server-Client Files:
[Hidden content]




Prerequisites
Before starting, download and install the following in your server:

  • SQL Server Express - (Choose "Custom" installation)
  • SQL Server Management Studio (SSMS) - (Core components only)
  • XAMPP - (For web server)
  • DB Browser for SQLite - (For editing .db3 files, also needed in client)
  • Visual C++ Redistributables 2012 - (both x86 & x64)





USING MY VM:

Time Required: 0.5-1 hour | Tested On: Windows 10 Pro​



Vindictus Private Server - Quick Setup (Pre-configured VM)

For use with the pre-configured VM image. Only IP changes required.
This configuration is for GUEST (VM SERVER) and HOST (CLIENT GAME) are in the same PC
​




Before You Start

Get your local IP address. We'll call this YOUR_IP.

  1. Open Command Prompt
  2. Type ipconfig
  3. Look for IPv4 Address (e.g., 192.168.1.100)





SERVER (VM)​


[Hidden content]



FROM SCRATCH WITH MY FILES:

Time Required: 2-3 hours | Tested On: Windows 10 Pro​



Important: Get Your Server IP Address


You will need your LAN IP address throughout this guide. Remember it!.

To find it:
  1. Open Command Prompt
  2. Type ipconfig
  3. Look for IPv4 Address (e.g., 192.168.1.100)



Note: When speaking of IPs I will refer to LOCALHOST (127.0.0.1), LAN(e.g., 192.168.1.200) or WAN(e.g., 142.7.123.34).



[Hidden content]


Extras and Fixes:

(thx j84c3)
(thx memvoicam)

(thx extazy20)

Troubleshooting
  • Enable SQL Server Authentication mode in SSMS (Server Properties > Security)
  • Verify SA password matches config files
  • Enable the SA account: Security > Logins > sa > Properties > Status > Login: Enabled

  • Verify SQL Server service is running
  • Check TCP/IP is enabled in SQL Configuration Manager
  • Confirm port 1433 is set in IPAll

Run the PowerShell commands in Step 8.

  • Verify EndPoint.txt file is configured with LAN/WAN ip
  • Verify hosts file is configured correctly on client
  • Check Windows Firewall isn't blocking connections
  • Confirm IP is correct in all config files

Guide compiled by ArtykWolf. Based on community contributions and my own.

Enjoy your server!
​
Nice
 
[Hidden content]


Server Setup Guide(EU/TW/US)​



Server-Client Files:
[Hidden content]




Prerequisites
Before starting, download and install the following in your server:

  • SQL Server Express - (Choose "Custom" installation)
  • SQL Server Management Studio (SSMS) - (Core components only)
  • XAMPP - (For web server)
  • DB Browser for SQLite - (For editing .db3 files, also needed in client)
  • Visual C++ Redistributables 2012 - (both x86 & x64)





USING MY VM:

Time Required: 0.5-1 hour | Tested On: Windows 10 Pro​



Vindictus Private Server - Quick Setup (Pre-configured VM)

For use with the pre-configured VM image. Only IP changes required.
This configuration is for GUEST (VM SERVER) and HOST (CLIENT GAME) are in the same PC
​




Before You Start

Get your local IP address. We'll call this YOUR_IP.

  1. Open Command Prompt
  2. Type ipconfig
  3. Look for IPv4 Address (e.g., 192.168.1.100)





SERVER (VM)​


[Hidden content]



FROM SCRATCH WITH MY FILES:

Time Required: 2-3 hours | Tested On: Windows 10 Pro​



Important: Get Your Server IP Address


You will need your LAN IP address throughout this guide. Remember it!.

To find it:
  1. Open Command Prompt
  2. Type ipconfig
  3. Look for IPv4 Address (e.g., 192.168.1.100)



Note: When speaking of IPs I will refer to LOCALHOST (127.0.0.1), LAN(e.g., 192.168.1.200) or WAN(e.g., 142.7.123.34).



[Hidden content]


Extras and Fixes:

(thx j84c3)
(thx memvoicam)

(thx extazy20)

Troubleshooting
  • Enable SQL Server Authentication mode in SSMS (Server Properties > Security)
  • Verify SA password matches config files
  • Enable the SA account: Security > Logins > sa > Properties > Status > Login: Enabled

  • Verify SQL Server service is running
  • Check TCP/IP is enabled in SQL Configuration Manager
  • Confirm port 1433 is set in IPAll

Run the PowerShell commands in Step 8.

  • Verify EndPoint.txt file is configured with LAN/WAN ip
  • Verify hosts file is configured correctly on client
  • Check Windows Firewall isn't blocking connections
  • Confirm IP is correct in all config files

Guide compiled by ArtykWolf. Based on community contributions and my own.

Enjoy your server!
​

[Hidden content]


Server Setup Guide(EU/TW/US)​



Server-Client Files:
[Hidden content]




Prerequisites
Before starting, download and install the following in your server:

  • SQL Server Express - (Choose "Custom" installation)
  • SQL Server Management Studio (SSMS) - (Core components only)
  • XAMPP - (For web server)
  • DB Browser for SQLite - (For editing .db3 files, also needed in client)
  • Visual C++ Redistributables 2012 - (both x86 & x64)





USING MY VM:

Time Required: 0.5-1 hour | Tested On: Windows 10 Pro​



Vindictus Private Server - Quick Setup (Pre-configured VM)

For use with the pre-configured VM image. Only IP changes required.
This configuration is for GUEST (VM SERVER) and HOST (CLIENT GAME) are in the same PC
​




Before You Start

Get your local IP address. We'll call this YOUR_IP.

  1. Open Command Prompt
  2. Type ipconfig
  3. Look for IPv4 Address (e.g., 192.168.1.100)





SERVER (VM)​


[Hidden content]



FROM SCRATCH WITH MY FILES:

Time Required: 2-3 hours | Tested On: Windows 10 Pro​



Important: Get Your Server IP Address


You will need your LAN IP address throughout this guide. Remember it!.

To find it:
  1. Open Command Prompt
  2. Type ipconfig
  3. Look for IPv4 Address (e.g., 192.168.1.100)



Note: When speaking of IPs I will refer to LOCALHOST (127.0.0.1), LAN(e.g., 192.168.1.200) or WAN(e.g., 142.7.123.34).



[Hidden content]


Extras and Fixes:

(thx j84c3)
(thx memvoicam)

(thx extazy20)

Troubleshooting
  • Enable SQL Server Authentication mode in SSMS (Server Properties > Security)
  • Verify SA password matches config files
  • Enable the SA account: Security > Logins > sa > Properties > Status > Login: Enabled

  • Verify SQL Server service is running
  • Check TCP/IP is enabled in SQL Configuration Manager
  • Confirm port 1433 is set in IPAll

Run the PowerShell commands in Step 8.

  • Verify EndPoint.txt file is configured with LAN/WAN ip
  • Verify hosts file is configured correctly on client
  • Check Windows Firewall isn't blocking connections
  • Confirm IP is correct in all config files

Guide compiled by ArtykWolf. Based on community contributions and my own.

Enjoy your server!
​
thanks
 
[Hidden content]


Server Setup Guide(EU/TW/US)​



Server-Client Files:
[Hidden content]




Prerequisites
Before starting, download and install the following in your server:

  • SQL Server Express - (Choose "Custom" installation)
  • SQL Server Management Studio (SSMS) - (Core components only)
  • XAMPP - (For web server)
  • DB Browser for SQLite - (For editing .db3 files, also needed in client)
  • Visual C++ Redistributables 2012 - (both x86 & x64)





USING MY VM:

Time Required: 0.5-1 hour | Tested On: Windows 10 Pro​



Vindictus Private Server - Quick Setup (Pre-configured VM)

For use with the pre-configured VM image. Only IP changes required.
This configuration is for GUEST (VM SERVER) and HOST (CLIENT GAME) are in the same PC
​




Before You Start

Get your local IP address. We'll call this YOUR_IP.

  1. Open Command Prompt
  2. Type ipconfig
  3. Look for IPv4 Address (e.g., 192.168.1.100)





SERVER (VM)​


[Hidden content]



FROM SCRATCH WITH MY FILES:

Time Required: 2-3 hours | Tested On: Windows 10 Pro​



Important: Get Your Server IP Address


You will need your LAN IP address throughout this guide. Remember it!.

To find it:
  1. Open Command Prompt
  2. Type ipconfig
  3. Look for IPv4 Address (e.g., 192.168.1.100)



Note: When speaking of IPs I will refer to LOCALHOST (127.0.0.1), LAN(e.g., 192.168.1.200) or WAN(e.g., 142.7.123.34).



[Hidden content]


Extras and Fixes:

(thx j84c3)
(thx memvoicam)

(thx extazy20)

Troubleshooting
  • Enable SQL Server Authentication mode in SSMS (Server Properties > Security)
  • Verify SA password matches config files
  • Enable the SA account: Security > Logins > sa > Properties > Status > Login: Enabled

  • Verify SQL Server service is running
  • Check TCP/IP is enabled in SQL Configuration Manager
  • Confirm port 1433 is set in IPAll

Run the PowerShell commands in Step 8.

  • Verify EndPoint.txt file is configured with LAN/WAN ip
  • Verify hosts file is configured correctly on client
  • Check Windows Firewall isn't blocking connections
  • Confirm IP is correct in all config files

Guide compiled by ArtykWolf. Based on community contributions and my own.

Enjoy your server!
​
Thanks friend
 
[Hidden content]


Server Setup Guide(EU/TW/US)​



Server-Client Files:
[Hidden content]




Prerequisites
Before starting, download and install the following in your server:

  • SQL Server Express - (Choose "Custom" installation)
  • SQL Server Management Studio (SSMS) - (Core components only)
  • XAMPP - (For web server)
  • DB Browser for SQLite - (For editing .db3 files, also needed in client)
  • Visual C++ Redistributables 2012 - (both x86 & x64)





USING MY VM:

Time Required: 0.5-1 hour | Tested On: Windows 10 Pro​



Vindictus Private Server - Quick Setup (Pre-configured VM)

For use with the pre-configured VM image. Only IP changes required.
This configuration is for GUEST (VM SERVER) and HOST (CLIENT GAME) are in the same PC
​




Before You Start

Get your local IP address. We'll call this YOUR_IP.

  1. Open Command Prompt
  2. Type ipconfig
  3. Look for IPv4 Address (e.g., 192.168.1.100)





SERVER (VM)​


[Hidden content]



FROM SCRATCH WITH MY FILES:

Time Required: 2-3 hours | Tested On: Windows 10 Pro​



Important: Get Your Server IP Address


You will need your LAN IP address throughout this guide. Remember it!.

To find it:
  1. Open Command Prompt
  2. Type ipconfig
  3. Look for IPv4 Address (e.g., 192.168.1.100)



Note: When speaking of IPs I will refer to LOCALHOST (127.0.0.1), LAN(e.g., 192.168.1.200) or WAN(e.g., 142.7.123.34).



[Hidden content]


Extras and Fixes:

(thx j84c3)
(thx memvoicam)

(thx extazy20)

Troubleshooting
  • Enable SQL Server Authentication mode in SSMS (Server Properties > Security)
  • Verify SA password matches config files
  • Enable the SA account: Security > Logins > sa > Properties > Status > Login: Enabled

  • Verify SQL Server service is running
  • Check TCP/IP is enabled in SQL Configuration Manager
  • Confirm port 1433 is set in IPAll

Run the PowerShell commands in Step 8.

  • Verify EndPoint.txt file is configured with LAN/WAN ip
  • Verify hosts file is configured correctly on client
  • Check Windows Firewall isn't blocking connections
  • Confirm IP is correct in all config files

Guide compiled by ArtykWolf. Based on community contributions and my own.

Enjoy your server!
​
:love:
 
[Hidden content]


Server Setup Guide(EU/TW/US)​



Server-Client Files:
[Hidden content]




Prerequisites
Before starting, download and install the following in your server:

  • SQL Server Express - (Choose "Custom" installation)
  • SQL Server Management Studio (SSMS) - (Core components only)
  • XAMPP - (For web server)
  • DB Browser for SQLite - (For editing .db3 files, also needed in client)
  • Visual C++ Redistributables 2012 - (both x86 & x64)





USING MY VM:

Time Required: 0.5-1 hour | Tested On: Windows 10 Pro​



Vindictus Private Server - Quick Setup (Pre-configured VM)

For use with the pre-configured VM image. Only IP changes required.
This configuration is for GUEST (VM SERVER) and HOST (CLIENT GAME) are in the same PC
​




Before You Start

Get your local IP address. We'll call this YOUR_IP.

  1. Open Command Prompt
  2. Type ipconfig
  3. Look for IPv4 Address (e.g., 192.168.1.100)





SERVER (VM)​


[Hidden content]



FROM SCRATCH WITH MY FILES:

Time Required: 2-3 hours | Tested On: Windows 10 Pro​



Important: Get Your Server IP Address


You will need your LAN IP address throughout this guide. Remember it!.

To find it:
  1. Open Command Prompt
  2. Type ipconfig
  3. Look for IPv4 Address (e.g., 192.168.1.100)



Note: When speaking of IPs I will refer to LOCALHOST (127.0.0.1), LAN(e.g., 192.168.1.200) or WAN(e.g., 142.7.123.34).



[Hidden content]


Extras and Fixes:

(thx j84c3)
(thx memvoicam)

(thx extazy20)

Troubleshooting
  • Enable SQL Server Authentication mode in SSMS (Server Properties > Security)
  • Verify SA password matches config files
  • Enable the SA account: Security > Logins > sa > Properties > Status > Login: Enabled

  • Verify SQL Server service is running
  • Check TCP/IP is enabled in SQL Configuration Manager
  • Confirm port 1433 is set in IPAll

Run the PowerShell commands in Step 8.

  • Verify EndPoint.txt file is configured with LAN/WAN ip
  • Verify hosts file is configured correctly on client
  • Check Windows Firewall isn't blocking connections
  • Confirm IP is correct in all config files

Guide compiled by ArtykWolf. Based on community contributions and my own.

Enjoy your server!
​
thank bro
 
Back