We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

SQLExpress

VBdotnet2005
VBdotnet2005 asked
on
Medium Priority
891 Views
Last Modified: 2008-03-04
I logined as Admin and installed SQLExpress on my Station.  Can other users use Query Analizer to query records on my station?
Comment
Watch Question

Top Expert 2006

Commented:
Yes - provided they have your ip - the port to connect to and a password (and query analyzer) then they should be able to

Author

Commented:
Could you provide me a procedure step by step?
CERTIFIED EXPERT
Top Expert 2012
Commented:
No, they will not be able to query SQL Server Express (or 2005 for that matter) from SQL Query Analyzer.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Top Expert 2006

Commented:
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.
Top Expert 2006
Commented:
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
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'
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
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.