Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Book / SQL connection question
Message
From
06/02/2003 01:13:07
 
 
To
06/02/2003 00:01:28
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Miscellaneous
Thread ID:
00749702
Message ID:
00749724
Views:
37
I'm glad I asked < g >

For benefit of anyone as ignorant as I am :

I was using Windows NT Verification - recommended but crunchy with the examples one mostly finds re connection strings.

Went to enterprise manager, right-clicked on icon for local server. On security tab changed Authentication from Windows Only to SQL Server and Windows

On the treeview in the left panel, again right clicking on local I was then able to change the Registration properties - this time changing from Use Windows Authentication to USE Sql Server Authentication.

Now all is well with Kevin's book sample and other things and examples re connection strings etc seem to be behaving as advertised.

Perhaps I'm the last person on earth to learn all this, but then again perhaps it will save some other hapless soul from my confusion.

( Great book Kevin - enjoying it very much. I being a VFE er ( a close cousin to the MM ers ) I am very fond of business objects and decoupling logic from presentation. You examples in this direction are very good and I am sure MM .NET is going to get a lot of folks involved in best practices on this stuff)


Charles Hankey

Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy

Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.

-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin

Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform