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?

  • How to get current connected database file path?
  • Join with recursive query
  • Connecting to local SQL Server database using C#
  • Backup remote SQL Server database to local
  • Can I set a query timeout when using Zend_Db_Adapter_Pdo_Mssql?
  • 4 Solutions collect form web for “How can access SQL SERVER 2008 in local PC with only IP?”

    I supposed 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:

    • your_ip\SQL
    • localhost\SQL

    if you have a default instance installed, you should be able to access using all the options above without the \SQL

    First :

    • Open Sql Server Configuration Manager

    • Choose SQL Server NetWork Configuration

    • Enable TCP/IP

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

    If you have named instance you need to specify the name. i.e. .\INSTANCE_NAME.

    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.

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.