Q
Problem solve Get help with specific problems with your technologies, process and projects.

Preventing specific hosts from connecting to SQL Server

I have one VB program installed in several PCs connected to SQL Server 7 with the same SQL user but, in the connection string, the Workstation parameter is personalized with the name of the PC.

I can see in SQL Server Enterprise Manager in Current Activity - Process Info; in the Host Column, the name of every PC connected.

The question is: Is it possible to say to SQL Server not to let the connection to a specific host?

Nope. The best you can do is dump sp_who into a table, scan the table for the host you do not want in, pull out the spid, and kill that spid.

 

For More Information

Dig Deeper on Microsoft SQL Server Installation

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close