Two simple ways of obtaining your port number for Connection String usage.
-- From start, right click on computer then click on Manage.
-- Click on Services and Applications
|
--SQL Server configuration manager
|
** --SQL Server <year> Network configuration
|
--Protocols for <Server type>
--Right click on TCP/IP then, select/click_on properties.
--Select the IP Address tab, look for TCP port; DONE!!!
OR
-- From start
|
-- All Programs
|
--Server configuration manager
|
--Microsoft SQL Server <year>
|
--SQL Server <year> configuration manager
Continue from ** above
-- From start, right click on computer then click on Manage.
-- Click on Services and Applications
|
--SQL Server configuration manager
|
** --SQL Server <year> Network configuration
|
--Protocols for <Server type>
--Right click on TCP/IP then, select/click_on properties.
--Select the IP Address tab, look for TCP port; DONE!!!
OR
-- From start
|
-- All Programs
|
--Server configuration manager
|
--Microsoft SQL Server <year>
|
--SQL Server <year> configuration manager
Continue from ** above
No comments:
Post a Comment