?
Solved

WebServer cannot access SQL 2008 server

Posted on 2011-09-02
3
Medium Priority
?
359 Views
Last Modified: 2012-05-12
I am upgrading my application from using SQL 2000 to SQL 2008. The db server's IP address is 1.1.1.1.
When I installed SQL 2008, because SQL 2000 has the default instance name, I make SQL 2008 instance as 1.1.1.1/SQL2008.
My application on the db server can access 1.1.1.1/SQL2008 perfectly.
However, my asp.net web server in DMZ that cannot access the new SQL 2008 databae.
I configure the web.confg to put the server name as 1.1.1.1/SQL2008 but the connection does not work.
Then I added a new IP address, 1.1.1.2 on my db server and configured as a new SQL 2008's IP address in server configuration tool.
I could use ODBC to connect to 1.1.1.2 from my web server and establish an ODBC connection successfully. Thus, I know the firewall is not blocking the ports.
However, I still cannot confgiure my web.config to connect to the 2008 database by using 1.1.1.2 because SQL2000  is answering all the request before SQL 2008.
How can I make SQL 2000 to ignore all request that goes to 1.1.1.2 from my web server?
0
Comment
Question by:atlasdev
[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
  • 2
3 Comments
 
LVL 6

Expert Comment

by:c1nmo
ID: 36476564
Should be a backslash between server and instance name?

Connecting to an SQL Server instance
The syntax of specifying the server instance in the value of the server key is the same for all connection strings for SQL Server.Server=myServerName\theInstanceName;Database=myDataBase;Trusted_Connection=True;
0
 

Author Comment

by:atlasdev
ID: 36476586
It was my typo in this issue. I did backslash.
Can Web.Config use DSN to connect to the db server?
0
 
LVL 6

Accepted Solution

by:
c1nmo earned 2000 total points
ID: 36477116
Here's an example I use in web.config:

  <connectionStrings>
            <add name="dbCENConnectionString" connectionString="Data Source=S153\SQLEXPRESS;Initial Catalog=dbCEN;Integrated Security=True;Connect Timeout=200; pooling='true'; Max Pool Size=200" providerName="System.Data.SqlClient" />
    </connectionStrings>

0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
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…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

800 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