[HELP]How to share database

01/27/2011 14:47 elitez123#1
Hello everyone i have a question how can i share my test server sql database with my friend so like he can be an admin too?
Thanks
01/27/2011 15:04 pieter#2
just give him access to remote desktop..

much easyer
01/27/2011 15:43 6shadow6#3
or just use TeamViewer :)
01/27/2011 15:48 T04STY#4
tell him to download mssql management studio and give him ip, login and pw of sql server.
01/27/2011 17:34 elitez123#5
TY Toasty ! 1 mroe question , how can i change meh sql pw??

Thanks
01/27/2011 18:56 6shadow6#6
If you already want to play with such access to what he says. Remember that if your MSSQL server is a router and redirect ports. Be aware of this that you may have hacked your MSSQL. However, if you change the default port for MSSQL which works when installed on the other will be safer. Port on which the standard operates at a port of the MSSQL server listens on port 1433, change it to something else. However, such a change would require modifications in dekaron server config files.
01/27/2011 19:11 elitez123#7
mhm i dont get how to change ports
01/27/2011 19:28 6shadow6#8
Open Menu START go to Programs-> MicroSoft SQL SERVER -> Run Client Network Utility
and in first find TCP/IP and click Properties and you see the port 1433 and chenge

Next step
Open Menu START go to Programs-> MicroSoft SQL SERVER -> Run Server Network Utility
and the same step in first window click once on TCP/IP then click Properties chenge Aplly OK and then restart your MSSQL Server

and all that then just change the ports in the config files. The cast folders, sesion, and dekaronserver only ther wher is port 1433 nothing more.

But remember that the ports are changing only when the server is behind a router. However, it is recommended to change even if the server is not behind a router.
Server time is less vulnerable to attack.
01/27/2011 19:40 elitez123#9
in what port i change it?
01/27/2011 22:18 6shadow6#10
This is your choice. I can not just say yes to what port you choose. Above all for security reasons. bleaching what comes to mind with the range between 1400 and 1800 I do not know, or 2000