Kevin,

>>Applied this 'fix', and it worked

By re-installing MDAC? Weird ... wonder how it got screwed up? Well, anyway, glad you found and fixed the problem!!

~~Bonnie




>Bonnie,
>
>Applied this 'fix', and it worked
>
>http://www.dotnet247.com/247reference/msgs/37/186589.aspx
>
>Thanks for your help
>
>
>
>
>
>>Kevin,
>>
>>The only thing I can think of is that maybe you didn't set up your SQL Server with mixed authentication mode. It should not be asking you to log in when you go the Server Explorer in .NET. So, check out BOL's topic on "authentication, Mixed Mode". Or, I guess I can quote it here:
>>

>>How to set up Mixed Mode security (Enterprise Manager)
>>To set up Mixed Mode security
>>
>>Expand a server group.
>>
>>Right-click a server, and then click Properties.
>>
>>Click the Security tab.
>>
>>Under Authentication, click SQL Server and Windows.
>>

>>I hope that helps, cuz if it doesn't, I'm not sure what the problem is.
>>
>>~~Bonnie
>>
>>
>>
>>>I just installed .Net and SQL 2000.
>>>
>>>I have added myself as a user to SQL, and when I go into .Net and
>>>expand the SQL Servers node in the Server Explorer, I get prompted
>>>to login.
>>>
>>>I enter the User Name and Password that I set up in SQL, and I get the
>>>error "The specified procedure could not be found"
>>>
>>>I'm 2 days old at this. I could use lots of help.
>>>
>>>Thanks