PDA

View Full Version : MSDE Configuration


Gwiz
May 3, 2005, 04:14 PM
I am installing MSDE and I download and extract the file in the default folder.

I use this command at the DOS promt.
setup SAPWD="password" INSTANCENAME="instance"
and then enter

Once it finish I restart computer, I can see the SQL thing running but I am not seeing the computer name in the SQL Server Service Mananger.

What steps did I miss?
pogi_2nr
May 3, 2005, 04:15 PM
SQL Server Service Mananger? where do you see this?

Download MSDE manager.
Gwiz
May 3, 2005, 04:31 PM
This comes up when you finish installing MSDE
SQLDBA
May 3, 2005, 05:44 PM
Look for an SQL service in the services option on the control panel.
jamrock
May 3, 2005, 07:23 PM
I am installing MSDE and I download and extract the file in the default folder.

I use this command at the DOS promt.
setup SAPWD="password" INSTANCENAME="instance"
and then enter

Once it finish I restart computer, I can see the SQL thing running but I am not seeing the computer name in the SQL Server Service Mananger.

What steps did I miss?

How did you install MSDE? At what point did you enter this command? Why did you enter this command? Didn't the install routine ask you to set the SA password?

What is the SQL thing that you see running? How do you plan to use MSDE?
rodalembs
May 4, 2005, 07:14 AM
This comes up when you finish installing MSDE

Right :eusa_doh: This should be pretty straight forward. It is in the system tray for starters... What version of MSDE is this? What O/S are you on?
Gwiz
May 4, 2005, 08:54 AM
I am installing MSDE and I download and extract the file in the default folder.

I use this command at the DOS promt.
setup SAPWD="password" INSTANCENAME="instance"
and then enter
What steps did I miss?

I am using Windows 2000 professional. I got it to work.
What I did what I missed was to enable the network protocol
DISABLENETWORKPROTOCOLS=0
SECURITYMODE=SQL

once I add those 2 lines it shows that SQL running on that computer.
rodalembs
May 4, 2005, 09:04 AM
I am using Windows 2000 professional. I got it to work.
What I did what I missed was to enable the network protocol
DISABLENETWORKPROTOCOLS=0
SECURITYMODE=SQL

once I add those 2 lines it shows that SQL running on that computer.
:eusa_clap Good , some thing for us to put in our knowledge base ;)
Gwiz
May 6, 2005, 03:33 PM
I have my MSDE installed now.. but how do I connect to it..
Any one know where I can finds dos commands to connect to the SQL server?