SqlExpress / Sql Server 2000
May 9, 2008
Hi Guys,
Hope you don't mind. I have put this in a different forum and although I appreciate the help, I'm not getting the answers I need and I am running out of time.
I have developed a web app in Visual Studio 2005. When I choose "view in browser" default.aspx from within Visual Studio it works perfectly. If I go directly to Internet Explorer and type in http://localhost/testapp it gives me an error of:
"Server Application Unavailable The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.
Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur."
This is because in IIS Virtual Directory for TestApp if I choose the asp.net tab and the choose "Edit Cofiguration" Button in the Connection String Manager LocalSqlServer is set to "data source=.SQLEXPRESS;Integrated Security=SSPI; AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true"
Which is making it use SQLExpress. If I Type "http://localhost:1323/testapp" it works because SQLExpress is still running. I want to be able to type "http://localhost/testapp" and it uses Sql Server 2000 How do I get it to do that.
I appreciate any help you can give.
Best Regards,
Steve.
Steve
Steve
View 1 Replies
ADVERTISEMENT
Jul 22, 2006
To be as brief as possible:I had Visual Studio 2005 installed with SQLExpress 2005. worked reallll good :) I needed to convert an excell spreadsheet to SQL, so I migrated it to Access. Then the upsizing wizard would not/could not create an sql table with the data. Just would not take the data when the table was created. Argh.FINALLY figured out that the SQLexpress 2005 doesn't come with import/export.So I uninstalled the sqlexpress and installed SQL 2000 - Developer. Veeola, able to convert and created the table I needed.Now Visual Studio 2005 won't let me touch the sql file, says it requires sql server express 2005.My ISP does not support SQL 2005 yet. Is there anyway to get Visual Studio 2005 to work with SQL 2000 (only?)If I install SQLExpress over again, will it create problems when I go to publish my website, and more importantly right now, will anything bad happen when I reinstall sql express, or do I need to uninstall SQL 2000 first? Thanks...
View 2 Replies
View Related
Sep 21, 2007
Some thread searches here say conversion (downgrade) of a SqlExpress database to Sql Server 2000 is trivial. I haven't yet figured out an efficient way of doing so beyond using someone's Database Publishing Wizard utility (http://www.codeplex.com/sqlhost) to create a sql 2000 compatible script, replete with schema *and* data, then running that script against the Sql 2000 database (freshly created without any structure). I've done this successfully with smaller databases, but the larger ones really tax and drain the server resources and scripts have failed with "out of memory" errors. We're putting more memory in the Sql 2000 server, which may avert memory errors, but there's still the issue of server load. Has anybody since come up with or know of a better method that's quicker, more efficent and less drain on the server?
TIA,
Rick
View 1 Replies
View Related
Jul 1, 2006
Hi All,I've been struggling with this for hours...Could someone please advise me on how to convert my current File based SQL Server Express website to a Server based SQL Express one.Particularly interested in what I need to do in the SQL Express management tool, changes I need to make the projecvt itself and changes needed to get IIS to understand things have been changed.Thanks,Martin.
View 1 Replies
View Related
Jan 14, 2008
I have sqlexpress 2005 on my local machine - but my hoster has sql 2000 - so i used the DB publishing wizard to create the script and sent it over to them - they are now saying that they need a .bak file in 2000 to host my database - is this a bunch of horse hockey or not?
if this is legit - any ideas on how I can create a .bak 2000 sql from sqlexpress 2005?
many thanks
View 5 Replies
View Related
May 28, 2008
Hi All! i have a database in SQLEXPRESS 2005 but i need to this Database in SQL 2000...there is any way to move data from sqlexpress 2005 to sql 2000.... please help me.....
View 4 Replies
View Related
Mar 13, 2007
I can't start SQLEXPRESS.
The SQL ERRORLOG shows: Error is 3414, Severity 21, State 2 and says: "An error occurred during recovery, preventing the database 'model' (database ID 3) from restarting." Just prior to this, I get a warning: "did not see LP_CKPT_END".
Any thoughts why this might be and how I can fix this?
View 3 Replies
View Related
Sep 21, 2006
hiya,
I have sqlExpress and sqlServerManagementStudio on my XP pro box.
Will the installation of sqlExpress (Advanced Services) cause any problems?IS thereanything that I shold be aware of in advance?
many thanks,
yogi
View 3 Replies
View Related
Jan 19, 2007
Hi All,
I have created an installation application which will install the application with SQL Express and .NET Framework 2.0.
If i install this application in a Fresh system(i.e which is not having SQL Express), it is installing the application with new database instance successfully.
But if i try to install the same in a system which is already having SQL Express, throwing "Object reference exception" because it is not able to create the new database instance.
Can anybody help me out .
Regards,
Doppalapudi.
View 2 Replies
View Related
Mar 21, 2006
Because of numerous problems trying to get sqlexpress working, I uninstalled it with the intention of reinstalling (via Add or Remove Programs). However, now when I try to reinstall it, I get a message that the I am not making a changes so it won't let me install it.
I do have sql server 2005 developer's edition installed; is that the reason? and does that mean I cannot have both installed on the same machine?
View 1 Replies
View Related
Sep 26, 2007
Can these two exist side by side? I have SQL Server 2005 (possibly installed when I installed Orcas beta 2?). Now I cannot connect to SQLEXPRESS with error Cannot Login to Default DB - error 4064. Please help!!
Neal
View 4 Replies
View Related
Aug 29, 2006
I have a small ASP.NET 2.0 that uses an instanse of SQLExpress. The connection string looks like this:
<connectionStrings>
<add name="DatabaseConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
It works fine when I use it in file system. When I copy it to the server ( IIS6 on Windows Server ) it gives me an error:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
I tried changing the path to the local path on the server but it did not help.
Any help would be greatly appreciated.
View 1 Replies
View Related
Nov 22, 2006
Hi.
I have XP with SP2. Install SQLExpress because I need test my system work in this plataform. The system used database in SQL Server. And try test uses SQLExpress.
The system work in my computer, I have not problem... but when the other client try to access to my computer...not the system. They cannot see me. I made ping to my computer this responsed, but in the other computer is not responed. The first instance had access, but when try access with the System the comunication lost. And now nobody can see my computer but i can see every one.
Check the access in secpol.msc in Local Policies | Access this computer form the network. And I have the group everyone, administrators.
Do you have any idea, what happed?
Thanks
View 1 Replies
View Related
Nov 16, 2007
I have web app and it is workin perfectly when i hawe SqlExpress started even if my database is in SqlServer (is that maybe that i did try membership provider if so how can i remove membership.) so i dont know how to solve this problem without using SqlExpress..
Can some one pleas help me.
"1.0"?>
"system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35">
"scripting" type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35">
"scriptResourceHandler" type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="MachineToApplication"/>
"webServices" type="System.Web.Configuration.ScriptingWebServicesSectionGroup, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35">
"jsonSerialization" type="System.Web.Configuration.ScriptingJsonSerializationSection, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="Everywhere"/>
"profileService" type="System.Web.Configuration.ScriptingProfileServiceSection, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="MachineToApplication"/>
"authenticationService" type="System.Web.Configuration.ScriptingAuthenticationServiceSection, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="MachineToApplication"/>
"sqlcon" connectionString="SERVER=MySQLSERVERSQL7557;DATABASE=SFE;UID=sa;PWD=;Timeout=10000;MultipleActiveResultSets=true">
"Forms">
"asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
"true" to insert debugging
symbols into the compiled page. Because this
affects performance, set this value to true only
during development.
-->
"true">
"System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
"System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
"CrystalDecisions.CrystalReports.Engine, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
"CrystalDecisions.ReportSource, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
"CrystalDecisions.Shared, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
"CrystalDecisions.Web, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
"CrystalDecisions.ReportAppServer.ClientDoc, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
"CrystalDecisions.Enterprise.Framework, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
"CrystalDecisions.Enterprise.InfoStore, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
"*" path="*.asmx"/>
"*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
"*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
"GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" validate="false"/>
"GET" path="CrystalImageHandler.aspx" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
"ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
"false"/>
"ScriptModule" preCondition="integratedMode" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
"WebServiceHandlerFactory-Integrated"/>
"ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
"ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
"ScriptResource" preCondition="integratedMode" verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
"true" inheritInChildApplications="true">
-->
Sorry for my bad english
View 2 Replies
View Related
Jun 12, 2008
I have SQL Express installed on my machine. I can access it with MACHINE_NAMESQLExpress but not .SQLExpress Because of this, I cannot add a .mdf to the App_Data folder of one of my projects (I assume) because it says "cannot locate server/instance specified".
View 4 Replies
View Related
Sep 7, 2006
I am using a virtual dedicated server to host sqlexpress at a remote site. I can't get the connection from MS SQL Server Management Studio Express to connect over the Internet. I only have the box IP address (xxx.xxx.xxx.xxx) and have tried various forms of xxx.xxx.xxx.xxxsqlexpress as the server name.
Can someone point me in the right direction please?
Thanks, John
View 3 Replies
View Related
Mar 6, 2008
Good day, my apologies if thes question has been asked before, but I can't find anything with the exact same situation...
Just managed to successfully install SQL Express 2005 (in place of MSDE2000), kept the same database, which upgraded without a problem. I can connect to my local SQL server, but only if I use my full PC name, I get 'SQL server not found out access denied' and 'Specified SQL server not found' whenever I try with . or (local) or localhost.
My main issue is that I have a million and one batch files for all the features I use most to simplify my work, which now will not run as they all specify (local) instead of my PC name. Looking on the MS Support pages, I've tried various different options, none of which seem to make any difference at all.
Here is my current setup:
SQL Express 2005 - version 9.00.2047.00 - (installed with 'Default Instance', not 'Instance: SQLExpress')
Win XP Pro SP3 - version 3264
All of the following are enabled in 'SQL Server Config Manager' - Protocols for MSSQLSERVER:
Shared Memory
Named Pipes
TCP/IP
VIA
I also attempted to install the latest MDAC (version 2.8), and it tells me these components are already part of SP2.
Could anybody tell me if I am missing something, or need to install / update anything further? I am at a dead end with this now.
Thanks in advance,
Andre Greeff
View 6 Replies
View Related
Dec 26, 2006
I am trying to set-up membership options on my MS Server 2003.
I also have a Computer running MS XP Professional sp2.
With the Advanced in stall of SQLExpress - trying to establish cojnectivity on the server fails when using the ASP.NET Configuration button.
This works fine on the XP box.
On the security tab the following message apppears:
There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.
The following message may help in diagnosing the problem: Unable to connect to SQL Server database.
I've compared all settings in ssemee, surface manager etc. - all identical.
run aspnet_regsql on both machines. Added the SERVERASPNET account to SQLExpress and to the aspnetdb database.
I've enabled TCP,remote connections, named pipes etc. to no avail.
Any suggestion as to what the error could be would be most appreciated - been trying now for 3 days to get this working without any success.
View 4 Replies
View Related
May 20, 2008
Hi all, I was looking for SQL server agent object in sql express to create a new job in order to process my abandoned shopping carts in my online shopping project. If neone knows how to get this done..i wud be grateful...thanks!regards,mandeep
View 9 Replies
View Related
Jul 20, 2005
I installed SQL Server Express and SQL Server manager, then tried to start manager. SQL Service is running, but SQL Manager attempt to connect to SQL Server instance times-out even though I correctly identify instance as SQLEXPRESS? Everything seems to be normal - both SQL Server and Manager are on a single Windows XP home machine. Any suggestions. Thanks
View 16 Replies
View Related
Jun 14, 2006
This is what I sometimes want:
I have installed on a localmachine sqlexpress. Also my application is installed on the local machine.
But for the night-backup of the database I want to put the database on the company server.
Let's say the database is on: X:datamydatabase.mdf
Why cant't I attach this database with the manager of sqlexpress
Second:
I have installed on local machine sqlexpress AND also the database
Why can't I backup the file to the server like:
BACKUP DATABASE [mydatabase] to DISK=x:datamydatabase.bak WITH FORMAT
It looks I can only backup to the localmachine.
thanks a lot
Klaas
View 5 Replies
View Related
Nov 24, 2006
situation
we intalled sqlexpress on a server 2003 ...work well... named server <deval-sqlexpr>
instance name of sql is <sqlexpress>
we changed the server name to <apps-ii>
after that we cannot access the sql instance <deval-sqlexprsqlexpress>
we cannot remove (with add and remove program) that unsuable instance.
we have an instance name <apss-iisqlexpress1> and its works well
we cannot change the server name back to <deval-sqlexpr> ...the server is now the DC....
QUESTION:
is it possible to remove and clean out that instance from the server.
Thank you
View 5 Replies
View Related
Dec 20, 2006
Trying to set up a development environment on an XP SP2 machine with an installation of SQLExpress and Oracle 10g Express. Having been trying to create a Linked Server in SQL to access the Oracle EX database. Have had no luck using either Oracle driver or Microsoft driver. With Oracle driver get the following error on an openquery statement:
select * from openquery(xe,'select top 1 * from HR.REGIONS')
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "OraOLEDB.Oracle" for linked server "xe" reported an error. The provider did not give any information about the error.
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "xe".
I am mapping a Windows authenticated login to an Oracle login/password in the Linked Server setup. I can connect to the Oracle database fine using Oracle tools. Likewise, I can connect to SQL Server database just fine. I have set up the linked server using the Oracle Service Name in the TSNAMES.ora file as the Data Source in SQL Server. ('XE') What could I be doing wrong? What else can I check?
View 5 Replies
View Related
Jun 19, 2006
Q1: When I try to move a database (.mdf and .ldf file), developed with SQLEXPRESS on Win/XP to my SBS2003 server running with SQL SERVER 2005, I cannot attach the database on the server. Backup/Restore fails as well.
"Could not find row in in sysindexes for database ID=12...."
Could not open new database 'Test'. CREATE DATABASE is aborted (error 602).
I tried to copy an ad hoc db with only one table from the client to the server, same error. Similar procedure withs MSDE and SQL 2000 worked flawlessly. It seems there is something wrong with my SQLEXPRESS setup.
Anybody who can advice?
Q2. on the client with SQL EXPRESS, I switched on in the surface area configuration TCP and pipes; however SQL SERVER Management Studio on the server cannot connect te SQLEXPRESS engine on the client machine. Is this normal?
However from the client, SQL EXPRESS Management Studio can connect to the SQL SERVER 2005 engine.on the server.
Thanks, eric
View 4 Replies
View Related
Apr 1, 2006
how does one convert from sqlexpress (mdf files) to sql server 2005 and vise-versa, ie from SQL Server 2005 to SQLExpress mdf files?
View 5 Replies
View Related
Jan 10, 2007
What happens when you install a SQLEXPRESS instance on a machine that already has SQL Server 2005? Will the SQLEXPRESS still run in the limited mode or will it sense that an full standard version of SQL Server 2005 is already present and just "upgrade" itself?
On the otherhand, how do I "upgade" an existing instance of SQLEXPRESS to a full version of SQL Server 2005 standard edition without uninstalling and installing the standard edition. If I have both the instances then will the SQLEXPRESS be freed from its limits?
Thanks,
Vikram
View 6 Replies
View Related
Jul 8, 2007
Hi all,I'm having a big problem here. I can't seem to connect to a database of MSSQL Server 2005... Here is what I've did:1. Under the Server Explorer>Data Connections. Right click and choose "Add Connection..."2. Data Source was "Microsoft SQL Server Database File". Click OK.3. I browse to the database in the MSSQL.2/MSSQL/Data folder.4. Click on the "Advanced" button, and change the default DataSource from .SQLEXPRESS to .MSSQLSERVER. Click OK5. Received this error:An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default setting SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid) Only .SQEXPRESS that I was able to connect to... i've tried the solution from Microsoft, opened SQL Server 2005 Surface Area Configuration and enabled "Local and remote connections", checked the option "Using both TCP/IP and named pipes" but it didn't help. This is frustrating because I can't get the Membership provider, login to work on my host. Please help. Thank you very much,Kenny.
View 2 Replies
View Related
Oct 31, 2007
Hi all, I'm having a little trouble connecting to a SQLExpress instance on a remote domain using SQL Server Management Studio Express.I've read that by default the program is set up locally only, so have edited the Surface Area Configuration. It only gives me the option to edit 'Services and Connections' on the localhost, but have edited the Remote Connections to use TCP/IP and Named Pipes. In the Management Studio, I enter the server name, and login credentials. On the Connection Properties tab I changed the network protocol to TCP/IP though everytime I attempt to connect I get the following error message: Any help would be greatly appreciated. Rich
View 4 Replies
View Related
Dec 14, 2005
I have created a user in SQL Server Management Studio Express. However,
View 1 Replies
View Related
Jan 29, 2008
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLAlamoDB.mdf'. (Microsoft.SqlServer.Express.Smo)
--------------------------------
Hi,
I got this error while trying to restore my database (which was running on SQL Server 2005 Express Edition) onto another machine's SQL Server 2005 Express Edition.
Can anyone plz. help me out with this error.
Thanks & Regards
Trinadh P.
View 4 Replies
View Related
Oct 12, 2006
Hello allMy computer was installed with SQL Server 2005 Developer version, however, I checked the Default Web Site in Internet Information Service console and saw that the ASP.NET configuration was not correct as below."data source=.SQLEXPRESS;Integrated Security=SSPI; AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true"I have a question that can I replace the string, “.SQLEXPRESS”, with my server name and my SQL Server 2005 Developer named instance as below“DEVSERSQL2005Dev”?Thanks in advance for your help.
View 3 Replies
View Related
Sep 19, 2006
I am trying to install SQL Express, but are getting a failure. The SQLSetUp_xxxx_SQL.log contains the following information? Who can help?
Property(S): CommonFilesFolder.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128 = C:Program FilesCommon Files
MSI (s) (CC:34) [22:03:07:796]: Note: 1: 1708
MSI (s) (CC:34) [22:03:07:796]: Product: Microsoft SQL Server 2005 Express Edition -- Installation failed.
MSI (s) (CC:34) [22:03:07:812]: Cleaning up uninstalled install packages, if any exist
MSI (s) (CC:34) [22:03:07:828]: MainEngineThread is returning 1603
MSI (s) (CC:DC) [22:03:07:937]: Destroying RemoteAPI object.
MSI (s) (CC:FC) [22:03:07:937]: Custom Action Manager thread ending.
=== Logging stopped: 19/09/2006 22:03:07 ===
MSI (c) (24:40) [22:03:07:937]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (24:40) [22:03:07:937]: MainEngineThread is returning 1603
View 7 Replies
View Related
Feb 24, 2005
Hello, i have a question that the sql server 2000 is install in window 2000 server. If i want to update to window 2003. Is that any problem in sql server 2000. I am worry about whether we will have problem after update. What i need to do? Many thanks.
View 5 Replies
View Related
