SQL Server Gems

Tuesday, January 24, 2006

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

0 Comments:

Post a Comment

<< Home