Showing posts with label attempting. Show all posts
Showing posts with label attempting. Show all posts

Tuesday, February 14, 2012

Connecting to SQL2005 Developer edition

I'm attempting to connect to and instance of SQL and cannot seam to find it. The server logs says its listening on '127.0.0.1 <ipx4> 1545'.

Kind of stuck what to check next. Will using pipes help? What do I need to do?

Hi,

check if the port listening or not using command prompt as:

netstat -an | find "YOUR PORT NUMBER"

for exampl, my SQL Server is listening to port 1433:

netstat -an | find "1433"

if it's working you'll find that the port is listening to local machine in TCP otherwise maybe there is a problem, you can check the Event Viewer to trace it

Connecting to SQL2000 using DNS Alias/Named Pipes

Hi,
I have a very confusing issue.
I am attempting to connect to a SQL2000 server using Named Pipes and a
DNS Alias without success. I get the sql server does not exist or
access is denied error. I can successfully connect using TCPIP
sockets however.
If I connect to the server using it's own servername I can connect
using Named Pipes or TCPIP sockets.
Any ideas?
Named pipes does not use DNS so a DNS alias will not work with named pipes.
Named pipes uses a broadcast of the NetBios name. Since TCP/IP uses DNS the
connection works.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||rboyd@.onlinemicrosoft.com (Rand Boyd [MSFT]) wrote in message news:<xEV$7$j0EHA.3152@.cpmsftngxa10.phx.gbl>...
> Named pipes does not use DNS so a DNS alias will not work with named pipes.
> Named pipes uses a broadcast of the NetBios name. Since TCP/IP uses DNS the
> connection works.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
Rand
I now have this working after using the DisableStrictNameChecking fix.
I can now use the DNA Alias for the SQL server ver named pipes.

Connecting to SQL2000 using DNS Alias/Named Pipes

Hi,
I have a very confusing issue.
I am attempting to connect to a SQL2000 server using Named Pipes and a
DNS Alias without success. I get the sql server does not exist or
access is denied error. I can successfully connect using TCPIP
sockets however.
If I connect to the server using it's own servername I can connect
using Named Pipes or TCPIP sockets.
Any ideas'Named pipes does not use DNS so a DNS alias will not work with named pipes.
Named pipes uses a broadcast of the NetBios name. Since TCP/IP uses DNS the
connection works.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||rboyd@.onlinemicrosoft.com (Rand Boyd [MSFT]) wrote in message news:<xEV$7$j0EHA.3152@.cpmsftngxa10.phx.gbl>...
> Named pipes does not use DNS so a DNS alias will not work with named pipes.
> Named pipes uses a broadcast of the NetBios name. Since TCP/IP uses DNS the
> connection works.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
Rand
I now have this working after using the DisableStrictNameChecking fix.
I can now use the DNA Alias for the SQL server ver named pipes.

Connecting to SQL2000 using DNS Alias/Named Pipes

Hi,
I have a very confusing issue.
I am attempting to connect to a SQL2000 server using Named Pipes and a
DNS Alias without success. I get the sql server does not exist or
access is denied error. I can successfully connect using TCPIP
sockets however.
If I connect to the server using it's own servername I can connect
using Named Pipes or TCPIP sockets.
Any ideas'Named pipes does not use DNS so a DNS alias will not work with named pipes.
Named pipes uses a broadcast of the NetBios name. Since TCP/IP uses DNS the
connection works.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||rboyd@.onlinemicrosoft.com (Rand Boyd [MSFT]) wrote in message news:<xEV$7$j0EHA.3152@.cpm
sftngxa10.phx.gbl>...
> Named pipes does not use DNS so a DNS alias will not work with named pipes
.
> Named pipes uses a broadcast of the NetBios name. Since TCP/IP uses DNS th
e
> connection works.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
Rand
I now have this working after using the DisableStrictNameChecking fix.
I can now use the DNA Alias for the SQL server ver named pipes.

Sunday, February 12, 2012

connecting to SQL Server with PHP issue

Hi all,

I've tried googling this.

I'm attempting to connect to a DB on SQL Server on a MS 2003 server box. The DB is for a different application that the office uses, and I'm not the owner of it. I'm attempting to connect without making any changes to the server side of things.

The sql server I'm attempting to connect to is set up with: "with Windows NT Authentication using the Network Login ID"

On my Linux box in PHP, I've tried using a valid Network Login ID and it's not working. I can connect to other data sources that use other login types on the same box.

I can from other boxes use MS Access and connect to the data.

Is there something special I need to do in PHP to connect to the DB?

here's some of my php code:

$con = mssql_connect('192.168.111.2', 'xxxxxxx', 'yyyyyyy');
$result = mssql_query ('select * from policyregister');
while ($row=mssql_fetch_array($result))
{ print $row[1]; }
mssql_close($numero);I think you are going to need to use SQL Server authentication for web apps. When I code ASP that is how I always do it. Which means the SQL Server might have to changed to mixed mode. Windows Authentication may not work off of the LAN. I am not 100% on this.

Hi all,

I've tried googling this.

I'm attempting to connect to a DB on SQL Server on a MS 2003 server box. The DB is for a different application that the office uses, and I'm not the owner of it. I'm attempting to connect without making any changes to the server side of things.

The sql server I'm attempting to connect to is set up with: "with Windows NT Authentication using the Network Login ID"

On my Linux box in PHP, I've tried using a valid Network Login ID and it's not working. I can connect to other data sources that use other login types on the same box.

I can from other boxes use MS Access and connect to the data.

Is there something special I need to do in PHP to connect to the DB?

here's some of my php code:

$con = mssql_connect('192.168.111.2', 'xxxxxxx', 'yyyyyyy');
$result = mssql_query ('select * from policyregister');
while ($row=mssql_fetch_array($result))
{ print $row[1]; }
mssql_close($numero);|||ahhh OK. thanks. I have a windows program that works that does a "backup" of the sql server data to mysql. Maybe I just cron job that to run once a minute since my data isnt that critical. :)

I didnt see any stuff on for PHP on SQL Server authentication for web apps.

thanks. you confirmed what I was dreading. heheh