Re: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

From: Scott Ivey (sivey_at_online.nospam)
Date: 11/09/04 

Date: Tue, 9 Nov 2004 14:24:36 -0600

The strange thing about it all is that when I copy the entire web directory,
including any connection strings, back to my win2000 server, everything
works fine - no errors ever.

Scott

"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:ucjAStoxEHA.3224@TK2MSFTNGP14.phx.gbl...
> Have you tried connecting with a different user name? And/or using the
> shorter server name (not sure what you're gaining from
> revsql01.revonet.local, unless you're trying to practice your typing
> skills)? And/or using the IP address in the connection string?
>
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
>
>
> "Scott Ivey" <sivey@online.nospam> wrote in message
> news:et8K4ooxEHA.2676@TK2MSFTNGP12.phx.gbl...
>> I haven't changed anything from the default, so yes.
>>
>> Scott
>>
>> "Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
>> news:u1$tSmoxEHA.3376@TK2MSFTNGP12.phx.gbl...
>> >> revsql01 - TCP/IP - pointed to the SQL IP address, dynamic port number
>> >> revsql01.revonet.local - TCP/IP - pointed to the SQL IP address,
> dynamic
>> >> port number
>> >>
>> >> My connect string is "Provider=SQLOLEDB;Data
>> >> Source=revsql01.revonet.local;Initial Catalog=RPM;User
>> >> ID=rpmuser;Password=xxxxx"
>> >
>> > Is it running on port 1433, or another port?
>> >
>> >
>>
>>
>
>

Relevant Pages
Loading