Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Remotely accessing SQL server DB

Reply
Thread Tools

Remotely accessing SQL server DB

 
 
helveticus
Guest
Posts: n/a
 
      05-02-2008
I'm in the process of finalizing my site. I spent quite a bit of time
designing content pages and would like to cut on development time by
simply managing the DB (SQL server, evt. MySQL) via MS Access. This
works well in my local environment. Can this be extended to a host
provider environment as well? Aside from interaction delays, what are
the pros/cons? Thanks for sharing some insights.
 
Reply With Quote
 
 
 
 
helveticus
Guest
Posts: n/a
 
      05-02-2008
Thanks. What alternative would you suggest? I'm really not inclined to
keep on adding extra admin pages for stuff that can easily be handled
by a DB client program.
 
Reply With Quote
 
 
 
 
helveticus
Guest
Posts: n/a
 
      05-02-2008
Thanks again for your feedback. Do you mean by SSMS SQL Server
Management Studio? I currently have the Express version 2008 which
unfortunately does not support connections beyond the host it is
installed at.

Does that mean that I need to purchase the commercial version to do DB
management? I plan on carrying out fairly simple operations
(retrieving data from the remote DB for additional processing via
Access/Excel, and editing existing DB content tables). No need to
create specialized SPROCS, etc. (I'll use pass-through queries.)
Before embarking on remotely linking to SQL Server via MS Access, I
just want to ascertain that MS Access can link up to a remote ISP DB w/
o too many problems. Is this feasible or do I have to factor in
potential vulnerabilities (security, data integrity over the wire,
etc. ) that would defeat the purpose of remotely managing the DB?
Currently, I still use Office 2K (still working fine for my
purposes ;=) )

 
Reply With Quote
 
Paul Shapiro
Guest
Posts: n/a
 
      05-02-2008
You can link an Access mdb or adp to a SQL Server db and do at least some of
the management that way IF your Access version is more recent than your SQL
Server version. But SQL Server Management Studio is more capable. You can
buy SQL Server Developer Edition for about $50, and that includes SSMS. You
can probably also find free downloadable SQL management programs but I
haven't used any.

"helveticus" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Thanks again for your feedback. Do you mean by SSMS SQL Server
> Management Studio? I currently have the Express version 2008 which
> unfortunately does not support connections beyond the host it is
> installed at.
>
> Does that mean that I need to purchase the commercial version to do DB
> management? I plan on carrying out fairly simple operations
> (retrieving data from the remote DB for additional processing via
> Access/Excel, and editing existing DB content tables). No need to
> create specialized SPROCS, etc. (I'll use pass-through queries.)
> Before embarking on remotely linking to SQL Server via MS Access, I
> just want to ascertain that MS Access can link up to a remote ISP DB w/
> o too many problems. Is this feasible or do I have to factor in
> potential vulnerabilities (security, data integrity over the wire,
> etc. ) that would defeat the purpose of remotely managing the DB?
> Currently, I still use Office 2K (still working fine for my
> purposes ;=) )


 
Reply With Quote
 
NH
Guest
Posts: n/a
 
      05-02-2008
I thought the Developer Edition is purely for testing and R&D and that kind
of thing. You cannot use it in Production.

"Paul Shapiro" wrote:

> You can link an Access mdb or adp to a SQL Server db and do at least some of
> the management that way IF your Access version is more recent than your SQL
> Server version. But SQL Server Management Studio is more capable. You can
> buy SQL Server Developer Edition for about $50, and that includes SSMS. You
> can probably also find free downloadable SQL management programs but I
> haven't used any.
>
> "helveticus" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Thanks again for your feedback. Do you mean by SSMS SQL Server
> > Management Studio? I currently have the Express version 2008 which
> > unfortunately does not support connections beyond the host it is
> > installed at.
> >
> > Does that mean that I need to purchase the commercial version to do DB
> > management? I plan on carrying out fairly simple operations
> > (retrieving data from the remote DB for additional processing via
> > Access/Excel, and editing existing DB content tables). No need to
> > create specialized SPROCS, etc. (I'll use pass-through queries.)
> > Before embarking on remotely linking to SQL Server via MS Access, I
> > just want to ascertain that MS Access can link up to a remote ISP DB w/
> > o too many problems. Is this feasible or do I have to factor in
> > potential vulnerabilities (security, data integrity over the wire,
> > etc. ) that would defeat the purpose of remotely managing the DB?
> > Currently, I still use Office 2K (still working fine for my
> > purposes ;=) )

>
>

 
Reply With Quote
 
sloan
Guest
Posts: n/a
 
      05-02-2008

Sql Server Management Studio Express (the free one) will connect to remote
Sql Server's.

The remote Sql Server NEEDS TO CONFIGURED TO HANDLE/ACCEPT REMOTE REQUESTS.

...

But I use the freebie tool all the time to connect to remote sql servers.

I have licenses for the developer edition for 2 boxes (work and laptop).
Everything else I put that freebie tool on.

...

The freebie tool does not do JOBS, FYI. Outside of that, I don't really
miss anything.

...

The $50 for developer edition is well spent as well.





"helveticus" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I'm in the process of finalizing my site. I spent quite a bit of time
> designing content pages and would like to cut on development time by
> simply managing the DB (SQL server, evt. MySQL) via MS Access. This
> works well in my local environment. Can this be extended to a host
> provider environment as well? Aside from interaction delays, what are
> the pros/cons? Thanks for sharing some insights.



 
Reply With Quote
 
helveticus
Guest
Posts: n/a
 
      05-02-2008
Thanks for your response. You seem to imply that there should not be
too many hassles. Currently, I use SQL Server (because of MS built-in
support), but I'm considering switching over to MySQL in the future
(alas, LINQ is not supported). To me, flexibility is key.

MS Access provides this versatility. As a front-end client, I am able
via ODBC to access w/o too much trouble - at least in my local
environment - either SQL Server or MySQL and retrieve/edit data on the
fly. From what I have read and the wording of your post, the
performance penalties appear to be acceptable.

PS: Don't quite understand your first instance: "..You can link an
Access mdb or adp to a SQL Server db and do at least some of the
management that way IF your Access version is more recent than your
SQL Server version". What restrictions may arise? I link up to SQL
Server Express 2005 via Access 2000. Editing/Retrieving work ok.
 
Reply With Quote
 
Peter Bromberg [C# MVP]
Guest
Posts: n/a
 
      05-02-2008
Somebody correct me if I am wrong, but I seem to remember using the EXPRESS
version of SQL Server with remote connections very easily. Have you checked
your settings? Check this:
http://support.microsoft.com/default...b;EN-US;914277
Peter
"helveticus" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Thanks again for your feedback. Do you mean by SSMS SQL Server
> Management Studio? I currently have the Express version 2008 which
> unfortunately does not support connections beyond the host it is
> installed at.
>
> Does that mean that I need to purchase the commercial version to do DB
> management? I plan on carrying out fairly simple operations
> (retrieving data from the remote DB for additional processing via
> Access/Excel, and editing existing DB content tables). No need to
> create specialized SPROCS, etc. (I'll use pass-through queries.)
> Before embarking on remotely linking to SQL Server via MS Access, I
> just want to ascertain that MS Access can link up to a remote ISP DB w/
> o too many problems. Is this feasible or do I have to factor in
> potential vulnerabilities (security, data integrity over the wire,
> etc. ) that would defeat the purpose of remotely managing the DB?
> Currently, I still use Office 2K (still working fine for my
> purposes ;=) )
>


 
Reply With Quote
 
Paul Shapiro
Guest
Posts: n/a
 
      05-03-2008
That's correct, you cannot use SQL Server Developer Edition in production.
The SQL Server is licensed for a single connection. But the Management
Studio works fine for also managing a production server, and seems to me to
at least be within the spirit of a developer license. I haven't looked at
the license text to verify that it's legal.

"NH" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I thought the Developer Edition is purely for testing and R&D and that kind
> of thing. You cannot use it in Production.
>
> "Paul Shapiro" wrote:
>
>> You can link an Access mdb or adp to a SQL Server db and do at least some
>> of
>> the management that way IF your Access version is more recent than your
>> SQL
>> Server version. But SQL Server Management Studio is more capable. You can
>> buy SQL Server Developer Edition for about $50, and that includes SSMS.
>> You
>> can probably also find free downloadable SQL management programs but I
>> haven't used any.
>>
>> "helveticus" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> > Thanks again for your feedback. Do you mean by SSMS SQL Server
>> > Management Studio? I currently have the Express version 2008 which
>> > unfortunately does not support connections beyond the host it is
>> > installed at.
>> >
>> > Does that mean that I need to purchase the commercial version to do DB
>> > management? I plan on carrying out fairly simple operations
>> > (retrieving data from the remote DB for additional processing via
>> > Access/Excel, and editing existing DB content tables). No need to
>> > create specialized SPROCS, etc. (I'll use pass-through queries.)
>> > Before embarking on remotely linking to SQL Server via MS Access, I
>> > just want to ascertain that MS Access can link up to a remote ISP DB w/
>> > o too many problems. Is this feasible or do I have to factor in
>> > potential vulnerabilities (security, data integrity over the wire,
>> > etc. ) that would defeat the purpose of remotely managing the DB?
>> > Currently, I still use Office 2K (still working fine for my
>> > purposes ;=) )


 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help. Getting a An error has occurred while establishing a connectionto the server. When connecting to SQL Server 2005, this failure may be causedby the fact that under the default settings SQL Server does not allow remote aboutjav.com@gmail.com ASP .Net 0 05-03-2008 12:43 PM
Accessing hosted SQL remotely eric302@gmail.com ASP .Net 5 07-23-2007 05:45 AM
remotely accessing my pc Kendra Kay Computer Support 9 12-27-2004 05:42 AM
Accessing email remotely °Mike° Computer Support 4 09-14-2003 10:00 PM
Application Accessing MySQL remotely Ike Java 1 09-12-2003 06:10 PM



Advertisments