Link to home
Create AccountLog in
Microsoft SQL Server

Microsoft SQL Server

--

Questions

--

Followers

Top Experts

Avatar of al4629740
al4629740🇺🇸

Managing access to SQL database via VB6 application from over the Internet

I have a VB6 application that accesses our database internally at our office using the connection string below.  


         conn.Open "Driver={SQL Server Native Client 11.0};Server=OfficeMgrAsst\SQLEXPRESS;Database=xxxx;Uid=xxxx;Pwd=xxxxxxx;"

Now we want to be able to have one computer from the outside access the database.  Is there a way to isolate only one IP address or computer from the outside to access our database using VB6?  I know I would have to open up the port 1433 and have a static IP address, but is there a way to manage who from the outside can gain access?


Ideas please.

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

Avatar of Éric MoreauÉric Moreau🇨🇦

Is your server accessible from the web? This isn't a good practice as you would become wide open to attack,

Do you have a VPN or RDP connection you could use instead?
Avatar of al4629740al4629740🇺🇸

ASKER

I have them using anydesk and they don’t like it.
ASKER CERTIFIED SOLUTION
Avatar of John TsioumprisJohn Tsioumpris🇬🇷

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account
SOLUTION
Avatar of Éric MoreauÉric Moreau🇨🇦

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account
Avatar of al4629740al4629740🇺🇸

ASKER

Azure is best because you can isolate the up address but it’s not an option.

John perked my curiosity.  They have a Comcast modem.  Can one up address be specified on it?
Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.

Avatar of David Johnson, CDDavid Johnson, CD🇨🇦

yes in the port forwarding rules.
Avatar of al4629740al4629740🇺🇸

ASKER

But can it specify an external IP?
Avatar of David Johnson, CDDavid Johnson, CD🇨🇦

Normally I would say Yes, absolutely but comcast's version of the firewall/port forwarding might not have that option.  Without a manual or the device I can't say for sure.. but normally you can
you can limit using windows firewall
Free T-shirt

Get a FREE t-shirt when you ask your first question.

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

Avatar of al4629740al4629740🇺🇸

ASKER

ok. but I imagine the windows firewall will
limit addresses within the LAN and not public IP addresses behind the modem gateway.
SOLUTION
Avatar of David Johnson, CDDavid Johnson, CD🇨🇦

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account
Microsoft SQL Server

Microsoft SQL Server

--

Questions

--

Followers

Top Experts

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.