I was just thinking about something I've never understood completely!
mssql_connect($server, 'sa', 'PW'); presumes the server doesn't have all the permissions in spite of the fact that it has the password.
The password I gave is the XP Prof login PW.
Maybe some other PW.
--- On Mon, 12/8/08, Fred Silsbee <fredsilsbee@xxxxxxxxx> wrote:
> From: Fred Silsbee <fredsilsbee@xxxxxxxxx>
> Subject: MS SQL error...I've come a long way to get this far
> To: php-db@xxxxxxxxxxxxx
> Date: Monday, December 8, 2008, 7:13 PM
> many changes to php.ini to get this far..whew!
>
> PHP 5.2.7 just got jerked out from underneathe me (I
> have't replaced it since this is a simple script)
>
> phpinfo works!
>
> <?php
> // Server in the this format:
> <computer>\<instance name> or
> // <server>,<port> when using a non default
> port number
> $server = 'LANDON\SQLEXPRESS';
>
> $link = mssql_connect($server, 'sa', 'PW');
> <<<<< line 6
>
> if(!$link)
> {
> die('Something went wrong while connecting to
> MSSQL');
> }
> ?>
>
>
> Warning: mssql_connect() [function.mssql-connect]: Unable
> to connect to server: LANDON\SQLEXPRESS in
> C:\Inetpub\wwwroot\trymssql.php on line 6
> Something went wrong while connecting to MSSQL
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
