Does Express run on a client? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Express Edition and Compact Edition (2005)

Does Express run on a client?

Author

Topic

X002548
Not Just a Number

15586 Posts

Posted - 2004-11-17 : 14:24:54

Got read about it, but can I load it on to an XP Pro client and the reach from another client using QA...or is it pure osql?

Brett

8-)

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2004-11-17 : 15:48:15

I don't think any client tools can access it just yet, from what I've read. Last I had heard, neither QA or EM can connect to it ... I think the Express edition of Visual Studio can, though I am not sure in what capacity (i.e., it might just be through code using the newer ADO.NET and not via graphical tools or QueryAnalyzer-like interfaces)

- Jeff

ehorn
Master Smack Fu Yak Hacker

1632 Posts

Posted - 2004-11-17 : 19:01:32

2005 Express runs fine on XP Pro. MS keeps promising to release Express Manager (XM) but I haven't seen or heard anything since the last blogs - http://blogs.msdn.com/sqlexpress

The Express IDE's also access the DB nicely and provide a QA like interface.

There is a decent, and free, QA replacement for 2005 Express:

http://www.tegels.org/qara/

It even lets you create assemblies if you care to tinker with CLR integration. Not a bad compliment to the free SQL 2005 Express engine.

X002548
Not Just a Number

15586 Posts

Posted - 2004-11-18 : 15:10:04

Just installed express...I'm so excited...

Books Online is huge.....

I also downloaded QARA....but it's having a problem..

I updated the config....since I installed it on my xp client, what would the server name be?

Brett

8-)

X002548
Not Just a Number

15586 Posts

Posted - 2004-11-18 : 16:59:26

BOOYAH

I'm in....

Now what's the Syntax for the family tree sh-t...

What's the keyword...

It's CONNECT BY in Oracle...

Brett

8-)

ehorn
Master Smack Fu Yak Hacker

1632 Posts

Posted - 2004-11-20 : 21:12:51

quote:
Now what's the Syntax for the family tree sh-t...

What's the keyword...

Recursive CTE's - using the WITH clause:

http://sqljunkies.com/WebLog/nielsb/archive/2004/08/15/3916.aspx

X002548
Not Just a Number

15586 Posts

Posted - 2004-11-22 : 14:50:37

Yup...way cool...

Thanks...

Brett

8-)

X002548
Not Just a Number

15586 Posts

Posted - 2004-11-22 : 16:19:17

Thanks a bunch....now it's time to kick in gear....

Hey Bill, could you post an announcement when they release XM...seems to be about 6 months late....

And when does it leave beta 2?

Brett

8-)

euan_garden
Microsoft SQL Server Product Team

34 Posts

Posted - 2004-11-28 : 22:56:01

XM should be available with the next CTP, in the next 10 days. It will need the newest CTP or Oct CTP to run. It will connect to SQL2000 as well.

Watch Bill Ramos's blog(http://blogs.msdn.com/billramo) and the SQL Express Blog(http://blogs.msdn.com/sqlexpress) for updates.

On the connectivity front, SQL Express can be connected to remotely but not by default, there are steps in the sqlexpress blog to explain how to enable this.

-Euan

Euan Garden
Product Unit Manager
SQL Server Tools

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2004-11-29 : 03:43:20

I used QA to connect to SQL Express 2005 beta2.
connected with SERVER_NAME\SQLEXPRESS, had to enable tcp/ip protocol.

Edit:
Btw. Why can't I subscribe to this topic / or forum ?

rockmoose

ehorn
Master Smack Fu Yak Hacker

1632 Posts

Posted - 2004-11-29 : 08:24:02

Thanks for the update Euan! Looking forward to the release.

X002548
Not Just a Number

15586 Posts

Posted - 2004-11-29 : 09:52:43

GREAT!

Now for the ignorance part...what's CTP

And I could not connect using QA...and I'm already tcp/ip enabled...

But I installed it on XP PRO Client..

Moose...where did you install eXPress?

Brett

8-)

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2004-11-29 : 11:41:36

I installed it on Windows Server 2003, Standard Edition.
The server has both SQL 2000 + SQL Express 2005 on it.

With QA I can connect to SERVER_NAME\SQLEXPRESS wich is the 2005 instance, both with winauth & sqlauth.

rockmoose

Frost
Starting Member

33 Posts

Posted - 2005-04-23 : 19:29:02

CTP = Community Technology Preview *S*

Vernon

"Never argue with an idiot..they will only bring you down to their level and beat you with years of experience"

:)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources