July 14, 2008 at 2:25 am
i got the following error message when i trying to connect to another pc sql server.
"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"
any help please? i tried the following link: http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277, but yet still cannot 🙁
July 14, 2008 at 3:51 am
Have you enabled remote connections?
On the machine you can't connect to, run the surface area config and check that remote connections have been enabled.
When you run the Surface area config, select the option 'for services and connections', go to remote connections and make sure that it's set for remote connections.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 14, 2008 at 4:02 am
yes, I already set the Remote Connections to "Local and remote connections -> Using both TCP/IP and named pipes"
July 14, 2008 at 4:04 am
Is the SQL service running on that machine?
Have a look in the server's error log, see if there's anything in there of interest.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 14, 2008 at 4:18 am
GilaMonster (7/14/2008)
Is the SQL service running on that machine?Have a look in the server's error log, see if there's anything in there of interest.
yes, sql server & sql browser are running.
below are part of the log file:
2008-07-14 16:57:31.65 Server Server is listening on [ 'any' 49222].
2008-07-14 16:57:31.65 Server Server is listening on [ 'any' 49222].
2008-07-14 16:57:31.65 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MAININSTANCE ].
2008-07-14 16:57:31.65 Server Server named pipe provider is ready to accept connection on [ \\.\pipe\MSSQL$MAININSTANCE\sql\query ].
2008-07-14 16:57:31.65 Server Server is listening on [ ::1 49223].
2008-07-14 16:57:31.65 Server Server is listening on [ 127.0.0.1 49223].
2008-07-14 16:57:31.65 Server Dedicated admin connection support was established for listening locally on port 49223.
2008-07-14 16:57:31.67 Server The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
2008-07-14 16:57:31.67 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply