Slider

Marie Curie Newton Stephen Hawkings APJ Kalam Edison Einstein Gregor Mendel Aryabhatta Ramanujan

Thursday, 5 November 2015

Accessing the local databases in Lan connected systems through sql server

In order to connect local sql server from one computer to another computer follow below rules.
Step 1: Go to Sql server configuration manager -> sql server network configuration -> protocols for sqlexpress

Step 2:(Shared memory, Named Pipes, Tcp/ip) Right click on protocol names and Enable all three status

Step 3: Set  Port=1433 in Tcp/ip properties in IPALL tab.

Step 4: Restart the Sql services

Step 5: Goto firewall settings=> allow app settings=> change settings=> allow app settings
 select   C:\Program Files\Microsoft SQLServer\MSSQL12.SQLEXPRESS\MSSQL\Binn\sqlservr.exe

Step 6: Done

Step 7: Open sql server management studio, give server name as   local computer name with port number
  example  server name:   Swamycomputer/sqlexpress,1433
                authentication: Sql server
                UserId: sa
                Password: sa123
go through the below images.





No comments:

Post a Comment