Can't find SQL Profiler after Install

I have installed SQL Server Express, the configuration tools as well as the SQL Server Management Express However, I need the SQL Profiler. Where or how does this get installed with SQL Server Express?

hi,

Profiler does not come with SQLExpress... it' only available with full blown SQL Server 2005 editions, as reported in http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

regards

Can''t create a SQL Server package configuration

I've created the table [SSIS Configurations] and have added a dummy row to this with "XYZ" in the filter name.

When I use the package configuration wizard I can see that offered as a filter - so I know my connection is seeing the server ok.

The problem I get is when I get through to "Finish" and insert the configuration to the table - I get this error message and I can't find any help on it:

Cannot insert configuration information into the configuration table. (Microsoft.DataTransformationServices.Wizards)

Could not complete wizard actions.

I'm connecting as system administrator and am just foxed as to why it won't insert ... Anyone got any pointers?

Many thanks

Matt

have you used SQL Profiler to watch what is being sent to the server?|||

*bump*

I am getting this error too.

Any ideas? Nothing odd in profiler.

|||

that is weird. If you are choosing a row that already exists in the configuration table; I think the wizard prompts you whether you wan to re-use the exiting row or not...do you see that prompt? what are you selecting?

|||

I've resolved my issue.

It was to do with a property value (an SQL string) that was too long to fit in the default configuration table data column (254 characters.)

I have moved to using an external xml file instead for the SQL statements.

I also tried making the column larger, but ultimately I think the more appropriate option for us is going to be external xml files.

Can't create a SQL Server package configuration

I've created the table [SSIS Configurations] and have added a dummy row to this with "XYZ" in the filter name.

When I use the package configuration wizard I can see that offered as a filter - so I know my connection is seeing the server ok.

The problem I get is when I get through to "Finish" and insert the configuration to the table - I get this error message and I can't find any help on it:

Cannot insert configuration information into the configuration table. (Microsoft.DataTransformationServices.Wizards)

Could not complete wizard actions.

I'm connecting as system administrator and am just foxed as to why it won't insert ... Anyone got any pointers?

Many thanks

Matt

have you used SQL Profiler to watch what is being sent to the server?|||

*bump*

I am getting this error too.

Any ideas? Nothing odd in profiler.

|||

that is weird. If you are choosing a row that already exists in the configuration table; I think the wizard prompts you whether you wan to re-use the exiting row or not...do you see that prompt? what are you selecting?

|||

I've resolved my issue.

It was to do with a property value (an SQL string) that was too long to fit in the default configuration table data column (254 characters.)

I have moved to using an external xml file instead for the SQL statements.

I also tried making the column larger, but ultimately I think the more appropriate option for us is going to be external xml files.

Can't connect to SQL Server(SQL Express) in VS 2005

In SQL Server Configuration Manager I apparently have a server named
SQL Server(SQL Express) running - however, in VS 2005 when I try to
'add connection' (right click in server explorer) I cant see it- I
would like to see it so I can create a new SQL server database.

Any help much appreciated- trying to learn web programming using
vb.net, asp, html, vbscript and SQL server.

DDanWeaver (danofweaver@.googlemail.com) writes:

Quote:

Originally Posted by

In SQL Server Configuration Manager I apparently have a server named
SQL Server(SQL Express) running - however, in VS 2005 when I try to
'add connection' (right click in server explorer) I cant see it- I
would like to see it so I can create a new SQL server database.
>
Any help much appreciated- trying to learn web programming using
vb.net, asp, html, vbscript and SQL server.

Try using .\SQLEXPRESS for the server name.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||On Feb 9, 6:16 pm, Erland Sommarskog <esq...@.sommarskog.sewrote:

Quote:

Originally Posted by

DanWeaver (danofwea...@.googlemail.com) writes:

Quote:

Originally Posted by

In SQL Server Configuration Manager I apparently have a server named
SQL Server(SQL Express) running - however, in VS 2005 when I try to
'add connection' (right click in server explorer) I cant see it- I
would like to see it so I can create a new SQL server database.

>

Quote:

Originally Posted by

Any help much appreciated- trying to learn web programming using
vb.net, asp, html, vbscript and SQL server.

>
Try using .\SQLEXPRESS for the server name.
>
--
Erland Sommarskog, SQL Server MVP, esq...@.sommarskog.se
>
Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

I tried it- It worked- you rock! Thanks so much.

Dan

Can't connect from remote computer

I can't connect to a sql server express server who is in another computer in
the same lan.
In the server I went to the configuration manager and I enabled the TCP/IP
protocol but it still doesn't work.
What else can I do?
Thank youAlberto,
please have a look here for details on enabling remote connections:
http://support.microsoft.com/kb/914277
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Hello,
Using Surface Area configuration toll see:-
1. The SQL Server is configured for Local and Remote connections
2. SQL Server Browse service is started.
If not, do both chnages and try connecting.
Thanks
Hari
"Alberto" <alberto@.nospam.es> wrote in message
news:%23LM3c23SHHA.412@.TK2MSFTNGP02.phx.gbl...
>I can't connect to a sql server express server who is in another computer
>in the same lan.
> In the server I went to the configuration manager and I enabled the TCP/IP
> protocol but it still doesn't work.
> What else can I do?
> Thank you
>
>|||In the surface area confgurarion tool I've got what you say and it still
doesn't work.
I don't know why.
"Hari Prasad" <hari_prasad_k@.hotmail.com> escribió en el mensaje
news:OQlRzI4SHHA.1212@.TK2MSFTNGP03.phx.gbl...
> Hello,
> Using Surface Area configuration toll see:-
> 1. The SQL Server is configured for Local and Remote connections
> 2. SQL Server Browse service is started.
> If not, do both chnages and try connecting.
> Thanks
> Hari
>
>
> "Alberto" <alberto@.nospam.es> wrote in message
> news:%23LM3c23SHHA.412@.TK2MSFTNGP02.phx.gbl...
>>I can't connect to a sql server express server who is in another computer
>>in the same lan.
>> In the server I went to the configuration manager and I enabled the
>> TCP/IP protocol but it still doesn't work.
>> What else can I do?
>> Thank you
>>
>

Can't connect from remote computer

I can't connect to a sql server express server who is in another computer in
the same lan.
In the server I went to the configuration manager and I enabled the TCP/IP
protocol but it still doesn't work.
What else can I do?
Thank youAlberto,
please have a look here for details on enabling remote connections:
http://support.microsoft.com/kb/914277
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Hello,
Using Surface Area configuration toll see:-
1. The SQL Server is configured for Local and Remote connections
2. SQL Server Browse service is started.
If not, do both chnages and try connecting.
Thanks
Hari
"Alberto" <alberto@.nospam.es> wrote in message
news:%23LM3c23SHHA.412@.TK2MSFTNGP02.phx.gbl...
>I can't connect to a sql server express server who is in another computer
>in the same lan.
> In the server I went to the configuration manager and I enabled the TCP/IP
> protocol but it still doesn't work.
> What else can I do?
> Thank you
>
>|||In the surface area confgurarion tool I've got what you say and it still
doesn't work.
I don't know why.
"Hari Prasad" <hari_prasad_k@.hotmail.com> escribi en el mensaje
news:OQlRzI4SHHA.1212@.TK2MSFTNGP03.phx.gbl...
> Hello,
> Using Surface Area configuration toll see:-
> 1. The SQL Server is configured for Local and Remote connections
> 2. SQL Server Browse service is started.
> If not, do both chnages and try connecting.
> Thanks
> Hari
>
>
> "Alberto" <alberto@.nospam.es> wrote in message
> news:%23LM3c23SHHA.412@.TK2MSFTNGP02.phx.gbl...
>