Re: Server Does Not Exist or Access Denied error

Im still looking for assistance on this matter which was posted in another
thread of same title. My latest discovery is as follows:

I have just worked out that I the machine that I can connect to has no SQL
Server service pack installed and the one that I cannot connect to from my
application has SP2 installed

Would this be cause of problem?



"Terry Holland" <terryeholland@xxxxxxxxxxxxxxxx> wrote in message
news:eqdyUafuFHA.2920@xxxxxxxxxxxxxxxxxxxxxxx
> As a test I have recreated the database on another pc and tried the same
> test. My new connection string is
> Password=123456;User ID=SA;Initial Catalog=CSA;Data Source=SGB007000
>
> When I run application on my machine and try to connect to this remote
> server, the connection is opened with no problem.
>
> Both remote machines are running win xp sp2. Im not sure what SQL Server
> service packs are installed on each of the remote servers as I am not sure
> how to tell
>
>
> "Terry Holland" <terryeholland@xxxxxxxxxxxxxxxx> wrote in message
> news:%23ON5HseuFHA.3236@xxxxxxxxxxxxxxxxxxxxxxx
> > I have modified the sa logon so that password is 123456
> > I have created a udl file pointing to remote server. The connection
> string
> > in this is:
> > Provider=SQLOLEDB.1;Password=123456;Persist Security Info=True;User
> > ID=SA;Initial Catalog=CSA;Data Source=SGB008940
> > When I click Test Connection button, the trace indicates a successful
> Audit
> > Login entry.
> >
> > I use the same connection string (without provider part) in my
application
> > and attempt to connect. I get the "SQL Server does not exist or access
> > denied" error in the application and nothing appeard in the trace to
> > indicate a login attempt (no activity in trace at all)
> >
> > Terry Holland
> >
> >
> >
> > "Kevin Yu [MSFT]" <v-kevy@xxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:WjWWjsNuFHA.932@xxxxxxxxxxxxxxxxxxxxxxxx
> > > Hi Terry,
> > >
> > > It seems that in the connection string, you didn't specify the
password
> > > field. Did you just ignored it or hid it for security purpose?
> > >
> > > If you just hid it, I suggest you add it in your app, and use SQL
> profiler
> > > to do a trace. You start the trace, run your app to reproduce the
> problem
> > > and stop the trace. In the trace log, you will see if the app has
> > connected
> > > to the server and what username it is using.
> > >
> > > Kevin Yu
> > > =======
> > > "This posting is provided "AS IS" with no warranties, and confers no
> > > rights."
> > >
> >
> >
>
>



.