sql server management studio on client PC | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

sql server management studio on client PC

Hi – I installed sql server management studio (enterprise addition) on my PC but cannot connect to any sql server 2005 . meanwhile using the very same sql server management studio I can easily connect to all my sql 2000 servers. do I do something wrong ?
this error appears when I try to connect to sql 2005: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 – No connection could be made because the target machine actively refused it.) (.Net SqlClient Data Provider)
What is the error you are getting? Make sure you enabled remote connections on the sql server 2005 servers you are connecting…
If you are connecting named instances try passing port number along with instance name… ex: Servernameintname,portnumber
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

HI,
If you haven’t configure your box for remote connection referhttp://support.microsoft.com/kb/914277 and as Mohammed suggested give your instance name too while connecting. Hemantgiri S. Goswami
MS SQL Server MVP
————————-
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami http://hemantgirisgoswami.blogspot.com
I made it working: went to sql 2000 client Network utility on my PC, found those sql 2005 servers in a list of aliases, checked "dynamically determine port" instead of specifing port =1443 and successfully registered servers.
And you can reach all 2000 also?
Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided “AS IS” with no warranties for accuracy.
If it is a SQL Express edition then by default it will be set to dynamic port settings.
http://support.microsoft.com/kb/823938 fyi Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>