Multi-Protocol & Standard Login > Discussions

September 02, 2010 Login |

Home
FAQs
       SQL Server FAQ
       SQL Injection FAQ
       SQL Security Checklist
       SQL Server-Related Products
       SQL Server/MSDE-Based Applications
       SQL Server Version Database
Tools
       Lockdown Script
       Free Tools
       Free Analysis
       Group Policy Templates
       Commercial Tools
Community
       Discussions
       Links
About
Search

SQL Security Forums

Note: SQLSecurity.com does not allow nor require registration due to privacy concerns for users. SQLSecurity.com is open and anonymous for all. Please report any abuse or profanity.

Unanswered

Active Topics

Forums

Forums > Discussions > SQL Server Security

Subject: Multi-Protocol & Standard Login

Prev Next

Add Reply

Author

Messages

Mick

09/27/2001 12:18 PM	Quote Reply Alert
Hi all, I am using SQL Server 7.0 SP3. I am using mixed-mode bothsecurity. In Enterprise Manager, I can connect using Integrated Authentication over both Named Pipes and Multi-Protocol. I can also connect using standard authentication over tcp/ip. However, what I would like to do is to connect over multi-protocol using standard authentication. Is this possible? If so, why is it failing for me? I am trying to do this over a router to a different subnet, if that makes a difference. Thanks

Chip Andrews

09/28/2001 7:11 PM	Quote Reply Alert
You should be able to do this but keep in mind that the RPC mechanisms used in Multi-Protocol will still need to be authenticated despite that fact that SQL Server is authenticating you via standard security. What concerns me is that you are claiming that you can make the connection via Integrated and not Standard. RPC mechanisms are notorious for creating back-channels on semi-random ephimeral ports so I'm not surprised that if you have limited connectivity between the machines you might be having trouble. Try a machine on the same subnet first and then try connecting over your router to make sure the RPC connection is not the problem here. Chip

Add Reply

Forums > Discussions > SQL Server Security > Multi-Protocol & Standard Login

Quick Reply

Username:
Subject:
Body:

ActiveForums 3.6