Re: Installing SQL Server on SBS 2003

Tech-Archive recommends: Fix windows errors by optimizing your registry

The MSDE instance you try to connect to is either the instance for SharePoint or SBS Monitoring. You'll have to create a different instance for web development or any other purpose. There is a newer version out (SQL Server 2005 Express Edition) which you can download ( http://msdn.microsoft.com/vstudio/express/sql/download/ ) and use for development. It includes SQL Server Management Studio Express, which you can use to manage the database

Costas


"Teo" <nospamteo@xxxxxxxxxxx> wrote in message news:%233nxuFLyHHA.3916@xxxxxxxxxxxxxxxxxxxxxxx
Ok, from what I see I have the MSDE SQL Server.
I already installed it and everything is great. Now I am trying to access the DB from my laptop that I have Visual Web Developer but it doesn't let me connect. Is there a restriction on the connections to the server using the MSDE verision of SQL? Does it have to be local?
Is there a way to create a DB and use it to administer it from my laptop where I am working on the website development?
Regards and thanks,
Teo
"Costas" <cpstechgroup@xxxxxxxxx> wrote in message news:A87F2040-3942-4919-A426-98DACB3C3A19@xxxxxxxxxxxxxxxx
From the DVD, go to the 'PREMTECH' directory and run "Setup.exe". When the 'Windows SBS 2003 R2 Premium Technologies Setup' window comes up, clik on "Install Microsoft SQL Server 2005". That should do it

Costas



"Teo" <nospamteo@xxxxxxxxxxx> wrote in message news:u7$5wvKyHHA.1188@xxxxxxxxxxxxxxxxxxxxxxx
Hi Costas,
For some reason, I am trying to run the setup for the MSDE SQL server. I added the SAPWD field to the SETUP.INI as well as the INSTANCENAME field. However, when I run the setup it sends me an invalide instance name and the installation quits.
Any suggestions on what else I am missing.

Thanks much,
Teo
"Costas" <cpstechgroup@xxxxxxxxx> wrote in message news:BBF1342F-55CC-4E3E-B803-A720AF25D1C4@xxxxxxxxxxxxxxxx
SQL Server is not installed by default during setup. You can find it in the Premium Technologies disks and manuall install it. As far as the icon on the tray, it is just the SQL Server Service Manager and it's not running that's why you don't see any arrows there. After you install SQL Server the manager will active and list the database server


Costas

"Teo" <nospamteo@xxxxxxxxxxx> wrote in message news:%23Acq1kJyHHA.4928@xxxxxxxxxxxxxxxxxxxxxxx
Hey guys, I have the 2003 SBS and I read that it contains the SQL server.
On the installation it didn't prompt me for the disks nor anything. Is there a way to install it from the disks? Or how would I go about to install it. Also, I see the small SQL server icon on the tray but it doesn't even have the green play arrow, it's just blank, not active.
Any help is greatly appreciated.

Regards,
Teo





.

Relevant Pages

  • Re: MSDE licensing rules
    ... > The only problem I ran into was when to setup MSDE. ... > approach is to only install it, with an instancename, when there is no ... Andrea Montanari (Microsoft MVP - SQL Server) ...
    (microsoft.public.sqlserver.msde)
  • Re: Administering MSDE with Enterprise Manager
    ... SETUP SAPWD="wombat" created 'Windows Only Authentication'. ... the MSDE machine from those on the machine that I was connecting from. ... > A. You can only use SQL Server tools and services in conjunction ... >> created during MSDE's install. ...
    (microsoft.public.sqlserver.connect)
  • Re: Administering MSDE with Enterprise Manager
    ... SETUP SAPWD="wombat" created 'Windows Only Authentication'. ... the MSDE machine from those on the machine that I was connecting from. ... > A. You can only use SQL Server tools and services in conjunction ... >> created during MSDE's install. ...
    (microsoft.public.sqlserver.msde)
  • Re: Administering MSDE with Enterprise Manager
    ... SETUP SAPWD="wombat" created 'Windows Only Authentication'. ... the MSDE machine from those on the machine that I was connecting from. ... > A. You can only use SQL Server tools and services in conjunction ... >> created during MSDE's install. ...
    (microsoft.public.sqlserver.setup)
  • Re: Named Instance, Connectivity Question
    ... with SQL Server 2000 Client ... I installed MSDE 2000 under Named Instance. ... yes, you can install only a named instance, only a default instance, or upt ...
    (microsoft.public.sqlserver.msde)