[HELP] Authorize SQL connections

06/15/2014 19:31 white95260#1
Hey, I have create on a Computer I use rarely a Shaiya Server, all works fine but I want know how to connect to my database with my other computer, I use SQL 2005, I prefer use a local IP because I have secured my server from all other IP.
06/19/2014 14:15 RealChew#2
In SQL Server Management Studio, enter the IP of your computer where your database is stored. (CMD > ipconfig, you IP should be like 192.168......)

Enter your Login and Password and it's done.

If you don't use a local IP, you need to open the port 1433 to allow remote connections.
06/20/2014 19:00 Autrux#3
#moved
06/21/2014 10:39 Cansas59#4
or use Hamachi