| Author |
Topic |
|
NeilG
Aged Yak Warrior
530 Posts |
 Posted - 2007-08-01 : 04:47:41
|
| Hi Guys Hoping that someone out there is able to give me some help on this oneI am trying to install SQL Server 2005 developer Edition on to a new laptop that is running Windows vista home premium editionHowever after running the install and then trying to run the Service Pack 2 it producing an error saying that the windows authorisation is not valid and not using named pipes protocol. After some searching and googling I have checked all the option that I can see like that my login to the windows environment is the administrator which its is but from there I still am unable to log Any Ideas people, or is this a known problem that I am just not seen |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2007-08-01 : 06:25:49
|
| anyone!!!! really need this up and running and at the moment I am googling anything to try and get and answer |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-01 : 06:38:39
|
Did you run the "user elevation tool" as suggested to you at the end of installation?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2007-08-01 : 07:06:57
|
| Do you mean at the end of the SQL Server installation? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-01 : 07:12:13
|
Yes.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2007-08-01 : 07:17:44
|
| I can't say that I was ever prompted for that at the end of the installation, I did try reinstalling in mixed mode and giving the sa login a password still gave the same error message when using the sql auth. I have uninstalled the sql server default instance again and I will re-try but look out for "user elevation tool" cheers for the help there Peso |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-01 : 08:33:22
|
When installing on Vista, local administrator do not longer by default get admin permission on sql server.The last screen (or second last) screen in installtion process describes this for you.I think you can launch this till afterwards tough.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-01 : 08:54:11
|
%ProgramFiles%\Microsoft SQL Server\90\Shared\sqlprov.exe
E 12°55'05.25"N 56°04'39.16" |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2007-08-01 : 16:34:57
|
| Right tried to reinstall and no user elevation tool appear and then tried the above and that was not there , please note that I am not installing the reporting services and i am on the vista home premium OS system. I really can not see what i can do here the sp2 will not run and even trying to run ssms using the "run as administrator" option still refuses me accessI understand that I need to get the the user access control to add my windows login to the sysadmin but how can I do this Any help would really really be good as it's driving me up the wall now |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2007-08-01 : 18:17:18
|
| Thanks ppl I have sorted the problem and after trying the re-install I found the sqlprov.exe that peso talks about and now all is working fine Thanks Loads Peso and as always determination to succeeds |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-01 : 19:06:35
|
Great!Thanks for the feedback.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
Authorization problem after SQL 2005 on vista