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...
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.
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?
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?
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.....
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?
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.
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?
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.
Hi I'm pretty new to all of this. I downloded a starter kit and am a bit confised as to SQLExpress. I have SQL Server already installed and just wondering what the option are. I am currently using Visual Web Developer Express Edition and in the config file data source is SQLExpress and can't go any further. I don't want to mess with my current setup so just want to get some sugestions first. Anyway hope this makes sense. Thanks GP
I have just created a website with membership just using the standard SqlExpress auto generated file Everything works fine until I upload it to webspace :( I get the following 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 don't have SQL Server 2005 :(
if my SQl server/COnnection is "SQL EXPRESS"..Im using an Import name "Import System.SqlClient" on every web form that i have... as well as other SQl command name like "SQLConnection,SQLCommand etc..."is this the correct that im using all sqlcommand in my webform??? well sorry for this im just new..and one more thing..can i include Ado.net on it if my connection is "SQLEXPRESS" just i said? Thanks for the answer....
I am new to this forum . I am running through few problems for sqlserver account settings .
I) My registery key entry for MSSQLserver just has a client folder . 2) My sql server configuration manager just has sqlserver 2005 services , native client configuration and 2005 network configuration.
I can't see any server name or databases under it.
3)I normally work on EMS lite so I can see my ./SQLEXPRESS as server and databases under it and i can create logins etc ..I assigned db_owner role to one of my recent created database. but when I try to connect it says :
The user is not associated with sqlserver connection.
5) i have sqlserver express service running, vss and sql server browser running.
I googled and searched for the solution and it says the authentication mode should be turned to mix mode form win authentication.
But from where. Have i missed some installation .I am able to connect to my other database from EMS.
I am trying to write an application for a MSSQL database, using SQL Express,and Visual Studio (Express edition)I tried to connect to an existing database (named testing) but to no avail.Visual Studio claims the database does not exist.Any ideas?TIA--Q: What is the difference between a mathematician and a philosopher?A: The mathematician only needs paper, pencil, and a trash bin for hiswork - the philosopher can do without the trash bin...
Installation of SP2 in step "Feature Selection" shows SQLEXPRESS unchecked and can''t be edited/checked. I tried it many times on different servers with different OSes, etc
Does it mean that SP2 for Expres Edition should be downloaded and applieŠ² separately?
Hello,I am just getting reaquainted with programming and all. I work in GIS mapping and am having diffilculty using a ASP.net internet Map site and adding records to a needed database.I would like to be able to add records to a linked SQLExpress table when the user clicks on a map location. I adapted the following code snippet from an example that does what I would like only using an .mdb file.CODE: // create connection to database var connection; connection = Server.CreateObject("ADODB.Connection"); connection.Open("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=OutdoorsExp;Data Source=NOLOGOSQLEXPRESS;"); status = "Can't access 'FishSQL' table."; // create recordset var recordset; recordset = Server.CreateObject("ADODB.Recordset"); recordset.CursorType = 1 recordset.LockType = 3; recordset.Open("dbo.FishTable", connection); status = "Can't append new record."; // append record for clicked location recordset.AddNew(); recordset.Fields("LongitudeI").Value = xco; recordset.Fields("LatitudeI").Value = yco; recordset.Update(); recordset.Close(); // release the .mdb file connection.Close();However, this does not add anything to the SQLEx table. What am I missing? I am thinking that it might have something to with the primary key.I had a table with way more columns then just lat/longs (as above) but only coded it to add data to the latitude and longitude fields. Nothing got added of course. Would have to add data to every field that doesnt allow nulls.How do I generate a random, unique ID for a primary key on the fly and for example add it to the appropriate column.Thanks you in adavnce for any insights.
hi:I set up a DSN via Adim tools, then I specify the connection string as "DSN=UserAppSample;Trusted_Connection=True".When I run my aspx page, it says: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "UserAppSample" requested by the login. The login failed. It asks for login, but I use windows authentication. So what is wrong with this? :(
** For those 20 users (or fewer) who've read http://forums.asp.net/thread/1692306.aspx, I'm sorry that I ask the same question.Like I said above, what is the limitation of SQLEXPRESS, in terms of performance and scability?I'm creating a new webboard application that will replace the old one. I intend it to handle 200 concurrent users + 70000 records (9 years of data)The current system use Microsoft Access, which is reaching it's limit in performance and size. I took a look in the SQL Server product information page : http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx.It didn't tell me what I want, like how many connections it can handle, for example.If there are limitations that might cause my application to not reach the required specification (above), I may need to switch to MySQL. I've no intention buying a licensed SQL Server 2005.Thanks in advance.PS: Why there're so few users viewing my posts? Anyone know a more active forum that may help me?
i'm using sqlexpress edition for my application and i'm wondering whether i will be able to execute the below sql statement use masteralter database <dbname> SET ENABLE_BROKER when i execute the above two lines its executing from last 30+ minutes... i'm wondering will that support in sqlexpress edition ? also, in order to use sqldependency do i have to enable broker service? thanks.
Ok it seems to me that if you use the ms recommended code to connect your apps using the app_data folder etc, that the dbs never show up in the SQLExpress manager.So I can't back them up like I can databases I connect to SQLExpress the 'old fashioned way'. Only 2 out of 6 dbs are visible in SQLExpress manager.What is the proper way to do this?Thanks,Jamey
1. Is there a white paper on how to upgrade an SQLExpress DataFile to a SQLServer attached database? 2. More importantly: Is there a way to upgrade a Beta 2 SqlExpress database to a RTM version? This lack of compatibility between beta 2 and RTM is killing me. Are their any resources for this transformation? Would be great!
As of right now I have two networked machines. I have a sql database on one that I have no problem connecting to, but I cannot connect to the database from the second machine.
From the second machine, I've come up with this connection string after all my research...
"server=[MACHINE_NAME]SQLExpress;databse=[NAME];User ID = sa;Password=[PASS]"
I keep getting a cannot connect to database error.
I know this isn't exactly SQL help, but I alwasy get great help here and thought someone might know why I'm having problems. I'm trying to map to a drive where I have a SQLExpress database on another computer within a workgroup. This is the cmd line I'm using...
NET USE * \XPPRO1SQLExpress /USER:Admin /SAVECRED /PERSISTENT: YES
I'm thinking the problem is with the * (which names the new drive with the next available letter), or that I have to use a password. Everything I've found says nothing about specifying a password though.
The error message I get says "A command was used with conflicting switches."
I just reinstalled SQLExpress and all the dbs that I created are no more linked. The files still exist in the folder where the current version stores dbs (...Microsoft SQL ServerMSSQL.1MSSQLData) but they are not "linked" (don't know the right term).
Is there anybody who could help me how to "relink" these dbs to the actual .SQLExpress instance?
Hi friends I insalled Visual Studio 2005 standard edi on XP machine. as you all know it also installs sqlexpress. i want to uninstall this sqlexpress as i also have sql server 2005 standard edition on my machine.
but i dont see any option to uninstall in add/remove programs or in start menu for sqlexpress. any ideas on this ? Thanks for your help.
I made a big mistake and deleted this program and now I cannot reinstall it. I get error messages stating that an instance is already on my machine and I need a unique name to restart install. I also get messages that say to install from the command line but I cannot get there the only access I have is error reporting. Is there any way I can make a FREASH install of this program????
I have finish building my ASP.NET site using VS 2005 and it compile just fine. Than I try hosting it to the web via IIS v5.1 and I am getting permission error from SQL express.
I have posted a detail question in experts-exchange.com and since you need a user account to even view the thread, I have taken the liberty to save the thread as .html file and host it to my ISP site. You can see the detail problem I am having here: http://users.accesscomm.ca/mm/EEdetail.html
I am going to list out some stuff I have done:
1. I have two database that need access, the ASPNETDB.mdf for user login and another database (PhotoDataBase.mdf) to store information relating to the photo I uploaded to my ASP.NET site.
2. I have already follow this How to site: http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx and setup: - TCP/IP enable, as shown here: - I have started SQL Browser service - The firewall part I am not so sure about. I am currently using Zonealarm....
3. I have installed SQL Server Management Studio Express(SSMSE) and attach the two database to it.
4. I have set SSMSE server properties to accept both SQL and window authentication.
5. I have made sure that both database "read only" setting to false
6. I have setup SQL login with User ID = SQLLOGIN
Here is the original connection in web.config: <add name="ConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|Da taDirectory|PhotoDataBase.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />
and here is the new connection I just type in web.config that replace the original one: <add name="ConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|PhotoDataBase.mdf; Server=MINGDESKTOP; Integrated Security=False; uid=SQLLOGIN; Password=XXXXXX;" providerName="System.Data.SqlClient" />
and the error i get are the follow:
Server Error in '/' Application. 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 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: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
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.
7. I did haven't done much to ASPNETDB.mdf yet and the error i get right now are the following:
________________________________________ __________________ Server Error in '/' Application. Cannot open user default database. Login failed. Login failed for user 'MINGDESKTOPASPNET'. 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 user default database. Login failed. Login failed for user 'MINGDESKTOPASPNET'. _______________________________________________
Please help! I am really running out of ideas.... and I need to have this setup in a few days....
Hi, I'm using Microsoft SQL Sever Management Studio Express. But all of a sudden, if I clicked connect button, the messageBox pops up and it doesn't let me connect. It says "TITLE: Connect to Server ------------------------------
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) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
------------------------------ BUTTONS:
OK ------------------------------ I didn't have such a problem before. If someone could help to solve to this problem, I appreciate it. Thanks.
I am a novice at working w/SQL and am trying to learn on my own... I download SQLExpress and installed it. However, I received a warning message that Internet Information Systems was not installed or enabled. I checked cpanel and it was not there. Figured out that I needed to check the windows components and attempted to enable it. I was asked for my XP Pro discs (which I can't find of course) in order to load admxprox.dll. How can I get a copy of that file so I can move forward???
First of all, I am a self taught programmer, and a Sql Neophyte, and know just enough to get confused (or in trouble). I have a TabletPC app that uses SqlExpress, installing as 'Click Once'. Works great on XP, but my app comes to a screeching halt on Vista, because of the permissions/contact network administrator issue. I read Mike's post (dated a year ago, Oct 06) about using SSMSE to create a new Login with sysadmin rights for the current user. Long story short, completed it successfully, but it didn't work.
I have been browsing posts here on the subject, but I am confused. Does my Vista user need to install SP2? Will that fix the problem? I am sorry, but some of the posts on this subject are over my head.
Could I prevail on one of the moderators to point me in the right direction, or to explain in v-e-r-y b-a-s-i-c terms what I need to do to help my Vista users access my SqlExpress DB?
I had sql express and microsoft express accounting working fine on xp. When I updated to vista and reinstalled sqlexpress with sp1 and management express sp1, I can not get the server to register. Any command I click gives error message "this type of initializer <module> threw and exception". Also when I tried to install accounting from office 2007 cd, will not install giving same message. Ihave uninstalled and reinstalled sql express w sp1 several times with no success. I can find no reference to this error message anywhere. Anybody got an idea where I can do to get this to work properly? Thanks in advance.
