Connection Open Exemptions

From: 11Oppidan (11Oppidan_at_community.nospam)
Date: 02/03/05 

Date: Thu, 3 Feb 2005 13:59:48 -0000

Hi,

Using VB .NET is there a way to return/track the reason why a connection has
failed to open. I want to be able to track the following reasons for
failure:
1. User doesn't have the correct permissions set to open the database
2. Unable to open the connection because the user setting are wrong, (server
name, username, password)
3. Using the wrong authentication - NT authentication instead of SQL Server
authentication and vis versa

Many thanks

Relevant Pages

  • Re: Remote connection failed
    ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
    (microsoft.public.sqlserver.connect)
  • Re: C# connection string using Windows NT Authentication
    ... you indicate that you are using Windows ... If you are connecting to a local instance of SQL Server on your ... it sounds much less like a connection string ... you'll need to resort to SQL Authentication. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Problems Using Laptop As SQL Server - Log On Failed
    ... > connected to the network and no password for windows. ... > the name of the laptop as name of the SQL Server. ... > trusted SQL Server connection ... you have to change the authentication mode... ...
    (microsoft.public.sqlserver.msde)
  • Re: No Windows, Only SQL Server Authentication
    ... To establish a Windows authenticated connection from OSQL, ... SQL Server programatically. ... Your connection string needs to specify the type of authentication desired. ...
    (microsoft.public.sqlserver.security)
  • Re: That $%#@ "Trusted Connection" Thing Again...
    ... SQL Server ODBC Driver Ignores Authentication ... What is the connection string you are using? ... Have you run Component checker to ...
    (microsoft.public.sqlserver.security)