Solved

How to configure SQL server express to listen at 127.0.0.1?

Posted on 2008-06-21
5
1,645 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

Title # Comments Views Activity
Record open by another user 6 64
Passing value to a stored procedure 8 107
How to simplify my SQL statement? 14 55
What is this datetime? 1 19
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

860 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