HomeНаука и техникаRelated VideosMore From: Engineering Classes

How to access sql server database from another computer (New)

209 ratings | 62244 views
how to access sql server database from another computer in lan!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! cccccccccccccccccc--CONTECT--cccccccccccccccccccccccc 🌐WhatsApp :+919563273765 🌐Youtube Channel:https://www.youtube.com/channel/UCciolV_TinVG39d0S4c1g4w 🔊 LIKE ➡ SHARE ➡ SUBSCRIBE ----------------------------------------------- ((()))-------------------------------------------------- sharing sql server database over network how to access sql server database from another computer how to share sql database between two computers how to make sql server available on the network how to configure sql server 2008 to allow network connections configuring sql server to allow remote connections how to access sql server database from another computer in c# how to connect to remote sql server database from management studio how to share sql database on network how to share mysql database between two computers how to access sql server 2008 database from another computer how to access sql server database from another computer in c# how to configure sql server 2008 to allow network connections how to connect to remote sql server database from management studio how to make sql server available on the network how to access sql server 2012 database from another computer -~-~~-~~~-~~-~- Please watch: "Untitled Project" https://www.youtube.com/watch?v=oQllmOhLzPo -~-~~-~~~-~~-~-
Html code for embedding videos on your blog
Text Comments (38)
Anti- Hypocrite (27 days ago)
What a shit video. Why even bother?
Rakesh Kumar (3 months ago)
half content you didn't show how to connect in client computer
Liridon Uka (4 months ago)
You don't need to specify any port unless you turn on the firewall
anka lim (4 months ago)
hi i really need help please. We change our ISP now we cannot connect to the server. What should we do. We are running a point of sale in a shop which server doing the job with the other computer. please help.
JAF (5 months ago)
What is this.. 2007?
Rhey Sachez (5 months ago)
Hello, if i have only 2 pc's with windows 10 and windows 7 i can do this?
Muhammad Junaid (5 months ago)
Thank you bro
King Rusty (6 months ago)
why are you such a bastard?
Jik Jik Hambala (7 months ago)
can you tell me how to connect the client into server without installing this sql server in client PC
Arsath Ali (8 months ago)
I did the all the process but i am not the getting the connection of the mssql server database from the other pc in android..I am connecting my android application with mssql server on other pc
RM Dorola (8 months ago)
How to connect the other pc in the server pc? Help me
Arsath Ali (8 months ago)
i am using LAN
Engineering Classes (8 months ago)
YOU USE LIKE LAN OR WLAN
hasan rana (8 months ago)
one desktop application that setup one more pc but sql server 2012 has installed one pc. i could not connect the sql server from another pc by ConnectionPool. all procedure are completed but did't login sql server by desktop application... i have use this link to get sql server.. SrvName="DESKTOP-P6RRS16" DbName="Printing_06_FEB_2018" UserId="admin" PassWord="asdfghjkl" would you help me, pls.
Engineering Classes (8 months ago)
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data.SqlClient; using System.Data; using System.Windows.Forms; using System.Collections.Specialized; using System.Configuration; using System.IO; using System.IO.Compression; using Ionic.Zip; using System.Threading; namespace SchoolPlus { class SQLHelper { public static SQLHelper mInstance; public static string mDataSource = string.Empty; public static string mInitalCatalog = string.Empty; public static string mUserPass = "user id=sa;password=!dcuseronly"; private static string CONNECTION_STRING = ""; private SQLHelper() { } public static SQLHelper GetInstance() { if (mInstance == null) { CONNECTION_STRING = string.Empty; mDataSource = System.Configuration.ConfigurationManager.AppSettings["DataSource"].ToString(); mInitalCatalog = System.Configuration.ConfigurationManager.AppSettings["InitialCatalog"].ToString(); CONNECTION_STRING = "Data Source=" + mDataSource + ";Initial Catalog=" + mInitalCatalog + ";" + mUserPass; mInstance = new SQLHelper(); } return mInstance; } public bool ExcuteQuery(string query) { using (SqlConnection con = new SqlConnection(CONNECTION_STRING)) { try { con.Open(); SqlCommand cmd = new SqlCommand(query, con); cmd.ExecuteNonQuery(); return true; } catch (Exception) { // DebugTracer.Instance.WriteLog(ex.ToString()); return false; } } } APPS.CONFIG----------------------------------------------------------------------- <?xml version="1.0"?> <configuration> <appSettings> <add key="DataSource" value="DESKTOP-3ICAT1V\SQLEXPRESS" /> <add key="InitialCatalog" value="sp" /> <add key="K1" value="10,15" /> <add key="K2" value="16,19" /> <add key="ClientSettingsProvider.ServiceUri" value="" /> </appSettings> <system.web> <membership defaultProvider="ClientAuthenticationMembershipProvider"> <providers> <add name="ClientAuthenticationMembershipProvider" type="System.Web.ClientServices.Providers.ClientFormsAuthenticationMembershipProvider, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" serviceUri="" /> </providers> </membership> <roleManager defaultProvider="ClientRoleProvider" enabled="true"> <providers> <add name="ClientRoleProvider" type="System.Web.ClientServices.Providers.ClientRoleProvider, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" serviceUri="" cacheTimeout="86400" /> </providers> </roleManager> </system.web> </configuration> APPLY THIS
AbdOo MaLiK (9 months ago)
i didn't find the sql Express service??
Engineering Classes (8 months ago)
ok. go on KEYBOARD AND PRESS WIN+R AND ENTER
CHINEDU OTY (9 months ago)
Thanks for the detailed explanation
Thomas Gural (10 months ago)
bakwas
Engineering Classes (10 months ago)
thanks for compliment
Felipe Mota (10 months ago)
Thanks, it helps a lot.
Gerald Vinuya (10 months ago)
Hi, can you help me, how to change this in the link table manager in ms access i need to change the file location from C:\admin to 192.168.1.1\admin, because i need to connect my ms access database server to client
Engineering Classes (10 months ago)
Table links can be UNC paths. For example, say I have a linked table pointing to a database on \\192.168.1.2\Public\ which is mapped to drive P:. If I launch the VBA editor (Alt+F11), open the Immediate Window (Ctrl+G) and type... ?CurrentDB.TableDefs("remoteTable").Connect ...it will return... ;DATABASE=P:\B.accdb ...because I pointed to drive P: when I created the link. Now if I create and run the VBA function... Function linkToUnc() Dim cdb As DAO.Database Set cdb = CurrentDb cdb.TableDefs("remoteTable").Connect = ";DATABASE=\\192.168.1.2\Public\B.accdb" cdb.TableDefs("remoteTable").RefreshLink Set cdb = Nothing End Function ...the link is now a UNC path. By the way, you can create UNC links in the Linked Table Manager if you browse to "Network", "machine name", "share name", but that will give you the machine name (in my case \\PICO\Public\B.accdb).
ANUBHAV SAGAR (11 months ago)
using this or following this steps I can access the database of any other System when the systems are in same network or I can also use being in a different network?? If I can not be able to access the database being in a different network, then plz suggest me how I can do that way.
Engineering Classes (10 months ago)
Then You can use remote access or online server
PhasePD (1 year ago)
but how the fuck do you find the server name?
hytham yassin (1 year ago)
The name of the server is the name of that computer SQL server installed in,or the device that want to Share it's database.
Bala Krishnan (1 year ago)
Thanks a lot sir... which is very useful for me...
you're a legend
Mohammed Jaleel (1 year ago)
Thank You
nice view (1 year ago)
Thx a lot for your video!! with sa ( as login ) it finally worked for me :-)
Engineering Classes (1 year ago)
Thanks for watch my video,
jonathan paniza (1 year ago)
i have a many computers but i need only 1 database how can i do that plss help me
Engineering Classes (1 year ago)
ok at first you download ultra viewer and  Contact me,then I see the problem
chris chan (1 year ago)
is it ok to use xp on 1 computer, and the other is windows 7?
Engineering Classes (1 year ago)
Yes
WINDOWS 7 + 8.1 + 10
Engineering Classes (1 year ago)
yes, you can do

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.