SQL Server Express Remote Connection
If you are trying to connect to the SQL Server Express instance on a remote server, you might want to check out the following blog.
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx
In order to connect to a remote SQL Server Express server, you should use the following cmd line option
sqlcmd -S [ip],[port] -U [userid]
e.g.
sqlcmd -S 176.33.192.130,2301 -U myuser
here, port = 2301, ip adddress = 176.33.192.130 and userid = myuser
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx
In order to connect to a remote SQL Server Express server, you should use the following cmd line option
sqlcmd -S [ip],[port] -U [userid]
e.g.
sqlcmd -S 176.33.192.130,2301 -U myuser
here, port = 2301, ip adddress = 176.33.192.130 and userid = myuser

0 Comments:
Post a Comment
<< Home