http://go.microsoft.com/fwlink/?LinkId=140820
http://go.microsoft.com/fwlink/?LinkId=140820
MIKE IN NYC
The above link is for the FULL Version of SQL (PAID)
The FREE version is SQL EXPRESS
FREE VERSION IS HERE
http://www.microsoft.com/express/sql/download/
http://www.asp.net/learn/sql-videos/
HOW TO INSTALL SQL - WATCH MICROSOFT SQL VIDEO
- 114
- 906
- 6/29/2009
- United States
If you use the free version. you may not be able to logon in using sql mode. fix. I forgot many people don't know why they can't connect afterward. Bad microsoft for not telling. So Paranoid of hackers everythings locked down by default.
(yes there right!)
SQLEXPRESS
During install make sure you choose "MIXED mode not Windows Authentication Mode". its ok if you choose windows mode too but see below if you installed using windows auth.
If you chose Windows server Authentication Mode you must enable the SA account. By default you will never be able to write to your NOP database no matter what unless you do the following.
Even if you create an admin account nothing happens via SQL auth because its not enabled by default during installation.
Open Microsoft SQL Server 2008 Management Studio
1) Create an account in MIXED Mode =(anything via internet connection is "SQL SERVER AUTHENTICATION").
HOW? by logging on used plain old Windows auth go to security directory>logins>rightclick >create new login. This is so simple yet you still can't connect using sql mode. WHY?
You can give your user name at least "DBO" permissions as database owner. If you have a hard time just enable all permissions!!! then deactivate permissions!!! later after connection. You should create two accounts one a super admin permission with all permissions, and another you use to connect over the internet(incase you get hacked they can't delete,remove etc)
Now thats done.
Close SQL Server Management Studio
Open via Windows Auth
Right click on the TOP directory called (Name of your server\SQLEXPRESS) > properties
Go to security directory on left side
AH haaaaaaaaaaa
SERVER AUTHENTICATION
check SQL Server and Windows Authentication Mode
That's almost it!
EITHER REBOOT OR RESTART ALL SERVICES RELATING TO "SQL" (wheel icon looks like a gear)
try to login using SQL MODE
You better be Good to go Now.
Now, if you want to get your databse up and running keep listening......./reading
To get Permissions to use NOP Commerce for users via the internet. www.mystore/store
YOU MUST ENABLE SQL BROWSER
1) services (wheel icon) auto startup type/in sql configuration manager > "sql server services" ONLY > enable SQL Browser
2) Windows Firewall exception created - go to directory point to SQLserver.exe
its c:\programFiles\Microsoft SQL Server\MSSQL 10.sqlexpress\mssql\BINN\SQLSERVR.EXE
Make sure that you have an exception that is created. Check see if you see "sqlservr.exe" listed in exceptions. This means that the port door is closed when the program is done unlike a hard core ROUTER that always leaves a door opened port for hackers to keep trying. Since i know you have Windows firwall install by deafult this is added protection because....... you must also open a specfic port using windows firewall but.....we MUST leave the door OPENED for any person who wants to view your store. Port 1434(see below)
#3) Windows Firewall > ADD Port> Name UDP Port 1434 for SQL Store Databse Connections> Port num = 1434
Now check off UDP not TCP got it? Check again to be sure.
#3 1/2) Now might be a good time to allow a few exceptions programs that you know are safe like Magicjack phone service via VOIP. Ok enough said lets move on.
Open you firewall GUI 192.168.mickeymouse and enable UDP port 1434 in port range "forward" to your server ip only
sql brower 1434 to 1434 UDP TO 192.168.1.ip of webserver. enabled.
If you can't do this I feel for you. Thats hours and hours.....
so both your "windows Firewall" and your Hard Firewall are now both OPENED for SQL Browser but windows firewall has two 1) Sql Browser port Opened UDP port 1434 in exceptions, 2) SQLservr 3) of course Port 80(if you get this wrong start drinking and smoking)
When in doubt reboot.
You should now be able to read/write and connect to database remotely via internet explorer!
Please tell me this helped!
More complete Info see
http://msdn.microsoft.com/en-us/library/ms188670.aspx
(yes there right!)
SQLEXPRESS
During install make sure you choose "MIXED mode not Windows Authentication Mode". its ok if you choose windows mode too but see below if you installed using windows auth.
If you chose Windows server Authentication Mode you must enable the SA account. By default you will never be able to write to your NOP database no matter what unless you do the following.
Even if you create an admin account nothing happens via SQL auth because its not enabled by default during installation.
Open Microsoft SQL Server 2008 Management Studio
1) Create an account in MIXED Mode =(anything via internet connection is "SQL SERVER AUTHENTICATION").
HOW? by logging on used plain old Windows auth go to security directory>logins>rightclick >create new login. This is so simple yet you still can't connect using sql mode. WHY?
You can give your user name at least "DBO" permissions as database owner. If you have a hard time just enable all permissions!!! then deactivate permissions!!! later after connection. You should create two accounts one a super admin permission with all permissions, and another you use to connect over the internet(incase you get hacked they can't delete,remove etc)
Now thats done.
Close SQL Server Management Studio
Open via Windows Auth
Right click on the TOP directory called (Name of your server\SQLEXPRESS) > properties
Go to security directory on left side
AH haaaaaaaaaaa
SERVER AUTHENTICATION
check SQL Server and Windows Authentication Mode
That's almost it!
EITHER REBOOT OR RESTART ALL SERVICES RELATING TO "SQL" (wheel icon looks like a gear)
try to login using SQL MODE
You better be Good to go Now.
Now, if you want to get your databse up and running keep listening......./reading
To get Permissions to use NOP Commerce for users via the internet. www.mystore/store
YOU MUST ENABLE SQL BROWSER
1) services (wheel icon) auto startup type/in sql configuration manager > "sql server services" ONLY > enable SQL Browser
2) Windows Firewall exception created - go to directory point to SQLserver.exe
its c:\programFiles\Microsoft SQL Server\MSSQL 10.sqlexpress\mssql\BINN\SQLSERVR.EXE
Make sure that you have an exception that is created. Check see if you see "sqlservr.exe" listed in exceptions. This means that the port door is closed when the program is done unlike a hard core ROUTER that always leaves a door opened port for hackers to keep trying. Since i know you have Windows firwall install by deafult this is added protection because....... you must also open a specfic port using windows firewall but.....we MUST leave the door OPENED for any person who wants to view your store. Port 1434(see below)
#3) Windows Firewall > ADD Port> Name UDP Port 1434 for SQL Store Databse Connections> Port num = 1434
Now check off UDP not TCP got it? Check again to be sure.
#3 1/2) Now might be a good time to allow a few exceptions programs that you know are safe like Magicjack phone service via VOIP. Ok enough said lets move on.
Open you firewall GUI 192.168.mickeymouse and enable UDP port 1434 in port range "forward" to your server ip only
sql brower 1434 to 1434 UDP TO 192.168.1.ip of webserver. enabled.
If you can't do this I feel for you. Thats hours and hours.....
so both your "windows Firewall" and your Hard Firewall are now both OPENED for SQL Browser but windows firewall has two 1) Sql Browser port Opened UDP port 1434 in exceptions, 2) SQLservr 3) of course Port 80(if you get this wrong start drinking and smoking)
When in doubt reboot.
You should now be able to read/write and connect to database remotely via internet explorer!
Please tell me this helped!
More complete Info see
http://msdn.microsoft.com/en-us/library/ms188670.aspx