How to install sql server 2005?

-
Steps to install sql server 2005 can be found at:

http://articles.techrepublic.com.com/5100-10878_11-6102265.html

You need to install the following,
1. Windows installer
Note: No need of installing windows installer for server 2003 sp1,sp2
2. SQLEXPR.EXE
3. SQLServer2005_SSMSEE.msi

Download links
SQLEXPR.EXE
SQLServer2005_SSMSEE.msi

If you get client systems error 'doesn't allow remote connections' then
follow these steps,
start -> programmers -> microsoft sql server 2005 -> configuration tools ->
sql server surface area configuration

#1 enable sql browser services
#2 set the appropriate type for remote connections
#3 Stop and start modified services.

Happy Installation.

Comments

Post a Comment

Popular posts from this blog

Email Validation for SharePoint list column

-
Image
Please use the below formula in [Column validation] of the list column edit section. Please replace the [Email] with your column name. Formula: --------------------------------------------------------------------- =AND(     ISERROR(FIND(" ", [Email],1)),     IF(ISERROR(FIND("@", [Email],2)),         FALSE,         AND(             ISERROR(FIND("@",[Email], FIND("@", [Email],2)+1)),             IF(ISERROR(FIND(".", [Email], FIND("@", [Email],2)+2)),                 FALSE,                 FIND(".", [Email], FIND("@", [Email],2)+2) < LEN([Email])             )   ...
Read more

Create a SharePoint group and add users using JSOm

-
Below code will create a sharegroup and adds login user and a static user to the group.    <div>       <h1>Create SharePoint Group </h1>       <br />       <input id="btnCreateCustomGroup" type="button" value="Create SPGroup" />     </div>     <script src="/Style%20Library/Scripts/jquery-1.12.1.js"></script>      <script src="/_layouts/15/sp.js" type="text/javascript"></script>     <script src="/_layouts/15/SP.RequestExecutor.js" type="text/javascript"></script>     <script src="/_layouts/15/SP.search.js" type="text/javascript"></script>     <script type="text/javascript">     $(function() {       $('#btnCreateCustomGroup').click(btnCreateCustomGroup_Click);  ...
Read more

SP, UDF and VIEW

-
SPs are Databse subroutine used to perform tasks within the database, whether it be to INSERT, UPDATE, DELETE, SELECT, send return values, send output parameters, send e-mail, call command line arguments, encapsulate business logic, enforce data integrity, or any combination thereof. They are compiled when first run, and the query plans are stored and cached by SQL Server's optimizer, and those cached plans are swapped out depending on frequency of usage. View: • To hide the complexity of the underlying database schema, or customize the data and schema for a set of users. • To control access to rows and columns of data. • To aggregate data for performance. UDFS: Set of statements which must return an object considered as function. In general, UDFs can be a serious source of performance issues. Also, UDFs cannot be used for DML operations (INSERT/UPDATE/DELETE), cannot use non-deterministic functions, cannot use dynamic SQL, and cannot have error-handling (e.g. RAISERROR)....
Read more