Re: Not able to add DB into Data Source catalog for some reason (REPOST)

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: John Jansen \(MSFT\) (johnjan_at_online.microsoft.com)
Date: 08/24/04


Date: Tue, 24 Aug 2004 10:05:54 -0700

Seriously, Mike? I had no idea that they would see a reply from me and then
not respond.

If you are using SQL auth and putting in the correct username and password,
something else is going on, so yeah, repost here.

-- 
Thanks!
John Jansen
Microsoft Office FrontPage
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mike Walsh" <englantilainen@hotmail.com> wrote in message 
news:OxgGksHhEHA.3980@TK2MSFTNGP12.phx.gbl...
>I can assure you this newsgroup is being managed by someone (unsure whether
> it's the TechNet managed newsgroups or the MSDN managed newsgroups or 
> both).
>
> Just find some of the long running threads where "research" is offered
> (usually by someone with a Chinese name) and/or where one person is taking
> an incredible amount of time to try to answer usually a very difficult and
> rare question and you can see such threads.
>
> John Jansen has unfortunately now answered this thread and thus none of 
> the
> official managed newsgroup guys will feel the need to do so any more.
>
> Try again ?
>
> Mike Walsh, Helsinki, Finland
> WSS FAQ at http://wss.collutions.com
> Please reply to the newsgroup
>
> "MDS_Work" <mds_work@newsgroup.nospam> wrote in message
> news:#ONE1MHhEHA.704@TK2MSFTNGP12.phx.gbl...
>> No, I'm not using Windows Auth (that would create the double-hop issue), 
>> I
>> specifying a username and password, I've tried using domain accounts with
>> rights and SQL accounts with rights... both of these worked on my test
>> machine.
>>
>>
>>
>> About replies from MS; on MSDN, there is a setup to get a e-mail account
>> that is supposed to be monitored for by Microsoft, the MSDN site states
> that
>> Microsoft WILL answer questions when posting using the e-mail address
> within
>> two business days; see http://msdn.microsoft.com/newsgroups/managed/ ....
>> are you saying that this newsgroup is not being managed in the manner
>> described by MSDN? Am I not really getting "Unlimited Free PSS Support 
>> for
>> Technical Issues"????
>>
>>
>>
>> "John Jansen (MSFT)" <johnjan@online.microsoft.com> wrote in message
>> news:uBx23CHhEHA.3916@TK2MSFTNGP11.phx.gbl...
>> > Hey there,
>> >
>> > The way that I use the newsgroups is actually unaffected by what 
>> > account
>> you
>> > use to submit your question.  I just bounce around from subject to
> subject
>> > to see if I can help.  Which means (obviously) I miss a lot of posts.
>> >
>> > The first thing that jumps out at me is that you say "I'm using
> specified
>> > username/pass (so not a double-hop issue)".  Are you using Windows auth
> on
>> > the SQL server?  If so, you should try using SQL authentication and
> create
>> a
>> > new user to use.
>> >
>> > -- 
>> > Thanks!
>> > John Jansen
>> > Microsoft Office FrontPage
>> > This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> > "MDS_Work" <mds_work@newsgroup.nospam> wrote in message
>> > news:%23r4TUqGhEHA.3476@tk2msftngp13.phx.gbl...
>> > >I am reposting this question under my MSDN managed account in hopes of
> a
>> > > reply from MS, if you don't have a real answer please don't respond 
>> > > so
>> MS
>> > > does. Thanks
>> > >
>> > > am unable to add a SQL Database connection into my data source
> catalog,
>> > > -I'm using specified username/pass (so not a double-hop issue).
>> > > -The servers are in a NLB farm and I've tried connecting to each
>> > > individual
>> > > node and adding
>> > > - I've tried adding the data source while on the server
>> > > - I've loaded the SQL client tools on the server and verified the
>> > > connection
>> > > from the server is possible,
>> > > - I can create Web Services data source connections,
>> > > - I have another isolated environment with WSS I use for testing and 
>> > > I
>> can
>> > > add sql datasources here with no problem...
>> > > - I've hand copied and modified the code from the working server to
> the
>> > > non-working farm, and simply get an error that the datasource cannot
> be
>> > > contacts
>> > >
>> > > ideas anyone? any thoughts would be appreciated this just doesn't 
>> > > make
>> > > sense...
>> > >
>> > >
>> > >
>> >
>> >
>>
>>
>
> 


Relevant Pages

  • Re: ASP rsObj doing unwanted trimming from SQL Server
    ... > am doing a simple test to return the value of a "Name" comumn in a SQL ... don't use the sa account for your application code. ... future version of sql server, ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Problems with SQL MSDE after SBS SP1 upgrade!
    ... Thanks for updates. ... This newsgroup only focuses on SBS technical issues. ... | Subject: Re: Problems with SQL MSDE after SBS SP1 upgrade! ...
    (microsoft.public.windows.server.sbs)
  • Re: sql problem
    ... Account # is the link field on ... The requirement is I have to come up with a report comparing the two ... customer tables to see if they are in sync. ... what I wanted to do was to get the SQL to return the "like" names ...
    (comp.databases.oracle.server)
  • RE: NOLOCK due to data movement
    ... It is unfortunate that you do not understand that this is an SBS problem. ... The default instance of SQL 2005 is working fine. ... Please understanding our newsgroup is mainly focused on SBS support. ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: sql problem
    ... Account # is the link field on ... table1, table2@dblink where ....) ... customer tables to see if they are in sync. ... what I wanted to do was to get the SQL to return the "like" names ...
    (comp.databases.oracle.server)