| Author |
Topic |
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
 Posted - 2006-03-01 : 06:08:17
|
| Hi All, I hope all of you must be doing good. On my server there are 2 instances of SQL, one is SQL 2000 and just few days back i installed SQL 2005 with the Instance Name as (SQL2005).Then I installed the SQL 2005 client on my local, but i m not able to access the SQL 2005. Its gives me error Server does not Exists. In the Server Box i typed Server/SQl2005 which is recommanded by the Microsoft if you 2 instances on one machine. And also when i am trying to make the ODBC to SQL 2005 instance, i m getting the same error "Server does not Exists"I enabled all the protocols on the clients as well on server. Any Clue if there is any other setting which are required ??Thanks for any kind of help. Sucess Comes to those who Believe in Beauty of their Dream.. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-03-01 : 12:40:30
|
| Have you run the Surface Area Configuration to allow remote connections? If so, have you stopped and started the services? |
 |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-03-02 : 02:19:51
|
| yeah..i have enable the Remote Connection, TCP/IP protocol.. But still no Luck..Any other clue.Sucess Comes to those who Believe in Beauty of their Dream.. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-03-02 : 03:41:43
|
| The link which mike gave you, i guess its disable, i am not able to access the same :-(. And i have installed Developer Edition, so does this make any difference?Sucess Comes to those who Believe in Beauty of their Dream.. |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-03-02 : 03:52:22
|
| Is the service running?Can you access it locally?Have you enabled the sql browser service? (If not you may need to use IP address)Are you using the SSMS rather than any older client tools to connect?-------Moo. :) |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-03-02 : 04:22:38
|
quote:
Originally posted by mr_mist
Is the service running?quote:
Which Service, SQL Server is running on the machine with the instance name as SQL2005
Can you access it locally? quote:
Yeah i can access it locally, from the server using SSMS by inputting Server/SQl2005
Have you enabled the sql browser service? (If not you may need to use IP address)No SQLBrowser Service is not running on machine, IP Address mean like 10.10.0.27/SQL2005??? Are you using the SSMS rather than any older client tools to connect?I Am using Client SSMS for connecting.. to the server.Infact i also tried from ODBC, but still no luck..:-( -------Moo. :)
Sucess Comes to those who Believe in Beauty of their Dream.. |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-03-02 : 07:46:59
|
quote:
No SQLBrowser Service is not running on machine, IP Address mean like 10.10.0.27/SQL2005???
Yep. Try that, or start sql browser.-------Moo. :) |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-03-02 : 09:25:18
|
| Thanks All of you who posted here and helped me.. :-)The following things, I did for making my remote connection with the SQl 2005. 1) I Unistall all the SQL 2005. 2)Rebooted my Server(Though got lots of hearing from other developers :-( but in the end it was worth :-))3) Installed the Fresh copy of the SQL 2005 Developer edition with all the components mentioned.4) Again Reboted :-)5) Then in the Surface area configuration enabled the Remote connection with TCP/IP. 6) Then in the SQL Server Configuration Manager I Enabled TCP/IP.7) Using my client SQl Server Mgt Stdio i tried to login and it worked for me.Now i am able to access, it via Query Analyser of 2000, ODBC.Thanks once again for all ur help.. Sucess Comes to those who Believe in Beauty of their Dream.. |
|
|
|
homebrew
Posting Yak Master
114 Posts |
Posted - 2006-03-02 : 15:27:34
|
| Is SSIS supposed to have a "Remote Connection" option in the Surface Area Config section ?? (I don't have see Remote Connection for SSIS) I can't get to SSIS remotely, but the other apps are fine remotely. |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-03-04 : 02:17:21
|
| YeahIts there in SQL Server Surface configuration. you have to enable it so that you can connect to the server remotely using the client tools. here are some of the links which were helpful to me when things were not working for me. http://www.datamasker.com/SSE2005_NetworkCfg.htmhttp://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspxHope this helps you. Sucess Comes to those who Believe in Beauty of their Dream.. |
|
|
|
|
SQL 2005 Connection Problem