MSDE login problem - Windows

I'm confused.
OS = Win XP Pro
I installed MSDE2000A on a new laptop using mixed security - Windows and
SQL. Everything went fine. At the time my everyday Windows user account wa
s
set up as a Windows (not SQL) administrator, so that I could get some other
software installed, too.
I subsequently changed my Windows user account to be a power user and NOT a
Windows administrator and now I cannot connect to MSDE with that Windows
account. If I switch the account back to Windows adminstrator all is well
with MSDE.
How can I coax MSDE to recognize this user account when it is no longer a
Windows administrator?Add your windows account to the Logins for MSDE. You are
getting in due to the default behavior of SQL Server adding
BUILTIN\Administrators as a login. That would include all
logins that are members of the local admins group.
You can add your login using sp_grantlogin. You can find
more information in books online.
-Sue
On Mon, 9 Jan 2006 08:07:04 -0800, "Duke Carey"
<DukeCarey@.discussions.microsoft.com> wrote:

>I'm confused.
>OS = Win XP Pro
>I installed MSDE2000A on a new laptop using mixed security - Windows and
>SQL. Everything went fine. At the time my everyday Windows user account w
as
>set up as a Windows (not SQL) administrator, so that I could get some other
>software installed, too.
>I subsequently changed my Windows user account to be a power user and NOT a
>Windows administrator and now I cannot connect to MSDE with that Windows
>account. If I switch the account back to Windows adminstrator all is well
>with MSDE.
>How can I coax MSDE to recognize this user account when it is no longer a
>Windows administrator?
>|||Sue -
Thanks for the guidance, but it looks like sp_grantlogin requires me to use
a domain name. The laptop is not part of a domain. Is there a workaround
for that?
"Sue Hoegemeier" wrote:

> Add your windows account to the Logins for MSDE. You are
> getting in due to the default behavior of SQL Server adding
> BUILTIN\Administrators as a login. That would include all
> logins that are members of the local admins group.
> You can add your login using sp_grantlogin. You can find
> more information in books online.
> -Sue
> On Mon, 9 Jan 2006 08:07:04 -0800, "Duke Carey"
> <DukeCarey@.discussions.microsoft.com> wrote:
>
>|||If you are logging into the laptop using a local account,
you would use:
MachineName\LoginName
-Sue
On Mon, 9 Jan 2006 16:29:02 -0800, "Duke Carey"
<DukeCarey@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Sue -
>Thanks for the guidance, but it looks like sp_grantlogin requires me to use
>a domain name. The laptop is not part of a domain. Is there a workaround
>for that?
>"Sue Hoegemeier" wrote:
>|||Sue -
I logged in to the laptop as Administrator and was automatically logged in
to MSDE. Within MSDE I then ran EXEC sp_grantlogin 'pc_name\duke' and it ra
n
successfully.
However, after logging in as Duke *without Windows administrator rights* I
was still unable to login to MSDE.
I have to be so dense, but what am I missing?
Duke
"Sue Hoegemeier" wrote:

> If you are logging into the laptop using a local account,
> you would use:
> MachineName\LoginName
> -Sue
> On Mon, 9 Jan 2006 16:29:02 -0800, "Duke Carey"
> <DukeCarey@.discussions.microsoft.com> wrote:
>
>|||If the login is there, you should be able to at least
connect.
So when you log in as Duke and try to log in to MSDE, what
is the exact error message - all the details?
-Sue
On Thu, 19 Jan 2006 08:24:04 -0800, "Duke Carey"
<DukeCarey@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Sue -
>I logged in to the laptop as Administrator and was automatically logged in
>to MSDE. Within MSDE I then ran EXEC sp_grantlogin 'pc_name\duke' and it r
an
>successfully.
>However, after logging in as Duke *without Windows administrator rights* I
>was still unable to login to MSDE.
>I have to be so dense, but what am I missing?
>Duke
>"Sue Hoegemeier" wrote:
>|||Sue -
There are no error messages as such
What is happening is that the SQL Service Mgr in the systray shows an empty
circle. When I open it I have to type in the pc name and select SQL Server
as the service. It then shows that it is already running. When I go into
MSDE Manager (Vale Software's management tool), it shows me logged in as
guest. It also shows the database owner (there's only one user database so
far) as hp_notebook\duke and says that I do not have permisssion to access
that database
If I grant my Windows login Windows Administrator status, MSDE starts fine
and I log in to the MSDE as myself
I don't know enough to provide you more helpful information
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:1q00t11aka3drrkih9ev7rofpbidk5c6dr@.
4ax.com...
> If the login is there, you should be able to at least
> connect.
> So when you log in as Duke and try to log in to MSDE, what
> is the exact error message - all the details?
> -Sue
>|||Okay...so you get on the server but can't do anything in
that database or can't access the database.
Add your Duke login as a user in the database using
sp_grantdbaccess.
If you need that login to be able to do anything and
everything on the MSDE instance, you can add that login to
the sysadmins server role using:
EXEC sp_addsrvrolemember 'pc_name\duke', 'sysadmin'
-Sue
On Thu, 19 Jan 2006 19:02:51 -0500, "Duke Carey"
<dukecarey@.hotmail.com> wrote:

> When I go into
>MSDE Manager (Vale Software's management tool), it shows me logged in as
>guest. It also shows the database owner (there's only one user database so
>far) as hp_notebook\duke and says that I do not have permisssion to access
>that database|||Sue -
Thanks for sticking with me. It appears that things are working correctly
now.
EXEC sp_addsrvrolemember 'pc_name\duke', 'sysadmin' seems to have done the
trick.
"Sue Hoegemeier" wrote:

> Okay...so you get on the server but can't do anything in
> that database or can't access the database.
> Add your Duke login as a user in the database using
> sp_grantdbaccess.
> If you need that login to be able to do anything and
> everything on the MSDE instance, you can add that login to
> the sysadmins server role using:
> EXEC sp_addsrvrolemember 'pc_name\duke', 'sysadmin'
> -Sue
> On Thu, 19 Jan 2006 19:02:51 -0500, "Duke Carey"
> <dukecarey@.hotmail.com> wrote:
>
>|||Good to hear it's all working now - thanks for posting back!
-Sue
On Mon, 23 Jan 2006 06:31:04 -0800, "Duke Carey"
<DukeCarey@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Sue -
>Thanks for sticking with me. It appears that things are working correctly
>now.
>EXEC sp_addsrvrolemember 'pc_name\duke', 'sysadmin' seems to have done the
>trick.
>
>"Sue Hoegemeier" wrote:
>