[cfaussie] Re: adding a dsn connectio with SQL 2005

Mon, 20 Mar 2006 00:33:03 -0800

I had to install the 7.0.1 updater to get it working on my server

On 3/20/06, Mike Kear <[EMAIL PROTECTED]> wrote:
Try Start > All Programs > Microsoft SQLServer 2005 > Configuration tools > SQL Server Configuration Manager
 
In that tool open SQL Native CLient Configuratoin > Aliases. 
 
There you'll see all teh different aliases you've set up for the connections you mak.  In the Parameters column, is normally nothing, but if you bdouble-click in it , you get a dialog box that sets the parameters for that alias.    The port field is normally blank for the default, which is to dynamically allocate ports.  But you can specify a port there and it'll always try to use that.
 
Disclaimer:   every time i do anything with a Microsoft product, the bit i'm looking for never seems to be where it was last time I looked, so this might be the same.  YMMV
 
HTH


Cheers
Mike Kear
Windsor, NSW, Australia
Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
 
 
 
On 3/20/06, Carl Vanderpal < [EMAIL PROTECTED]> wrote:
Yes I know where it is in CFMX admin, but the new SQL panel..is there a way to find it there..

:)



--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "cfaussie" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---

Reply via email to