Re: sql server management studio

2007-08-02 Thread Dinner
On 8/1/07, Jim Davis <[EMAIL PROTECTED]> wrote: > I see one problem - you shouldn't be using name pipes as the protocol for > CrystalTech - use TCP/IP instead. The default port (1433) should be fine. Yup, I that's it. IIRC it defaults to named pipes. For me, if I click on the "Advanced" bu

Re: sql server management studio

2007-08-02 Thread Dana
sionsconsulting.net > > -Original Message- > From: Dana [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 01, 2007 9:15 PM > To: CF-Community > Subject: Re: sql server management studio > > ok

RE: sql server management studio

2007-08-02 Thread Shawna Hampton
E. Hampton r(E)-Visions Consulting www.revisionsconsulting.net -Original Message- From: Dana [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 01, 2007 9:15 PM To: CF-Community Subject: Re: sql server management studio ok well. Where it says Server Name I am putting the ip address of the Cry

RE: sql server management studio

2007-08-01 Thread Jim Davis
> -Original Message- > From: Dana [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 01, 2007 10:15 PM > To: CF-Community > Subject: Re: sql server management studio > > ok well. Where it says Server Name I am putting the ip address of the > Crystaltech server.

Re: sql server management studio

2007-08-01 Thread Dana
ok well. Where it says Server Name I am putting the ip address of the Crystaltech server. I am choosing SQL Server authentication because the password over there is different than the one here on my desktop. Server Type is Database Eng but it's greyed out. Maybe firewall? The message sounds to me

Re: sql server management studio

2007-08-01 Thread Dinner
On 8/1/07, Dana Tierney wrote: > no :) I'm sure I don't. Where do I enter it? For me, it asks for the info right when I fire it up. Server Type: Database Eng Server Name: (this is where you'd put the DNS name or IP addy) Authentication: (probably SQL Server Auth ;) Login: Password: Clicking "adv

Re: sql server management studio

2007-08-01 Thread Dana Tierney
no :) I'm sure I don't. Where do I enter it? >appears. Are you sure you've got the right connection info entered? > > >> ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today C

Re: sql server management studio

2007-08-01 Thread Dana
Ah. So much for Crystaltech's customer support. Thanks for straightening me out. On 8/1/07, Robert Munn <[EMAIL PROTECTED]> wrote: > Not in SQL Server Management Studio Express. There is a separate tool called > SQL Server Configuration Manager where you can change your client > network/protocol s

Re: sql server management studio

2007-08-01 Thread Dinner
Are you connecting to your local box? Thats usually when that message appears. Are you sure you've got the right connection info entered? On 8/1/07, Dana wrote: > ok boys and girls -- I want to connect to my crystaltech account using > this tool. Crystaltech says this should work. I am getting a

Re: sql server management studio

2007-08-01 Thread Robert Munn
Not in SQL Server Management Studio Express. There is a separate tool called SQL Server Configuration Manager where you can change your client network/protocol settings. Make sure you have TCP/IP enabled and that the port settings match the server's port settings. On 8/1/07, Dana wrote: > > ok bo