• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1710
  • Last Modified:

How to configure SQL server express to listen at 127.0.0.1?

I have SQL server express version installed on windows XP professional. It is running, accessible via Management Studio, and Visual Studio with "Computname\Sqlexpress" name  and work fine with SQL and Windows authentication.
But I would like to configure it on 127.0.0.1 because I need to use it with that ip address.
I have configured it like this way http://semmle.com/microsoft-sql-server-installation/
but still unable to get it working. Please could anyone guide me how to set that...?

--Thanks
0
Munawar Hussain
Asked:
Munawar Hussain
  • 3
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>But I would like to configure it on 127.0.0.1
127.0.0.1 is not really an ip address, but the loopback adapter.
and sql server does listen on that address also (I don't think you can disable that unless you disabled the TCP/IP network protocol)

> because I need to use it with that ip address.
why that (curious).
alternatives to connect locally are, depending on the connection tools:
.
localhost
(local)



0
 
Munawar HussainPrincipal Software EngineerAuthor Commented:
Thank you for quick reply.
Sorry, for inconvenience. Actucally I need to access SQL server using an IP adress instead of named instance like compName\Sqlexpress.

I have only Express edition running on machine with default installation options.
I cannot connect to Engine when using 10.10.1.33 .. that is local ip of my machine.

how SQL can be configured so that it can be access via ip?

Thanks
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
a named instance will be like this:

compName\Sqlexpress
127.0.0.1\Sqlexpress
localhost\Sqlexpress

in other words: if the instance is a named instance, you HAVE to specify the instance name also.
with a possible workaround: using the sql server client network utility, you can define a alias to a named instance, but then you connect using that alias named and not via the ip or the full instance name.
0
 
Munawar HussainPrincipal Software EngineerAuthor Commented:
Dear AngelIII,

It sounds, perhaps not possible what I am looking for?
The default instance is for SQL server 2000 which I installed before installing Sql Express(2005)
Therefore, the later one is instance based (Sqlexpress is name of instance.)

but I have seen one person accessing SQL server express using 127.0.01 thats why I got curious to know how can be used like that.

Feeling that no other way is right there.. I got uninstalled everything and installed enterprized edition with default instance and now I can access using ip address of my machine.

I would be happy to know if there is any possibility to to rename instance?
like I have SQL 2000 as default but I would like to make SQL express as default and SQL 2000 as named instance?
-- Once again thanks
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>I would be happy to know if there is any possibility to to rename instance?
no, a instance cannot be renamed (other than reinstallation)

0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now