RE: have sql on a different box

From: Daniel Larson (www.portalbuilder.org) (daniel_at_larsontechnology.spamfree.com)
Date: 11/08/04


Date: Mon, 8 Nov 2004 09:49:05 -0800

Greg,

Have you ruled out the possibility that it's an access denied issue? With
what user are you authenticating to SQL for your SPS setup, and does that
user have db creation rights as well as db security admin rights?

If that fails, can you configure SPS to use SQL by its IP address?

Daniel Larson
www.portalbuilder.org

"greg" wrote:

> Hello,
> I am trying to install Sharepoint on 1 box and SQL on a second box.
> I get an error specifying the specific sql box name. that sharepoint cannot
> see it.
>
> the versions are:
> Microsoft Windows Server 2003 Enterprise Edition
> SQL Server 2000 SP3
> Windows Sharepoint Services 2003
>
> I installed the SQL client tools on my sharepoint box. And can connect to
> the SQL box and see the databases on it.
> why can sharepoint not see the SQL box?
> Is there a back door, where i can create an odbc connection to it?
> can someone give some insite on this?
> thanks
>
>
>
>



Relevant Pages

  • Re: Sharepoint and SQL?
    ... I understand you have removed SQL on you SBS Server, ... Companyweb to MSDE, based on my experience, you can perform the following ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ...
    (microsoft.public.windows.server.sbs)
  • RE: Problems upgrading SQL MSDE for Sharepoint
    ... I am glad to know the upgrade Sharepoint ... Microsoft CSS Online Newsgroup Support ... With this working I was able to start upgrading SQL MSDE for SharePoint. ... >white paper to backup your SBS server first. ...
    (microsoft.public.windows.server.sbs)
  • Re: sharepoint error
    ... If you are using SBS 2003 Premium Edition the easiest way is to follow ... to upgrade the SharePoint named instance. ... and search on "Migrating from WMSDE to SQL Server" ... Microsoft Small Business Server Support ...
    (microsoft.public.windows.server.sbs)
  • RE: Upgrade of Sharepoint to SQL Server 2000 - Questions
    ... If you are using SBS 2003 Premium Edition then you could upgrade the ... SharePoint named instance to full SQL. ... enjoy Full Text Search in Sharepoint and all the advantages SQL server ...
    (microsoft.public.windows.server.sbs)
  • Re: Having trouble getting Sharepoint over to SQL 2000 during Premium Upgrade
    ... > I ran through the html procedure to install single instance of SQL ... > (including Sharepoint) and SQL agents and instances, IIS services, etc ... > sharepoint seemingly operating in SQL Server now? ...
    (microsoft.public.windows.server.sbs)