SQL Server 2008 Express Edition on Vista (1 Viewer)

Rockape

Registered User.

Local time

Today, 20:16

Joined

Aug 24, 2007

Messages

271

• Oct 15, 2010

• #1

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

Smeghead

Local time

Today, 11:16

Joined

Jan 12, 2001

Messages

32,059

• Oct 15, 2010

• #2

Yes, it should work just fine.

 

Rockape

Registered User.

Local time

Today, 20:16

Joined

Aug 24, 2007

Messages

271

• Oct 15, 2010

• #3

Hi Bob,

Long time no see. Many thanks for your opinion.

Thanks again

 

Rockape

Registered User.

Local time

Today, 20:16

Joined

Aug 24, 2007

Messages

271

• Oct 15, 2010

• #4

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

Rockape said:

Hi Bob,

Long time no see. Many thanks for your opinion.

Thanks again

Click to expand...

 

boblarson

Smeghead

Local time

Today, 11:16

Joined

Jan 12, 2001

Messages

32,059

• Oct 15, 2010

• #5

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

Registered User.

Local time

Today, 20:16

Joined

Aug 24, 2007

Messages

271

• Oct 15, 2010

• #6

Hi

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

 

boblarson

Smeghead

Local time

Today, 11:16

Joined

Jan 12, 2001

Messages

32,059

• Oct 15, 2010

• #7

Vista is fine but you may want to check this out for installing and configuring.

 

Rockape

Registered User.

Local time

Today, 20:16

Joined

Aug 24, 2007

Messages

271

• Oct 15, 2010

• #8

Thanks...

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

Regards

 

Rockape

Registered User.

Local time

Today, 20:16

Joined

Aug 24, 2007

Messages

271

• Oct 15, 2010

• #9

Installed it finally...now to learn to use it

Rockape said:

Thanks...

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

Regards

Click to expand...

 

boblarson

Smeghead

Local time

Today, 11:16

Joined

Jan 12, 2001

Messages

32,059

• Oct 15, 2010

• #10

Rockape said:

Installed it finally...now to learn to use it

Click to expand...

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

Registered User.

Local time

Today, 20:16

Joined

Aug 24, 2007

Messages

271

• Oct 16, 2010

• #11

Thanks again Bob. Greatly appreciated.

Finally got it to work.

Regards