| Author |
Topic |
|
Allen
Starting Member
20 Posts |
 Posted - 2009-12-14 : 19:29:55
|
| I downloaded SQLEXPRESS and it was running, then I messed with some settings and now it's stopped and I can't seem to get it to run again.I have a SQL Server db on my hosting site and I want to use SQL Express as a test db to test imports. Thanks, Allen |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Allen
Starting Member
20 Posts |
Posted - 2009-12-14 : 19:57:47
|
| Where is that applog event viewer - Sorry, new to this |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Allen
Starting Member
20 Posts |
Posted - 2009-12-14 : 21:34:06
|
| 17058 error:initerrlog: Could not open error log file ''. Operating system error = 3(The system cannot find the path specified.). |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Allen
Starting Member
20 Posts |
Posted - 2009-12-14 : 23:22:05
|
| I just downloaded SQL Express yesterday. When I first downloaded it it was running. Then I might have changed a setting and now it's stopped and I can't get it started. I haven't set up any paths to anything, I just want to get it started so I can then try to export into it from my SQL Server db that is up on my hosting site |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Allen
Starting Member
20 Posts |
Posted - 2009-12-14 : 23:44:45
|
| In SQL Enterprise Manager > SQL Server Group I have my hosted SQL Server db and this new one called 'ALLEN' that was added when I downloaded SQL Express (I want to use SQL Express as my development db for doing imports)I was trying to get it to run in Enterprise Manager so I was doing different things in the SQL Express config manager like enabling/disabling TCP/IP, trying SQL Server authentication/Windows authentication, etc.There was an old alias saved from a long time ago, so I deleted it. I was doing different thing like that to get it to run |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Allen
Starting Member
20 Posts |
Posted - 2009-12-15 : 00:59:32
|
| Tara - Could I get your private email address? Please send to info@awesome-art.bizI have few more questions about getting this set up corectly.I am also a DBA for Oracle/PeopleSoftThanks,Allen |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Allen
Starting Member
20 Posts |
Posted - 2009-12-15 : 10:48:53
|
| I am using SQL Server 2000 up on my hosting site. I want to use Express for a development system. Do you think I should uninstall Express 2008 and find a version of Express 2000 to install ?Also do you recommend Management console, and uninstall Enterprise Mgr ? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Allen
Starting Member
20 Posts |
Posted - 2009-12-15 : 11:12:16
|
| My host is fine, I could upgrade to 2005 whenever I want to, I just started out with 2000 and it's working fineMy db is used in an e-commerce site (shopping cart)It's a simple structure that just holds items, categories, orders, customers, etc. There are never more than a couple of concurrent users logged in at one time and only about 5000 items, items need to be added 100 at a time in the future.What I wanted a development db for is to practice doing imports when i add items. But maybe just doing my imports from Excel will work fineDoes importing from Excel => SQL Server work OK? |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
behrman
Yak Posting Veteran
76 Posts |
Posted - 2009-12-15 : 14:25:02
|
| hi,run SQL Server Configuration Manager, select the SQL Server 2005 services node... in the right pane select the SQL Server engine you want to manage and rx click.. "Properties"..regardsRAQ Report: Web-based Excel-like Java reporting tool |
|
|
|
|
Can't gert SQL Express to start