Re: XP SP2 uograde to Vista - Access denied to SQL 2005
- From: "Roger Wolter[MSFT]" <rwolter@xxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 13 Feb 2007 22:56:44 -0800
I've been running SP1 on Vista for a while. The biggest issue is that under Vista by default, you're not an admin. In the past you could assume that since you are an admin you could always log into the local SQL Server because you were part of the sysadmin role. To get around that you have to log into SSMS as an admin (right click on the SSMS icon and select runas administrator) once you are logged in as an admin you can create a login for yourself and grant it whatever permissions you like. Once you have a login, you won't need to run as an admin to get access. SP2 will do this for you automagically but it's not an insurmountable obstacle to create a login for yourself.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Jacques" <Jacques@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:213BE4E2-FBDF-40DA-8224-7B3279E7A153@xxxxxxxxxxxxxxxx
:-( too bad !
I can't wait to use NAv and Vista :-)....in a few months i guess.
Tks for your help Henrik,
Jack
"Henrik Nordgren" wrote:
Hi!
Because of the difference in the security model of Vista, SQL Server 2005
will not run properly until SP2 of Vista, that is the info I got from a MVP
at Microsoft. I tried to install it too on Vista, refused to work.
As of now, Vista is not a supported OS... sorry to say
kind regards
Henrik
Now Im running SS 2005 standard on XP sp2.
--
.NET Developer
"Jacques" wrote:
> I am using Dymanics VPC Image of Nav 5.0
> The setup is as follow:
> Windows XP + SQL Server 2005 + Dynamics NAV setup (Server+Client).
>
> I upgraded XP to Vista. I log in with the default admin account ( > admin), i
> can log in the SQL console (Visual Studio management SQL) but i can't > have
> access to any existing database, i can't create any users...and of > course i
> don't have the sa password. Anyone can help me ? Last scenario is to
> uninstall SQL + Reinstall...
> Thks,
>
> Jacques
>
.
- Prev by Date: Re: non-sa users get access denied in OLE DB query
- Next by Date: Re: transfering logins
- Previous by thread: Re: XP SP2 uograde to Vista - Access denied to SQL 2005
- Next by thread: Re: Surface Area Configuration
- Index(es):
Relevant Pages
|
