Jump to content

Remote Connection "Network Issues"?¿? SQL Server 2008


powpow

Recommended Posts

Hello Freaks!

 

I am having issues connecting to a virtual Windows SQL 2008 Server which is on our network.  My PC can currently connect to the server through an ODBC connection.  However, the ODBC connection is authenticated "with Windows NT authentication using the network login ID". 

 

If I try to authenticate "with SQL server authentication using a login ID and password entered by the user" it fails as follows:

 

See attachment

 

I have tried to make a connection through a php application that connects via odbc connection basically piggy-backing this connection; however I keep getting failure messages:

 

function.odbc-connect</a>]: SQL error: [Microsoft][ODBC SQL Server Driver][sql Server]Login failed for user '[machine name]'., SQL state 28000 in SQLConnect in C:\xampp\htdocs\test\sqlsrv.php on line 2

 

the user for this error code is my actual machine name. 

 

After the odbc connection fail I set up a sqlserv_connect and tried connecting with my user name as well as leaving it blank to see what happened:

 

 

[23-Jan-2012 17:40:37] sqlsrv_connect: entering

[23-Jan-2012 17:40:37] sqlsrv_connect: SQLSTATE = 28000

[23-Jan-2012 17:40:37] sqlsrv_connect: error code = 18456

[23-Jan-2012 17:40:37] sqlsrv_connect: message = [Microsoft][sql Server Native Client 10.0][sql Server]Login failed for user 'rpowell'.

[23-Jan-2012 17:40:38] sqlsrv_connect: SQLSTATE = 28000

[23-Jan-2012 17:40:38] sqlsrv_connect: error code = 18456

[23-Jan-2012 17:40:38] sqlsrv_connect: message = [Microsoft][sql Server Native Client 10.0][sql Server]Login failed for user '[mylogin]'.

[23-Jan-2012 17:40:38] sqlsrv_errors: entering

[23-Jan-2012 17:40:38] PHP_RSHUTDOWN for php_sqlsrv: entering

[23-Jan-2012 17:46:47] PHP_RINIT for php_sqlsrv: entering

[23-Jan-2012 17:46:47] sqlsrv.WarningsReturnAsErrors = On

[23-Jan-2012 17:46:47] sqlsrv.LogSeverity = -1

[23-Jan-2012 17:46:47] sqlsrv.LogSubsystems = -1

[23-Jan-2012 17:46:47] sqlsrv_connect: entering

[23-Jan-2012 17:46:47] sqlsrv_connect: SQLSTATE = 28000

[23-Jan-2012 17:46:47] sqlsrv_connect: error code = 18456

[23-Jan-2012 17:46:47] sqlsrv_connect: message = [Microsoft][sql Server Native Client 10.0][sql Server]Login failed for user '[machine-name]'.

[23-Jan-2012 17:46:47] sqlsrv_connect: SQLSTATE = 28000

[23-Jan-2012 17:46:47] sqlsrv_connect: error code = 18456

[23-Jan-2012 17:46:47] sqlsrv_connect: message = [Microsoft][sql Server Native Client 10.0][sql Server]Login failed for user '[machine-name]'.

 

 

Now to me this is a networking issue, some how the connection cannot resolve because of the NT authentication process.  I was hoping some far superior developer had already figured a work around for this and felt like sharing :D.

Any thoughts would be greatly appreciated.

post-103899-13482403196549_thumb.png

Link to comment
Share on other sites

  • 2 weeks later...

The error shown in your attached image would lead me to believe that your server instance is not accepting connections over TCP/IP.  You should check the server configuration to see if it is allowing tcp/ip.  As a quick check you could look at the output of the netstat -nap tcp command and see if there is anything listening on port 1433.

 

As for your login failure, make sure the username and password are correct of course, and make sure they have been setup in the server's security settings for a DB.

 

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.