February 3, 2006 at 12:31 pm
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
February 3, 2006 at 2:29 pm
What was your error message?
make sure ian user has access to the db.
February 3, 2006 at 7:51 pm
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
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply