[Originally posted by peteraharrison]

Generally I have very much enjoyed ADO.NET - it is a pleasant read and has
even produced a couple of laughs - not bad for such heavy material.
Trying to work the chapter 21 (remoting) example has led nowhere however.
Having downloaded the sample files (which do not appear to include an
installer by the way), placed them where they need to be, I attempted to work
chapter 21. This, of course, requires the tables to be created and populated
using the loader in the utility directory.
Problem: No matter which account and password I enter into the start-up pane I
am informed that I do not have a trusted connection and the program
terminates. There does not appear to be any source code for the loader so
everything has ground to a halt. Any suggestions would be welcome. At this
point I am completely stalled.

Thanks in anticipation.

[Originally posted by arlen]


Sorry about the installer - I will get that up there soon!

I'm not entirely sure what the problem is that you are having. One thing you
might try is to manually create the database in SQL Server Enterprise Manager.
. .

If that doesn't work, let me know - also if you can tell me the exact error
message - does it say "Could not connect to SQL Server with UserID. . ." or do
you get an "Error Creating Database" error?

Thanks,

Arlen

> Generally I have very much enjoyed ADO.NET - it is a pleasant read and has
> even produced a couple of laughs - not bad for such heavy material.
> Trying to work the chapter 21 (remoting) example has led nowhere however.
> Having downloaded the sample files (which do not appear to include an
> installer by the way), placed them where they need to be, I attempted to work
> chapter 21. This, of course, requires the tables to be created and populated
> using the loader in the utility directory.
> Problem: No matter which account and password I enter into the start-up pane I
> am informed that I do not have a trusted connection and the program
> terminates. There does not appear to be any source code for the loader so
> everything has ground to a halt. Any suggestions would be welcome. At this
> point I am completely stalled.
>
> Thanks in anticipation.

[Originally posted by peteraharrison]

Arlen,
The problem, I believe is that I do not normally use SQL logins and passwords
on my development machines, but rely on the Windows security if that makes
sense. (I run the Enterprise version of SQL.) The loader insists on a SQL
login and password and "sa" with a blank password does not let me in. The
message states (in MS-Speak) that "sa" is not a trusted name. At this point
I'm stalled since any login-password combination I can use in tne Enterprise
Manager does not get me by.
However, I have now successfully accomplished what I needed to do with an
existing database and all is well.

Again, thanks for your prompt replies and, again, for an informative book. May
you write many more!


Peter.
>
> Sorry about the installer - I will get that up there soon!
>
> I'm not entirely sure what the problem is that you are having. One thing you
> might try is to manually create the database in SQL Server Enterprise Manager.
> . .
>
> If that doesn't work, let me know - also if you can tell me the exact error
> message - does it say "Could not connect to SQL Server with UserID. . ." or do
> you get an "Error Creating Database" error?
>
> Thanks,
>
> Arlen
>