Hi Weeble, jaywalkins & the users of SSMS Express and VWD Express:

I have used SSMS Express, VB Express and VDW Express (downloaded from Microsoft VS Express website to my Windows XP Pro PC that is on our Microsoft NT 4.0 LAN System under the Computer Administrator account) to play the stuffs of Try It Out of SQL Server 2005 Express Edition Starter Kit written by R. George and L. Delano under my end-user account. I had no programming problems in executing the stuffs of Try It Out of Chapter 4 for the Database Applications in VB Express. But I had a persistent problem to get the VWD result shown in Figure 5-8 on Page 95 (no extracted BookID, BookTitle & AuthorID) and problems to get the results shown in Figure 2-6 on Page 35 (error message: Msg 916, Level 14, State 1, Line 1. The server pricipal "XXXX\YYYYYY" [where XXXX=log-on domain and YYYYYY=end-user account] is not able to access the database "testDb" under the current security context.) when I used my end-user account to run the VWD Express and SSMS Express programs. I think these problems are caused by the end-user account that is inaccessible to the connections of VWD Express and SSMS Express installed in the PC.
My Computer Adminitrator changed my local PC account from the "end-user account" to the "Administrator account" in my local Domain and I executed these VWD and SSMS programs again and I had no suceess in the output!!?? Does anyone have good ideas to solve this coonction problem? Please help and advise.
Thanks in advance,
Scott Chang

Scott Chang

__________________
Scott Chang

To update my last posted message:
(1) A small mistake in my user-name listed in my terminal PC for the Adminitrator Priviledge purpose was discovered and corrected. So, I can do the Stored Procedures of Chapter 2 in SSMS-EE now - I am just getting it started.
(2) I still have difficulties to get the stuffs of Try It Out "Filtering Data Dynamically" on Pages 89-90, "Inserting Data" on Page 91-92, and "Working with Master Detail" on Pages 93-95 executed correctly - I think I have to get the "Filtering Data Dynamically" and "Insert Data" right first and then tuckle the problem of getting Figure 5-8 for the "Working with Master Detail". Any comments or suggestions on this matter.
Thanks,
Scott Chang

Scott Chang