MS SQL Server - Connection to SQL Server 2005

Author

Connection to SQL Server 2005

Kahkashan

2006-03-30, 3:23 am

Hi all,

When I installed SPS 2003 , it installed MSDE as part of onstallation.
I also installed WSS SP 2 and SPS SP2 on it. I have SQL Server 2005
also installed on my machine.

How do I connect to this database for my WSS sites? How my sites in WSS
will be communicating to this sequal server?

Someone has suggeted that I should install SPS with SQLServer 2000 and
then upgrade it to SQL Server2005.I don't now why is it important to
install SQLServer 2000 and then upgrade it to 2005?
Is there any way that I can cope with the already made installations on
my machine???

Thanks
Kahkashan

MSLam

2006-03-30, 7:23 am

Download the WindowsSharePointSer
vicesAdmin BOL from Microsoft, looks
into the section of 'Deployment Scenarios', it has very details how to
set up SPS to connect to a existing SQL Server (rather than use the
default WMSDE)

I followed the instruction and built a test SPS for our department, no
problem.

In the BOL, it only mention you need to have a SQL Server 2000 sp3 or
above to host the SPS databases. So you may need to check if they are
compatible with MSSQL 2005.

Mel

Sponsored Links