vmukti sql server configuration during server installation for v1034 to v1038
DESCRIPTION
VMukti SQL Server Configuration during server installationTRANSCRIPT
![Page 1: VMukti SQL Server Configuration during server installation For V1034 to V1038](https://reader035.vdocuments.us/reader035/viewer/2022062308/55866282d8b42aea588b469e/html5/thumbnails/1.jpg)
1 of 18Copyright © 2007-2008 VMukti Solutions Pvt. Ltd.
VMukti – SQL Server Configuration during VMukti
Server Installation“Communicate, Conference & Collaborate through web & Mobile”
![Page 2: VMukti SQL Server Configuration during server installation For V1034 to V1038](https://reader035.vdocuments.us/reader035/viewer/2022062308/55866282d8b42aea588b469e/html5/thumbnails/2.jpg)
2 of 18
Server installation would ask you to install SQL Server, if your system have SQL Server its needs to be configured to run VMukti successfully.
Go to Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Surface Area Configuration
Copyright © 2007-2008 VMukti Solutions Pvt. Ltd.
STEP – 1
SQL Server Configuration during VMukti Server Installation
![Page 3: VMukti SQL Server Configuration during server installation For V1034 to V1038](https://reader035.vdocuments.us/reader035/viewer/2022062308/55866282d8b42aea588b469e/html5/thumbnails/3.jpg)
3 of 18Copyright © 2007-2008 VMukti Solutions Pvt. Ltd.
STEP – 2 The following window would open, Click to “Server Surface Area
Configuration for Services and Connections”.
![Page 4: VMukti SQL Server Configuration during server installation For V1034 to V1038](https://reader035.vdocuments.us/reader035/viewer/2022062308/55866282d8b42aea588b469e/html5/thumbnails/4.jpg)
4 of 18Copyright © 2007-2008 VMukti Solutions Pvt. Ltd.
STEP – 3 The following window would open.
![Page 5: VMukti SQL Server Configuration during server installation For V1034 to V1038](https://reader035.vdocuments.us/reader035/viewer/2022062308/55866282d8b42aea588b469e/html5/thumbnails/5.jpg)
5 of 18Copyright © 2007-2008 VMukti Solutions Pvt. Ltd.
STEP – 4 The following window would open
![Page 6: VMukti SQL Server Configuration during server installation For V1034 to V1038](https://reader035.vdocuments.us/reader035/viewer/2022062308/55866282d8b42aea588b469e/html5/thumbnails/6.jpg)
6 of 18Copyright © 2007-2008 VMukti Solutions Pvt. Ltd.
STEP – 5 Click on “Database Engine” > “Remote Connections” and select “Using
both TCP/IP and named pipes”.
![Page 7: VMukti SQL Server Configuration during server installation For V1034 to V1038](https://reader035.vdocuments.us/reader035/viewer/2022062308/55866282d8b42aea588b469e/html5/thumbnails/7.jpg)
7 of 18Copyright © 2007-2008 VMukti Solutions Pvt. Ltd.
STEP – 6 Go to “SQL Server Browser” > Services
![Page 8: VMukti SQL Server Configuration during server installation For V1034 to V1038](https://reader035.vdocuments.us/reader035/viewer/2022062308/55866282d8b42aea588b469e/html5/thumbnails/8.jpg)
8 of 18Copyright © 2007-2008 VMukti Solutions Pvt. Ltd.
STEP – 7 Click on “Stop” to stop the browser service.
![Page 9: VMukti SQL Server Configuration during server installation For V1034 to V1038](https://reader035.vdocuments.us/reader035/viewer/2022062308/55866282d8b42aea588b469e/html5/thumbnails/9.jpg)
9 of 18Copyright © 2007-2008 VMukti Solutions Pvt. Ltd.
STEP – 8 Now go to “Database Engine”, click on ”Services”.
![Page 10: VMukti SQL Server Configuration during server installation For V1034 to V1038](https://reader035.vdocuments.us/reader035/viewer/2022062308/55866282d8b42aea588b469e/html5/thumbnails/10.jpg)
10 of 18Copyright © 2007-2008 VMukti Solutions Pvt. Ltd.
STEP – 9 Click “Stop” to stop the database service.
![Page 11: VMukti SQL Server Configuration during server installation For V1034 to V1038](https://reader035.vdocuments.us/reader035/viewer/2022062308/55866282d8b42aea588b469e/html5/thumbnails/11.jpg)
11 of 18Copyright © 2007-2008 VMukti Solutions Pvt. Ltd.
STEP – 10 Click “Start” to start the database service.
![Page 12: VMukti SQL Server Configuration during server installation For V1034 to V1038](https://reader035.vdocuments.us/reader035/viewer/2022062308/55866282d8b42aea588b469e/html5/thumbnails/12.jpg)
12 of 18Copyright © 2007-2008 VMukti Solutions Pvt. Ltd.
STEP – 11 Now click on “Apply” to apply the new configurations then click “OK” to
finish the configuration settings.
![Page 13: VMukti SQL Server Configuration during server installation For V1034 to V1038](https://reader035.vdocuments.us/reader035/viewer/2022062308/55866282d8b42aea588b469e/html5/thumbnails/13.jpg)
13 of 18Copyright © 2007-2008 VMukti Solutions Pvt. Ltd.
STEP – 12 After finishing the new configuration settings, you will be prompted
following window. Close the following window.
![Page 14: VMukti SQL Server Configuration during server installation For V1034 to V1038](https://reader035.vdocuments.us/reader035/viewer/2022062308/55866282d8b42aea588b469e/html5/thumbnails/14.jpg)
14 of 18Copyright © 2007-2008 VMukti Solutions Pvt. Ltd.
STEP – 13 The following 2 steps is required for confirming successful installation and
configuration of SQL Server 2005, go to Start > All Programs > Microsoft SQL Server 2005 > SQL Server Management Studio Express.
![Page 15: VMukti SQL Server Configuration during server installation For V1034 to V1038](https://reader035.vdocuments.us/reader035/viewer/2022062308/55866282d8b42aea588b469e/html5/thumbnails/15.jpg)
15 of 18Copyright © 2007-2008 VMukti Solutions Pvt. Ltd.
STEP – 14 You will get the following window, this window shows that the SQL server
management studio is trying to connect to a SQL server. For Server type field: Select “Database Engine” For Server name field: Write the SQL server IP (SQL server IP is IP of the
PC where the SQL server is installed/running which you trying to connect like 192.168.191.2) + “\” + SQLEXPRESS
For example “192.168.191.2\SQLEXPRESS”. The Server name may be only IP address of the SQL server (Like “192.168.191.2” in case of enterprise version of SQL Server 2005), but this user guide directed to install Express version of Microsoft SQL Server 2005.
![Page 16: VMukti SQL Server Configuration during server installation For V1034 to V1038](https://reader035.vdocuments.us/reader035/viewer/2022062308/55866282d8b42aea588b469e/html5/thumbnails/16.jpg)
16 of 18Copyright © 2007-2008 VMukti Solutions Pvt. Ltd.
STEP – 14 For Authentication field: Select SQL Server Authentication For Login field: Write “sa” as per SQL server installation steps followed
previously. For Password field: Write the password you entered in the Mixed Mode
step while installing the SQL Server. Following slide shows the SQL window , SQL gets configured
![Page 17: VMukti SQL Server Configuration during server installation For V1034 to V1038](https://reader035.vdocuments.us/reader035/viewer/2022062308/55866282d8b42aea588b469e/html5/thumbnails/17.jpg)
17 of 18Copyright © 2007-2008 VMukti Solutions Pvt. Ltd.
STEP – 14
![Page 18: VMukti SQL Server Configuration during server installation For V1034 to V1038](https://reader035.vdocuments.us/reader035/viewer/2022062308/55866282d8b42aea588b469e/html5/thumbnails/18.jpg)
18 of 18
THANKS
Copyright © 2007-2008 VMukti Solutions Pvt. Ltd.