Managed index in Fuzzy Lookup Error

If we run the package with fuzzy lookup without selecting the "manage index" option it runs great and select the data and inserts data within the table as expected.

If we run the sam package after selecting the option for "manage index" it gives error:

Error: 0xC0202009 at Data Flow Task, Composite Lookup [15209]: An OLE DB error has occurred. Error code: 0x80040E14.

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "A .NET Framework error occurred during execution of user defined routine or aggregate 'sp_FuzzyLookupTableMaintenanceInstall':

OK this becasue there is a known issue in SQL server 2005 June CTP. Its not there in Sep CTP

Managed index in Fuzzy Lookup Error

If we run the package with fuzzy lookup without selecting the "manage index" option it runs great and select the data and inserts data within the table as expected.

If we run the sam package after selecting the option for "manage index" it gives error:

Error: 0xC0202009 at Data Flow Task, Composite Lookup [15209]: An OLE DB error has occurred. Error code: 0x80040E14.

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "A .NET Framework error occurred during execution of user defined routine or aggregate 'sp_FuzzyLookupTableMaintenanceInstall':

OK this becasue there is a known issue in SQL server 2005 June CTP. Its not there in Sep CTP

Manage with SQL Server Management Studio Express

I have read that SQL Server Compact Edition can be managed within SQL Server Management Studio Express.

Can anyone show me how to do it?

Or I can manage the Compact Edition in other way instead of in VS 2005.

Thanks a lot,

JD

SQL Server Management Studio Express SP2 will allow you to manage SQL Compact Edition (despite the statement on the download page). It can be downloaded from http://www.microsoft.com/downloads/details.aspx?FamilyID=6053C6F8-82C8-479C-B25B-9ACA13141C9E&displaylang=en

sql

Manage Triggers...

Is there one place where I can manage all triggers?
When I come in on Monday mornings - I would like to take a
quick glance to see if all the updates where done.
Thanks,
Lynn.
I was thinking there might be a modified column in the
Server Enterprise Manager - I do not see such a column.You can manage a table's trigger right-clicking on a table
in EM then All Tasks Then Manage Triggers...
If you need to take a look at all your triggers then you
can can use this script :
select object_name(parent_obj) TableName, name TriggerName
from sysobjects where xtype = 'TR'
>--Original Message--
>Is there one place where I can manage all triggers?
>When I come in on Monday mornings - I would like to take
a
>quick glance to see if all the updates where done.
>Thanks,
>Lynn.
>I was thinking there might be a modified column in the
>Server Enterprise Manager - I do not see such a column.
>.
>|||You mean you want to verify when a trigger ran? You can add the logic into
the trigger to store the date/time it ran into a modified column of the
table, if that is not what you are looking for, please reply.
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Lynn Pennington" <anonymous@.discussions.microsoft.com> wrote in message
news:000401c3d3a5$f5e891b0$a301280a@.phx.gbl...
> Is there one place where I can manage all triggers?
> When I come in on Monday mornings - I would like to take a
> quick glance to see if all the updates where done.
> Thanks,
> Lynn.
> I was thinking there might be a modified column in the
> Server Enterprise Manager - I do not see such a column.|||Ray.
Yes - I want to make sure the trigger ran.
So I add a datetime field to the table?
Thanks,
Lynn.
>--Original Message--
>You mean you want to verify when a trigger ran? You can
add the logic into
>the trigger to store the date/time it ran into a modified
column of the
>table, if that is not what you are looking for, please
reply.
>HTH
>--
>Ray Higdon MCSE, MCDBA, CCNA
>--
>"Lynn Pennington" <anonymous@.discussions.microsoft.com>
wrote in message
>news:000401c3d3a5$f5e891b0$a301280a@.phx.gbl...
>> Is there one place where I can manage all triggers?
>> When I come in on Monday mornings - I would like to
take a
>> quick glance to see if all the updates where done.
>> Thanks,
>> Lynn.
>> I was thinking there might be a modified column in the
>> Server Enterprise Manager - I do not see such a column.
>
>.
>

Manage Triggers grayed out

What do I need to do to give someone access to Manage Triggers in EM?
Is there a way to give them access to view triggers via EM, but disable their ability to create/drop?
You need to be table owner or higher for this. And you cannot grant table owner in 2000. In other
words, either be the owner of the table or db_owner (you could try db_ddladmin, not sure). Whether
EM then will enable the option or not, I don't know...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"JLS" <jlshoop@.hotmail.com> wrote in message news:eoNMiiW5FHA.620@.TK2MSFTNGP12.phx.gbl...
What do I need to do to give someone access to Manage Triggers in EM?
Is there a way to give them access to view triggers via EM, but disable their ability to
create/drop?

Manage Triggers grayed out

What do I need to do to give someone access to Manage Triggers in EM?
Is there a way to give them access to view triggers via EM, but disable thei
r ability to create/drop?You need to be table owner or higher for this. And you cannot grant table ow
ner in 2000. In other
words, either be the owner of the table or db_owner (you could try db_ddladm
in, not sure). Whether
EM then will enable the option or not, I don't know...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"JLS" <jlshoop@.hotmail.com> wrote in message news:eoNMiiW5FHA.620@.TK2MSFTNGP
12.phx.gbl...
What do I need to do to give someone access to Manage Triggers in EM?
Is there a way to give them access to view triggers via EM, but disable thei
r ability to
create/drop?

Manage Triggers grayed out

This is a multi-part message in MIME format.
--=_NextPart_000_0020_01C5E53E.B83BB160
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
What do I need to do to give someone access to Manage Triggers in EM?
Is there a way to give them access to view triggers via EM, but disable = their ability to create/drop?
--=_NextPart_000_0020_01C5E53E.B83BB160
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
What do I need to do = to give someone access to Manage Triggers in EM?

Is there a way to give = them access to view triggers via EM, but disable their ability to = create/drop?

--=_NextPart_000_0020_01C5E53E.B83BB160--You need to be table owner or higher for this. And you cannot grant table owner in 2000. In other
words, either be the owner of the table or db_owner (you could try db_ddladmin, not sure). Whether
EM then will enable the option or not, I don't know...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"JLS" <jlshoop@.hotmail.com> wrote in message news:eoNMiiW5FHA.620@.TK2MSFTNGP12.phx.gbl...
What do I need to do to give someone access to Manage Triggers in EM?
Is there a way to give them access to view triggers via EM, but disable their ability to
create/drop?

manage transaction to avoid locks

Hi,
I am quite puzzled how SQLServer manages transactions.
Whatever the isolation level I set when performing an insertion, other
connections do not have access to the table in select mode.

Example in SQL Analyzer:
create table foo (
id numeric(10),
data varchar(100)
)

On Connection 1
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
GO
BEGIN TRANSACTION
insert into foo(id,data) values (1,'data');

On Connection 2
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
select * from foo
-> QUERY HANGS

On Connection 1
COMMIT

On Connection 2
Get the result

Using READ COMMITTED level, I was expecting not to lock the table when
performing the select.

Thanks in advance for your help,
Cedric(extmb@.yahoo.fr) writes:
> I am quite puzzled how SQLServer manages transactions.
> Whatever the isolation level I set when performing an insertion, other
> connections do not have access to the table in select mode.
> Example in SQL Analyzer:
> create table foo (
> id numeric(10),
> data varchar(100)
> )
> On Connection 1
> SET TRANSACTION ISOLATION LEVEL READ COMMITTED
> GO
> BEGIN TRANSACTION
> insert into foo(id,data) values (1,'data');
> On Connection 2
> SET TRANSACTION ISOLATION LEVEL READ COMMITTED
> select * from foo
> -> QUERY HANGS
> On Connection 1
> COMMIT
> On Connection 2
> Get the result
> Using READ COMMITTED level, I was expecting not to lock the table when
> performing the select.

Why not? READ COMMITTED means just that, read committed data, and there
is uncommitted data in the table.

You can access the uncommitted data if you change the isolation level
for connection 2 to READ UNCOMMITTED.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Ok thanks,
However the question is how can I avoid dirty reads i.e. uncommitted
data without being locked ?
This corresponds to the default behaviour in Oracle.
Thanky you|||Concurrency control in SQL Server 2000 is done using locking. SQL Server
2005 introduces a new feature, snapshot isolation, that operates more like
the Oracle default you mentioned. There is a link to a whitepaper describing
the snapshot isolation feature as it is in SQL Server 2005 Beta 2 here:

http://msdn.microsoft.com/SQL/2005/...es/default.aspx

--
Alan Brewer [MSFT]
Content Architect
SQL Server Documentation Team

This posting is provided "AS IS" with no warranties, and confers no rights|||The scan from the second connection has to wait on the lock on the newly
insert row from the uncommitted transaction in connection1 because under
READ COMMITTED isolation it can't see dirty data.

The next SQL Server release will provide a new isolation level named
SNAPSHOT that will allow the second connection not to block on the
uncommited insert from the first connection, much like Oracle's scan
behavior.

--
Gang He
Software Design Engineer
Microsoft SQL Server Storage Engine

This posting is provided "AS IS" with no warranties, and confers no rights.
<extmb@.yahoo.fr> wrote in message
news:1111565523.911633.41290@.o13g2000cwo.googlegro ups.com...
> Hi,
> I am quite puzzled how SQLServer manages transactions.
> Whatever the isolation level I set when performing an insertion, other
> connections do not have access to the table in select mode.
> Example in SQL Analyzer:
> create table foo (
> id numeric(10),
> data varchar(100)
> )
> On Connection 1
> SET TRANSACTION ISOLATION LEVEL READ COMMITTED
> GO
> BEGIN TRANSACTION
> insert into foo(id,data) values (1,'data');
> On Connection 2
> SET TRANSACTION ISOLATION LEVEL READ COMMITTED
> select * from foo
> -> QUERY HANGS
> On Connection 1
> COMMIT
> On Connection 2
> Get the result
> Using READ COMMITTED level, I was expecting not to lock the table when
> performing the select.
> Thanks in advance for your help,
> Cedricsql

manage the stored procedure permissions....

hello all....can anyone tell me how can i manage the stored procedure permissions in SQL Server Express. Untill now i have developed in SQL Server 2000 and there i used SQL Enterprise Manager for this problem..in SQL Express i can't handle it...Manny thanks.....

hi,

for a graphic management tool, you can have a look at the Microsoft free provided one, you can get for free at http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

regards

|||

Thanks Andrea....but i have allready installed this tool...

in the mean time ....i've find the solution using that tool......go in the DB tree : Security-Users (choose the user that i want to add permisions) -Properties- Securables- here i add the objects and grant the permisions....

manage the MSDE with command tool

i an newbie to MSDE, but i have experience Mysql before, can someone tell me how can i find help to manage MSDE with commands ??http://www.asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=631069

This pinned post at the top of this forum talks about one possible tool.|||sorry man, i think you misunderstood my question, actually i want to use command to manage MSDE.|||Do you mean you want to manage MSDE from the command prompt? If so then you are talking about osql. SeeHow To Manage the SQL Server Desktop Engine (MSDE 2000) by Using the Osql Utility

Terri|||thank for that,
by the way i found that my MSDE is unbeliveable slow, like you have to take a minute to show all the database in the MSDE(from command line), why it is so slow??|||Which command are you using to list the databases?

Terri|||exec sp_database
also when i use sql web data administrator is even more slower than command, it's like take 2 minutes to login, and 3 minutes to go to the query section.
i have no ideas what cause this

Manage TextBox.Value in other TextBox for calculations

Hi,
I need to know if and how can I do this:
tbTotal tbNumber1 tbNumber2
? 12 5
? 3 7
If I've some rows and I want insert in expression of tbTotal the pseudo-code
tbNumber1+tbNumber2
how can I do this? I need this method because the real formula is more
complex with condition etc..
Help me please!!!!! :-)Dario,
you can do this way
ReportItems!tbNumber1.Value+ReportItems!tbNumber2.value
or
Fields!Number1.Value+Fields!Number2.Value
Kiran
"Dario Concilio [MCP]" <dco@.experta-spa.com> wrote in message
news:eP3TQqxcFHA.3940@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I need to know if and how can I do this:
>
> tbTotal tbNumber1 tbNumber2
> ? 12 5
> ? 3 7
>
> If I've some rows and I want insert in expression of tbTotal the
> pseudo-code
> tbNumber1+tbNumber2
> how can I do this? I need this method because the real formula is more
> complex with condition etc..
> Help me please!!!!! :-)
>

Manage style of reports from one place?

Is it possible to maintain the style of all of my reports from one place,
say by using a style sheet or by applying a template?
--
McGeeky
http://mcgeeky.blogspot.comThis will help you:
http://www.databasejournal.com/features/mssql/article.php/3422801
It´s a nice guide.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"McGeeky" <anon@.anon.com> schrieb im Newsbeitrag
news:uVk6BgkRFHA.3288@.TK2MSFTNGP14.phx.gbl...
> Is it possible to maintain the style of all of my reports from one place,
> say by using a style sheet or by applying a template?
> --
> McGeeky
> http://mcgeeky.blogspot.com
>
>|||Hi Jens,
Thanks for getting back to me with the link. It is useful but it doesn't
quite fit my requirements. The template approach helps when creating a new
report but what if you already have existing reports and you want to change
their look? It seems overly labourious to go in to every report and manually
change all the fonts, colours etc.
Thanks
--
McGeeky
http://mcgeeky.blogspot.com
"Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:uU%23EOukRFHA.2356@.TK2MSFTNGP14.phx.gbl...
> This will help you:
> http://www.databasejournal.com/features/mssql/article.php/3422801
> It´s a nice guide.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "McGeeky" <anon@.anon.com> schrieb im Newsbeitrag
> news:uVk6BgkRFHA.3288@.TK2MSFTNGP14.phx.gbl...
>> Is it possible to maintain the style of all of my reports from one place,
>> say by using a style sheet or by applying a template?
>> --
>> McGeeky
>> http://mcgeeky.blogspot.com
>>
>|||If all your reports are the same layout e.g. excel style, you could write
something to parse the reports & apply in your fonts, colours etc. using
xpath. The report would have to be published as a new report, but you could
always delete the old one or move it to a new folder.
Obviously if all the reports are different layouts, then this technique
won't be so good as you'd end up writing a parser for each report!
"McGeeky" wrote:
> Hi Jens,
> Thanks for getting back to me with the link. It is useful but it doesn't
> quite fit my requirements. The template approach helps when creating a new
> report but what if you already have existing reports and you want to change
> their look? It seems overly labourious to go in to every report and manually
> change all the fonts, colours etc.
> Thanks
> --
> McGeeky
> http://mcgeeky.blogspot.com
>
> "Jens Sü�meyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
> message news:uU%23EOukRFHA.2356@.TK2MSFTNGP14.phx.gbl...
> > This will help you:
> >
> > http://www.databasejournal.com/features/mssql/article.php/3422801
> >
> > It´s a nice guide.
> >
> > HTH, Jens Suessmeyer.
> >
> > --
> > http://www.sqlserver2005.de
> > --
> >
> > "McGeeky" <anon@.anon.com> schrieb im Newsbeitrag
> > news:uVk6BgkRFHA.3288@.TK2MSFTNGP14.phx.gbl...
> >> Is it possible to maintain the style of all of my reports from one place,
> >> say by using a style sheet or by applying a template?
> >>
> >> --
> >> McGeeky
> >> http://mcgeeky.blogspot.com
> >>
> >>
> >>
> >
> >
>
>|||Thanks for your suggestion. As the number of reports increases I may need to
do something like that.
I found an article since posting this question that said that stylesheets
are not supported in this version of reporting services but will be
introduced in a later version. I suppose you don't know which version that
would be?
Thanks.
--
McGeeky
http://mcgeeky.blogspot.com
"mark-s" <marks@.discussions.microsoft.com> wrote in message
news:F261DC6E-E8CA-428F-A765-5C4688BE4CD4@.microsoft.com...
> If all your reports are the same layout e.g. excel style, you could write
> something to parse the reports & apply in your fonts, colours etc. using
> xpath. The report would have to be published as a new report, but you
> could
> always delete the old one or move it to a new folder.
> Obviously if all the reports are different layouts, then this technique
> won't be so good as you'd end up writing a parser for each report!
> "McGeeky" wrote:
>> Hi Jens,
>> Thanks for getting back to me with the link. It is useful but it doesn't
>> quite fit my requirements. The template approach helps when creating a
>> new
>> report but what if you already have existing reports and you want to
>> change
>> their look? It seems overly labourious to go in to every report and
>> manually
>> change all the fonts, colours etc.
>> Thanks
>> --
>> McGeeky
>> http://mcgeeky.blogspot.com
>>
>> "Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote
>> in
>> message news:uU%23EOukRFHA.2356@.TK2MSFTNGP14.phx.gbl...
>> > This will help you:
>> >
>> > http://www.databasejournal.com/features/mssql/article.php/3422801
>> >
>> > It´s a nice guide.
>> >
>> > HTH, Jens Suessmeyer.
>> >
>> > --
>> > http://www.sqlserver2005.de
>> > --
>> >
>> > "McGeeky" <anon@.anon.com> schrieb im Newsbeitrag
>> > news:uVk6BgkRFHA.3288@.TK2MSFTNGP14.phx.gbl...
>> >> Is it possible to maintain the style of all of my reports from one
>> >> place,
>> >> say by using a style sheet or by applying a template?
>> >>
>> >> --
>> >> McGeeky
>> >> http://mcgeeky.blogspot.com
>> >>
>> >>
>> >>
>> >
>> >
>>

Manage ssce 3.5

I have been having "fun" trying to get all the bits (SSCE 3.5, Orcas Beta 2, SQL Managment Studio) in Vista 64 and Xp 32.

So far I have found at the SQLMetal does work with SSCE 3.5 but not in Vista64

BUT I cannot get any tool (tried SQL and SLQ express) to manage my SSCE db - ie make relationshipos so that SQLMatal can do its stuff

Any advice as to which tool to use to manage SSCE 3.5

Thanks

Mike

From Data Connections in VS 2008 beta 2, you can manage SQL Compact 3.5 databases, tables, indexes and even relations (new feature).

You can also manage relations with SQL script, like this:

ALTER TABLE ADD CONSTRAINT ...

Integration between SQL Compact 3.5 and SSMS 2008 July CTP is not yet availabel, as noted in the SQL Server 2008 July CTP readme.

|||

Thanks - did not know about SSMS CTP

Have managed to get the SQL script to work but cannot see anywhere is VS 2008 Beta 2 to manage relationships or index - I have been through all the possible menu items so I could do with a pointer to the correct place

Thanks again

Mike

|||

Open Visual Studio 2008. Select View, Server Explorer from the menu. Create a connection to an existing or new SQL Compact 3.5 database. Open the database, select the Tables node, right click a table (or create one).

Relations: Select Table Properties, and then you can choose the Add Relations page.

Indexes: Expand the table name node, and right click indexes, then you have the Create Index menu option, which will take you to the New Index dialog.

Hope this helps!

|||

Hi

Many thanks - found it !!

Mike

sql

Manage SQL server accross WAN?

Hi,
Has anyone had any experience managing a SQL 2000 server behind a a locked
down router? I have to move a SQL server into a secure DMZ and give access
to it from an internal netework. If I open TCP port 1433 and UDP 1434 will
this allow SQL management using Enterprise Manager installed on the remote
client?
Thanks in advance.....Yes, however, i suggest that you either setup the terminal service and
connect remotely through the terminal service client to the server. it
is more secure. you could also do a port forwarding using SSH. This
could be done by setting up the SSH server on the server that you
install SQL server and on the client use a ssh client, setup the port
forwarding to map to 1433 or any other port your sqlserver is running
on. in this setup (via SSH), you usually have to configure in your
client network utility an alias to the server and port. it is far more
secure and faster to do it this way. reason being that a. terminal
service does not send the actual data across the line b. ssh allow
compression to be done on the packet sent over the line and c. both
support data encryption.|||I do this all the time, typically via a VPN solution to the network. If
this is not an option then the following KB article will help.
INF: TCP Ports Needed for Communication to SQL Server Through a Firewall
http://support.microsoft.com/default.aspx?scid=kb;en-us;287932
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"mostro" <mostro@.nospam.com> wrote in message
news:KaKdnRNK5J5KzhveRVn-gg@.adelphia.com...
> Hi,
> Has anyone had any experience managing a SQL 2000 server behind a a locked
> down router? I have to move a SQL server into a secure DMZ and give access
> to it from an internal netework. If I open TCP port 1433 and UDP 1434 will
> this allow SQL management using Enterprise Manager installed on the remote
> client?
> Thanks in advance.....
>

Manage SQL server accross WAN?

Hi,
Has anyone had any experience managing a SQL 2000 server behind a a locked
down router? I have to move a SQL server into a secure DMZ and give access
to it from an internal netework. If I open TCP port 1433 and UDP 1434 will
this allow SQL management using Enterprise Manager installed on the remote
client?
Thanks in advance.....Yes, however, i suggest that you either setup the terminal service and
connect remotely through the terminal service client to the server. it
is more secure. you could also do a port forwarding using SSH. This
could be done by setting up the SSH server on the server that you
install SQL server and on the client use a ssh client, setup the port
forwarding to map to 1433 or any other port your sqlserver is running
on. in this setup (via SSH), you usually have to configure in your
client network utility an alias to the server and port. it is far more
secure and faster to do it this way. reason being that a. terminal
service does not send the actual data across the line b. ssh allow
compression to be done on the packet sent over the line and c. both
support data encryption.|||I do this all the time, typically via a VPN solution to the network. If
this is not an option then the following KB article will help.
INF: TCP Ports Needed for Communication to SQL Server Through a Firewall
http://support.microsoft.com/defaul...kb;en-us;287932
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"mostro" <mostro@.nospam.com> wrote in message
news:KaKdnRNK5J5KzhveRVn-gg@.adelphia.com...
> Hi,
> Has anyone had any experience managing a SQL 2000 server behind a a locked
> down router? I have to move a SQL server into a secure DMZ and give access
> to it from an internal netework. If I open TCP port 1433 and UDP 1434 will
> this allow SQL management using Enterprise Manager installed on the remote
> client?
> Thanks in advance.....
>

Manage SQL server accross WAN?

Hi,
Has anyone had any experience managing a SQL 2000 server behind a a locked
down router? I have to move a SQL server into a secure DMZ and give access
to it from an internal netework. If I open TCP port 1433 and UDP 1434 will
this allow SQL management using Enterprise Manager installed on the remote
client?
Thanks in advance.....
Yes, however, i suggest that you either setup the terminal service and
connect remotely through the terminal service client to the server. it
is more secure. you could also do a port forwarding using SSH. This
could be done by setting up the SSH server on the server that you
install SQL server and on the client use a ssh client, setup the port
forwarding to map to 1433 or any other port your sqlserver is running
on. in this setup (via SSH), you usually have to configure in your
client network utility an alias to the server and port. it is far more
secure and faster to do it this way. reason being that a. terminal
service does not send the actual data across the line b. ssh allow
compression to be done on the packet sent over the line and c. both
support data encryption.
|||I do this all the time, typically via a VPN solution to the network. If
this is not an option then the following KB article will help.
INF: TCP Ports Needed for Communication to SQL Server Through a Firewall
http://support.microsoft.com/default...b;en-us;287932
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"mostro" <mostro@.nospam.com> wrote in message
news:KaKdnRNK5J5KzhveRVn-gg@.adelphia.com...
> Hi,
> Has anyone had any experience managing a SQL 2000 server behind a a locked
> down router? I have to move a SQL server into a secure DMZ and give access
> to it from an internal netework. If I open TCP port 1433 and UDP 1434 will
> this allow SQL management using Enterprise Manager installed on the remote
> client?
> Thanks in advance.....
>

Manage SQL server accross WAN?

Hi,
Has anyone had any experience managing a SQL 2000 server behind a a locked
down router? I have to move a SQL server into a secure DMZ and give access
to it from an internal netework. If I open TCP port 1433 and UDP 1434 will
this allow SQL management using Enterprise Manager installed on the remote
client?
Thanks in advance....."mostro" <mostro@.nospam.com> wrote in
news:f7SdnVXY5ffkzhvenZ2dnUVZ_vydnZ2d@.ad
elphia.com:

> Has anyone had any experience managing a SQL 2000 server behind a a
> locked down router? I have to move a SQL server into a secure DMZ and
> give access to it from an internal netework. If I open TCP port 1433
> and UDP 1434 will this allow SQL management using Enterprise Manager
> installed on the remote client?
I do think you only need TCP 1433 to work with SQL Server, and yes it
should work.
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging

Manage SQL Server 2000 database from new workstation?

I'm currently using a new workstation and need to manage some databases on
my ISPs SQL 2000 server.
I've tried installing SSMSEE, but it won't install since I don't have
SQL2005 (or any SQL server) installed on this machine.
My host does not have a control panel that I can use to maintain SQL
databases.
What can I use to modify our online databases?Hi,
you can use any third party tool:
http://www.aspfaq.com/2442
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--|||"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1144223204.270214.319200@.e56g2000cwe.googlegroups.com...
> Hi,
> you can use any third party tool:
> http://www.aspfaq.com/2442
Thanks!
Looks like I'm going to need a web based app due to firewall constraints.
Several to check out on that page.sql

Manage SQL Server 2000 database from new workstation?

I'm currently using a new workstation and need to manage some databases on
my ISPs SQL 2000 server.
I've tried installing SSMSEE, but it won't install since I don't have
SQL2005 (or any SQL server) installed on this machine.
My host does not have a control panel that I can use to maintain SQL
databases.
What can I use to modify our online databases?
Hi,
you can use any third party tool:
http://www.aspfaq.com/2442
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1144223204.270214.319200@.e56g2000cwe.googlegr oups.com...
> Hi,
> you can use any third party tool:
> http://www.aspfaq.com/2442
Thanks!
Looks like I'm going to need a web based app due to firewall constraints.
Several to check out on that page.

Manage SQL Express Over Lan

Hey Everyone

I have a desktop machine and a laptop machine. Both have XP Pro. I prefer to code on my laptop, but I want to use my desktop machine as a home server/development environment because its always on. I have IIS (HTTP and FTP), .NET 2.0, my mp3 server, etc up and running just fine on my desktop.

When I'm working on an application, I access the site with VWD through a network share. It's worked great so far. What I haven't been able to do, however, is connect to the database with VWD or Management Studio Express. I don't even really know where to begin with this one. What I don't want to do is open this up to the internet. I'd like to just keep it accessible from the LAN (the database, not the website)

I'm new to database stuff, and I don't really know where to look to figure out how to do this. Basically, I want to have the same functionality with VWD or Management Studio that I would have if I was physically on the machine with the SQL Express server.

If anyone can provide some advice, I'd really appreciate it.

Thanks!

Brandon

Any advice?|||

If you develop in your laptop then just get the no deployment Developer edition so you can develop with VWD in your laptop and move only finished code to the desktop. That way Express and IIS in the desktop will be deployment testing place because you can deploy with Express in house. If you choose to get it try the link below for the SQL Server 2005 developer edition. Hope this helps.

http://www.provantage.com/microsoft-e32-00575~7MCSB0EX.htm

|||

Thanks for the post!

Sorry. What I said was very vague.

I prefer to write code on my laptop, but the code is actually stored on my desktop. I access it from my laptop with a network share. I don't want my laptop to run IIS or SQL, that's what I want the desktop to do. So far, everything is working great. My desktop has IIS and SQL running very well. The problem is that I don't know how to work on the databases from my laptop. I can access the application code on my desktop through a network share, but I don't know how to access the SQL Server on my desktop.

Any ideas?

|||

If SQL Server is not in your laptop it is remote so you have to configure remote connection and if you don't have Management Studio installed you need it to configure the connection. The links below will help you and I don't know about VWD your should have a datalink property. At this moment you have developed only the application layer but you need both to run your application. Hope this helps.

http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

|||You're amazing! Thank you!|||

bqmassey:

You're amazing! Thank you!

I am glad I could help.