Can i use sql server 2005 on my standalone Laptop

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

General SQL Server Forums

New to SQL Server Programming

Can i use sql server 2005 on my standalone Laptop

Author

Topic

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2007-08-13 : 06:31:04

Can someone please tell me if i can use SQL Server 2005 on my standalone laptop, and how do i connect, i dont know how to set up the password so i can connect

Many thanks Rob

ashley.sql
Constraint Violating Yak Guru

299 Posts

Posted - 2007-08-13 : 08:46:28

install the server and not just the client.
Follow the step by step instructions and you will be able to connect as sa or windows user.

its easy. but you need to install the server to use it on standalone laptop.

Ashley Rhodes

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2007-08-13 : 08:53:27

Thank you. I have been trying to log on using vista, and the version of SQL im using is Enterprise. Do i need to install Microsoft Server 2003. IS that what you mean by installing the server.

THank you

Rob

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-08-13 : 08:56:23

Enterprise Edition can only run on Window Server. Is your laptop running Windows Server ?

If you are using Windows XP you can install the Developer or Express Edition.

KH
[spoiler]Time is always against us[/spoiler]

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2007-08-13 : 09:11:04

No my laptop is quite new and has vista running on it, so i was thinking i could partition the hard drive with windows server then install enterprise. Do you think this would be ok

Regards

Rob

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2007-08-13 : 09:13:27

If you're going to develop in .NET you can just install visual studio 2005 and it will install express edition for you.

The instance name will be ./SQLEXPRESS.

You can then install the advanced edition which includes reporting services.

Important to remember alot of features are locked down by default in 2005 so use the configuration tool to enable features if you need them, and also which protocols (named pipes,tcp/ip,etc..)

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-08-13 : 09:14:24

Yes. But if you are going to use for development, why not just install the developer edition on Vista ? It saves you the trouble of setting another partition for Window Server for the Enterprise edition.

KH
[spoiler]Time is always against us[/spoiler]

ashley.sql
Constraint Violating Yak Guru

299 Posts

Posted - 2007-08-13 : 09:15:59

first if you are running VISTA you need to apply all the appropriate Service Packs for sql server to run on it.

No I do not mean Windows Server 2003, i mean SQL server which you need to select from the options when installing the SQL server 2005.

If you install just the client then it will not work. Try to look for help on service packs and upgrades for vista and sql server 2005

Ashley Rhodes

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2007-08-13 : 09:17:41

I just want to use it purely for learning purposes, im going through a self learning kit to get my MCTS. So i dont want to publish anything, just for my own use. So can i install the developer edition and still use all the features so i can practise everything.

Regards

Rob

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-08-13 : 09:19:05

Yes. Developer Edition is equivalent to the Enterprise Edition

KH
[spoiler]Time is always against us[/spoiler]

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2007-08-13 : 09:28:15

So i will be able to install developer edition on vista with the Service Pack 2 and it will be ok?

Regards

Rob

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-08-13 : 09:31:41

yes

KH
[spoiler]Time is always against us[/spoiler]

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2007-08-13 : 09:32:32

Thank you very much

Regards

Rob

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2007-08-16 : 07:16:53

If anyone else has anymore information please dont hesitate to post

Regards

Rob

X002548
Not Just a Number

15586 Posts

Posted - 2007-08-16 : 09:35:25

quote:
Originally posted by masterdineen

If anyone else has anymore information please dont hesitate to post

Regards

Rob

OK, sure, understand that it will consume your laptop and everything else that yo uwant to run will run veeeeeeeeeeery slowly

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2007-08-16 : 10:38:48

What spec would you recommend?

Regards

Rob

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources