Cant Find Server, using isql -E, after deleting default database ! HELP

• Digs

  SSCertifiable

  Points: 7333

  More actions

  July 17, 2005 at 3:53 pm

  #164356

   I deleted my default database for the DBO, thus I cant reconnect to server, as default does not exists.

  Using this method to fix it,

  http://support.microsoft.com/default.aspx?scid=kb;EN-US;307864

  But when I type in command promt    c:\>isql -E

  I get error from the command prompt..

  DB-Library: Uable to connect to connect:Server is unavailable or does not exists.Or network access is denied

  Network library error 52, ConnectionOpen (Connect())

  The SQL server is on my C drive, and it has worked before, so how can I fix this, any ideas !

  I can ping ther server no problems on my c drive, also the "SQL Server Manager" is showing that its running fine !@^%(o*^

• SQLBill

  SSC Guru

  Points: 51440

  More actions

  July 18, 2005 at 8:14 am

  #575212

  The -E option requires that your SQL Server login be:

  1. the same as your Windows account

  and

  2. set to Windows Authentication.

  Things to check

  1. do you have a login on SQL Server

  2. is the login the same as your Windows login

  3. is the login set to use Windows Authentication

  4. does your login have access to any databases

  -SQLBill