October 8, 2007 at 8:57 am
Hi,
First post!
I have installed SQL Server Ent Console on my PC. In Ent Mgr, how do I register my own PC as a server (where I can then create databases etc)? I have tried supplying my network hostname with a blank pwd for sa, but no joy...
Tx
October 8, 2007 at 9:10 am
You need to install the SQL Server services. If this is 2005, then you need to install the Developer Edition, Workgroup edition, or Express edition. You will have a SQL Server database service that will run automatically. Then you'll be able to connect with SSMS.
If this is 2000, then you're in the wrong forum, let me know and I'll move it. But you then need to install the Personal edition.
October 8, 2007 at 9:14 am
You can only install the server portion of SQL Server 2005 Enterprise Edition on Windows 2K server SP4 or later or Windows Server 2003. When you run the Enterprise Edition install on any other Windows OS you can only install the client tools. So unless you installed SQL Server 2005 Standard, Workgroup, Developer, or Express on your PC you do not have the Server portion of SQL Server installed.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 9, 2007 at 1:30 am
Many thanks!
Also, If I'm doing an install on a new server, do I need to install express/dev edition also, or just the Mgt Console?
October 9, 2007 at 6:48 am
when you run setup, any version any o/s, it will tell you if it can't install the database engine, it will also prompt you for which parts you wish to install. You obvioulsy want the database engine and management tools watch the messages as they come up on install.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
October 9, 2007 at 6:59 am
Thanks,
Saw that alright - when I ran the install on my PC none of the Database Engine/Analysis Services options were available for install (greyed-out) but when I tried to install on the server they were available for install. How is Microsoft able to differentiate between pc & server?
Thanks again for the prompt replies!
October 9, 2007 at 7:49 am
Server and PC have no meaning. They're both computers. The install differentiates between which version of the operating system you have. Some SQL Server versions will only install on a server operating system, like Windows 2000 Server or Windows 2003.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply