Post New Web Links

Is SQL Server Express the answer?

Posted By: Posted Date: September 10, 2010 Points: 0 Category :Sql Server

I really wasn't sure where to put this, and this seemed like a decent enough place. I'm sure like a lot of other small businesses we are in the process of moving from Visual Studio 6 and Office 2000 up to Visual Studio 2010 and Office 2010. All of our applications are run inhouse so distribution isn't a issue here as everything is "local". We are now running into the question of do we really need to use and spend money on Access. I'm going to say that 98% of our applications that use access are just using it as a database and not using Access (i.e. using C++, C# or VB as the front end). Now that SQL Server Express Edition is around would that be a better alternative for what we are doing? We do run SQL Server 2000 (moving to 2008) for our "bigger" needs but our DBA would rather keep the smaller things away from it (his choice and there is no changing his mind). We currently run 4 servers and would be able to put SQL Server Express on one of the other servers. Would this be something that would work, are there user limits I'm not aware of? Looking for input on this. Thanks everyone in advance!

View Complete Post

More Related Resource Links

Send Email from SQL Server Express Using a CLR Stored Procedure

Problem
One of the nice things about SQL Server is the ability to send email using T-SQL. The downside is that this functionality does not exist in SQL Server Express. In this tip I will show you how to build a basic CLR stored procedure to send email messages from SQL Server Express, although this same technique could be used for any version of SQL Server.

Solution
If you have not yet built a CLR stored procedure, please refer to this tip for what needs to be done for the initial setup.

connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly.

I dont have the SQL EXPRESS installed instead I have SQL Standard Edition.

I have two SQL Server instances installed.

1- UserLT (this is sql 2000)
2- UserLT\SQL2005 (this is SQL 2005 named instance)

But when i try to add a database to my VS website project I get the following error:

Connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=4925

I went in Tools>Opetions>DataBase tools>Data Connection>Sql Server Instance Name (blank for default)

and changed the "SQLEXPRESS" to "USERLT\SQL2005".

But I still get the same error message. Any ideas how i can resolve this issue?

How to connect to local instance of SQL Server 2008 Management Studio Express ?

I just installed SQL Server 2008 Management studio Express on my Vista machine.

i tried connecting to local machine using :

.\sqlexpress, (local)\sqlexpress, or .\SQLExpress, MyPCNAME\SQLExpress

nothing is working, getting this error:

-----------------------------
Cannot connect to PC-NAME\SQLEXPRESS. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
----------------------------

Just-In-Time Debugger error when opening SQL Server studio express

Hi, ÃÂ I am new to these forums; hope I am posing in the correct forum ÃÂ I have problem opening the SQL Server 2005 Management Studio Express. Getting the error below ÃÂ 'An unhandled win32 exception occurred in ssmsee.exe [5336]' ÃÂ Searched in many forums but none of the suggestions resolved my issue.. ÃÂ I have re-installed .net 2.0, upgraded to 3.5 but still no luck either ÃÂ Have re-installed SQL server management studio express again no luck ÃÂ Deleted the shell folder from both documents and settings and in registry still have the same problem ÃÂ Appreciated your suggestions to resolve this issue ÃÂ Many thanks

sql server 2005 express - don't allow to create table

i have downloaded sql server 2005 Express version from the web and use domainname\SQLEXPRESS as server name but now i can't create table seems every create by sa user, what is the password of this user or how to grand right to my window login user so that i can modify/create something in database.

Can't Create ODBC to Local SQL Server Express 2008

Hello. I have SQL Server Express 2008 SP1 LOCALLY on my Windows XP Professional SP3 box. I have databases already created in Access 2007 that I imported into SQL. Now I want to keep the front end Access forms for data entry but have them connect to the databases in SQL. What I can't seem to do is connect from Access to the SQL db's because I can't create the ODBC connection. When I try to connect, I get the following two 'Connection failed' errors: 1. SQLState: '08001' SQL Server Error: 10061 [Microsoft][SQL Server Native Client 10.0]TCP Provider: No connection could be made because the target machine actively refused it. 2. SQLState: 'HYT00' SQL Server Error: 0 [Microsoft][SQL Server Native Client 10.0]Login timeout expired Additionally, this information may help. 1. Windows firewall is turned off. 2. In SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for SQLEXPRESS, Shared Memory, Named Pipes and TCP/IP are all 'Enabled'. The order is Shared Memory (1), Named Pipes (2) and TCP/IP (3). 3. In SQL Server Configuration Manager > SQL Native Client 10.0 Configuration > Client Protocols, the above three are also 'Enabled'. The order is Shared Memory (1), Named Pipes (2) and TCP/IP (3). Double-clicking TCP/IP tells me that the default port is 1433. 4. Running "netstat -ano", I see no entries for [myIPaddress]:1433.

SQL-DMO Install on SQL Server 2005 Express Client

I am installing a Client side SQL 2005 Express that needs SQL-DMO. The Client computer does not have SQL Server 2005 Express installed. I have installed all the MDAC andÃÂ .Net 2.0. The command line I'm using to try and install the SQL-DMO and XML modules is: SQLEXPR_ADV ADDLOCAL=Tools_Legacy,SQLXML I get a message something like 'SQL Server 2005 Version does not support this install option.' How do I get SQL-DMO installed on a SQL Server 2005 Express Client computer?

Multiple XML files into SQL SERVER Express 2005

Hello. I am familiar with classic ASP and use this with MS SQL SERVER EXPRESS. I have an SQL table and want to import multiple XML files into this on a daily basis. I currently have 3 files, transferdata.vbs which loops through the XML files. FAQschema.xml which maps XML to the SQL database and test.xml shows the xml in the test file. If I run transferdata.vbs I get the following error "Error opening the data file" line 33 char 3. Microsoft Bulkload for SQL Server". My SQL table is called EnqOrd id (int), Debitor (varchar), PurchaseDate (varchar) transferdata.vbs set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad") objBL.ConnectionString = "Provider=SQLOLEDB; Data Source=XXXXXX\XXXXX; Initial Catalog=XXXX; User ID=XXXXX; Password=XXXXXX" objBL.ErrorLogFile = "E:\fuelsql\Teccom\error.log" ' Here is the path to your XML files Const path = "E:\fuelsql\Teccom\XML\" Dim Text, Title, oFile Dim fso, oFolder, oFiles, wsh ' Object variables Text = "Folder " Title = "XML Files" Set wsh = WScript.CreateObject("WScript.Shell") ' Create FileSystemObject object to access the file system. Set fso = CreateObject("Scripting.FileSystemObject") ' Get Folder object. Set oFolder = fso.GetFolder(wsh.ExpandEnvironmentStrings(path)) ' Get All Files Set oFiles = oFolder.

SQL express 2008 r2 on windows server 2003

install ends with the following error : "MsiEnumRelatedProducts failed to enumerate products with UpgradeCode='{1B117BA7-5BC1-419E-820E-7D4F3F412C7B}'. Error code: 1610."

How I can remove The Microsoft SQL Server 2008 Express installation manually.

How I can remove The Microsoft SQL Server 2008 Express installation manually ? ÃÂ Other componentsÃÂ uninstalled via Add/Remove but i cant remove SQL Server 2008 Express ÃÂ ÃÂ From Add/Remove the following is installed:Microsoft SQL Server 2008 ÃÂ I have attempted to uninstall it via the Add/Remove method and this also failed.

SQL Server 2005 Express Edition Service Pack 3 (KB955706) update is successful but repeats installin

Microsoft SQL Server 2005 Express Edition Service Pack 3 (KB955706) (update 1 of 1) This update seems to be stuck in a loop of installing, each time it successfull installs acccording to automatic updates. Then says it requires installing again straight away. This has been happening for 10 days now. I have tried a manual update from the website rather than automatic updates, no change. Any ideas why? Have posted in Windows update which is where I think the problem lies but they have suggested I post here also.

Having problems installing/setting up SQL Server 2008 Express/R2 for ASP.NET user management on deve

I'm a bit new to installing and configuring, well, just about anything regarding databases, so please bear with me. I'm currently building a couple of ASP.NET MVC 2 sites. I'm following along with the MVCMusicStore tutorial, and am trying to set up user management using ASP.NET's configuration tool. The problem is that ASP.NET can't 'see' the database. I have SQL Server 2008 installed on my laptop. It's the version which is available on the Web Platform Installer (I believe it's Express). When I try running the aspnet_sqlreg.exe program to set up my user management database, it can't tell that I'm running any version of SQL Server at all. I get an exception about 'named pipes', and some other things I don't understand at the moment. Obviously, this is all a bit over my head. Is there an idiot proof guide or tutorial available that describes, step-by-step, how to: 1. Install SQL Server 2008 on a development PC 2. How to configure it to be used by Visual Studio 2010 Professional 3. How to properly upload/modify the db on the production server with what's on the development PC Essentially, all the things that the ASP.NET tutorials gloss over. Any suggestions, links to documentation, or other nudges in the right direction would be immensely appreciated.

Microsoft SQL Server 2005 Express Edition Service Pack 3 (KB955706) - will not download.install on W

I have tried and tried unsuccessfully to get this download to install properly. I get no error message at all but it quite clearly is not working properly. This has all ready taken me hours and hours of my time with no success (after following the fixes mentioned on this site). I look forward to suggestions at to how to proceed that may actually work. Many thanks cdbc81

SQL Server Express 2008 Setup fails. Support Rule "Restart Computer" Failed

Hi, I have been trying to install SQL Server Express for most of the day now without any luck.ÃÂ Whatever I do setup fails at the stage of Setup Support Rules, Rule "Restart Computer" - Failed.ÃÂ Needles to say I have restarted (several times!) and I have triedÃÂ downloadingÃÂ ÃÂ and installing the "Advanced", "Tools" and "Basic" versions, all give the same error.ÃÂ Trying a repair does the same.ÃÂ I have been searching the net for an answer without success, any help would be MUCH appreciated. Further info: I am trying to install a stand-alone installation on to a single PC running under XP SP 3 with .NET 3.5 SP1 installed.ÃÂ The PC did have some earler versions of SQL server installed but I (?hopefully?) removed all of these through Control Panel.ÃÂ Before trying the first SQL install I installed Windows installer 4.5 and PowerShell 1.0 as per the Microsoft Instructions. Running SQL Server Configuration Manager results in an error (MMC could not create the snap-in. The snap in might not have been installed correctly).ÃÂ A directory structure for SQL server exists in "Program Files".ÃÂ Services MSC shows SQL Server (SQLEXPRESS) as Automatic Statup (not running).ÃÂ Trying to start this manually gives error 14001: "application configuration incorrect - re-install to fix" .......... Which is precisely what I'm trying to do.........:(

Please Help Installing SQL Management Studio (not Express) w/ local SQL Server Express

I have recently formatted my hard drive and over the past few days I've been reloading my software. I have installed on my machine SQL Server Express 2005 SP3. I prefer to have SQL Express running on my development machine because that is what my customers primarily use. I also have a full MSDN license, and I would need to install SQL Management Studio 2005. However, when I download the SQL Server 2005 Developer ISO from MSDN, and run the setup file I get an error message that states: Installation of Microsoft SQL Server Native Client failed because a higher version already exists on the machine. To proceed, uninstall the higher version and then run Microsoft SQL Server Native Client Setup. I would assume the problem is that the copy of SQL Server - Dev Edition that is available through my MSDN subscription is using an earlier version of SQL Server 2005 (most likely the version prior to SP1.) I would just unistall SQL Server Express 2005 SP3 and reinstall it with out any service pack updates. The problem is that I also see within my Add or Remove Programs list four SQL Server 2008 R2 entries, that I believe were installed when I installed Visual Studio Pro 2010 (they are, Microsoft SQL Server 2008 R2 Data-Tier Application Framework, Microsoft SQL Server 2008 R2 Data-Tier Application Project, Microsoft SQL Server 20

SQL Server CE in Management studio express

Hello,I am trying to connect to sql server CE trough SQL Management studio express. But it seems like it only wants to connect to an SQL server express instance. Does SQL server CE needs to run as a server? because I can't seem to be able to just connect to a file. Does Anyone know how to connect to SQL CE?Thanks!Greetings,Mark

SQL Server Express 2005 SP3 Bootstrapper

Hi Guys,I am currently in the process of creating a bootstrapper for SQL2005 Express SP3 so I can slip it into a Visual Studio 2008 setup project.Here's what I did:1) I copied the SqlExpress-SP2 folder (C:\Program Files\Microsoft SDKs\Windows\v6.0A\Bootstrapper\Packages\SqlExpress)ÃÂ into a new folder (C:\Program Files\Microsoft SDKs\Windows\v6.0A\Bootstrapper\Packages\SqlExpressSP3)2) I replaced the eula.txt and sqlexpr32.exe with the new SP3 ones.3) I changed the following in product.xml:<Product xmlns="http://schemas.microsoft.com/developer/2004/01/bootstrapper" ProductCode="Microsoft.Sql.Server.Express.9.3">4) I changed the following in package.xml:<PackageFile Name="sqlexpr32.exe" HomeSite="SqlExprExeSP3" PublicKey="3082010A0282010100A2DB0A8DCFC2C1499BCDAA3A34AD23596BDB6CBE2122B794C8EAAEBFC6D526C232118BBCDA5D2CFB36561E152BAE8F0DDD14A36E284C7F163F41AC8D40B146880DD98194AD9706D05744765CEAF1FC0EE27F74A333CB74E5EFE361A17E03B745FFD53E12D5B0CA5E0DD07BF2B7130DFC606A2885758CB7ADBC85E817B490BEF516B6625DED11DF3AEE215B8BAF8073C345E3958977609BE7AD77C1378D33142F13DB62C9AE1AA94F9867ADD420393071E08D6746E2C61CF40D5074412FE805246A216B49B092C4B239C742A56D5C184AAB8FD78E833E780A47D8A4B28423C3E2F27B66B14A74BD26414B9C6114604E30C882F3D00B707CEE554D77D2085576810203010001"/>......ÃÂ ÃÂ ÃÂ <Strings>ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ <String Name="DisplayNam


Categories:

ASP.Net	Windows Application	.NET Framework	C#	VB.Net	ADO.Net
Sql Server	SharePoint	Silverlight	Others	All