Re: Cannot connect to SQL using ODBC

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: David Copeland [MSFT] (davidcop_at_online.microsoft.com)
Date: 05/04/04 

Date: Tue, 4 May 2004 16:42:28 -0500

Miquel,

Couple of things to look at if you are trying to connect to the
servername\sharepoint instance from a different machine after upgrading to
full SQL. First, go to Start/All Programs/Microsoft SQL Server/Server
Network Utility and be sure to add the appropriate library (Named Pipes or
TCP/IP (sockets)) to the servername\sharepoint named instance. Also, by
default the SharePoint instance is only configured for Windows
Authentication so the SA account would not be able to logon unless you
enable SQL and Windows Authentication. You would also probably need to set
the SA account password to a password you would know. 

-- 
Hope that helps,
David Copeland
Microsoft Small Business Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
Newsgroups:
SBS v4.x : microsoft.public.backoffice.smallbiz
SBS 2000: microsoft.public.backoffice.smallbiz2000
SBS 2003: microsoft.public.windows.server.sbs
"Miguel" <anonymous@discussions.microsoft.com> wrote in message 
news:85a801c43215$fdfd1460$a301280a@phx.gbl...
> one of my applications requires me to manually create
> system DSN using the MS SQL Driver. When I try to connect
> to the server using "SERVER\SHAREPOINT" and the sa login,
> the connection fails. When I select the "SERVER" from the
> drop down it shows 2 to pick from, SERVER and SERVER.
> I've completed the SQL upgrade procedures also.

Relevant Pages

  • Re: Redundancy design in SBS Domain
    ... But virtualization was not on my radar, and Exchange and SQL need more with each iteration. ... I originally went the SBS route because it was by far the cheapest was to get a server up and running with SQL Server at the time. ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 Std - SQL Eval expired...will un-installing break SBS fun
    ... I agree with Claus that you're able to remove SQL 2005 instances if you did ... you can get SBS R2 which already contains SQL Server 2005 ... Workgroup Edition, and upgrade Sharepoint instance, and install other ...
    (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: WSUS
    ... Les Connor [SBS MVP] ... Is your server exhibiting significant performance problems, and if so, how ... SQL Server: ... >No wonder SBS brings servers with 4GB of RAM to their knees. ...
    (microsoft.public.windows.server.sbs)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)