Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1000
  • Last Modified:

Create a new Data Source to SQL SERVER


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
taru_bhargava
Asked:
taru_bhargava
  • 7
  • 5
1 Solution
 
gpompeCommented:
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
 
taru_bhargavaAuthor Commented:
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
 
gpompeCommented:
In the server name try Localhost or (local).

0
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

 
gpompeCommented:
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
 
taru_bhargavaAuthor Commented:
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
 
gpompeCommented:
On the SERVER BOX goto All programs >> Microsoft SQL Server >> Server Network Utility. (This application is installed with the Server)
0
 
taru_bhargavaAuthor Commented:
what is this server box
0
 
gpompeCommented:
the machine where SQL SERVER is Running.
0
 
taru_bhargavaAuthor Commented:
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
 
gpompeCommented:
What version of SQL Server are you using ?
0
 
taru_bhargavaAuthor Commented:
7.0
0
 
gpompeCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 7
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now