当IP不是静态时如何连接sql server [英] how to connect sql server when IP is not Static

问题描述

当IP不是来自客户端的静态时如何连接sql server

vb.net

how to connect sql server when IP is not Static from client side
vb.net

推荐答案

对于你的独立电脑不是远程的电脑



使用'。'在您的IP地址中连接字符串



如下所示



connectionString =Data Source = .; Initial Catalog = xdb; Persist Security Info = True; User ID = sa; Password = *********

for your standalone pc not remote pc

use '.' insted of your ip address in connection String

Like Below

connectionString="Data Source=.;Initial Catalog=xdb;Persist Security Info=True;User ID=sa;Password=*********"

使用URL而不是IP地址，并提供所需的登录详细信息。

Use the URL instead of an IP address, and provide the required login details.

Data Source=TheDomainName.com;Initial Catalog=TheDataBaseName;Persist Security Info=True;User ID=UserID;Password=UserPassword

这篇关于当IP不是静态时如何连接sql server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！