SQLExpress

I logined as Admin and installed SQLExpress on my Station.  Can other users use Query Analizer to query records on my station?
VBdotnet2005Asked:
Who is Participating?
 
nmcdermaidCommented:
By default SQLExpress does not allow network connections so you also need to enable TCP/IP connections using the surface area configuration tool.

Open this tool up from the start menu and under 'Remote Connections' select 'Local and remote connections', and 'TCP/IP only'
0
 
Raynard7Commented:
Yes - provided they have your ip - the port to connect to and a password (and query analyzer) then they should be able to
0
 
VBdotnet2005Author Commented:
Could you provide me a procedure step by step?
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
Anthony PerkinsCommented:
No, they will not be able to query SQL Server Express (or 2005 for that matter) from SQL Query Analyzer.
0
 
Raynard7Commented:
acperkins is correct

if they were using the "query editor" then they would be able to access it - but query analyzer is depreciated for 2005

www.databasejournal.com/features/mssql/article.php/3489661

I was assuming you were talking about the query editor - I apologise.
0
 
Raynard7Commented:
If they had the quey editor the steps would be as above - if not then they would need something to query it, they could use something similar to http://www.x-sql.com/LiteEdition.aspx which is a free query tool for mssql 2005
0
 
dynamicrevolutionsCommented:
im able to use query analyzer to connect to SQL 2005 standard
maybe after u enable TCP (and advanced tcp/ip settings) in SQL express configuration, you'll be able to use sql 2000 query analyzer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.