Groups | Blog | Home
all groups > sql server clients > january 2004 >

sql server clients : Connection could not be established in accessing SQL Server from Client Computer


Lans
1/29/2004 1:26:11 AM
Hi All

I have installed a SQL Server Client Standard Edition. I am trying to establish a connection using the Enterprise Manager in accessing the SQL Servers of our company. The error message that was displayed is

A Connection could not be established to <server name>
Reason: Invalid attribute/option identifier

Its very urgent

I will appreciate your email response. Thanks
Wei Ci Zhou
1/29/2004 6:09:13 PM
Hi:
I guess it is because that you can not get the sqlserver by server name.
If you have the IP of the sever in your in company, you should try
telnet IP(the value is the sever IP) 1433 to try it you can connect to
it
If it work then register a new server with the IP, then it may work.
Best Wishes
Wei Ci Zhou

rboyd NO[at]SPAM onlinemicrosoft.com
1/29/2004 7:04:08 PM
This error can occur because of a MDAC file mismatch. Since you have
already applied the SQL Server utilities, I would apply SQL Server 2000
Service Pack 3a to you client machine. This might alleviate the problem.

Rand
This posting is provided "as is" with no warranties and confers no rights.
rhaslam
2/1/2004 9:41:07 PM
AddThis Social Bookmark Button