View Full Version : SQL Server 2008 Express Edition on Vista


Rockape
10-15-2010, 01:00 AM
Hi,

is it possible to run SQL S2008EE on Vista. I would like to do some testing using Server as a backend and my A2003 tables on the same PC?

i.e. backend and frontend on the same PC.

thanks

boblarson
10-15-2010, 06:03 AM
Yes, it should work just fine.

Rockape
10-15-2010, 06:19 AM
Hi Bob,

Long time no see. Many thanks for your opinion.

Thanks again

Rockape
10-15-2010, 07:28 AM
Hi,

Tried installing it but its asking for Windows Power Shell?

and I got a warning regarding Windows Firewall. .."Make sure the appropriate ports are opne to enable remote access"... but I dont want remote access!!!


Help



Hi Bob,

Long time no see. Many thanks for your opinion.

Thanks again

boblarson
10-15-2010, 07:40 AM
Windows Power Shell is a version of a command line interface on steroids. You should be okay installing it (what version of Windows are you on).

As for the ports, it gives you that notice so you know what is needed. You may need to also go into the configuration and enable TCP/IP or Named Pipes, depending on your usage - even on a local computer.

You might do a Google Search on installing and configuring the 2008 Express as it can be a bit daunting.

Rockape
10-15-2010, 07:50 AM
Hi

I'm running Vista....Nothing ever comes easy!!!

boblarson
10-15-2010, 07:53 AM
Vista is fine but you may want to check this out (http://www.symantec.com/connect/articles/install-and-configure-sql-server-2008-express) for installing and configuring.

Rockape
10-15-2010, 07:55 AM
Thanks...

Will try later, I'm washed out... need a coffee.

Regards

Rockape
10-15-2010, 10:58 AM
Installed it finally...now to learn to use it :confused:



Thanks...

Will try later, I'm washed out... need a coffee.

Regards

boblarson
10-15-2010, 11:00 AM
Installed it finally...now to learn to use it :confused:

If you are going to be writing to it, you should use the SQL Native Client 10 driver for it as that is its normal driver (for setting up a DSN or connection string for a DSNLess connection).

Rockape
10-16-2010, 07:56 AM
Thanks again Bob. Greatly appreciated.

Finally got it to work.

Regards