Hello,
I signed up with 1and1 for webhosting and picked the business package which
includes MS SQL server. I would like to connect to
this database from a local Visual Studio C#.NET 2003 IDE. I went to the serv
er explorer and tried to create a new data connection,
filled in the database server, uid, password and database name but was not a
ble to connect to it. The error said "the server does
not exist or access denied". Does anyone know how I can do this? I would li
ke to make some data sets and populate them with data
from the online database.
Thanks,
Max.Hi
In general I would not expect you to work on a live database in this way! I
would expect any changes to use a local copy to be developed and tested
before going live. The live upgrade can either be packaged as scripts or a
backup to be implemented on the live system. This would help prevent you
implementing bad code and causing system problems by developing on live. You
should also be able to implement source code control and have roleback
strategies for any release.
Your host should provide tools to manage/upgrade the database.
John
"Max" wrote:
> Hello,
> I signed up with 1and1 for webhosting and picked the business package w
hich includes MS SQL server. I would like to connect to
> this database from a local Visual Studio C#.NET 2003 IDE. I went to the se
rver explorer and tried to create a new data connection,
> filled in the database server, uid, password and database name but was not
able to connect to it. The error said "the server does
> not exist or access denied". Does anyone know how I can do this? I would
like to make some data sets and populate them with data
> from the online database.
> Thanks,
> Max.
>
Showing posts with label business. Show all posts
Showing posts with label business. Show all posts
Sunday, 25 March 2012
Connect to online webhost MS SQL database
Hello,
I signed up with 1and1 for webhosting and picked the business package which includes MS SQL server. I would like to connect to
this database from a local Visual Studio C#.NET 2003 IDE. I went to the server explorer and tried to create a new data connection,
filled in the database server, uid, password and database name but was not able to connect to it. The error said "the server does
not exist or access denied". Does anyone know how I can do this? I would like to make some data sets and populate them with data
from the online database.
Thanks,
Max.Hi
In general I would not expect you to work on a live database in this way! I
would expect any changes to use a local copy to be developed and tested
before going live. The live upgrade can either be packaged as scripts or a
backup to be implemented on the live system. This would help prevent you
implementing bad code and causing system problems by developing on live. You
should also be able to implement source code control and have roleback
strategies for any release.
Your host should provide tools to manage/upgrade the database.
John
"Max" wrote:
> Hello,
> I signed up with 1and1 for webhosting and picked the business package which includes MS SQL server. I would like to connect to
> this database from a local Visual Studio C#.NET 2003 IDE. I went to the server explorer and tried to create a new data connection,
> filled in the database server, uid, password and database name but was not able to connect to it. The error said "the server does
> not exist or access denied". Does anyone know how I can do this? I would like to make some data sets and populate them with data
> from the online database.
> Thanks,
> Max.
>
I signed up with 1and1 for webhosting and picked the business package which includes MS SQL server. I would like to connect to
this database from a local Visual Studio C#.NET 2003 IDE. I went to the server explorer and tried to create a new data connection,
filled in the database server, uid, password and database name but was not able to connect to it. The error said "the server does
not exist or access denied". Does anyone know how I can do this? I would like to make some data sets and populate them with data
from the online database.
Thanks,
Max.Hi
In general I would not expect you to work on a live database in this way! I
would expect any changes to use a local copy to be developed and tested
before going live. The live upgrade can either be packaged as scripts or a
backup to be implemented on the live system. This would help prevent you
implementing bad code and causing system problems by developing on live. You
should also be able to implement source code control and have roleback
strategies for any release.
Your host should provide tools to manage/upgrade the database.
John
"Max" wrote:
> Hello,
> I signed up with 1and1 for webhosting and picked the business package which includes MS SQL server. I would like to connect to
> this database from a local Visual Studio C#.NET 2003 IDE. I went to the server explorer and tried to create a new data connection,
> filled in the database server, uid, password and database name but was not able to connect to it. The error said "the server does
> not exist or access denied". Does anyone know how I can do this? I would like to make some data sets and populate them with data
> from the online database.
> Thanks,
> Max.
>
Connect to object explorer but cannot connect to Integration services.
I try to import my SSIS packages which are created using the Business Intelligent studio into SQL server 2005 but I cannot do that.
I am running SQL server 2005 enterprise edition.
Also when i tried to connect to Integration services using Object explorer, it only prompt me for server name. I cannot change the username and password which is disabled.
Then how am i supposed to connect to Integration services on a server in this case?
There is no username and password required to connect to SSIS Server.
-Jamie
|||i got a server A...i tried to connect without password and user it gives me error....
the sql server is using sql authetication not windows authetication.
|||SQL Server authentication is for SQL Server. The SSIS Server (service) is something else and does not support SQL Server auth. You need windows auth to connect. It actually uses DCOM.|||so how should i proceed from here?
my server wont allow me to connect to SSIS services using object explorer.
"Access is denied" connect to server 1 on machine failed.
Do i need to create anything on the server?
sqlsqlThursday, 22 March 2012
Connect to MSDE/SBS2003 remotely
I am writing a small app for a company using Access (adp) and MSDE. The MSDE
is installed on a Small Business Server and I have been told it is a
complete standard setup.
First question: I know MSDE is running because I recognise the icon in the
system tray. Also, locally I can connect to the MSDE so I know it is there.
However, from previous installations of MSDE I seem to recall that although
you don't get Enterprise Manager, Query Analyzer etc with MSDE, you do get
Client Network Utility etc. I have not been able to locate *any* utilities
for MSDE on the server. Is this normal?
This brings me onto my main question. I expect to do some alterations to the
database after the initial installation, and it is not feasible for me to
make a trip to the client for every alteration. I would therefore like to be
able to use Enterprise Manager that I have locally to connect to the remote
SBS/MSDE. How do I do that under the circumstances? I know they have a Cisco
firewall in place.
Any pointers in the right direction would be much appreciated.
What I have found out so far is that I need to check if Server Network
Utility (svrnetcn.exe) is present and has enabled TCP/IP protocol. But I am
sure that is not the end of the story...
"bobby" <bobby@.bobbys.com> wrote in message
news:%23arsRdOjEHA.3612@.TK2MSFTNGP12.phx.gbl...
> I am writing a small app for a company using Access (adp) and MSDE. The
MSDE
> is installed on a Small Business Server and I have been told it is a
> complete standard setup.
> First question: I know MSDE is running because I recognise the icon in the
> system tray. Also, locally I can connect to the MSDE so I know it is
there.
> However, from previous installations of MSDE I seem to recall that
although
> you don't get Enterprise Manager, Query Analyzer etc with MSDE, you do get
> Client Network Utility etc. I have not been able to locate *any* utilities
> for MSDE on the server. Is this normal?
> This brings me onto my main question. I expect to do some alterations to
the
> database after the initial installation, and it is not feasible for me to
> make a trip to the client for every alteration. I would therefore like to
be
> able to use Enterprise Manager that I have locally to connect to the
remote
> SBS/MSDE. How do I do that under the circumstances? I know they have a
Cisco
> firewall in place.
> Any pointers in the right direction would be much appreciated.
>
|||MSDE does not ship with any of the graphical utilities that you're used to
seeing. It does ship with a command line utility, osql.exe, that you can use
to manage it, assuming that you're familiar with T-SQL.
As to whether or not you're allowed to use the copy of SQL Server Enterprise
Manager you have to manage it remotely, I doubt it. Please see the FAQ page
at http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp. The sixth Q & A
is the following:
Q. Can I use SQL Server tools and services in conjunction with MSDE?
A. You can only use SQL Server tools and services in conjunction with
MSDE if you acquired MSDE through SQL Server 2000 (Developer Edition,
Standard Edition, or Enterprise Edition), and if you are using MSDE in
conjunction with a properly licensed copy of SQL Server 2000. Visit the How
to Buy page for information on obtaining a valid SQL Server license.
Note: The tools and services included with SQL Server Developer
Edition may not be used to manage production server environments.
The following utilities are installed by the MSDE setup application
and are provided without restrictions for use with the copy of MSDE that is
installed by your application: bcp.exe, cnfgsvr.exe, dcomscm.exe, osql.exe,
sqlmaint.exe, sqlmangr.exe, scm.exe, sqladhlp.exe, and svrnetcn.exe. The
dtsrun.exe utility is also provided, but can only be used to run existing
Data Transformation Services (DTS) packages against the copy of MSDE
installed by your application; it cannot be used to develop new DTS
packages.
It sounds to me like the small app that you're writing isn't being used in
conjuction with your copy of SQL Server 2000 and thus you won't be allowed
to use SQL Server Enterprise Manager against it.
As always, of course, I'm not a lawyer so you should consult yours. :-)
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"bobby" <bobby@.bobbys.com> wrote in message
news:%23arsRdOjEHA.3612@.TK2MSFTNGP12.phx.gbl...
>I am writing a small app for a company using Access (adp) and MSDE. The
>MSDE
> is installed on a Small Business Server and I have been told it is a
> complete standard setup.
> First question: I know MSDE is running because I recognise the icon in the
> system tray. Also, locally I can connect to the MSDE so I know it is
> there.
> However, from previous installations of MSDE I seem to recall that
> although
> you don't get Enterprise Manager, Query Analyzer etc with MSDE, you do get
> Client Network Utility etc. I have not been able to locate *any* utilities
> for MSDE on the server. Is this normal?
> This brings me onto my main question. I expect to do some alterations to
> the
> database after the initial installation, and it is not feasible for me to
> make a trip to the client for every alteration. I would therefore like to
> be
> able to use Enterprise Manager that I have locally to connect to the
> remote
> SBS/MSDE. How do I do that under the circumstances? I know they have a
> Cisco
> firewall in place.
> Any pointers in the right direction would be much appreciated.
>
begin 666 ts.gif
J1TE&.#EA`0`!`( ``````/___R'Y! $`````+ `````!``$```(!1 `[
`
end
|||Hi bobby,
In addition, we've got a program called MSDE Manager that's free for
personal use. Details at our site.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:O7dgcQrjEHA.1348@.TK2MSFTNGP15.phx.gbl...
> MSDE does not ship with any of the graphical utilities that you're used to
> seeing. It does ship with a command line utility, osql.exe, that you can
use
> to manage it, assuming that you're familiar with T-SQL.
> As to whether or not you're allowed to use the copy of SQL Server
Enterprise
> Manager you have to manage it remotely, I doubt it. Please see the FAQ
page
> at http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp. The sixth Q & A
> is the following:
> Q. Can I use SQL Server tools and services in conjunction with
MSDE?
> A. You can only use SQL Server tools and services in conjunction
with
> MSDE if you acquired MSDE through SQL Server 2000 (Developer Edition,
> Standard Edition, or Enterprise Edition), and if you are using MSDE in
> conjunction with a properly licensed copy of SQL Server 2000. Visit the
How
> to Buy page for information on obtaining a valid SQL Server license.
> Note: The tools and services included with SQL Server Developer
> Edition may not be used to manage production server environments.
> The following utilities are installed by the MSDE setup application
> and are provided without restrictions for use with the copy of MSDE that
is
> installed by your application: bcp.exe, cnfgsvr.exe, dcomscm.exe,
osql.exe,
> sqlmaint.exe, sqlmangr.exe, scm.exe, sqladhlp.exe, and svrnetcn.exe. The
> dtsrun.exe utility is also provided, but can only be used to run existing
> Data Transformation Services (DTS) packages against the copy of MSDE
> installed by your application; it cannot be used to develop new DTS
> packages.
>
> It sounds to me like the small app that you're writing isn't being used in
> conjuction with your copy of SQL Server 2000 and thus you won't be allowed
> to use SQL Server Enterprise Manager against it.
> As always, of course, I'm not a lawyer so you should consult yours. :-)
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
rights.[vbcol=seagreen]
> "bobby" <bobby@.bobbys.com> wrote in message
> news:%23arsRdOjEHA.3612@.TK2MSFTNGP12.phx.gbl...
the[vbcol=seagreen]
get[vbcol=seagreen]
utilities[vbcol=seagreen]
to[vbcol=seagreen]
to
>
>
sqlsql
is installed on a Small Business Server and I have been told it is a
complete standard setup.
First question: I know MSDE is running because I recognise the icon in the
system tray. Also, locally I can connect to the MSDE so I know it is there.
However, from previous installations of MSDE I seem to recall that although
you don't get Enterprise Manager, Query Analyzer etc with MSDE, you do get
Client Network Utility etc. I have not been able to locate *any* utilities
for MSDE on the server. Is this normal?
This brings me onto my main question. I expect to do some alterations to the
database after the initial installation, and it is not feasible for me to
make a trip to the client for every alteration. I would therefore like to be
able to use Enterprise Manager that I have locally to connect to the remote
SBS/MSDE. How do I do that under the circumstances? I know they have a Cisco
firewall in place.
Any pointers in the right direction would be much appreciated.
What I have found out so far is that I need to check if Server Network
Utility (svrnetcn.exe) is present and has enabled TCP/IP protocol. But I am
sure that is not the end of the story...
"bobby" <bobby@.bobbys.com> wrote in message
news:%23arsRdOjEHA.3612@.TK2MSFTNGP12.phx.gbl...
> I am writing a small app for a company using Access (adp) and MSDE. The
MSDE
> is installed on a Small Business Server and I have been told it is a
> complete standard setup.
> First question: I know MSDE is running because I recognise the icon in the
> system tray. Also, locally I can connect to the MSDE so I know it is
there.
> However, from previous installations of MSDE I seem to recall that
although
> you don't get Enterprise Manager, Query Analyzer etc with MSDE, you do get
> Client Network Utility etc. I have not been able to locate *any* utilities
> for MSDE on the server. Is this normal?
> This brings me onto my main question. I expect to do some alterations to
the
> database after the initial installation, and it is not feasible for me to
> make a trip to the client for every alteration. I would therefore like to
be
> able to use Enterprise Manager that I have locally to connect to the
remote
> SBS/MSDE. How do I do that under the circumstances? I know they have a
Cisco
> firewall in place.
> Any pointers in the right direction would be much appreciated.
>
|||MSDE does not ship with any of the graphical utilities that you're used to
seeing. It does ship with a command line utility, osql.exe, that you can use
to manage it, assuming that you're familiar with T-SQL.
As to whether or not you're allowed to use the copy of SQL Server Enterprise
Manager you have to manage it remotely, I doubt it. Please see the FAQ page
at http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp. The sixth Q & A
is the following:
Q. Can I use SQL Server tools and services in conjunction with MSDE?
A. You can only use SQL Server tools and services in conjunction with
MSDE if you acquired MSDE through SQL Server 2000 (Developer Edition,
Standard Edition, or Enterprise Edition), and if you are using MSDE in
conjunction with a properly licensed copy of SQL Server 2000. Visit the How
to Buy page for information on obtaining a valid SQL Server license.
Note: The tools and services included with SQL Server Developer
Edition may not be used to manage production server environments.
The following utilities are installed by the MSDE setup application
and are provided without restrictions for use with the copy of MSDE that is
installed by your application: bcp.exe, cnfgsvr.exe, dcomscm.exe, osql.exe,
sqlmaint.exe, sqlmangr.exe, scm.exe, sqladhlp.exe, and svrnetcn.exe. The
dtsrun.exe utility is also provided, but can only be used to run existing
Data Transformation Services (DTS) packages against the copy of MSDE
installed by your application; it cannot be used to develop new DTS
packages.
It sounds to me like the small app that you're writing isn't being used in
conjuction with your copy of SQL Server 2000 and thus you won't be allowed
to use SQL Server Enterprise Manager against it.
As always, of course, I'm not a lawyer so you should consult yours. :-)
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"bobby" <bobby@.bobbys.com> wrote in message
news:%23arsRdOjEHA.3612@.TK2MSFTNGP12.phx.gbl...
>I am writing a small app for a company using Access (adp) and MSDE. The
>MSDE
> is installed on a Small Business Server and I have been told it is a
> complete standard setup.
> First question: I know MSDE is running because I recognise the icon in the
> system tray. Also, locally I can connect to the MSDE so I know it is
> there.
> However, from previous installations of MSDE I seem to recall that
> although
> you don't get Enterprise Manager, Query Analyzer etc with MSDE, you do get
> Client Network Utility etc. I have not been able to locate *any* utilities
> for MSDE on the server. Is this normal?
> This brings me onto my main question. I expect to do some alterations to
> the
> database after the initial installation, and it is not feasible for me to
> make a trip to the client for every alteration. I would therefore like to
> be
> able to use Enterprise Manager that I have locally to connect to the
> remote
> SBS/MSDE. How do I do that under the circumstances? I know they have a
> Cisco
> firewall in place.
> Any pointers in the right direction would be much appreciated.
>
begin 666 ts.gif
J1TE&.#EA`0`!`( ``````/___R'Y! $`````+ `````!``$```(!1 `[
`
end
|||Hi bobby,
In addition, we've got a program called MSDE Manager that's free for
personal use. Details at our site.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:O7dgcQrjEHA.1348@.TK2MSFTNGP15.phx.gbl...
> MSDE does not ship with any of the graphical utilities that you're used to
> seeing. It does ship with a command line utility, osql.exe, that you can
use
> to manage it, assuming that you're familiar with T-SQL.
> As to whether or not you're allowed to use the copy of SQL Server
Enterprise
> Manager you have to manage it remotely, I doubt it. Please see the FAQ
page
> at http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp. The sixth Q & A
> is the following:
> Q. Can I use SQL Server tools and services in conjunction with
MSDE?
> A. You can only use SQL Server tools and services in conjunction
with
> MSDE if you acquired MSDE through SQL Server 2000 (Developer Edition,
> Standard Edition, or Enterprise Edition), and if you are using MSDE in
> conjunction with a properly licensed copy of SQL Server 2000. Visit the
How
> to Buy page for information on obtaining a valid SQL Server license.
> Note: The tools and services included with SQL Server Developer
> Edition may not be used to manage production server environments.
> The following utilities are installed by the MSDE setup application
> and are provided without restrictions for use with the copy of MSDE that
is
> installed by your application: bcp.exe, cnfgsvr.exe, dcomscm.exe,
osql.exe,
> sqlmaint.exe, sqlmangr.exe, scm.exe, sqladhlp.exe, and svrnetcn.exe. The
> dtsrun.exe utility is also provided, but can only be used to run existing
> Data Transformation Services (DTS) packages against the copy of MSDE
> installed by your application; it cannot be used to develop new DTS
> packages.
>
> It sounds to me like the small app that you're writing isn't being used in
> conjuction with your copy of SQL Server 2000 and thus you won't be allowed
> to use SQL Server Enterprise Manager against it.
> As always, of course, I'm not a lawyer so you should consult yours. :-)
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
rights.[vbcol=seagreen]
> "bobby" <bobby@.bobbys.com> wrote in message
> news:%23arsRdOjEHA.3612@.TK2MSFTNGP12.phx.gbl...
the[vbcol=seagreen]
get[vbcol=seagreen]
utilities[vbcol=seagreen]
to[vbcol=seagreen]
to
>
>
sqlsql
Thursday, 8 March 2012
Connect .mdf file to MSDE 2000
I'm using a product (SAP Business one) using MSDE 2000A. Another product I
receintly bought also uses SQL. According to this products manual I need to
connect the *.mdf database to my SQL server using SQL Enterprise Manager. How
does it work?
hi,
GV wrote:
> I'm using a product (SAP Business one) using MSDE 2000A. Another
> product I receintly bought also uses SQL. According to this products
> manual I need to connect the *.mdf database to my SQL server using
> SQL Enterprise Manager. How does it work?
you are required to "attach" the provided database to an existing SQL
Server/MSDE instance...
as MSDE does not provide Entrprise Manager, you have to resort on the
command line tool, oSql.exe, to execute the corresponding Transact-SQL
statement to attach the database using the system stored procedure
sp_attach_db...
you can find the full synopsis of the introduced stored procedure at
http://msdn.microsoft.com/library/de...ae-az_52oy.asp
at http://support.microsoft.com/default...;EN-US;q325003 you will
find some information on how to use oSql.exe to perform this task as long as
other related management tasks..
for your convenience, you can have a look at a free prj of mine, available
at the link following my sign., which provides a graphical user interface
similar to Enterprise Manager in order to accomplish management tasks,
including the one here discussed..
futher tools for MSDE, both commercial and free, are listed
http://www.microsoft.com/sql/msde/partners/default.asp and/or
http://www.aspfaq.com/show.asp?id=2442
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
receintly bought also uses SQL. According to this products manual I need to
connect the *.mdf database to my SQL server using SQL Enterprise Manager. How
does it work?
hi,
GV wrote:
> I'm using a product (SAP Business one) using MSDE 2000A. Another
> product I receintly bought also uses SQL. According to this products
> manual I need to connect the *.mdf database to my SQL server using
> SQL Enterprise Manager. How does it work?
you are required to "attach" the provided database to an existing SQL
Server/MSDE instance...
as MSDE does not provide Entrprise Manager, you have to resort on the
command line tool, oSql.exe, to execute the corresponding Transact-SQL
statement to attach the database using the system stored procedure
sp_attach_db...
you can find the full synopsis of the introduced stored procedure at
http://msdn.microsoft.com/library/de...ae-az_52oy.asp
at http://support.microsoft.com/default...;EN-US;q325003 you will
find some information on how to use oSql.exe to perform this task as long as
other related management tasks..
for your convenience, you can have a look at a free prj of mine, available
at the link following my sign., which provides a graphical user interface
similar to Enterprise Manager in order to accomplish management tasks,
including the one here discussed..
futher tools for MSDE, both commercial and free, are listed
http://www.microsoft.com/sql/msde/partners/default.asp and/or
http://www.aspfaq.com/show.asp?id=2442
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Subscribe to:
Posts (Atom)