Re: 101

From: Rick Sawtell (ricksawtell_at_hotmail.com)
Date: 08/26/04 

Date: Thu, 26 Aug 2004 14:59:46 -0700

Sounds to me like your OLE-DB connection can see the server, but you gave it
invalid login credentials.

What is your connection string and is SQL Server running in Mixed Mode
security, or is it Windows Authentication.

Rick Sawtell
MCT, MCSD, MCDBA

"Lost" <novirus@hotmail.com> wrote in message
news:hWrXc.64228$3O2.15928@trndny07...
> Just trying to use SQL server for a VB .NET course. Using the SQL2000
trial
> editiond on XP PRO.
>
> When trying to connect to the northwind sample I get "Test Connection
> Succeeded" Followed by "Login failed. Catalog information can not be
> retrieved".
>
> What does this mean?
>
> I remember having this problem in the past with an ACCESS database after
try
> to upgrade it from 97 to 2000. In this case I am using the current version
> downloaded from Microsoft. Just trying to learn VB .NET right now without
> becoming an expert on SQL server. HELP!!!
>
>

Relevant Pages

  • Re: What is the best way to connect to a server not on the network?
    ... That 192 IP address is most likely not a remote one. ... but doesn't object to migrating the data to SQL server. ... I tried using ADO within Access to create a connection string to the remote ...
    (microsoft.public.access.modulesdaovba)
  • Re: Installing Sql Server Express on Vista Home Premium
    ... It seems that your SQL Server instances are Named Instances, ... Default Instances uses 1433 TCP port by default as a Static Port but not the ... If you change your Connection String as following, ...
    (microsoft.public.sqlserver.setup)
  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Database Connection Problems
    ... What I didn't understand before, is that you can create a database that is not attached to the SQL server. ... The common connection strings I've encountered only work when the database is provided by the SQL server. ... connection string not working. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)