[HELP]How to share database

[elitez123]

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

[pieter]

just give him access to remote desktop..

much easyer

[6shadow6]

or just use TeamViewer

[T04STY]

tell him to download mssql management studio and give him ip, login and pw of sql server.

[elitez123]

TY Toasty ! 1 mroe question , how can i change meh sql pw??

Thanks

[6shadow6]

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.

[elitez123]

mhm i dont get how to change ports

[6shadow6]

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.

[elitez123]

in what port i change it?

[6shadow6]

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