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

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

Date: Thu, 11 Nov 2004 09:41:15 -0600

I've tried that, but it didn't help. I've also used the Client Network
Utility to force TCP/IP, but that didn't help either.

Scott

"Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
news:OQ18XHAyEHA.2200@TK2MSFTNGP09.phx.gbl...
> You should try forcing TCP/IP to be used with the Network Library
> attribute in your connection string.:
>
> Network Library=DBMSSOCN;"
>
> Bob Barrows
>
> Scott Ivey wrote:
>> I changed the connect string to use the IP address - and still get the
>> errors. I don't get it - this just should not be happening. New
>> connect string is...
>>
>> "Provider=SQLOLEDB;Data Source=192.168.200.40;Initial Catalog=RPM;User
>> ID=rpmuser;Password=xxxxx"
>>
>>
>> MS - are you watching this post??? I'm posting with my MSDN alias -
>> and we're now at the deadline for resolution for my MSDN Managed
>> Newsgroup support. I had opened a support incident before posting
>> this, but had opened it with the Cluster group (since the website is
>> on 2 servers running NLBS), and they were unable to help me, so I
>> cancelled the ticket. Anyone have any ideas on which group should
>> handle this?
>>
>> Thanks,
>> 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?
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>

Relevant Pages
Loading