How to remote connect to mssql database?

10/28/2011 23:00 18andLife#1
How can I connect to dedicated server's mssql database?
sqlserver2005 express edition + sql managment studio installed on both computer (dedi server and my pc)
sqlbrowser enabled and running
tcp/ip enabled, remote connections enabled

i tried connecting like
serverip:port
serverip\sqlexpress
serverip:port\sqlexpress
serverip
serverip,port
serverip\pcname

And none works, I get this error:
[Only registered and activated users can see links. Click Here To Register...]
10/28/2011 23:24 Bаne#2
Have you made sure the port is open?

After you opened MSSQL remote connections, did you restart the MSSQL services?
10/28/2011 23:31 18andLife#3
Quote:
Originally Posted by Bаne View Post
Have you made sure the port is open?

After you opened MSSQL remote connections, did you restart the MSSQL services?
I restarted it several times, 1433 and 1434 TCP and UDP opened.. sqlserver.exe added to exceptions aswell

Edit: also, im confused, i have no idea what to type at "server name" (only ip, or IP,port or ip\sqlexpress etc..)
10/29/2011 00:24 peter0021#4
Quote:
Originally Posted by 18andLife View Post
I restarted it several times, 1433 and 1434 TCP and UDP opened.. sqlserver.exe added to exceptions aswell

Edit: also, im confused, i have no idea what to type at "server name" (only ip, or IP,port or ip\sqlexpress etc..)
if u wanna connect (via remote) type: IP\SQLEXPRESS

e.g. 87.75.123.21/SQLEXPRESS

if u wanna link 2 gameserver write this "IP\SQLEXPRESS" in ur cert ini's aswell