Go Back   Access World Forums > Apps and Windows > SQL Server

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-15-2010, 01:00 AM   #1
Rockape
Newly Registered User
 
Rockape's Avatar
 
Join Date: Aug 2007
Posts: 271
Thanks: 12
Thanked 0 Times in 0 Posts
Rockape is an unknown quantity at this point
SQL Server 2008 Express Edition on Vista

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

Rockape is offline   Reply With Quote
Old 10-15-2010, 06:03 AM   #2
boblarson
Smeghead
 
boblarson's Avatar
 
Join Date: Jan 2001
Location: Oregon, USA
Posts: 32,068
Thanks: 97
Thanked 1,828 Times in 1,579 Posts
boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold
Re: SQL Server 2008 Express Edition on Vista

Yes, it should work just fine.
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
boblarson is offline   Reply With Quote
Old 10-15-2010, 06:19 AM   #3
Rockape
Newly Registered User
 
Rockape's Avatar
 
Join Date: Aug 2007
Posts: 271
Thanks: 12
Thanked 0 Times in 0 Posts
Rockape is an unknown quantity at this point
Re: SQL Server 2008 Express Edition on Vista

Hi Bob,

Long time no see. Many thanks for your opinion.

Thanks again

Rockape is offline   Reply With Quote
Old 10-15-2010, 07:28 AM   #4
Rockape
Newly Registered User
 
Rockape's Avatar
 
Join Date: Aug 2007
Posts: 271
Thanks: 12
Thanked 0 Times in 0 Posts
Rockape is an unknown quantity at this point
Re: SQL Server 2008 Express Edition on Vista

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



Quote:
Originally Posted by Rockape View Post
Hi Bob,

Long time no see. Many thanks for your opinion.

Thanks again
Rockape is offline   Reply With Quote
Old 10-15-2010, 07:40 AM   #5
boblarson
Smeghead
 
boblarson's Avatar
 
Join Date: Jan 2001
Location: Oregon, USA
Posts: 32,068
Thanks: 97
Thanked 1,828 Times in 1,579 Posts
boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold
Re: SQL Server 2008 Express Edition on Vista

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.
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
boblarson is offline   Reply With Quote
Old 10-15-2010, 07:50 AM   #6
Rockape
Newly Registered User
 
Rockape's Avatar
 
Join Date: Aug 2007
Posts: 271
Thanks: 12
Thanked 0 Times in 0 Posts
Rockape is an unknown quantity at this point
Re: SQL Server 2008 Express Edition on Vista

Hi

I'm running Vista....Nothing ever comes easy!!!
Rockape is offline   Reply With Quote
Old 10-15-2010, 07:53 AM   #7
boblarson
Smeghead
 
boblarson's Avatar
 
Join Date: Jan 2001
Location: Oregon, USA
Posts: 32,068
Thanks: 97
Thanked 1,828 Times in 1,579 Posts
boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold
Re: SQL Server 2008 Express Edition on Vista

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

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
boblarson is offline   Reply With Quote
Old 10-15-2010, 07:55 AM   #8
Rockape
Newly Registered User
 
Rockape's Avatar
 
Join Date: Aug 2007
Posts: 271
Thanks: 12
Thanked 0 Times in 0 Posts
Rockape is an unknown quantity at this point
Re: SQL Server 2008 Express Edition on Vista

Thanks...

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

Regards
Rockape is offline   Reply With Quote
Old 10-15-2010, 10:58 AM   #9
Rockape
Newly Registered User
 
Rockape's Avatar
 
Join Date: Aug 2007
Posts: 271
Thanks: 12
Thanked 0 Times in 0 Posts
Rockape is an unknown quantity at this point
Re: SQL Server 2008 Express Edition on Vista

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



Quote:
Originally Posted by Rockape View Post
Thanks...

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

Regards
Rockape is offline   Reply With Quote
Old 10-15-2010, 11:00 AM   #10
boblarson
Smeghead
 
boblarson's Avatar
 
Join Date: Jan 2001
Location: Oregon, USA
Posts: 32,068
Thanks: 97
Thanked 1,828 Times in 1,579 Posts
boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold
Re: SQL Server 2008 Express Edition on Vista

Quote:
Originally Posted by Rockape View Post
Installed it finally...now to learn to use it
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).
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
boblarson is offline   Reply With Quote
Old 10-16-2010, 07:56 AM   #11
Rockape
Newly Registered User
 
Rockape's Avatar
 
Join Date: Aug 2007
Posts: 271
Thanks: 12
Thanked 0 Times in 0 Posts
Rockape is an unknown quantity at this point
Re: SQL Server 2008 Express Edition on Vista

Thanks again Bob. Greatly appreciated.

Finally got it to work.

Regards

Rockape is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Server 2008 books? YNWA SQL Server 2 03-11-2010 10:24 PM
access table to the SQL express server 2008 no update endless_waltz SQL Server 3 11-17-2009 09:03 AM
migrate access to SQL server associates SQL Server 5 09-16-2009 08:42 PM
SQL Server 2005 Express and Access 2007 razorking General 2 01-29-2009 08:21 AM
SQL Server Express...where to start CEH SQL Server 19 08-28-2008 09:53 PM




All times are GMT -8. The time now is 12:11 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World