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.
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