How to connect to remote server

Hi All,

I have created my sql database script using SQL data publishing wizard, now i want to execute the same on my shared hosting database. But i am not getting any option to connect to remote server in SSMSE.

I have developed web based application with back hand as SQL Server 2005, so now i want to execute my script file onto the server. so how i will connect with my server using SSMSE ?

My application is located under www.briskonsales.com/sales

Any idea ?

Thanks,

Jay

You will have to work with your Hosting provider to obtain access through their firewalls to access their SQL Server instance.

|||Is the remote instance a SQL Server Express edition ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Very few hosting providers will allow you to connect to their server using SSMS; rather they provide their own set of management tools accessable through their site. If you log into your account you will likely find a set of links that take you to the management console for your hosted database. From there you should be able to load the script file that you saved from the DPW and run it to create your objects in the hosted database.

As others mention, contact your hosting provider if you have questions about managing your hosted database.

Mike

How to connect to MSSQL server from HP-UX environment

Hi,

Please confirm.. is it possible to connect to MSSQL server by executing
a shell script on HP-UX (UNIX) platform.

Regards,
Uncle Sam
On Oct 9, 7:30 am, "Uncle Sam" <mainisund...@.hotmail.comwrote:

Quote:

Originally Posted by

Hi,
>
Please confirm.. is it possible to connect to MSSQL server by executing
a shell script on HP-UX (UNIX) platform.
>
Regards,
Uncle Sam

Well, certainly, but the shell script is irrelevant. A shell on
HP won't have any native capability to connect to MS SQL.
It will simply be able to run anything on your box that has
a commandline interface. So your question is whether there
is anything existing or creatable that will have a commandline
interface and can connect to MS SQL.
Yes. What do you want this connection to do? For instance,
you can write something (or find something) in Java that uses
MS's all-java JDBC driver for MS SQL. Such a Java program
could connect to MS SQL from anywhere on the net that can
see your DBMS machine. All you would need is Java. That
could be on HP or Sun, or a PDA.
Joe Weinstein at BEA Systems.|||Thanks Joe,

for your response... also.. could you please provide in the JDBC
connection string in UNIX environment....... for establishing
connection to MSSQL on WINDOWS platform

Rgds,
Uncle Sam
joeNOSPAM@.BEA.com wrote:

Quote:

Originally Posted by

On Oct 9, 7:30 am, "Uncle Sam" <mainisund...@.hotmail.comwrote:

Quote:

Originally Posted by

Hi,

Please confirm.. is it possible to connect to MSSQL server by executing
a shell script on HP-UX (UNIX) platform.

Regards,
Uncle Sam

>
Well, certainly, but the shell script is irrelevant. A shell on
HP won't have any native capability to connect to MS SQL.
It will simply be able to run anything on your box that has
a commandline interface. So your question is whether there
is anything existing or creatable that will have a commandline
interface and can connect to MS SQL.
Yes. What do you want this connection to do? For instance,
you can write something (or find something) in Java that uses
MS's all-java JDBC driver for MS SQL. Such a Java program
could connect to MS SQL from anywhere on the net that can
see your DBMS machine. All you would need is Java. That
could be on HP or Sun, or a PDA.
Joe Weinstein at BEA Systems.

|||
On Oct 10, 12:27 am, "Uncle Sam" <mainisund...@.hotmail.comwrote:

Quote:

Originally Posted by

Thanks Joe,
>
for your response... also.. could you please provide in the JDBC
connection string in UNIX environment....... for establishing
connection to MSSQL on WINDOWS platform
>
Rgds,
Uncle Sam

Just read the documentation for the driver. All you need
is the name of the machine running SQLServer, and to
make the setup of the DBMS allow mixed-mode (TCP)
connection requests.

How to configure Log shipping on SQL server 2000 developer edition

Rajendra,
you should be able to use the log shipping wizard to set
things up. If you do need to script it out, then you
could use profiler while the wizard runs, but the main
part will be in the maintenance plan, which is not
scriptable in the usual meaning of the word.
Rgds,
Paul Ibison, SQL Server MVP, WWW.Replicationanswers.Com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Hi Paul,
Thanx for ur reply but I don't have Enterprise edition. We purchased the
developer edition because Log shipping feature was listed in the available
features of SQL server 2000. If it is not available in developer edition then
Why Microsoft claimed to have this feature in developer edition?
"Paul Ibison" wrote:

> Rajendra,
> you should be able to use the log shipping wizard to set
> things up. If you do need to script it out, then you
> could use profiler while the wizard runs, but the main
> part will be in the maintenance plan, which is not
> scriptable in the usual meaning of the word.
> Rgds,
> Paul Ibison, SQL Server MVP, WWW.Replicationanswers.Com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Rajendra,
this facility should be there as developer is essentially
the same functionalitywise as enterprise edition and I
have just checked on a box at work. If you start the
maintenance plan wizard, and the log-shipping checkbox is
disabled for a particular database, this is because the
database is in simple recovery mode - perhaps this is the
case? Also, can you do select @.@.version just to confirm
that you have the developer edition installed.
Rgds,
Paul Ibison, SQL Server MVP, WWW.Replicationanswers.Com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||It is not installed in the developer edition, only the EE one.
I suggest Rajendra check out this link for info on how to set it up without
using EE.
http://www.sql-server-performance.co...g_shipping.asp
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:01fa01c4ba7e$668d7a10$a401280a@.phx.gbl...
> Rajendra,
> this facility should be there as developer is essentially
> the same functionalitywise as enterprise edition and I
> have just checked on a box at work. If you start the
> maintenance plan wizard, and the log-shipping checkbox is
> disabled for a particular database, this is because the
> database is in simple recovery mode - perhaps this is the
> case? Also, can you do select @.@.version just to confirm
> that you have the developer edition installed.
> Rgds,
> Paul Ibison, SQL Server MVP, WWW.Replicationanswers.Com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||AFAIK it is installed with Enterprise, Developer and
Enterprise Evaluation Editions - I can see the options on
my desktop, which only has Developer Edition.
Rgds,
Paul Ibison, SQL Server MVP, WWW.Replicationanswers.Com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||I'm sorry, I just realized that this laptop has standard edition SQL Server.
I'll take your word for it Paul! Thanks for the clarification.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:0c2d01c4ba9a$9095e8d0$a601280a@.phx.gbl...
> AFAIK it is installed with Enterprise, Developer and
> Enterprise Evaluation Editions - I can see the options on
> my desktop, which only has Developer Edition.
> Rgds,
> Paul Ibison, SQL Server MVP, WWW.Replicationanswers.Com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>

How to comair Database objects

I have couple of Stored procedures and UDFs and Tables which I generated an
script from our development server and our database admin has run that
script on the production server.Unfortunately because of some changes I had
to generate the script two more times and now I'd like to make sure that the
objects in the producation are same as development.Is there a way to compaur
tham and to see what the potential differences are?
ThanksHi
Using a version control system should stop this occuring. You can use dmo to
compare objects or possibly a third party application such as dbghost
www.dbghost.com or red gate compare www.red-gate.com .
John
"J-T" <J-T@.nospam.com> wrote in message
news:%23Jr%238I8jFHA.3048@.TK2MSFTNGP10.phx.gbl...
>I have couple of Stored procedures and UDFs and Tables which I generated an
>script from our development server and our database admin has run that
>script on the production server.Unfortunately because of some changes I had
>to generate the script two more times and now I'd like to make sure that
>the objects in the producation are same as development.Is there a way to
>compaur tham and to see what the potential differences are?
>
> Thanks
>|||The red-gate is awesome.
Thanks a lot
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:u6Z%23yP8jFHA.3144@.TK2MSFTNGP12.phx.gbl...
> Hi
> Using a version control system should stop this occuring. You can use dmo
> to compare objects or possibly a third party application such as dbghost
> www.dbghost.com or red gate compare www.red-gate.com .
> John
> "J-T" <J-T@.nospam.com> wrote in message
> news:%23Jr%238I8jFHA.3048@.TK2MSFTNGP10.phx.gbl...
>>I have couple of Stored procedures and UDFs and Tables which I generated
>>an script from our development server and our database admin has run that
>>script on the production server.Unfortunately because of some changes I
>>had to generate the script two more times and now I'd like to make sure
>>that the objects in the producation are same as development.Is there a way
>>to compaur tham and to see what the potential differences are?
>>
>> Thanks
>

How to choose one of two success-paths?

I have an ActiveX Script Task in SQL Server 2000. It chooses one of two
possible success-paths depending on if a file exist or not. (Part of the old ActiveX Script for choosing next step is below)

I need to rewrite this for a Script Task in SQL Server 2005 but it seems like it
doesn't have this functionality and objects.

Does anyone know how to write the code for choosing the next step in a
Script Task or knows another way to solve my problem?

The package is not suppose to fail if the file is missing, it's must succeed and that's why I need two success-paths.

Regards,
Sara

'**********************************************************************
' Visual Basic ActiveX Script
'************************************************************************
Function Main ()

Dim pkg
Dim stpContinuePkg
Dim stpExit

SET pkg = DTSGlobalVariables.Parent

SET stpContinuePkg = pkg.Steps("DTSStep_DTSActiveScriptTask_4")
SET stpExit = pkg.Steps("DTSStep_DTSActiveScriptTask_21")

If ...... Then
Main = DTSStepScriptResult_ExecuteTask
stpContinuePkg.DisableStep = False
stpExit.DisableStep = True
Else
.......
End If

Main = DTSTaskExecResult_Success

End Function

What you are talking about is conditional execution. You're right that you have to write script to do this in DTS but it is much easier in SSIS because you can put conditions on the precedence constraints.

All explained here: http://www.sqlis.com/default.aspx?306

-Jamie

|||

Thanks a lot for your answer!

Regards,
Sara