How can access SQL SERVER 2008 in local PC with only IP?
I have installed SQL Server 2008 already, but now I only can access by writing “PCNAME\SQL”.
So what can I configure to can access SQL Server 2008 with only IP?
4 Solutions collect form web for “How can access SQL SERVER 2008 in local PC with only IP?”
SQL is the
named instance you have installed, right? so you cant access it only by using your IP, you need to infor the name of the instance. You should be able to do it by:
if you have a default instance installed, you should be able to access using all the options above without the
Open Sql Server Configuration Manager
Choose SQL Server NetWork Configuration
Then Restart you SQL Server in SQL Server Service
Now you can connect to you SQL Server by IP : yourIp\SQL or yourIp or yourIp\SQLEXPRESS
If you have default instance installed you can just targeted with
If you have named instance you need to specify the name. i.e.
There are always numerous options to connect to a local installation of SQL Server:
There’s more than that:
If you installed an instance, you have to add that, though, as specified by Diego.