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

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

302 ratings | 79591 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 (43)
Sunil R (1 month ago)
I employed the same process to connect a remote sql server. Initially it worked but later in it started throwing an error which says “target principal name is incorrect. Can not generate SSPI context. “ does anyone know how to troubleshoot this error???
Sabbr Hajri (3 months ago)
can do that online? or local network only?
Oliver Paulite (3 months ago)
after doing all the steps .. did i just need to open the application in another Pc and it will automatically read the database in the server pc ?? pls reply im a student and i really need to know .. thank you sir
Oliver Paulite (1 month ago)
+jaswinder singh ohh is that so .. can you give a link or website where can i learn it. thank you sir for your reply
jaswinder singh (2 months ago)
he has shown half content. he doesnt tell us that how to connect client system to server to share database
Anti- Hypocrite (6 months ago)
What a shit video. Why even bother?
Rakesh Kumar (9 months ago)
half content you didn't show how to connect in client computer
Liridon Uka (9 months ago)
You don't need to specify any port unless you turn on the firewall
anka lim (9 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 (10 months ago)
What is this.. 2007?
Rhey Sachez (10 months ago)
Hello, if i have only 2 pc's with windows 10 and windows 7 i can do this?
Muhammad Junaid (10 months ago)
Thank you bro
King Rusty (11 months ago)
why are you such a bastard?
Jik Jik Hambala (1 year ago)
can you tell me how to connect the client into server without installing this sql server in client PC
Al Hadi (1 year 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 (1 year ago)
How to connect the other pc in the server pc? Help me
Al Hadi (1 year ago)
i am using LAN
Engineering Classes (1 year ago)
YOU USE LIKE LAN OR WLAN
hasan rana (1 year 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 (1 year 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
MaLiK Orgh (1 year ago)
i didn't find the sql Express service??
Engineering Classes (1 year ago)
ok. go on KEYBOARD AND PRESS WIN+R AND ENTER
CHINEDU OTY (1 year ago)
Thanks for the detailed explanation
Thomas Gural (1 year ago)
bakwas
Engineering Classes (1 year ago)
thanks for compliment
Felipe Mota (1 year ago)
Thanks, it helps a lot.
Gerald Vinuya (1 year 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 (1 year 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 (1 year 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 (1 year 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.