Feeds:
Posts
Comments

Posts Tagged ‘SQL Server Express’

SQL SERVER – Fix : Error: 15372 Failed to generate a ser instance od SQL Server due to a failure in starting the process for the user instance. The connection will be closed

Posted in Pinal Dave, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged on June 8, 2009 | 16 Comments »

Just a day ago, I was installing SQL Server Express on backup computer. I only use this computer when I have something to experiment. While installing SQL Server Express I found following error in my error log which prevented successful installation to computer. It was difficult to initially understand the problem by itself, after some try and error I found the solution.

Error: 15372, Severity: 16, State: 1.
Failed to generate a ser instance od SQL Server due to a failure in starting the process for the user instance.  The connection will be closed.

Solution for this error is fairly simple.

Fix/Workaround/Solution:

For XP:
Delete the directory “c:\Documents and Settings\username\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS ”

For Vista:
Delete the directory “c:\Users\<username>\AppData\Local\Microsoft\Microsoft Sql Server Data\SQLEXPRESS”

Reboot the system.

Watch SQL in Sixty Seconds video to Resolve Connection Error:

Reference : Pinal Dave (http://blog.sqlauthority.com)


About these ads

Read Full Post »

SQL SERVER – Difference Between SQL Server Compact Edition (CE) and SQL Server Express Edition

Posted in Database, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology, tagged , on April 22, 2009 | 10 Comments »

I often received question regarding what are difference between SQL Server Compact Edition (CE) and SQL Server Express Edition. In one line – SQL Server CE is for mobile application and embaded systems where as SQL Server Express Edition is limited feature light version of SQL Server Standard.

SQL Server Compact Edition SQL Server Express Edition
ClickOnce Deployment ClickOnce Deployment
Installed centrally with an MSI Installed centrally with an MSI
XML storage XML storage
Transact-SQL Transact-SQL
Subscriber for merge replication Subscriber for merge replication
Simple transactions Simple transactions
Database size support – 4GB Database size support – 4GB
Number of concurrent connections – 256 Number of concurrent connections – Unlimited
Privately installed, embedded, with the application
Non-admin installation option
Runs on Windows Mobile platform
Runs in-process with application
Data file storage on a network share
Support for different file extensions
Code free, document safe, file format
Remote Data Access (RDA)
ADO.NET Sync Framework
Subscriber for merge replication
Simple transactions
Runs as a service
Procedural T-SQL
Distributed transactions
Native XML, XQuery/QPath
Stored procedures, views, triggers
Role-based security

I am interested to know if my readers have used any of these servers what was the real life application for the same.

Reference : Pinal Dave (http://blog.SQLAuthority.com)

Source : http://blog.sqlauthority.com/2009/04/22/sql-server-difference-between-sql-server-compact-edition-ce-and-sql-server-express-edition

Read Full Post »

SQL SERVER – 2008 – Download Microsoft SQL Server 2008 Express with Tools Free

Posted in Database, SQL, SQL Authority, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, SQL Utility, SQLAuthority News, T SQL, Technology, tagged on February 9, 2009 | 2 Comments »

Note: Download Microsoft SQL Server 2008 Express with Tools Free by Microsoft

SQL Server 2008 Express Edition was much awaited version of SQL Server 2008. It is FREE and available to download from web.

Microsoft SQL Server 2008 Express with Tools (SQL Server 2008 Express) is a free, easy-to-use version of SQL Server Express that includes graphical management tools. SQL Server 2008 Express provides powerful and reliable data management tools and rich features, data protection, and fast performance. It is ideal for small server applications and local data stores.

SQL Server 2008 Express with Tools has all of the features in SQL Server 2008 Express, plus you can easily manage and administer SQL Server 2008 Express with a easy-to-use graphical management tool – SQL Server 2008 Management Studio Basic.

Free to download, free to deploy, and free to redistribute as an embedded part of an application, SQL Server 2008 Express with Tools is the fast and easy way to develop and manage data-driven applications.

Download Microsoft SQL Server 2008 Express with Tools Free

Abstract courtesy : Microsoft

Reference : Pinal Dave (http://blog.SQLAuthority.com)

Read Full Post »

SQLAuthority News – SQL Server Express 2008 Downloads

Posted in Software Development, SQL, SQL Authority, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology, tagged on August 27, 2008 | 5 Comments »

Microsoft SQL Server 2008 Express with Tools

Microsoft SQL Server 2008 Express with Tools (SQL Server 2008 Express) is a free, easy-to-use version of SQL Server Express that includes graphical management tools. SQL Server 2008 Express provides powerful and reliable data management tools and rich features, data protection, and fast performance. It is ideal for small server applications and local data stores.

Download Microsoft SQL Server 2008 Express with Tools

Microsoft SQL Server 2008 Express with Advanced Services

Microsoft SQL Server 2008 Express with Advanced Services (SQL Server 2008 Express) is a free, easy-to-use version of SQL Server Express that includes a graphical management tool and powerful features for reporting and advanced text-based searches. SQL Server 2008 Express provides powerful and reliable data management tools and rich features, data protection, and fast performance. It is ideal for small server applications and local data stores.

SQL Server 2008 Express with Advanced Services has all of the features in SQL Server 2008 Express, plus you can:

* Easily manage and administer SQL Server 2008 Express with a easy-to-use graphical management tool – SQL Server 2008 Management Studio Basic.

* Issue full-text queries against plain character-based data in SQL Server tables. Full-text queries can include words and phrases, or multiple forms of a word or phrase.

* Run SQL Server Reporting Services reports on local relational data.

Download Microsoft SQL Server 2008 Express with Advanced Services

Abstract courtesy : Microsoft

Reference : Pinal Dave (http://blog.SQLAuthority.com)

Read Full Post »

SQL SERVER – 2005 NorthWind Database or AdventureWorks Database – Samples Databases

Posted in Pinal Dave, SQL, SQL Authority, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged , on May 23, 2007 | 70 Comments »

SQL Server 2005 does not install sample databases by default due to security reasons.I have received many questions regarding where is sample database in SQL Server 2005. One can install it afterwards. AdventureWorks and AdvetureWorksDS are the new sample databases for SQL Server 2005, they can be download from here.

After installing sample databases the second most asked question is WHERE IS NORTHWIND?

Northwind database was the best sample database for SQL Server 2000. Since I started to work with AdventureWorks of SQL Server 2005, I like AdventureWorks as much as Northwind. Northwind is not the best database due to few new features of analysis and reporting service of SQL Server 2005. MSDN Book On Line (BOL) uses the AdventureWorks in all of their example and it makes it easy to follow up if proper understanding of AdventureWorks schema is developed. However, SQL Server Compact Edition uses Northwind as sample database.

If you still want to download and install Northwind and Pubs in SQL Server 2005, download them from here.

My recommendation : Start getting familiar with AdventureWorks.
UPDATE: SQL SERVER – 2005 NorthWind Database or AdventureWorks Database – Samples Databases – Part 2 explains how to restored NorthWind to SQL Server 2000 using images.

Reference : Pinal Dave (http://blog.SQLAuthority.com)

Read Full Post »

« Newer Posts