SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - SQL Server 2005/Yukon
 SQL 2005 Connection Problem
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

chiragkhabaria
Flowing Fount of Yak Knowledge

India
1907 Posts

Posted - 03/01/2006 :  06:08:17  Show Profile  Visit chiragkhabaria's Homepage  Send chiragkhabaria a Yahoo! Message
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

United Kingdom
3608 Posts

Posted - 03/01/2006 :  12:40:30  Show Profile
Have you run the Surface Area Configuration to allow remote connections? If so, have you stopped and started the services?
Go to Top of Page

chiragkhabaria
Flowing Fount of Yak Knowledge

India
1907 Posts

Posted - 03/02/2006 :  02:19:51  Show Profile  Visit chiragkhabaria's Homepage  Send chiragkhabaria a Yahoo! Message
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..
Go to Top of Page

jen
Flowing Fount of Yak Knowledge

Sweden
4110 Posts

Posted - 03/02/2006 :  02:25:44  Show Profile  Send jen a Yahoo! Message
check if this helps... i know how you feel at this point...

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=62167

--------------------
keeping it simple...
Go to Top of Page

chiragkhabaria
Flowing Fount of Yak Knowledge

India
1907 Posts

Posted - 03/02/2006 :  03:41:43  Show Profile  Visit chiragkhabaria's Homepage  Send chiragkhabaria a Yahoo! Message
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..
Go to Top of Page

mr_mist
Grunnio

United Kingdom
1870 Posts

Posted - 03/02/2006 :  03:52:22  Show Profile  Visit mr_mist's Homepage
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. :)
Go to Top of Page

chiragkhabaria
Flowing Fount of Yak Knowledge

India
1907 Posts

Posted - 03/02/2006 :  04:22:38  Show Profile  Visit chiragkhabaria's Homepage  Send chiragkhabaria a Yahoo! Message
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..
Go to Top of Page

mr_mist
Grunnio

United Kingdom
1870 Posts

Posted - 03/02/2006 :  07:46:59  Show Profile  Visit mr_mist's Homepage
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. :)
Go to Top of Page

chiragkhabaria
Flowing Fount of Yak Knowledge

India
1907 Posts

Posted - 03/02/2006 :  09:25:18  Show Profile  Visit chiragkhabaria's Homepage  Send chiragkhabaria a Yahoo! Message
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..
Go to Top of Page

homebrew
Posting Yak Master

114 Posts

Posted - 03/02/2006 :  15:27:34  Show Profile
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.

Edited by - homebrew on 03/02/2006 15:29:08
Go to Top of Page

chiragkhabaria
Flowing Fount of Yak Knowledge

India
1907 Posts

Posted - 03/04/2006 :  02:17:21  Show Profile  Visit chiragkhabaria's Homepage  Send chiragkhabaria a Yahoo! Message
Yeah

Its 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.htm
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

Hope this helps you.




Sucess Comes to those who Believe in Beauty of their Dream..
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000