Re: Simple(?) Question...

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: William Ryan eMVP (dotnetguru_at_comcast.nospam.net)
Date: 05/04/04 

Date: Tue, 4 May 2004 14:11:10 -0400

And you've verified that the account you are trying to connect with in your
connectionstring has all the permissions right? Often, it will work b/c you
as a user are authenticated, but your connectionstring will specify Trusted
Connection = true or SSPI and that will account for the difference when you
try to run on a web server.
"Wardeaux" <wardeaux@bellsouth.net> wrote in message
news:eveA0lfMEHA.892@TK2MSFTNGP09.phx.gbl...
> Mixed-mode...
> Hmmm.... I can connect fine from the webserver when MSDE is loaded on the
> webserver, and I can connect from my workstation to my MSDE on my
> workstation, but can't connect server to workstation or workstation to
> server... (server is Win2K3 and workstation is WinXPPro) any clue which
> permission is not set correctly? ;)
> M,MTIA
> wardeaux
> "William Ryan eMVP" <dotnetguru@comcast.nospam.net> wrote in message
> news:%23Z4aCafMEHA.3012@tk2msftngp13.phx.gbl...
> > I doesn't have ot be on the web server, it's a real client/server db.
> It's
> > a permissions thing almost for sure. Are you using trusted connection
or
> > mixed mode authentication?
> > "Wardeaux" <wardeaux@bellsouth.net> wrote in message
> > news:uyTp2AfMEHA.268@TK2MSFTNGP11.phx.gbl...
> > > William,
> > > thanks for the reply! Does the MSDE have to be installed on the
> > > Webserver? I've installed it on my workstation, and I can't connect
to
> it
> > > from anywhere except from my workstation? Or is this likely just a
> > > permissions thing? The error says "can't find server or access
> > denied."...
> > > ANy clues?
> > > thanks!
> > > wardeaux
> > > "William Ryan eMVP" <dotnetguru@comcast.nospam.net> wrote in message
> > > news:eqFc8QeMEHA.268@TK2MSFTNGP11.phx.gbl...
> > > > Comments below:
> > > > "Wardeaux" <wardeaux@bellsouth.net> wrote in message
> > > > news:#Nuk0CeMEHA.1556@TK2MSFTNGP10.phx.gbl...
> > > > > Hey all,
> > > > > Somewhat new to ADO.NET... I've developed an enterprise ASP.NET
> app
> > > > that
> > > > > uses SQL Server 2000. I now want to retail the app to smaller
> > customers
> > > > but
> > > > > don't want to require all customers to license their own SQL
Server
> > > > ($$$$).
> > > > > I would like to have one set of code that will run with either SQL
> > > Server
> > > > > 2000 or MSDE 2000.
> > > > > 1) Is this an easy task or is there a lot of coding involved?
> > > >
> > > > There's no difference at all code wise, the only difference will be
on
> > the
> > > > install. One you install the full SQL Server, the other you install
> > MSDEE
> > > > > 2) Are there any articles that outline coding differences or is it
> > > simply
> > > > an
> > > > > "install and config" issue on the server?
> > > > There aren't any
> > > > > 3) Can I load my SQL Server 2000 DB into MSDE or are there
> > difficulties
> > > > > going backwards?
> > > > Yes, no problems at all. The 'real' differences are MSDE's limit of
a
> > 2gb
> > > > size for instance. For the most part, the differences are
> transparent..
> > > > both use SQL Client, both use T-SQL etc etc
> > > > >
> > > > > Many thanks in advance!
> > > > > wardeaux
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Accessing peers share from local logon
    ... But how do you assign permissions, on a PC, to an account that does not ... > workstation share a folder ... >>Ie. from the sharing machine how does one specify rights ...
    (microsoft.public.win2000.security)
  • Re: Accessing peers share from local logon
    ... just assign appropriate permissions on the Share. ... > But how do you assign permissions, on a PC, to an account that does not ... >> workstation share a folder ... >>>Ie. from the sharing machine how does one specify rights ...
    (microsoft.public.win2000.security)
  • Re: user permissions in peer to peer / VPN
    ... irrelevant,...it doesn't matter if you are using a VPN or not. ... how to grant the popper user> permissions in such an environment? ... > user account on workstation #2 and Peter wants to grand John permissions> drive C, from where he get Johns User account to grand this permission? ...
    (microsoft.public.win2000.networking)
  • Re: After password change - cannot access shares on server
    ... On the workstation, (under the users account), control panel, users. ... folders, profile folder, email, etc. ... permissions on the users folders on the server etc. so the user can access ...
    (microsoft.public.windows.server.sbs)
  • Re: Connection problems SQL Express
    ... I would go with the obvious and assume the user running your application doesn't have write permissions on the C:\Temp\Test.mdf or C:\Temp\Test.ldf file. ... The connectionstring looks like this: ... I can even connect from a .Net Windows application to the database ...
    (microsoft.public.sqlserver.connect)