Hi Nadya -

(Please see my reply to Bonnie too)

Is there some way to examine the System Error? I think I see the root of the problem in trying to get in with Query Analyzer and being refused entry using SQL Server Authentication and having to us Windows Authentication instead (spelled all this out in the message to Bonnie)

I think if I can get past that I will at least be looking at *new* errors < S >



>Hi Charles,
>
>I'm guessing, you have to add a new user like CHARLES\ASPNET At least, that's happened with me in both ASP.NET and ASP In both cases I had to add a new user (go to Enterprise Manager, then click on User icon on the top). Examine the error, it should tell you the name of the user...
>
>>Hi Kevin -
>>
>>Since this came up in the context of trying to run the C# winforms sample in your book I thought this might be a useful place to display my complete ignorance of all things SQL Server:
>>
>>I have SQL2000 installed with (I believe) the default settings. The computer name is CHARLES. When I open Enterprise Manager I don't see CHARLES I see local. Can get in to Northwind etc. I have SQLServer loading on OS boot. Service manager shows server as CHARLES.
>>
>>I run your C# winforms sample. When I try to launch the Orders form I get
>>
>>An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll
>>
>>Additional information: System error.
>>
>>No source code link.
>>
>>Left all connection string settings at default in Data.cs
>>
>>Then tried changing server to CHARLES in that conneciton string. No joy.
>>
>>I'm sure I'm missing something very obvious but with my level of SQL Server knowledge the obvious is obscure.
>>
>>Guidance?
>>
>>TIA