Not able to retrive information from SQL 7 server after patching

From: C.J. McParland (chrism@caboyachts.com)
Date: 01/29/03


From: "C.J. McParland" <chrism@caboyachts.com>
Date: Wed, 29 Jan 2003 10:44:37 -0800


The attached file shows the result of trying to connect to
my SQL server. This occured after patching the server with sp4.
The server is running & I can get into it. My problem comes
when a user tries to pull data from the server via a VB
script. The SA account doesn't work so I created another
and it also fails to allow entry. The authentication has
been switched from SQL to NT and back with no changes.
The question is : how do I ensure that this account(or any)
can connect and retrieve data.
Thank You for any assistance provided!




SQL_Error.jpg

Relevant Pages

  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Memory issues with 64-bit SQL Server 2005 on 64-bit Win 2003 C
    ... I also checked the individual patch levels for the .NET drivers, SQL Server ... The SQL Server is fully patched, however Windows Update reported that the OS ... Lock pages in memory -- I guess you might have taken care of it as well. ...
    (microsoft.public.sqlserver.clustering)
  • RE: migrating from wmsde to sql server
    ... Click Start, point to All Programs\Microsoft SQL Server, and then click ... then click New SQL Server Registration. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Best replication architecture?
    ... Looking for a SQL Server replication book? ... So if it is subscribing to Publisher 1, ...
    (microsoft.public.sqlserver.replication)

Quantcast