SharePoint Cafe

 All MindsharpBlogs

My Links

Article Categories

Archives

Blog Stats

2007 IT Pro Resources

Mindsharp Instructors

Mindsharp Training

Can You Hear Me? SQL 2005 and SharePoint Portal Server 2003

For those installing SharePoint Portal Server 2003 with SQL 2005, you might find that a default install of SQL05 results in an inability on the part of SharePoint to connect to the database server when creating new databases, including the farm-starting configdb.

Technically, this is by design, since SQL05 starts locked down and you must open it up to work.  One tip, if you have a difficult time getting SPS03 to create new databases in SQL05 (and the error message is a connection-oriented error message) is to ensure that you have opened up the Configuration Manager and enabled connections via TCP/IP.  I'm thinking Named Pipes also needs to be enabled, but I've not tested that for sure to know.

If you know more about this topic, please post back here.  Thanks.

Bill English
Mindsharp

posted on Monday, March 27, 2006 8:53 PM

Feedback

# re: Can You Hear Me? SQL 2005 and SharePoint Portal Server 2003 3/28/2006 4:34 AM Shane Perran

Hey Bil,

I know we ran into issues with this recently with one of our 2003 webparts connecting to SQL2005.

I remember a team member speaking to me on this exact issue, drop me line and I will shoot you his email, I would rather not post it online.

shane at graphicalwonder dot com

Cheers,

# re: Can You Hear Me? SQL 2005 and SharePoint Portal Server 2003 4/4/2006 1:22 AM Jim P

Yes, SharePoint installs fine with SQL 2005. Just need to make sure TC/IP is checked or both TC/IP and Named Pipes works well too. In fact, SQL 2005 on x64 box is quite fast.

# SharePoint 2003 and SQL2005 4/17/2006 8:34 PM Steve Caravajal's Ramblings

In the past month or so several customers have asked about the use of SQL 2005 with SharePoint 2003. ...

# re: Can You Hear Me? SQL 2005 and SharePoint Portal Server 2003 4/27/2006 9:41 AM Janice

Microsoft now has Knowledge Base article addressing this configuration:

http://support.microsoft.com/kb/917446

How to install SharePoint Portal Server 2003 Service Pack 2 and Windows SharePoint Services Service Pack 2 in a deployment that uses SQL Server 2005 as the database back end
4/13/2006

# re: Can You Hear Me? SQL 2005 and SharePoint Portal Server 2003 10/30/2006 8:12 PM Avijit Macker

I recently migrated by sharepoint databases from SQL 2000 to SQL 2005 and the search is not working.Has anyone faced a similar problem like this before?

# Installing SPS 2003 on SQL 2005 - useful links 11/4/2006 7:42 AM All About SharePoint

http://support.microsoft.com/kb/917446
http://rjcharity.spaces.live.com/Blog/cns!45A38976DB774CBC!984.entry...

# re: Can You Hear Me? SQL 2005 and SharePoint Portal Server 2003 11/5/2006 7:38 PM Avijit Macker

Perfect, the migration just went through flawlessly and all the issues related to search were resolved by rebuilding the catalog containing fulltext indexes.

# çizgi film 8/21/2008 4:39 AM Çizgi Film

very good

# film izle 8/21/2008 4:40 AM film izle

very good

# gelinlikler 8/21/2008 4:40 AM Gelinlikler

very good

# masaüstü resimleri 8/21/2008 4:40 AM masaüstü resimleri

very good

# mercedes yedek parçaları 8/21/2008 4:40 AM Mercedes Yedek Parçaları

very good

# autocad kursu 8/21/2008 4:40 AM autocad kursu

very good

# müzik dinle 8/21/2008 4:41 AM müzik dinle

very good

# Bay 8/21/2008 4:41 AM Havuz

very good

# yemek tarifleri 8/21/2008 4:41 AM yemek tarifleri

very good

# Bay 8/21/2008 4:41 AM havuz

very good

# re: Can You Hear Me? SQL 2005 and SharePoint Portal Server 2003 8/21/2008 4:43 AM gaziosmanpaşa

very good

# re: Can You Hear Me? SQL 2005 and SharePoint Portal Server 2003 8/21/2008 4:43 AM ilahi dinle

very good

Title  
Name  
Url
CAPTCHA
Protected by Clearscreen.SharpHIPEnter the code you see:
Comments