Friday, February 24, 2012

Connection error

Hi All
when i try to register an instance of SQL server sometimes it's registered
successfully and sometimes not, giving me the error SQL server Error:17 SQL
server does not exist or access denied.
I installed service pack 3 and i still get error.
Also when i try to add a Data source, i can do it successfully using named
pipes as the network protocol but it fails with TCP/IP.
Thanks for your helpprobably is ur network having probs. check if u can telenet to port 1433. if u can't, check ur network settings, if u still can't telenet, try restart ur syste
-- Nader Galal wrote: --
Hi Al
when i try to register an instance of SQL server sometimes it's registere
successfully and sometimes not, giving me the error SQL server Error:17 SQ
server does not exist or access denied
I installed service pack 3 and i still get error
Also when i try to add a Data source, i can do it successfully using name
pipes as the network protocol but it fails with TCP/IP
Thanks for your hel|||You must have appropriate information to connect to the server, (name or IP,
and port number)...
The server must be listening on the same network protocol that the client is
trying to connect with ( server network utility, and client network
utility).
Lastly you must register the server with a login that is a valid SQL server
login for the server.
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Nader Galal" <ngalal@.hotmail.com> wrote in message
news:uKag%23agyDHA.2720@.TK2MSFTNGP09.phx.gbl...
> Hi All
> when i try to register an instance of SQL server sometimes it's registered
> successfully and sometimes not, giving me the error SQL server Error:17
SQL
> server does not exist or access denied.
> I installed service pack 3 and i still get error.
> Also when i try to add a Data source, i can do it successfully using named
> pipes as the network protocol but it fails with TCP/IP.
> Thanks for your help
>
>

No comments:

Post a Comment