ASP.Net connection

• Ian Hockaday

  Newbie

  Points: 8

  More actions

  February 3, 2006 at 12:31 pm

  #68645

  I have a connect string to a SQL database:

  “Data Source=Catshill;Initial Catalog=Orders;User ID=sa;Password=sa” It connects to the database correctly.

  If I change the string to:

  “Data Source=Catshill;Initial Catalog=Orders;User ID=ian;Password=ih” It will not connect

  “ian” is a valid SQL login to the Catshill server – I can successfully login to SQL Query Analyzer with ian/ih.

  I tried the same thing on a “local” SQL server database too – got the same error.

  Any suggestions would be appreciated!

  Ian

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  February 3, 2006 at 2:29 pm

  #618798

  What was your error message?

  make sure ian user has access to the db.

   

• Ian Hockaday

  Newbie

  Points: 8

  More actions

  February 3, 2006 at 7:51 pm

  #618819

  There is no error message that I can see - I have the SQLConnection.Open() in a try-catch block and with "ian" it gets caught - "sa" sails right on by.

  I did look at the "Watch" for the SQLConnection object after it has been trapped by the "Catch", but could not see any obvious clues to an error.

  "ian" has dbo_Owner access to the database - I can log into the database using SQL Quey Analyzer and the user/password "ian/ih".

   

  Thanks

  Ian