Solved

How to configure SQL server express to listen at 127.0.0.1?

Posted on 2008-06-21
5
1,651 Views
Last Modified: 2008-06-22
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
Comment
Question by:needo_jee
  • 3
  • 2
5 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 21838365
>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
 
LVL 12

Author Comment

by:needo_jee
ID: 21838984
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
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 21839011
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
 
LVL 12

Author Comment

by:needo_jee
ID: 21841658
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
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 21841685
>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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question