Can not open Database (MS SQL) requested login failed

From: Bobby (anonymous_at_discussions.microsoft.com)
Date: 03/08/04 

Date: Mon, 8 Mar 2004 07:16:06 -0800

I have installed MSDE but when ever i try to connect to it from the same computer, it gives me
'Can not open Database requested in Login 'pubs' failed. Login fails'

I tried everything nothing seem to work plz help

my connection string is as follows

Public Conn As New ADODB.Connection
conn.Open("Driver={SQL Server};User ID=sa;Password=ab;Database=BigSQL;Server=Master\Mycube")

where 'Master' is the computer name and 'Mycube' is the insance name

Also If the computer is password protected, could that create the problem ?

Thanks
Bobby

Relevant Pages

  • MSDE 2000 SP3a on a Windows 2003 server
    ... I have installed MSDE 2000 SP3a on both Standard and ... Enterprise Windows Server 2003 with the same problem. ... machine with any valid account, ... login with the same accounts from another computer in the ...
    (microsoft.public.sqlserver.msde)
  • Cannot open SQL Server 2000
    ... I have installed MSDE but when ever i try to connect to it from the same computer, ... 'Can not open Database requested in Login 'pubs' failed. ... where 'Master' is the computer name and 'Mycube' is the insance name ...
    (microsoft.public.dotnet.framework.adonet)
  • Can not open Database requested in Login pubs failed.
    ... I have installed MSDE but when ever i try to connect to it from the same computer, ... 'Can not open Database requested in Login 'pubs' failed. ... Public Conn As New ADODB.Connection ... Earlier I installed similarly in a different XP machine and that machine is working fine with the same database so the id and pwd is not the problem, ...
    (microsoft.public.sqlserver.msde)
  • What could it be ? Plz answer me
    ... I have installed MSDE but when ever i try to connect to it from the same computer, ... 'Can not open Database requested in Login 'pubs' failed. ... Public Conn As New ADODB.Connection ... Earlier I installed in a different XP machine and that machine is working fine with the same database so the id and pwd is not the problem, ...
    (microsoft.public.dotnet.general)
  • cant log in with MS SQL Web Data Administrator
    ... Installed MSDE with the SAPWD parameter. ... Installed the MS SQL Web Data ... started Cassini on port 81 since it didn't like port 80. ... Can't get the login to work at http://localhost:81/webadmin/default.aspx. ...
    (microsoft.public.sqlserver.msde)