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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

Date: Thu, 11 Nov 2004 08:32:02 -0600

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?
>> >
>> >
>>
>>
>
>

Relevant Pages

  • Multipart connectionstring question
    ... I’ve got an asp.net site that contains an access database. ... running the same app both on my machine and my host without making changes. ... How could one even use a server.mappath with a database connection string? ...
    (microsoft.public.dotnet.general)
  • Installer - Custom Textboxes in UI problem
    ... void Install function. ... I've tested it by writing the string out to a text file ... put the connection string and I intend to test the db connectivity and write ... throw new InstallException("The database conection information is not ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Accessing mdb file via VB code
    ... None of the previous installs re-registers etc worked but I got it fixed ... If any of you know why my string would not work, ... You need a connection string like: ... Some people report it as happening to an entire new suite of boxes. ...
    (microsoft.public.vb.general.discussion)
  • Re: EXEC master..xp_cmdshell Prevention
    ... way to significantly reduce vulnerabilities around dynamic string execution. ... > I found that my web application did use a connection string in a file ... I have created a new login account ...
    (microsoft.public.sqlserver.security)
  • Re: EXEC master..xp_cmdshell Prevention
    ... I take it you're using string concatenation to build your sql statements. ... Next item -- using dbo for a web application's login is dangerous, ... sounds as though either a) your connection string isn't what you think it is ...
    (microsoft.public.sqlserver.security)