Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Change in security between MSDE 7 and MSDE 2000
Message
From
06/12/2002 10:30:25
 
General information
Forum:
Microsoft SQL Server
Category:
Security
Miscellaneous
Thread ID:
00730248
Message ID:
00730318
Views:
25
>I would check what protocols are enabled on the client PC and make sure that TCP/IP is the first in the list.

Local Area connection properties for my machine:
Client for Microsoft Networks
File and printer sharing for Micorsoft Networks
QoS Packet Scheduler
Internet Protocol (TCP/IP)

Should I try to move TCP/IP higher in this list?

I cannot access the server from this machine (where the MSDE 2000 server is running) using the connection in the DBC unless I use Trusted Connection. In fact I cannot access it from enterprise Manager without using trusted connection.

Thank you for your help.

Alex

>>>Looks like you set up MSDE 2000 with Windows Authentication. You can use EM to change it to the Mixed mode on the Server property page.
>>
>>Thanks for your response, Sergey. Just checked and it indicates Authentication: SQL Server and Windows. What else could be the problem?
>>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform