Re: ODBC connection problem

Now working, installed new default SQL instance + Service Packs.

Cannot install user databases in SERVER\Sharepoint instance according to
Microsoft support.




"Dave Nickason [SBS MVP]" <gwdibble@xxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:Ou2DpMgFGHA.1124@xxxxxxxxxxxxxxxxxxxxxxx
> I'd try that. It sounds likely that there are particular properties of
> the SharePoint DBs that are keeping you from using them the way you wish.
>
>
> "Mike E." <mre@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:%23Riq76bFGHA.376@xxxxxxxxxxxxxxxxxxxxxxx
>> Hi Dave. I'm not trying to connect to the share point databases, but my
>> own databases, that I have placed
>> in the sharepoint SQL instance.
>>
>> Should, I just install a fresh SQL instance on the Server and use (local)
>> ?
>>
>> Mike
>>
>> "Dave Nickason [SBS MVP]" <gwdibble@xxxxxxxxxxxxxxxxxxxxxx> wrote in
>> message news:OdwYWsXFGHA.648@xxxxxxxxxxxxxxxxxxxxxxx
>>> Not that I have much hope of helping if this is a genuine sql issue, but
>>> why are you trying to connect to the sharepoint databases in that way?
>>> FWIW, I get a similar error when I try to connect to either \sbs or
>>> \sbs\sharepoint.
>>>
>>> "Mike E." <mre@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>>> news:eWYprRXFGHA.1180@xxxxxxxxxxxxxxxxxxxxxxx
>>>> Thanks for the reply Dave, tried ipcong /flushdns but did not solve it.
>>>>
>>>> Does not work on any clients on the system XP Pro or W2K.
>>>>
>>>> The error message is as follows:-
>>>>
>>>> Connection failed:
>>>> SQL State 01000
>>>> SQL Server Error 11004
>>>> etc
>>>> SQL Server not found
>>>>
>>>> Tried it with TCP/IP and named Pipes.
>>>>
>>>> Mike
>>>>
>>>>
>>>>
>>>> "Dave Nickason [SBS MVP]" <gwdibble@xxxxxxxxxxxxxxxxxxxxxx> wrote in
>>>> message news:uCBHUtWFGHA.4036@xxxxxxxxxxxxxxxxxxxxxxx
>>>>> You're attachment didn't make it through, so I'm not sure what you're
>>>>> seeing.
>>>>>
>>>>> I just had a situation where I replaced an old win2k member server
>>>>> named X with a new 2k3 member server named X, and I ended up with one
>>>>> workstation that could not connect to an MSDE database that was
>>>>> otherwise working normally. What fixed it was to run "ipconfig
>>>>> /flushdns" on that workstation (from a command prompt, without the
>>>>> quotes). If that works, thanks to SBS MVP Henry Craven for the
>>>>> suggestion.
>>>>>
>>>>>
>>>>> "marin" <marin@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>>>>> news:E1E050BC-C53E-4D31-ADC8-C17449D34F06@xxxxxxxxxxxxxxxx
>>>>>>I have just switched my SBS2000 over to an SBS2003 system and
>>>>>>everything is
>>>>>> working fine, except for connecting to my SQL databases using ODBC on
>>>>>> the
>>>>>> client computers. SQL is fully updated with SP4 and updates,
>>>>>> Sharepoint
>>>>>> Services is working fine. I have placed the databases in the
>>>>>> SERVER/Sharepoint instance, and added the TCP/IP and Named Pipes in
>>>>>> the
>>>>>> network section of the SQL instance. I have added security groups for
>>>>>> each
>>>>>> database and added the users and then added it to the SQL security.
>>>>>> Then when
>>>>>> I run the ODBC, I just get errors when trying to connect to the
>>>>>> SERVER\SHAREPOINT - see attached SQL Error. Never had a problem with
>>>>>> SQL 2000
>>>>>> on SBS2000 systems. Can any one please help, as I need to get these
>>>>>> back up
>>>>>> and running quickly.
>>>>>>
>>>>>> Thanks.
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>


.

Relevant Pages

  • Re: Setting Up Full Text Search For WSS
    ... Just to clarify having databases on two drives ... All of my SharePoint ... is a default install. ... > When you installed WSS did you install it with the default installation? ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Configuring Full Text Search FOr SharePoint Web
    ... SharePoint web to be able to use Full-Text Search. ... When you say "make sure that you have installed the SQL instance on ... >> can refer the whitepaper below to install SQL instance on sharepoint: ...
    (microsoft.public.windows.server.sbs)
  • Re: ODBC connection problem
    ... installed new default SQL instance + Service Packs. ... I'm not trying to connect to the share point databases, ... >>> in the sharepoint SQL instance. ... I just install a fresh SQL instance on the Server and use ...
    (microsoft.public.windows.server.sbs)
  • Re: Does SharePoint 2003 work with SQL 2005?
    ... SQL Server 2000 box to a new SQL Server 2005 box (not an in-place ... * Use SQL Server to manually backup each SharePoint database - config, ... INSTALL NECESSARY UPGRADE ITEMS ... MIGRATE THE DATABASES TO SQL 2005 ...
    (microsoft.public.sharepoint.portalserver)
  • Re: How do I upgrade/migrate from SQL 2000 (not MSDE) to SQL 2005?
    ... SQL Server 2000 box to a new SQL Server 2005 box (not an in-place ... * Use SQL Server to manually backup each SharePoint database - config, ... INSTALL NECESSARY UPGRADE ITEMS ... MIGRATE THE DATABASES TO SQL 2005 ...
    (microsoft.public.sharepoint.portalserver)
Loading