all groups > sql server connect > april 2006 >
You're in the

sql server connect

group:

Problems Connecting to MS SQL Server


Problems Connecting to MS SQL Server Tech Parts
4/25/2006 7:49:01 AM
sql server connect:
After a new installation of MS Enterprise SQL Server, i am unable to connect
to the database from a website, and i dont know if MS SQL is working at all.
All the startup services and SQL services are started.Here is the website
that im trying to access my SQL server:
http://www.techparts.org/scripts/install.php

The error message is: Warning: mysql_connect(): Can't connect to MySQL
server on '10.10.8.6' (10061)

Here are the logistics:

The database name is “master” and I just reset the password for “db_website”
to “database”

Username: db_website
Password: database
Database: master
Host: 10.10.8.6 (MAIN)
Website: http://www.techparts.org/scripts/install.php
Forwarded Ports: 1433 and 3306 to 10.10.8.6
Firewall: No firewall on server or router
Software: MS SQL enterprise server, PHP, and SBS 2003
Permissions: db_website has full permissions to the master database
Authentication: db_website has full permissions to root and subfolders for
the website.

Is there something that im missing on the intial setup of SQL, and why cant
i login?
Re: Problems Connecting to MS SQL Server Roger Wolter[MSFT]
4/25/2006 10:13:22 AM
I assume what you're doing is trying to connect to SQL Server from PHP?
Chances are the connection string will be different for SQL Server than it
is for mySQL so you may want to look at the connection string that is
actually used for the connection to see if it follows the SQL Server
conventions. ODBC queries are pretty standard but the connections string
aren't always. There may be information on the PHP site on how to do this -
or maybe someone here has done it successfully.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

[quoted text, click to view]

Re: Problems Connecting to MS SQL Server Sue Hoegemeier
4/25/2006 11:05:02 AM
You are trying to connect to MySQL. I'm not sure what
exactly you installed but it looks like you are confusing
Microsoft SQL Server and MySQL. They are two different
products.
For MySQL questions, try posting to:
comp.databases.mysql

-Sue

On Tue, 25 Apr 2006 07:49:01 -0700, Tech Parts
[quoted text, click to view]
Re: Problems Connecting to MS SQL Server Nathan H. Omukwenyi
4/26/2006 12:00:00 AM
Hi,

After this is over, you may want to change the password to the database and
never give it out again in a public newsgroup.

Nathan H. Omukwenyi

[quoted text, click to view]

AddThis Social Bookmark Button