Can't find Reporting Service?

I wanted to add Reports Service to my sql express. I downloaded the SQLEXPR_ADV.EXE and also Edition Toolkit SP1. But can't see the option to install Report service.

Any help please.

Juvan

Reporting Services is included with SQL Express Advanced. Launch this installer and you will see an option to install it during the "Feature Selection" dialog.

Thanks,
Sam Lester (MSFT)

Can't find Reporting Service?

I wanted to add Reports Service to my sql express. I downloaded the SQLEXPR_ADV.EXE and also Edition Toolkit SP1. But can't see the option to install Report service.

Any help please.

Juvan

Reporting Services is included with SQL Express Advanced. Launch this installer and you will see an option to install it during the "Feature Selection" dialog.

Thanks,
Sam Lester (MSFT)

Cant Find MS SQL SERVER in DataSource

hi..

i am using C# eXpress edition 2005..and i have downloaded the SQL Express Edition..

the problem is that i cant find "Microsoft SQL Server" in data sources..

there are only two items listed

-> Microsoft Access DataBase File

-> Microsoft SQL Server Database File

Where do i get "Microsoft SQL Server" ?

hi,

Visual Studio Express editions designers are "designed" to use only "file based" connections and thus User Instances features... you can connect to the "traditional" SQLExpress engine, but only by code and not via the designers..

regards

|||thankXX a lot mate..

Cant find installer

I'm trying my first install of MSDE 2000 and having some
difficulty. I downloaded the package, then extracted it.
Then read the entire readme telling me all the
requirements and such. I then opened a console window,
and tried to install it. I made my changes to my .ini
file and referenced that on the command line. I'm
getting an error message however that says this. "The
installation package could not be opened. Verify that
the package exists and that you can access it, or contact
the application vendor to verify that this is a valid
Windows installer pakcage".
I went to the knowledge base and the only thing I could
find as a possible problem was that I have SQL server
running all 16 instances on my machine, but this is my
first install ever so there's no way that I have any
other instances running. Please help!
"Culbert" <anonymous@.discussions.microsoft.com> wrote in message
news:7d1301c4773e$0d033c10$a301280a@.phx.gbl...
> I'm trying my first install of MSDE 2000 and having some
> difficulty. I downloaded the package, then extracted it.
> Then read the entire readme telling me all the
> requirements and such. I then opened a console window,
> and tried to install it. I made my changes to my .ini
> file and referenced that on the command line. I'm
> getting an error message however that says this. "The
> installation package could not be opened. Verify that
> the package exists and that you can access it, or contact
> the application vendor to verify that this is a valid
> Windows installer pakcage".
> I went to the knowledge base and the only thing I could
> find as a possible problem was that I have SQL server
> running all 16 instances on my machine, but this is my
> first install ever so there's no way that I have any
> other instances running. Please help!
This may be belaboring the obvious, but you did navigate to the directory
where MSDE was extracted before issuing the install command (or, include the
fully qualified path to the install file in the command), correct?
Peter [MVP Visual Developer]
Jack of all trades, master of none.
|||
>--Original Message--
>"Culbert" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:7d1301c4773e$0d033c10$a301280a@.phx.gbl...
some[vbcol=seagreen]
it.[vbcol=seagreen]
contact
>This may be belaboring the obvious, but you did navigate
to the directory
>where MSDE was extracted before issuing the install
command (or, include the
>fully qualified path to the install file in the
command), correct?
>--
>Peter [MVP Visual Developer]
>Jack of all trades, master of none.
>
>.
>
Thank you for the reply. I figured it out, but what it
was I never though of. I downloaded a corrupt .exe
file. It was the same size, but when I re-downloaded it,
it will still the same size except it had WAY more files
this time after extracting.
Thanks!
|||"Culbert" <anonymous@.discussions.microsoft.com> wrote in message
news:9e0501c47907$84099910$a401280a@.phx.gbl...
> Thank you for the reply. I figured it out, but what it
> was I never though of. I downloaded a corrupt .exe
> file. It was the same size, but when I re-downloaded it,
> it will still the same size except it had WAY more files
> this time after extracting.
> Thanks!
Glad you got it worked out, and thank you for posting the resolution!
Peter [MVP Visual Developer]
Jack of all trades, master of none.
sql

can't find Enterprise Manager and Query Analyzer after setup

I downloaded the trial version of sql server 2005. but after installation, I couldnt find the Enterprise Manager and Query Analyzer. Any idea about that? Thanks.

Hi zhishan,

I believe those services can be configured from control panel (turn windows features on or off). Check the boxes next to enterprise manager services and query analyzer, then ok, and windows wil configure and update for those services.

|||Thanks djartsinc - do you know where on the control panel has the function? I spent a long time trying to find, but couldn't...|||

Which Edition of SQL Server 2005 do you download? If it is SQL Server 2005 Express, such tool is not included. Please try SQL Server 2005 Expree with Advanced Services, which includes tools. You can get it from the same download website as SQL Server 2005 Express.

Cant connect to SQL Server 2005 with Pet Shop 4.0 : No process at other end of pipe?!

I downloaded MS Pet Shop 4.0 recently for best-practice training purposes. The installation went smoothly with a SQL Server 2005 backend. At first I had a problem authenticating the mspetshop4 user in the database, but that was solved by fixing some settings with the password policy. Now the mspetshop4 user is authenticated properly, but I came across this error instead:

Server Error in '/Web' Application.A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: System.Data.SqlClient.SqlException: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)Source Error:Line 216:Line 217: if (conn.State != ConnectionState.Open)Line 218: conn.Open();Line 219:Line 220: cmd.Connection = conn;Source File: C:\Program Files\Microsoft\.NET Pet Shop 4.0\DBUtility\SQLHelper.cs Line: 218Stack Trace:[SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +117 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +346 System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) +619 System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj) +224 System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected) +113 System.Data.SqlClient.TdsParserStateObject.ReadBuffer() +59 System.Data.SqlClient.TdsParserStateObject.ReadByte() +36 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +181 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +56 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +1083 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +272 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +688 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +82 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +558 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +126 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +651 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +160 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +122 System.Data.SqlClient.SqlConnection.Open() +229 PetShop.DBUtility.SqlHelper.PrepareCommand(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, CommandType cmdType, String cmdText, SqlParameter[] cmdParms) in C:\Program Files\Microsoft\.NET Pet Shop 4.0\DBUtility\SQLHelper.cs:218 PetShop.DBUtility.SqlHelper.ExecuteReader(String connectionString, CommandType cmdType, String cmdText, SqlParameter[] commandParameters) in C:\Program Files\Microsoft\.NET Pet Shop 4.0\DBUtility\SQLHelper.cs:127 PetShop.SQLServerDAL.Category.GetCategories() in C:\Program Files\Microsoft\.NET Pet Shop 4.0\SQLServer\Category.cs:27 PetShop.BLL.Category.GetCategories() in C:\Program Files\Microsoft\.NET Pet Shop 4.0\BLL\Category.cs:20 PetShop.Web.NavigationControl.BindCategories() in c:\Program Files\Microsoft\.NET Pet Shop 4.0\Web\Controls\NavigationControl.ascx.cs:53 PetShop.Web.NavigationControl.Page_Load(Object sender, EventArgs e) in c:\Program Files\Microsoft\.NET Pet Shop 4.0\Web\Controls\NavigationControl.ascx.cs:27 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +31 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +68 System.Web.UI.Control.OnLoad(EventArgs e) +88 System.Web.UI.Control.LoadRecursive() +74 System.Web.UI.Control.LoadRecursive() +158 System.Web.UI.BasePartialCachingControl.LoadRecursive() +61 System.Web.UI.Control.LoadRecursive() +158 System.Web.UI.Control.LoadRecursive() +158 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3035Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

Now I'm clueless. What does No process at the other end of the pipe mean?Check if SQL Server is configured to accept Local and Remote Connections (using tcp) in Surface Area Configuration Manager. Also, check to see if your SQL Server is configured to accept connections over both TCP/IP and named pipes.|||

Hi, quick searched on these forums and I found a post with excatly similar issue as yours, hope this helps:

http://forums.asp.net/thread/1072499.aspx