Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
legasy
Starting Member
6 Posts |
 Posted - 2008-02-26 : 11:32:53
|
| I have a problem starting a database engine. I do not have admin rights to do so.When i try to add a new admin i am told that it failed since sql server does not provide for remote connections and when i try to change that....changes will take place when the database engine is restarted. The problem with that last one is that the engine wont even start in the first place so it seems like i have in a loop deadlock. Can someone help me out with this one? I am using Vista Home Premium.The sky aint the limit for me.....I dont have any!!! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-26 : 11:38:12
|
| Check application log. |
 |
|
|
legasy
Starting Member
6 Posts |
Posted - 2008-02-26 : 12:32:33
|
| What do you mean by check application log? if u r talkin abt the error messages...they were not of much helpThe sky aint the limit for me.....I dont have any!!! |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-26 : 21:47:07
|
| Let your windows admin start the service. |
|
|
|
legasy
Starting Member
6 Posts |
Posted - 2008-02-27 : 10:09:47
|
| I found these two when i tried to start the service....and when i tried to allow remote connections...and I am on the windows admin account...since im using vista, im not automatically added to the admin listing which i can not add myself to since i cannot allow remote connectionsError 2(The system cannot find the file specified.) occurred while opening file 'c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\master.mdf' to obtain configuration information at startup. An invalid startup option might have caused the error. Verify your startup options, and correct or remove them if necessary.The configuration of the AdminConnection\TCP protocol in the SQL instance SQLEXPRESS is not valid.The sky aint the limit for me.....I dont have any!!! |
|
|
|
legasy
Starting Member
6 Posts |
Posted - 2008-02-28 : 21:36:42
|
| I cant find the master.db file for the db engine. What do i do now?The sky aint the limit for me.....I dont have any!!! |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-01 : 22:02:00
|
| Reinstall sql. |
|
|
|
|
|
|
Problem with starting engine