Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How to configure SQL server express to listen at 127.0.0.1?

Posted on 2008-06-21
5
Medium Priority
?
1,682 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:Munawar Hussain
[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:Munawar Hussain
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 1500 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:Munawar Hussain
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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

688 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