Tuesday, March 20, 2012

Can I connect to remote SQL 2005 server through SQL Server Management Studio Express?

Can I connect to remote SQL 2005 server through SQL Server Management Studio Express?

I always get a error code 18456 when I try to connect to SQL 2005 server through SQL Server Management Studio Express. I'm sure I enter correct username and password!

The answer is yes its possible but it depends on the security configuration of the remote server.

Hope it helps,

Joe

|||oh wait. I don't have the Express version so I'm not sure if it is limited to local connections, it might be.|||

mycwcgr:

Can I connect to remote SQL 2005 server through SQL Server Management Studio Express?

I always get a error code 18456 when I try to connect to SQL 2005 server through SQL Server Management Studio Express. I'm sure I enter correct username and password!

Try the thread below everything you need and alternatives is covered in it. Post again if you still have questions. Hope this helps.

http://forums.asp.net/thread/1379211.aspx

No comments:

Post a Comment