I have a computer (computer A) that is installed MS SQL, and I have another computer (computer B) in which application I want to connect the MS SQL database to Computer B from computer using this application? How do I do this? Should I use the connection string of firewall settings, database configuration, etc.?
Ok, the firewall rule will open by default by port 1433 (but for this There is very little reason), but if you are just running one instance and can not change it, then it is probably 1433.
Enable remote connections through SQL Studio and TCP / IP through connections Manager:
And Stephennel's excellent connection string site, www.connectionstrings.com; Different application languages / techniques will use different connection strings.
You will also need some type of user, and whatever is the easiest SQL Server Ath will be, and it will be easy to right click on the "Security" folder under a database in Management Studio , And new-> users
is going to help!
Comments
Post a Comment