cant start services

Sorry for the newbie question here:

I've just installed VS.NET and have installed MSDE. All has gone well so far. I followed the instructions for setting a db password during install and the installer seemed to do its job. The SQL Server Service Manager runs in the taskbar when I reboot but the status icon is a white circle... The status bar indicates that it is not connected.

How do I connect to the server?Sorry guys... I found the answer to my own question...

had to set the server to <myComputerName>\VSDOTNET

Like I said... NEWBIE question!

Cant see stored procedures

Hi,

Can anyone help me. I've created a stored procedure in sql server and I'm trying to run it from my asp.net page. On Database Explorer I can't see it, or any for that matter, however I can see tables in the same schema.

Also I can't see it when I build a table adapter either.

Can anybody help?

Thanks

Sam

My first suspicion is that you didn't succeed in creating the stored procedure as you think you have done. To allay that suspicion, can you see the proc in Sql Server Management Studio?

|||

Yes I can see it and execute it, it works fine through sql server

I'm thinking that it might be because I'm using the express versions of the software sql server studio and visual web developer. Do you think that might be limiting the functionality?

|||

No. That wouldn't limit what you can see in the Database explorer. I've just attached Northwind to SqlExpress, and can see the procs, views etc in DataBase Explorer in VWD.

Try clicking the Refresh button at the top of the Database Explorer panel.

|||

check you master database mybe you created it in default database which is usual master when you open New Query window.If it is true put line below on top of your proceureUSE [DATABASE NAME] GO

|||

As JPazgier mentioned you probably created the proc in the default master db. If so, script out the proc, drop the proc from master db, re-create it in the actual db. If that is not the case and the proc is already in the right database, then check your connection string to see if your application is connecting to the right database.

cant see server

Hi,
Twice this has happened....
WinXP Pro SP2. SQL server 2000
When I have used a third party app (.net tool) to select my sql box from the
"available list" it pauses for a while and the drop down list is empty.
I manually type the name of the server in and it goes ahead just fine.
The same happened when I just tried to create a DSN via the MS Access upsize
wizard.

Why can't 3rd parties see the server instance?

JayIf your are using TCP. Sounds like WINS is working but something is
blocking UDP port 1434.

Could be a router, firewall, XP SP2's built in firewall blocks this...

"Jay" <nospam@.*here.com> wrote in message
news:WqUsd.22789$9A.392629@.news.xtra.co.nz...
> Hi,
> Twice this has happened....
> WinXP Pro SP2. SQL server 2000
> When I have used a third party app (.net tool) to select my sql box from
> the "available list" it pauses for a while and the drop down list is
> empty.
> I manually type the name of the server in and it goes ahead just fine.
> The same happened when I just tried to create a DSN via the MS Access
> upsize wizard.
> Why can't 3rd parties see the server instance?
> Jay|||Hi Danny,
More info...

Looked at network config and it says that named pipes and tcp are the
enabled protocols.
I don't use the XP SP2 firewall. I use Kerio.
I've checked the kerio app settings and SQL is set to "ask" as opposed to
permit or deny (so I'd expect a Kerio dialogue if anything was trying?)
The server installation (in EM) is listed simply as (local).

New DSN and the server drop down box is empty but, get this!, if I type in a
period "." and click next it goes ahead no problem and the connection tests
ok!

Jay

"Danny" <istdrs@.flash.net> wrote in message
news:mzYsd.29107$Rf1.16651@.newssvr19.news.prodigy. com...
> If your are using TCP. Sounds like WINS is working but something is
> blocking UDP port 1434.
> Could be a router, firewall, XP SP2's built in firewall blocks this...
>
> "Jay" <nospam@.*here.com> wrote in message
> news:WqUsd.22789$9A.392629@.news.xtra.co.nz...
>> Hi,
>> Twice this has happened....
>> WinXP Pro SP2. SQL server 2000
>> When I have used a third party app (.net tool) to select my sql box from
>> the "available list" it pauses for a while and the drop down list is
>> empty.
>> I manually type the name of the server in and it goes ahead just fine.
>> The same happened when I just tried to create a DSN via the MS Access
>> upsize wizard.
>>
>> Why can't 3rd parties see the server instance?
>>
>> Jay
>>

can't see MSDE icon on XP pro...

hi..
for some reason i can't see the MSDE icon on the tray (it came with
Visual Studio .NET 2002)
althought the service i running i cann't access the MSDE from access
or visual studio..
Hi,
I presume you meant to say the service is running. Are you determining that
by looking in the Services applet (in Administrative tools via Control
Panel)?
If so, when you say you can't access it from Access or Visual Studio, what
error is returned?
Are there any errors in your system or application event logs? (access the
event viewer also from Administrative tools).
Regards,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Elhanan Maayan" <emaayan@.hotmail.com> wrote in message
news:ec817d75.0405122055.77a6de3@.posting.google.co m...
> hi..
> for some reason i can't see the MSDE icon on the tray (it came with
> Visual Studio .NET 2002)
> althought the service i running i cann't access the MSDE from access
> or visual studio..

Cant open Northwind

Can't open Northwind - asp.net - dataaccess-sqldatasource

I remembered doing walkthrough using Northwind. However it wasn't an http project but a file project using the development server. Northwind allowed me to add, edit and insert, and the web page looked fine.

I opened a simple project just to see whether I could get my sqlserver on the internet. (vs studio 2005, sqlserver 2005)

I created the project in http locationhttp://localhost/Northwind . I dragged a sqldatasource to the page, configuring it to display ID and ProductName. I clicked advanced, but noticed the generate insert, edit and delete were grayed out. That told me something was wrong with my authetification.

I configured my sqlserver 2005 to have integrated security.

I built the solution and website, then pressed cntl-F5. I got a login error. Nowhere did the page ask me for username and password. First questions - how do I get this to open up a web page, and how to I get it to allow me to generate insert, edit and delete statements?

dennist685

Server Error in '/Northwind' Application.
------------------------

Cannot open database "Northwind" requested by the login. The login failed.
Login failed for user 'YOUR-02910F1DF1\ASPNET'.
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: Cannot open database "Northwind" requested by the login. The login failed.
Login failed for user 'YOUR-02910F1DF1\ASPNET'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Cannot open database "Northwind" requested by the login. The login failed.
Login failed for user 'YOUR-02910F1DF1\ASPNET'.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735123
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770
System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17
System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
System.Web.UI.WebControls.DetailsView.DataBind() +4
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
System.Web.UI.WebControls.DetailsView.EnsureDataBound() +181
System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69
System.Web.UI.Control.EnsureChildControls() +87
System.Web.UI.Control.PreRenderRecursiveInternal() +41
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360

You need to allow permissions for the ASPNET account to access the Northwind database.

Cant login remotely even though membership data is present

(Sorry this was posted to VWD2005 Express by mistake)

I have created a simple project using ASP.NET 2.0 which enables a user to login. I created the login user using the Web Administration Tool in Visual Studio 2005.

I created everything locally and it worked.

Locally I have 2 databases. One containing normal data (which my site uses to populate a GridView control) and the other being ASPNETDB.MDF - which contains membership (login user) data. These 2 databases sit in the App_Data folder which is in the root of the project.

I have a remote database which is hosted in a shared environment.

This is just the one database and it appears to have all tables in the one database (membership tables and normal tables - such as the one I use to populate my GridView control).

I uploaded the website and using the Database Publishing Wizard I uploaded the database data to the shared host. I also changed the connection string to point to my remote database.

If I visit the website the GridView is populating correctly (pulling data from the remote database) but when I try to login it crashes. The error is "Access denied creating App_Data sub directory".

The membership login details for the user I created are in the remote database as I have compared the data in it to the data in my ASPNETDB.MDF local database.

If I launch from within Visual Studio 2005 then it allows me to login perfectly well.

Please does anybody know why it won't let me login when I access it via the website?

Many thanks for any help,

Graham

It seems that appropriate machine user (that is usualy NETWORK SERVICE) under which this web application is running has no write rights over App_Data subdirectory.

Check with your host if that is setup properly.

|||

Well I am pleased to say my work colleague fixed this one.

I had to change the ConnectionString name to LocalSqlServer and change my DataSource control (see below).

I had them named something else before. Please can somebody explain what is going on here and why it wasn't working before?

<connectionStrings>
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="BLAH BLAH BLAH"
providerName="System.Data.SqlClient" />
</connectionStrings>

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:LocalSqlServer %>"

Many thanks.

|||That's because LocalSqlServer is the connection string used by?default security providers. Take a look at this article for details:

http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx

Can't install SQL Server 2005 Standard on Windows Server 2003

--
SQL Server 2005 Setup has detected incompatible components from beta
versions of Visual Studio, .NET Framework, or SQL Server 2005.
(Full text of dialog below.)
--
Well, thanks guys, for narrowing it down for me with such precision. :-\
Yes, I did have Beta components installed at one point, but I've removed
them all. I've looked through Add/Remove Programs and I don't see any Beta
products left to uninstall. How can I find out what exactly is blocking my
install?
Thanks for your help!
- Joe Geretz -
TITLE: Microsoft SQL Server 2005 Setup
--
SQL Server 2005 Setup has detected incompatible components from beta
versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or
Remove Programs to remove these components, and then run SQL Server 2005
Setup again. For detailed instructions on uninstalling SQL Server 2005, see
the SQL Server 2005 Readme.
For help, click:
http://go.microsoft.com/fwlink?Link...rform%400x11190
BUTTONS:
OK
--OK, I found it.
It was the SQL Server Setup Support Files, must have been left over form a
previous Beta install. Tricky, because it wasn't titled as Beta in the Add /
Remove Programs listing.
- Joe Geretz -
"Joseph Geretz" <jgeretz@.nospam.com> wrote in message
news:%23P$1CbOaGHA.3896@.TK2MSFTNGP05.phx.gbl...
> --
> SQL Server 2005 Setup has detected incompatible components from beta
> versions of Visual Studio, .NET Framework, or SQL Server 2005.
> (Full text of dialog below.)
> --
> Well, thanks guys, for narrowing it down for me with such precision. :-\
> Yes, I did have Beta components installed at one point, but I've removed
> them all. I've looked through Add/Remove Programs and I don't see any Beta
> products left to uninstall. How can I find out what exactly is blocking my
> install?
> Thanks for your help!
> - Joe Geretz -
> TITLE: Microsoft SQL Server 2005 Setup
> --
> SQL Server 2005 Setup has detected incompatible components from beta
> versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or
> Remove Programs to remove these components, and then run SQL Server 2005
> Setup again. For detailed instructions on uninstalling SQL Server 2005,
> see the SQL Server 2005 Readme.
>
> For help, click:
> http://go.microsoft.com/fwlink?Link...rform%400x11190
> --
> BUTTONS:
> OK
> --
>

Can't install SQL Server 2005 Mobile Edition Server Tools Beta 1

I'm working with VS.NET 2005 Beta2 and SQL Server 2005 April CTP. My
SQL Server 2005 installation was more or less full, that is, I
installed everything related to Client Connectivity. I was bound to
build a merge replication scenario when I've noticed I needed "SQL
Server 2005 Mobile Edition Server Tools Beta 1".
Download the installer and execute it, obtaining the following error:
"You must first install the Replication Components for SQL Server 2000
SP 3a or higher or the SQL Server 2005 Client Connectivity Components."
What is the problem here if I have installed all Client components?
Any help will be greatly appreciated.
Instead of downloading "SQL Server 2005 Mobile Edition Server Tools
Beta 1" from Microsoft, which still warns me that I cannot replicate
with SQL Server 2005 because I don't have Client Connectivity
Components installed, I finally read this on MSDN2:
http://msdn2.microsoft.com/en-us/library/ms171908
The setup file is "sqlce30setupen.msi", located at "C:\Program
Files\Microsoft SQL Server\90\Tools\binn\VSShell\Common7\IDE". This
setup process went ok and did not warn me about anything.
Hope it helps people having the same problem.
PS: How does MS redirect developers to download Server Tools Beta 1 in
order to setup replication and then setup fails or warns the user
wihout any logical reason. Incredible! Can anybody explain me this?

Can''t install Reporting Services on Vista x64

When I try to install Reporting Services on my Vista x64 machine, the following happens:
Firstly, the System Configuration Check shows a "ASP.Net Version Registration Requirement" warning. Clicking on the error message gives the extra details "Failed to find the ASP.Net Version Registration with Microsoft Internet Information Services (IIS)."On the next section, Reporting Services is greyed out and so I can't attempt to install it.I have seen many other posts on this topic, and all seem to suggest that various IIS7 features need to be enabled in the "Turn Windows Features On or Off" section. I have already tried this, and in fact now have every possible IIS7 feature turned on. No change though.

I have also installed SQL 2005 SP2. But again going back to the install disk to add Reporting Services led to the same story.

So I'm pretty much completely stuck. Can anyone help?

Hi Fagster,

It seems that these workarounds worked for other people. Could you try it, please, and let me know how is working?

For install 32 bit Reporting Services on Vista run this script before the Reporting Services installation:

cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1

For install 64 bit Reporting Services on Vista run this script before the Reporting Services installation:

cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 0

Mihaela

|||This did indeed work. I managed to post this twice so I may well be the "other people".

Thanks anyway.

RichardF
|||Worked for me to after spending a lot of time trying to get around this problem - Woo Hoo - Thanks|||

I get the error:

Input Error: Can not find script file "C:\inetpub\AdminScripts\adsutil.vbs"

When I run this script, anyone help?

|||

Turn UAC off: http://windowshelp.microsoft.com/Windows/en-US/Help/58b3b879-924d-4e08-9358-c316055d3eae1033.mspx

Follow this KB: http://support.microsoft.com/default.aspx/kb/934164

I now have SSRS on Windows Vista Ultimate. Woohhoo.

Can't install Reporting Services on Vista x64

When I try to install Reporting Services on my Vista x64 machine, the following happens:
Firstly, the System Configuration Check shows a "ASP.Net Version Registration Requirement" warning. Clicking on the error message gives the extra details "Failed to find the ASP.Net Version Registration with Microsoft Internet Information Services (IIS)."On the next section, Reporting Services is greyed out and so I can't attempt to install it.I have seen many other posts on this topic, and all seem to suggest that various IIS7 features need to be enabled in the "Turn Windows Features On or Off" section. I have already tried this, and in fact now have every possible IIS7 feature turned on. No change though.

I have also installed SQL 2005 SP2. But again going back to the install disk to add Reporting Services led to the same story.

So I'm pretty much completely stuck. Can anyone help?

Hi Fagster,

It seems that these workarounds worked for other people. Could you try it, please, and let me know how is working?

For install 32 bit Reporting Services on Vista run this script before the Reporting Services installation:

cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1

For install 64 bit Reporting Services on Vista run this script before the Reporting Services installation:

cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 0

Mihaela

|||This did indeed work. I managed to post this twice so I may well be the "other people".

Thanks anyway.

RichardF|||Worked for me to after spending a lot of time trying to get around this problem - Woo Hoo - Thanks|||

I get the error:

Input Error: Can not find script file "C:\inetpub\AdminScripts\adsutil.vbs"

When I run this script, anyone help?

|||

Turn UAC off: http://windowshelp.microsoft.com/Windows/en-US/Help/58b3b879-924d-4e08-9358-c316055d3eae1033.mspx

Follow this KB: http://support.microsoft.com/default.aspx/kb/934164

I now have SSRS on Windows Vista Ultimate. Woohhoo.

Can't install Reporting Services on Vista x64

When I try to install Reporting Services on my Vista x64 machine, the following happens:
Firstly, the System Configuration Check shows a "ASP.Net Version Registration Requirement" warning. Clicking on the error message gives the extra details "Failed to find the ASP.Net Version Registration with Microsoft Internet Information Services (IIS)."On the next section, Reporting Services is greyed out and so I can't attempt to install it.I have seen many other posts on this topic, and all seem to suggest that various IIS7 features need to be enabled in the "Turn Windows Features On or Off" section. I have already tried this, and in fact now have every possible IIS7 feature turned on. No change though.

I have also installed SQL 2005 SP2. But again going back to the install disk to add Reporting Services led to the same story.

So I'm pretty much completely stuck. Can anyone help?

Hi Fagster,

It seems that these workarounds worked for other people. Could you try it, please, and let me know how is working?

For install 32 bit Reporting Services on Vista run this script before the Reporting Services installation:

cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1

For install 64 bit Reporting Services on Vista run this script before the Reporting Services installation:

cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 0

Mihaela

|||This did indeed work. I managed to post this twice so I may well be the "other people".

Thanks anyway.

RichardF
|||Worked for me to after spending a lot of time trying to get around this problem - Woo Hoo - Thanks|||

I get the error:

Input Error: Can not find script file "C:\inetpub\AdminScripts\adsutil.vbs"

When I run this script, anyone help?

|||

Turn UAC off: http://windowshelp.microsoft.com/Windows/en-US/Help/58b3b879-924d-4e08-9358-c316055d3eae1033.mspx

Follow this KB: http://support.microsoft.com/default.aspx/kb/934164

I now have SSRS on Windows Vista Ultimate. Woohhoo.

Can't install Reporting Services on Vista x64

When I try to install Reporting Services on my Vista x64 machine, the following happens:
In the System Configuration Check, there is a "ASP.Net Version Registration Requirement" warning.
On the following section, Reporting Services is greyed out so cannot be installed.I have found many posts on this matter and all of them suggest going into "Turn Windows Features on / off" and enabling various IIS7 features. However, even though I have ticked every possible IIS7 feature the problem remained.

I have also installed SP2, but again this didn't help when I returned to the original installation.

Can anybody please help?

Could you try run the below script and install again.

For install 32 bit Reporting Services

cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1|||Worked a treat - thanks very much!

Cant install MSDE

I have tried to install MSDE 2000, first the normal version, then the
one for developers using Visual Studio .NET. Each time the installation
appears to complete, but there is no shortcut to start the program and
it's not in the Start/Programs menu. However, if I look for it in "Add
and Remove Programs" it's there.
The directory

C:\Program Files\Microsoft SQL Server\MSSQL\Binn

includes some exe files and I have tried to start them, but nothing
appears to happen. If I start sqlsrvr.exe I get a command prompt window
in which I see things like "Server Process ID is 182", "Logging SQL
server messages in file..." etc, but I have no idea how to go on from
there.
I tried installing the new 2005 Beta version but exactly the same
problem.
Why is this happening? How can I make it work?
Thanks in advance.

Bruno PanettaPS the installation probably doesn't even complete. The installation
window just disappears at some point, without saying that it completed
successfully.

Bruno Panetta wrote:
> I have tried to install MSDE 2000, first the normal version, then the
> one for developers using Visual Studio .NET. Each time the installation
> appears to complete, but there is no shortcut to start the program and
> it's not in the Start/Programs menu. However, if I look for it in "Add
> and Remove Programs" it's there.
> The directory
> C:\Program Files\Microsoft SQL Server\MSSQL\Binn
> includes some exe files and I have tried to start them, but nothing
> appears to happen. If I start sqlsrvr.exe I get a command prompt window
> in which I see things like "Server Process ID is 182", "Logging SQL
> server messages in file..." etc, but I have no idea how to go on from
> there.
> I tried installing the new 2005 Beta version but exactly the same
> problem.
> Why is this happening? How can I make it work?
> Thanks in advance.
> Bruno Panetta|||There is no UI tool for MSDE. MSDE is a database engine that can be
manipulated programmatically via the various APIs, using the OSQL command
line utility or using any of various third party utilities.

SQL 2005 Express (the product that replaces MSDE) does have a UI called
Express Manager but it's a separate download to the database engine product.
http://lab.msdn.microsoft.com/express/sql/

--
David Portas
SQL Server MVP
--|||Thanks but I'm afraid I don't understand since I'm a beginner to SQL
and am trying to install this program in order to learn it.
What should I do once I have installed MSDE 2000 in order to start
creating databases and running SQL queries?
Thank you very much.

Bruno

David Portas wrote:
> There is no UI tool for MSDE. MSDE is a database engine that can be
> manipulated programmatically via the various APIs, using the OSQL command
> line utility or using any of various third party utilities.
> SQL 2005 Express (the product that replaces MSDE) does have a UI called
> Express Manager but it's a separate download to the database engine product.
> http://lab.msdn.microsoft.com/express/sql/
> --
> David Portas
> SQL Server MVP
> --|||http://www.aspfaq.com/show.asp?id=2442

--
David Portas
SQL Server MVP
--

Can't install Express June CTP?!

Hey all, I'm trying to install SQL Server 2005 Express June CTP on a windows 2003 Web Edition Server (With SP1).

I've had an old version of the .NET 2.0 Framework installed, so I downloaded the one mentioned next to the SQL Express download (this one: http://go.microsoft.com/fwlink/?linkid=48448).

Each and every time I run the setup I encounter this error:
The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
There is not even any sort of SQL Server service in the list of services, what should I do?
Regards,

Hendrik BehrensI've also tried the same on Windows XP Professional SP2. I had to uninstall a previous version of .NET 2.0 and VWD Express/VB Express Beta 2 are installed.

I get the same error message?! - The service is not there and the setup just fails with that message.

I've had SQL Express April CTP installed on a windows 2003 Enterprise *trial*, which worked, the update to Junce CTP... right, fails with the same message.
Any proposals?|||Did you look for the log files?

-Euan|||Yes I did, and I found the problem: My windows XP Professional and Windows Server 2003 Web Edition are both german - the setup fails on non-english langauge versions with default settings, this german article describes the problem and how to solve it (for everyone else who encounters this):

http://www.microsoft.com/germany/msdn/vs2005/installvs2005beta.mspx
(basically, remove the tick "Hide advanced configuration Options" and select "Local System" as the service account, instead of "Network Service", which is the default.)

Can't Install Express because .Net Framework 2 is installed! I'm going around in circles.

I'm new to SQL Express and from the SQL Express DOWNLOAD page you need to install .NET Framework 2 then install SQL Express. After installing .NET Framework 2.0 I then attempt to install SQL Express and I get a message that SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework or SQL Server 2005. I used the Visual Studio removal tool and it took out .NET Framwork. I re-installed this and did a reboot and get the SAME ISSUE! CAN ANYONE GET ME OUT OF THIS MS loop nightmare.

Thanks! Jeff

Make sure that you uninstalled any beta-versions of SQLServer 2005 / VS / The Framework and other beta products that might have shipped the .NET 2.0 beta along with them. THen run the removal tool. THis should clean out every reference to the assemblies and evidences.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||Thanks Jens but this is a clean Win Pro 2K wkstation that NEVER had any of these products, BETA or live installed. When I ran the removal tool it took .NET 2 off and I tried to the SQL xpress install and it wanted .NET 2K. Could the site that I downloaded it from have been BETA? I would guess not as I saw no reference to it and it was a link right off the SQL Express site that mentioned I needed this first anyway. I'm still baffled. I also looked at a full SQL Server 2005 disk from MS and it also wanted the same .NET 2 loaded before an install. I only need SQL Express for the app. I'm running. Thanks Jeff|||

This issue has been answered several times in this forum. Check out my answer to this post for example.

Mike

|||

Thanks Mike for some direction. Again this was a clean O/S and I was simply following the instructions on the SQL Express page with no luck. I looked at the logs as you suggested and saw no real issue. Here is the summary. I looked at each log file and do not see what is causing the fuss other than an additiona of .42 to the end of the version of .NET. So I uninstalled .NET again and re-downloaded it from the same site and re-installed it and behold all is well.

Loaded DLL:C:\WINNT\system32\msi.dll Version:3.1.4000.2435
Product "{44568A1C-53F6-49A5-A163-CD9ADC0F76D5}" versioned 2.0.50727 is not compatible with current builds of SQL Server.Expected at least version: 2.0.50727.42

Why the old version is still floating on the links to SQL Express is yet another MS mystery to solve, GFL. I really did search the forum and did not see any answers to this.Thanks again, your log viewing saved the day! Jeff

Can't Install Express because .Net Framework 2 is installed! I'm going around in circles.

I'm new to SQL Express and from the SQL Express DOWNLOAD page you need to install .NET Framework 2 then install SQL Express. After installing .NET Framework 2.0 I then attempt to install SQL Express and I get a message that SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework or SQL Server 2005. I used the Visual Studio removal tool and it took out .NET Framwork. I re-installed this and did a reboot and get the SAME ISSUE! CAN ANYONE GET ME OUT OF THIS MS loop nightmare.

Thanks! Jeff

Make sure that you uninstalled any beta-versions of SQLServer 2005 / VS / The Framework and other beta products that might have shipped the .NET 2.0 beta along with them. THen run the removal tool. THis should clean out every reference to the assemblies and evidences.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||Thanks Jens but this is a clean Win Pro 2K wkstation that NEVER had any of these products, BETA or live installed. When I ran the removal tool it took .NET 2 off and I tried to the SQL xpress install and it wanted .NET 2K. Could the site that I downloaded it from have been BETA? I would guess not as I saw no reference to it and it was a link right off the SQL Express site that mentioned I needed this first anyway. I'm still baffled. I also looked at a full SQL Server 2005 disk from MS and it also wanted the same .NET 2 loaded before an install. I only need SQL Express for the app. I'm running. Thanks Jeff|||

This issue has been answered several times in this forum. Check out my answer to this post for example.

Mike

|||

Thanks Mike for some direction. Again this was a clean O/S and I was simply following the instructions on the SQL Express page with no luck. I looked at the logs as you suggested and saw no real issue. Here is the summary. I looked at each log file and do not see what is causing the fuss other than an additiona of .42 to the end of the version of .NET. So I uninstalled .NET again and re-downloaded it from the same site and re-installed it and behold all is well.

Loaded DLL:C:\WINNT\system32\msi.dll Version:3.1.4000.2435
Product "{44568A1C-53F6-49A5-A163-CD9ADC0F76D5}" versioned 2.0.50727 is not compatible with current builds of SQL Server.Expected at least version: 2.0.50727.42

Why the old version is still floating on the links to SQL Express is yet another MS mystery to solve, GFL. I really did search the forum and did not see any answers to this.Thanks again, your log viewing saved the day! Jeff

Cant insert and delete

Hi,

Can anyone help me? I am using MSDE 2000 with VS.NET. I can SELECT from the database but i cant insert and delete and update. Below are my code

public static int Add(string tmpSql, string connectionString)

{

oleConn = new OleDbConnection(connectionString);

oleConn.Open();

oleTran = oleConn.BeginTransaction();

try

{

oleCom = new OleDbCommand(tmpSql, oleConn);

oleCom.Transaction = oleTran;

int a =oleCom.ExecuteNonQuery();

return(0);

}

catch

{

oleTran.Rollback();

return(1);

}

finally

{

oleConn.Close();

}

}

my int a give a value of 1 but when i look at the database the data is not inserted? but my primary key of the table did increase by one. what went wrong? is it due to my configuration which dun allow my to insert and update? help. Thank you

Please some1 pls help me or send me any useful link and i will figure out my self thanks..

|||Is it possible that you need to explicitly commit your transaction inside your try block before returning? In the example code on MSDN at the link below the transaction is explicitly committed.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdataoledboledbconnectionclassbegintransactiontopic.asp

Hope this helps,
Vaughn|||oh ya how can i forget that.. thanks alot..

Cant get SQL Server 2005 to work

Hello ia m trying to install SQL Server 2005 but i am unable to run it. I installed Net Framework 2.0
Then i have tried the following files:
SQLEXPR.EXE
SQLEXPR_ADV.EXE
Then i installed Service PAck 1 for that but an error occoured during the install.

Basiclly i have no idea what i am doing here. It creates a configuration tools start menu item but it seems just like configuration. In C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn there is a file called sqlservr.exe but all it does is create a black console window and does nothing.

OS: XP Pro + SP2

How to get it to work?

Thank You

SQLEXPR.EXE is the installer for the edition SQL Express. SQLEXPR_ADV.exe is the installer for SQL Express Advanced. So if you ran both installers, you will now have two different editions on your machine. SQL Express Advanced comes with the option of installing Management Studio Express, a set of client tools available to view/edit/manage your database on your machine (or on remote machines). I'd suggest going through the Getting Started section of Books Online (the SQL documentation) for some suggested exercises.

Thanks,
Sam Lester (MSFT)

|||Thank You for Your reply.
I did not install them at the same time, i tried them both. I could not find the exe file to run the program. Is there such a thing. Ill read the getting started section also.|||

Which one did you fully install? If you installed Express, then it has no client tools (I think that's what you are searching for). If you installed Express Advanced, you have the option of installing Management Studio Express. Once this is installed, it will launch the UI-based tool that will allow you to browse through your instance.

Thanks,
Sam

cant get Reporting services

hello sir/madam

i have been installed Visual web developer 2005 express edition. with that i have been installed .net framework 2.0 and SQL server 2005. Even then i can't enabled with the reporting services. i am doing my final year projects now. i am in the conclution stage. so i hav to design reports.But without enabling with reporting services nothing i can do...

Wht will be the problem

Have a look athttp://www.microsoft.com/technet/prodtechnol/sql/2005/usingssrswithsqlexpress.mspx

If you cannot get enough information from the Technet note, please reply, and I will have a look tonight (once I can connect from my lodgings ~ 18:00 UTC)

|||

Did you get IIS working and confim that it was working, before you installed SQL Express and SQL Reporting Services?