I want to install SQL express edition on a laptop with vista home basic, but
I faced a lot of problems.I have this error:
SQL Setup could not connect to the database service for server
configuration. The error was:[Microsoft][SQL Native client][SQL Server] Login
failed for user 'sa'.refer to server error logs ans setup logs for more
information.
I went to Microsoft 'help and support center'. I found a page that describes
my problem. it is available at 'bug#431174'. It said that I must delete some
specific temporary files and goto SQL configuration Manager and start the SQL
Server services. I delete those files, but I couldn't start the "MSSQLSERVER"
in SQL configuration Manager. I tried to do that. It was going to be started,
but in the middle of the progress, it stopped. I do it several times, but it
did not start. I think the main problem that I can't install SQL Server is: I
can't make the MSSQLSERVER start.what can I do?Please help me! 3 2147
When you run the sql icon, do you right click on it and say "Run as
Administrator" ?
"F.N.Z" <FN*@discussions.microsoft.comwrote in message
news:70**********************************@microsof t.com...
>I want to install SQL express edition on a laptop with vista home basic, but
I faced a lot of problems.I have this error:
SQL Setup could not connect to the database service for server
configuration. The error was:[Microsoft][SQL Native client][SQL Server]
Login
failed for user 'sa'.refer to server error logs ans setup logs for more
information.
I went to Microsoft 'help and support center'. I found a page that
describes
my problem. it is available at 'bug#431174'. It said that I must delete
some
specific temporary files and goto SQL configuration Manager and start the
SQL
Server services. I delete those files, but I couldn't start the
"MSSQLSERVER"
in SQL configuration Manager. I tried to do that. It was going to be
started,
but in the middle of the progress, it stopped. I do it several times, but
it
did not start. I think the main problem that I can't install SQL Server
is: I
can't make the MSSQLSERVER start.what can I do?Please help me!
I am not too familiar with SQL 2005 and Vista but if you are
logged in as an administrator you can use the OSQL utility from the
command prompt to access the database. From there you can reset the
'sa' password.
i.e.
1) Select: Start Run and type in the word COMMAND and click on OK.
2) At the prompt type osql -E and press Enter.
3) Type sp_password 'oldpassword','newpassword',sa and press Enter at
the "1>" prompt.
4) Type go and press Enter at the "2>" prompt.
5) You should receive the message Password changed.
6) The "1>" prompt should return. Type in exit and press Enter.
7) Type in exit and press Enter again.
If you don't know the 'oldpassword' you can try the line: sp_password
NULL, NULL, sa ...BUT, I am not sure if SQL 2005 will let you set the
'sa' password to NULL.
On Apr 30, 4:40*pm, Blue Streak <rdlebre...@hotmail.comwrote:
* * I am not too familiar with SQL 2005 and Vista but if you are
logged in as an administrator you can use the OSQL utility from the
command prompt to access the database. *From there you can reset the
'sa' password.
i.e.
1) Select: Start Run and type in the word COMMAND and click on OK.
2) At the prompt type osql -E and press Enter.
3) Type sp_password 'oldpassword','newpassword',sa and press Enter at
the "1>" prompt.
4) Type go and press Enter at the "2>" prompt.
5) You should receive the message Password changed.
6) The "1>" prompt should return. *Type in exit and press Enter.
7) Type in exit and press Enter again.
If you don't know the 'oldpassword' you can try the line: sp_password
NULL, NULL, sa *...BUT, I am not sure if SQL 2005 will let you set the
'sa' password to NULL.
Oh, crap! Please disregard this post. It *assumes* the SQL server is
running. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: MLH |
last post by:
I copied the following code snippet from A97 HELP. Am
getting an error at compile time suggesting there's a problem
with the first line (compile error, user-defined type not defined).
It is likely...
|
by: Boris |
last post by:
I install embeeded visual C++ sp2 (eVC 4.0) on new instalation of windows XP pro en SP1 () (with no update).
Then I to install SDK for windows ce dot.net 4.2.
Installation failed with error...
|
by: bruce |
last post by:
Hi,
I am trying to write a simple installation program that
asks the user a few questions and then installs a
software application and its associate files based on
those answers.
I am new to...
|
by: Jeff Bowden |
last post by:
For ease of configuration and other reasons, I would like for my
single-user GUI app to be able to use postgresql in-process as a library
accessing a database created in the users home directory. ...
|
by: Datawonk |
last post by:
Hi, I have a user who somehow managed to turn off the min max close
icons in her menu bar (across Access as a whole, not just the
application that I built). She has it in her other MS products,...
| |
by: David Veeneman |
last post by:
I had to reformat my Windows XP Professional development machine yesterday
and reinstall everything, including IIS and VS 2005. I thought I had worked
out the procedure to get ASP.NET up and...
|
by: godsmustbcrazy |
last post by:
Here is my problem. Brand new SQL Server 2005 Installation
1. Create a database "Test"
2. Create a database user "Domain\user" and set user mapping to "Test"
with datareader, datawriter...
|
by: MaxDraxyl |
last post by:
Hi,
I am installing DB2 Express-C on Fedora Core 6.
Installation went smoothly, but I cannot create a database.
$ db2 create database test
SQL1092N "EMOB" does not have the authority to...
|
by: thiefhunter |
last post by:
Wordpress image upload has worked well for months. Suddenly, I get "failed to write file to disk" though nothing has changed. Read the wp forums and worked with my hosting co to do the following:
...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |