I am using the desktop sqlexpress 2005 and I was experimenting with the account setting and I accidentally disabled my access. I am using windows authentication and there is no password, just the windows login name.
How can I reactivate the login for this connection. Any help is greatly appreciated.Log on as administrator, then try.sql
Showing posts with label desktop. Show all posts
Showing posts with label desktop. Show all posts
Friday, March 30, 2012
Friday, February 24, 2012
Local Database Issue with SQL 2000 Install
I've got a user with a new HP desktop requesting SQL 2000 Developer Server
and Client Tools to be installed. When I install the software along with SQL
SP4, the local database shows up in Enterprise Manager. When the user logs
on to the same machine, the local database is missing in Enterprise Manager.
I had another user with the same type of permissions log on to the machine
and they get the local database to show up as well.
Why can't this particular person get the local database to show up in
Enterprise Manger when they log on? Is there a registry edit that's needed?
Any help is greatly appreciated.
Colette
Hi Colette,
Perhaps it's been removed. Have they tried just registering the server in
Enterprise Manager? (ie: right-click the SQL Servers group in the main tree
and choose the option to register a server)
HTH,
Greg
"Colette" <Colette@.discussions.microsoft.com> wrote in message
news:084583C7-EA4C-4BC5-8EA1-1D0F448FDA32@.microsoft.com...
> I've got a user with a new HP desktop requesting SQL 2000 Developer Server
> and Client Tools to be installed. When I install the software along with
> SQL
> SP4, the local database shows up in Enterprise Manager. When the user
> logs
> on to the same machine, the local database is missing in Enterprise
> Manager.
> I had another user with the same type of permissions log on to the machine
> and they get the local database to show up as well.
> Why can't this particular person get the local database to show up in
> Enterprise Manger when they log on? Is there a registry edit that's
> needed?
> Any help is greatly appreciated.
> Colette
and Client Tools to be installed. When I install the software along with SQL
SP4, the local database shows up in Enterprise Manager. When the user logs
on to the same machine, the local database is missing in Enterprise Manager.
I had another user with the same type of permissions log on to the machine
and they get the local database to show up as well.
Why can't this particular person get the local database to show up in
Enterprise Manger when they log on? Is there a registry edit that's needed?
Any help is greatly appreciated.
Colette
Hi Colette,
Perhaps it's been removed. Have they tried just registering the server in
Enterprise Manager? (ie: right-click the SQL Servers group in the main tree
and choose the option to register a server)
HTH,
Greg
"Colette" <Colette@.discussions.microsoft.com> wrote in message
news:084583C7-EA4C-4BC5-8EA1-1D0F448FDA32@.microsoft.com...
> I've got a user with a new HP desktop requesting SQL 2000 Developer Server
> and Client Tools to be installed. When I install the software along with
> SQL
> SP4, the local database shows up in Enterprise Manager. When the user
> logs
> on to the same machine, the local database is missing in Enterprise
> Manager.
> I had another user with the same type of permissions log on to the machine
> and they get the local database to show up as well.
> Why can't this particular person get the local database to show up in
> Enterprise Manger when they log on? Is there a registry edit that's
> needed?
> Any help is greatly appreciated.
> Colette
Local Database Issue with SQL 2000 Install
I've got a user with a new HP desktop requesting SQL 2000 Developer Server
and Client Tools to be installed. When I install the software along with SQL
SP4, the local database shows up in Enterprise Manager. When the user logs
on to the same machine, the local database is missing in Enterprise Manager.
I had another user with the same type of permissions log on to the machine
and they get the local database to show up as well.
Why can't this particular person get the local database to show up in
Enterprise Manger when they log on? Is there a registry edit that's needed?
Any help is greatly appreciated.
ColetteHi Colette,
Perhaps it's been removed. Have they tried just registering the server in
Enterprise Manager? (ie: right-click the SQL Servers group in the main tree
and choose the option to register a server)
HTH,
Greg
"Colette" <Colette@.discussions.microsoft.com> wrote in message
news:084583C7-EA4C-4BC5-8EA1-1D0F448FDA32@.microsoft.com...
> I've got a user with a new HP desktop requesting SQL 2000 Developer Server
> and Client Tools to be installed. When I install the software along with
> SQL
> SP4, the local database shows up in Enterprise Manager. When the user
> logs
> on to the same machine, the local database is missing in Enterprise
> Manager.
> I had another user with the same type of permissions log on to the machine
> and they get the local database to show up as well.
> Why can't this particular person get the local database to show up in
> Enterprise Manger when they log on? Is there a registry edit that's
> needed?
> Any help is greatly appreciated.
> Colette
and Client Tools to be installed. When I install the software along with SQL
SP4, the local database shows up in Enterprise Manager. When the user logs
on to the same machine, the local database is missing in Enterprise Manager.
I had another user with the same type of permissions log on to the machine
and they get the local database to show up as well.
Why can't this particular person get the local database to show up in
Enterprise Manger when they log on? Is there a registry edit that's needed?
Any help is greatly appreciated.
ColetteHi Colette,
Perhaps it's been removed. Have they tried just registering the server in
Enterprise Manager? (ie: right-click the SQL Servers group in the main tree
and choose the option to register a server)
HTH,
Greg
"Colette" <Colette@.discussions.microsoft.com> wrote in message
news:084583C7-EA4C-4BC5-8EA1-1D0F448FDA32@.microsoft.com...
> I've got a user with a new HP desktop requesting SQL 2000 Developer Server
> and Client Tools to be installed. When I install the software along with
> SQL
> SP4, the local database shows up in Enterprise Manager. When the user
> logs
> on to the same machine, the local database is missing in Enterprise
> Manager.
> I had another user with the same type of permissions log on to the machine
> and they get the local database to show up as well.
> Why can't this particular person get the local database to show up in
> Enterprise Manger when they log on? Is there a registry edit that's
> needed?
> Any help is greatly appreciated.
> Colette
Local Database Issue with SQL 2000 Install
I've got a user with a new HP desktop requesting SQL 2000 Developer Server
and Client Tools to be installed. When I install the software along with SQ
L
SP4, the local database shows up in Enterprise Manager. When the user logs
on to the same machine, the local database is missing in Enterprise Manager.
I had another user with the same type of permissions log on to the machine
and they get the local database to show up as well.
Why can't this particular person get the local database to show up in
Enterprise Manger when they log on? Is there a registry edit that's needed?
Any help is greatly appreciated.
ColetteHi Colette,
Perhaps it's been removed. Have they tried just registering the server in
Enterprise Manager? (ie: right-click the SQL Servers group in the main tree
and choose the option to register a server)
HTH,
Greg
"Colette" <Colette@.discussions.microsoft.com> wrote in message
news:084583C7-EA4C-4BC5-8EA1-1D0F448FDA32@.microsoft.com...
> I've got a user with a new HP desktop requesting SQL 2000 Developer Server
> and Client Tools to be installed. When I install the software along with
> SQL
> SP4, the local database shows up in Enterprise Manager. When the user
> logs
> on to the same machine, the local database is missing in Enterprise
> Manager.
> I had another user with the same type of permissions log on to the machine
> and they get the local database to show up as well.
> Why can't this particular person get the local database to show up in
> Enterprise Manger when they log on? Is there a registry edit that's
> needed?
> Any help is greatly appreciated.
> Colette
and Client Tools to be installed. When I install the software along with SQ
L
SP4, the local database shows up in Enterprise Manager. When the user logs
on to the same machine, the local database is missing in Enterprise Manager.
I had another user with the same type of permissions log on to the machine
and they get the local database to show up as well.
Why can't this particular person get the local database to show up in
Enterprise Manger when they log on? Is there a registry edit that's needed?
Any help is greatly appreciated.
ColetteHi Colette,
Perhaps it's been removed. Have they tried just registering the server in
Enterprise Manager? (ie: right-click the SQL Servers group in the main tree
and choose the option to register a server)
HTH,
Greg
"Colette" <Colette@.discussions.microsoft.com> wrote in message
news:084583C7-EA4C-4BC5-8EA1-1D0F448FDA32@.microsoft.com...
> I've got a user with a new HP desktop requesting SQL 2000 Developer Server
> and Client Tools to be installed. When I install the software along with
> SQL
> SP4, the local database shows up in Enterprise Manager. When the user
> logs
> on to the same machine, the local database is missing in Enterprise
> Manager.
> I had another user with the same type of permissions log on to the machine
> and they get the local database to show up as well.
> Why can't this particular person get the local database to show up in
> Enterprise Manger when they log on? Is there a registry edit that's
> needed?
> Any help is greatly appreciated.
> Colette
Subscribe to:
Posts (Atom)