How do I set up WSS to use SQL Server 2000?

[tdacquisto]

How do I tell WSS to use SQL Server 2000? The server has SQL Server 200 installed on it and when running the install pgm for WSS, it doesn't ask me what type of database to use.

Any suggestions?

Also, SQL Server 2000 sp3 SUCKS! I put on sp4 and it went smoothly... Will WSS work with this sp?

Thanks!

Tom.

 

[Thomas2000]

Hello,

When you do the WSS installation chose to go with a server farm installation. Easiest way is to run from a commandline stsv2.exe remotesql=yes.

Even if you are installing everything on a single machine chose to go with the server farm installation, then WSS will not install the WMSDE and you will have the possibility to use SQL 2000 instead.

We have had no problems with WSS/SPS and SQL 2000 SP4.

Regards,
Thomas

 

[ChaserNL]

Just go to the admin pages after you have done what Thomas said, and follow the steps that show up there it is very easy to do!

 

[tdacquisto]

Hi guys,

I tried running the stsv2.exe remotesql=yes from a command line and get "Command line option syntax error"

Any ideas?

 

[tdacquisto]

I should add that I've downloaded the latest version of WSS 2 that contains Sp2 from the following site.

http://www.microsoft.com/downloads/...8D-806A-427B-A4C5-AB0F1AA0F7F9&displayLang=en

Maybe this version doesn't let me do command line options..

 

[tdacquisto]

Hey Guys,

I ran the stsv2.exe and selected "server farm" and got to the point where I'm selecting the SQL database. I got this error:

Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. (Error code: 18456).

What does this mean?

 

[tdacquisto]

I found how to fix this and got it all running! Thanks guys!

 

[ChaserNL]

Just to clarify the remotesql commandline option it is not run against stsv2.exe because this is just the extraction file, you should run it against the extracted setupsts.exe

Or alternatively do it like this:

C:\>DownloadDirectory\STSV2.EXE /C:"setupsts.exe /remoteSql=yes