Solved

How to configure SQL server express to listen at 127.0.0.1?

Posted on 2008-06-21
5
1,660 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
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…

710 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