I installed two databases on sqlexpress one right after the other using the following command
osql -S(local)\SQLExpress -E -i"instnwnd.sql"
osql -S(local)\SQLExpress -E -i"pubs.sql"
Both execute the script properly.
But when I go to test the connection like this:
osql -S(local)\SQLExpress -E -d Pubs -q "SELECT Au_Lname FROM Authors"
Pubs runs great! Calls the select no problem.
osql -S(local)\SQLExpress -E -d Pubs -q "SELECT FirstName FROM Employees"
However tells me that my user name and password are not correct for this database. How can that be I load them one after the other have tried this twice and even looked at the rights on the instnwnd.sql and pubs folders.
One thing I notice different when they are executing the script and you see it working on pubs you see on the screen (computer name/user) but on northwind you see (computer name/SQLExpress)?
Thanks for any help resolving this.
Rich