i have a beginners question, and i apologize if it is stupid.
i am a beginner at sql server. i can do sql pretty well, but i dont know much about connecting.
Microsoft SQL Server Management Studio and SQL EXPRESS
what is the process of allowing remote connections to it?
i would like to leave my laptop online at home with the management studio running and would like to access my home sql server through a remote connection.
i would like to know
how do i allow one of my databases to accept remote connections? what would the connection string be? just my laptop's IP address or what? is it dangerous to accept remote connections? i have done the following BTW:
and when i do this it works:
SQLCMD -e -s localhost\sqlexpress,2301
however when i try to do this:
sqlcmd -e -s my.ip.add.ress\sqlexpress,2301
it does NOT work
anyway, after i do get this to work how would i connect to a specific db??