I have probably done a very silly thing

[Tony Johansson]

I have now done a very silly thing.

I have been playing around to get a better understanding how all this works.

I have right click and take properies on the builtin\administrator and then
select the server Roles and here I have
unchecked the sysadmin.

This mean that I can't check this sysadmin for builtin\administrator any
more the errro message is
user does not have permission to perform this action. Is there any
workaround to fix this

I might have to reinstall SQL Server Express 2005 that is included in Visual
Studio 2005.

How do I reinstall SQL Server Express 2005 from Visual Studio 2005

//Tony

 

[PvdG42]

I have now done a very silly thing.

I have been playing around to get a better understanding how all this
works.

I have right click and take properies on the builtin\administrator and
then
select the server Roles and here I have
unchecked the sysadmin.

This mean that I can't check this sysadmin for builtin\administrator any
more the errro message is
user does not have permission to perform this action. Is there any
workaround to fix this

I might have to reinstall SQL Server Express 2005 that is included in
Visual Studio 2005.

How do I reinstall SQL Server Express 2005 from Visual Studio 2005

//Tony

Here's a suggestion (untested, as I have no need):

Use Control Panel to uninstall "Microsoft SQL Server 2005" from your
installed programs list, then insert your VS 2008 install media and do a
repair install of VS. It should detect the missing SQL Express and reinstall
it.

 

[Gregory A. Beamer]

I have right click and take properies on the builtin\administrator and
then select the server Roles and here I have
unchecked the sysadmin.

This mean that I can't check this sysadmin for builtin\administrator
any more the errro message is
user does not have permission to perform this action. Is there any
workaround to fix this

I might have to reinstall SQL Server Express 2005 that is included in
Visual Studio 2005.

Possibly, but see if you, meaning your account, can get into SQL first.
If so, then you can fix it. If your account is not an SA, then the only
other option is if you have created a SQL login for the SA account. If
that is not the case, you are probably hosed and need to reinstall.

If so, you can reattach any databases you have created later. Just
reinstall and then open the Express manager and choose to attach. If you
cannot do it this way, look up sp_attach_db on the web and you will find
an example of the syntax.

If I had a dollar for every time I hosed myself learning something new
.... In other words, you are not alone in this. And, you ultimately learn
more from your failures than successes, as you learn the consequences of
wrong moves.

Peace and Grace,

--
Gregory A. Beamer (MVP)

Twitter: @gbworld
Blog: http://gregorybeamer.spaces.live.com

*******************************************
| Think outside the box! |
*******************************************

 

[Gregory A. Beamer]

How do I reinstall SQL Server Express 2005 from Visual Studio 2005

Control Panel >> Add/Remove Programs. Find SQL Server Express and
uninstall. If this is your only SQL install, remove all of the programs
that say SQL Server.

I agree with Michael about Advanced Services install, as it definitely
includes the express manager.

peace and grace,

--
Gregory A. Beamer (MVP)

Twitter: @gbworld
Blog: http://gregorybeamer.spaces.live.com

*******************************************
| Think outside the box! |
*******************************************

 

[Tony Johansson]

My login sa has never been enabled so it seems to me that Ii have to
reinstall SQL Server Express.

To uninstall I use Control Panel >> Add/Remove Programs. Find SQL Server
Express and
uninstall.

But have you any idea how I reinstall the SQL Server Express again because
it exist in Visual Studio 2005.
What should I search for when looking for an install program for SQL Server
Express on my computer ?

Do you think I might have to download this ?

//Tony

 

[Gregory A. Beamer]

But have you any idea how I reinstall the SQL Server Express again
because it exist in Visual Studio 2005.

Just download it.

2005 version (with Advanced Services and SP3):
http://snurl.com/tz3jx

2008 version:
http://snurl.com/tz3k2

SP1 (separate install if you want advanced services):
http://snurl.com/tz3k6

Peace and Grace,

--
Gregory A. Beamer (MVP)

Twitter: @gbworld
Blog: http://gregorybeamer.spaces.live.com

*******************************************
| Think outside the box! |
*******************************************