[tut]How to setup Mssql 2005 Express on Windows 7

[WRECKE]

Ok below are the following steps into setting up your Mssql 2005 server Express addition accurately with Windows 7 64 bit Operating systems.

Step 1: Download Mssql 2005 Express edition

• Mssql 2005 Express

Step 2: Install Mssql 2005 Express edition using the following steps

1. Check I accept the licensing terms and conditions and click next
2. Click Install
3. Then click Next
4. When the server installation Wizard comes up click next
5. Once the System Configuration is completed Click Next
6. Next enter your name and company (company isn't required)
7. Make sure Hid advanced configuration options is checked and then click next
8. Next screen you will see a list with the following: Database Services, Client Components, Connectivity Components, and software development kit. Now click on each Red X and then click Will be installed on local hard drive. Then click next.
9. Next is Instance Name, choose Default instance then click next
10. Next is Authentication Mode, click Mixed mode and enter your shaiya password then click next
11. Next are configuration Options uncheck all and then click next
12. Error and Usage Report Settings, make sure none are checked and click next
13. Next click install

After the installation open the SQL Server Configuration Manager and follow these steps:

1. Click on SQL server 2005 Network Configuration. Then on the right double click Protocols for MSSQLSERVER
2. Next enable all protocol names by right clicking them and clicking enable
3. Now Double click on TCP/IP and click the ip addresses tab at the top
4. Here you will see a list of ip's. On IP4 set it to Enabled and for the ip address put your local IP address. Make sure the port is 1433. Make sure all the rest of the IP's are Disabled. Apply your settings.
5. Next in your Configuration manager click on SQL Native Client Configuration. Then on the right double click Client protocols
6. Now make sure all of these are enabled as well by right clicking on each and selecting enable.
7. Next Click on SQL Server 2005 Services
8. Next double click on SQL Server (MSSQLSERVER)
9. Next, under the Logon tab change your built in account from Network services to Local system, then click apply.
10. Next do same for your SQL Server Browser
11. Your all done

If you have any questions or need help please let me know here. thanks

[rafal622]

Did u try SQL 2008?
And use version Standart, bc ur any other version not work with server. Trust me i had same problem some days ago
I using SQL 2005 Standart but on XP Pro.

[WRECKE]

I use windows 7 64 bit with SQL 2005 Express and my server works like a charm. Its all in how you set it up throught your network and firewall.

[kb3rcl]

When I try to change the Server Browser from Network to Local System I get a message stating

"The Service cannot be started, either because it is disabled or because it has no enabled devices associated with it. [0x80070422]"

Is this normal, or possibly because I have not installed the shaiya server yet? Any ideas?

Thank you in advance.

[Polypropylen]

i think it's for pserver right?
#moved
#added to the important topics

[zeroxx2x]

strange i had to run it in compabilty mode to get it installed ,
Windows 7 Ultimate , 32 bit

[ruhi123]

hi .. i use windows7 64 bit system . wen i click on sql server(MSSQLSERVER) and change built in acc to local system . it says process terminated unexpectedly .. and even sql browser doesn go well .. can u please help me out ..

[13latrix]

Originally Posted by ruhi123

hi .. i use windows7 64 bit system . wen i click on sql server(MSSQLSERVER) and change built in acc to local system . it says process terminated unexpectedly .. and even sql browser doesn go well .. can u please help me out ..

You're best bet is to run in 32 bit mode. It's much more stable. I too can verify that MsSql epress works fine with EP 3/4 for instalation. However there are many scripts to be fixed and things you will want to alter. Enjoy the headaches.

~Phish

[XXXShaiyaXXX]

everything works fine till step 9 after i klick default instance then next i cant enter a password or find the autenthication mode.

[ProfNerwosol]

It's best to use MSSQL 2008 with Vista and Win7. MSSQL 2005 is know to have compatibility issues if not updated.

[XXXShaiyaXXX]

Ok and i can use that guide on 2008 Version too and where can i get it?

EDIT: Ok i got it now but after creating the Account Shaiya the Installation Window is closed and i cant continue installation. I get this.



Account Shaiya and Password Shaiya123 ( tried shaiya123 too)

[sunder702]

your better off using the built in NT AUTHORITY\SYSTEM and then using the config_sql script thats in the batch folder. and like I've said in a previous post, to save some headaches, install it as a named instance with the instance name of MSSQLSERVER

[ProfNerwosol]

Originally Posted by sunder702

your better off using the built in NT AUTHORITY\SYSTEM and then using the config_sql script thats in the batch folder. and like I've said in a previous post, to save some headaches, install it as a named instance with the instance name of MSSQLSERVER

My gosh. Named Instance is a receipt for disaster. Lots of people don't understand the simple sentence "CHOSE DEFAULT INSTANCE" while installing MSSQL and then come here asking 'Why is my server not working?'. I gave explanation to it once, search my posts. Don't choose Named Instance unless you know how to set up MSSQL for Shaiya Server to connect to it.


Plus XXXShaiyaXXX, goddamit go and ask Microsoft why is their product unable to install on your system!

[TakeOver82]

Hello ,,

I have a problem ....


If i try to install mey shaiya server i get a text with tells me that my remote is not activatet....

but i have allready activeted it...

pls help

firewall is open

i use a router

lankabel

and windwos 7

[TakeOver82]

Hello guys


i have a prob ...

if i try to install the server it says that myssql is not ready for remoteconnection...

I use win 7 64bit

Router - Netgear

can u help me please to get connection ??