[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Create a new Data Source to SQL SERVER

Posted on 2006-11-08
14
Medium Priority
?
996 Views
Last Modified: 2012-05-05

When i trying to create new data source name i got the following error

Connection failed:
SQL State : '01000'
SQL Server Error : 11001
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Connection Open[Connect[]].
Connection failed:
SQL State : '08000'
SQL Server Error : 6
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL Server not found.

how do i rectify it
0
Comment
Question by:taru_bhargava
[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
  • 7
  • 5
14 Comments
 
LVL 9

Expert Comment

by:gpompe
ID: 17901730
This error means that you cannot reach the Server. So some of possible problem are:

1. Typo in the Server name you wrote.

2. Due to network configuration you cannot reach the server box from your box

3. The sql server was configured to listen in other port than 1433

4. SQL server is not running

Some test you can do are ping the server box. Try creating the datasource using IP instead of server name.

If you have the SQL Client tools, try connecting usin Query Analyzer (or Management Studio depending on the version you are using)

Let me know the result so we work from there.
0
 

Author Comment

by:taru_bhargava
ID: 17901862
I am using Apachee Tomcat as server, Server name i typed in the window is "Local Server".SQL Server is also running.
How would i test that whether SQL Server is configured to listen to another port than 1433.


Please help
0
 
LVL 9

Expert Comment

by:gpompe
ID: 17901941
In the server name try Localhost or (local).

0
Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

 
LVL 9

Expert Comment

by:gpompe
ID: 17901956
To check the port there is a program called Server Network Utility in the SQL Server program group.

Select the protocol TCP/IP and then click properties...
0
 

Author Comment

by:taru_bhargava
ID: 17902043
I couldn't find out that where this server network utility is located and please be little elaborate so that i can solve my problem fast as i really running out of time Kindly give me all details
0
 
LVL 9

Expert Comment

by:gpompe
ID: 17902168
On the SERVER BOX goto All programs >> Microsoft SQL Server >> Server Network Utility. (This application is installed with the Server)
0
 

Author Comment

by:taru_bhargava
ID: 17902216
what is this server box
0
 
LVL 9

Expert Comment

by:gpompe
ID: 17902224
the machine where SQL SERVER is Running.
0
 

Author Comment

by:taru_bhargava
ID: 17902273
SQL server is running on my machine that is local server,  actually could you please provide me the whole solution to my problem as exactly what should i do, is there any problem in installation and whatever links you are telling to search i am not getting them
0
 
LVL 9

Expert Comment

by:gpompe
ID: 17902312
What version of SQL Server are you using ?
0
 

Author Comment

by:taru_bhargava
ID: 17902330
7.0
0
 
LVL 9

Accepted Solution

by:
gpompe earned 2000 total points
ID: 17902373
If you are using 2005 you have to go to Start >> All Program >> Microsoft SQL Server 2005 >> Configuration Tools >> Sql Server Configration Manager

In there you have to check if you server is running. Check if the column state of SQL Server (MSSQLSERVER) says "Running"

and to check the port click on Sql Server 2005 Network Configration >> Protocols for MSSQLSERVER and Double click on TCP/IP.
This will open a window, on this window click on tab IP Address check the rows TCP Port
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

656 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