开发者

SQL Server 2008 SSMS connection and http connection string?

开发者 https://www.devze.com 2022-12-21 05:13 出处:网络
I have a SQL Server 2008 on a server which goes out on the internet through a domain namecomputer.example.com, I want to develop a .net app on my PC and to connect to that database through SSMS - to c

I have a SQL Server 2008 on a server which goes out on the internet through a domain name computer.example.com, I want to develop a .net app on my PC and to connect to that database through SSMS - to create tables and so on... And I still want a 开发者_StackOverflow中文版connection string which can be accessed from anywhere - I'm thinking at a http url or something like that - which will be consumed by the app.

What do I must to configure on the server so that I can connect via SSMS to the database (from my PC) and how do I get a connection string to that database?


you can use Sql Server Configuration Manager for this work. when you run this application, expand the SQL Server Network Configuration, after that you can see Protocols for sql server 2008. by click on it you can enable or disable TCP/IP.

your connection string can be like this :

connectionString="Database=DBName;Server = Server IP;Integrated Security=false;user id=sa; password=Pass;
0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号