MSSQLserver

I have lost my password to my SQL server can someone help me retrieve it or
should I delete this server and download a new one?
Can you log in from the console or a domain admin account, using Windows
authentication, and change the password?
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
"RonP" <RonP@.discussions.microsoft.com> wrote in message
news:7119DAA8-68B0-416D-A53E-9EE46856B5B7@.microsoft.com...
>I have lost my password to my SQL server can someone help me retrieve it or
> should I delete this server and download a new one?
|||Look at this here if you are abel to change to mixed mode:
http://groups.google.de/group/comp.d...6b23861fd54c77
Then change the password ( If you ment that you lost the password of
the sa ) within a sql statement like:
EXEC sp_password 'sa', 'newpassword'
HTH, Jens Suessmeyer

MSSQLserver

I have lost my password to my SQL server can someone help me retrieve it or
should I delete this server and download a new one?Can you log in from the console or a domain admin account, using Windows
authentication, and change the password?
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"RonP" <RonP@.discussions.microsoft.com> wrote in message
news:7119DAA8-68B0-416D-A53E-9EE46856B5B7@.microsoft.com...
>I have lost my password to my SQL server can someone help me retrieve it or
> should I delete this server and download a new one?|||Look at this here if you are abel to change to mixed mode:
http://groups.google.de/group/comp... />
861fd54c77
Then change the password ( If you ment that you lost the password of
the sa ) within a sql statement like:
EXEC sp_password 'sa', 'newpassword'
HTH, Jens Suessmeyer

MSSQLserver

I have lost my password to my SQL server can someone help me retrieve it or
should I delete this server and download a new one?Can you log in from the console or a domain admin account, using Windows
authentication, and change the password?
--
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"RonP" <RonP@.discussions.microsoft.com> wrote in message
news:7119DAA8-68B0-416D-A53E-9EE46856B5B7@.microsoft.com...
>I have lost my password to my SQL server can someone help me retrieve it or
> should I delete this server and download a new one?|||Look at this here if you are abel to change to mixed mode:
http://groups.google.de/group/comp.databases.ms-sqlserver/browse_frm/thread/3f6b23861fd54c77
Then change the password ( If you ment that you lost the password of
the sa ) within a sql statement like:
EXEC sp_password 'sa', 'newpassword'
HTH, Jens Suessmeyer

MsSQL Software

is there any free web apps out there that can interface with an SQL Server in real time, like add, edit, delete, update and search the DB?Ummm yeah, any ideas?|||There's always Query Analyzer, the free query tool that ships with MS-SQL Server. Free to use as long as the server you connect to is licensed.

If you're looking for a non-MS tool, just google 'SQL Query tool' and you'll find lots of stuff or check tucows.|||Originally posted by loach
There's always Query Analyzer, the free query tool that ships with MS-SQL Server. Free to use as long as the server you connect to is licensed.

If you're looking for a non-MS tool, just google 'SQL Query tool' and you'll find lots of stuff or check tucows.

Thats not what I am talkin about, I dont want to find an SQL Query tool, I want a full GUI interface to control the DB. All the programs I found in google to view and export data. I dont want a program that just lets you control the DB via SQL statements alone...|||I guess I don't really understand what you're looking for. What is it that you're looking for that Enterprise Manager does not do?|||Originally posted by sabastious
Thats not what I am talkin about, I dont want to find an SQL Query tool, I want a full GUI interface to control the DB. All the programs I found in google to view and export data. I dont want a program that just lets you control the DB via SQL statements alone...

Hello.

See if this help... I have not tried it myself yet.

http://www.msde.biz/msdequery/download.htm|||Originally posted by sabastious
is there any free web apps out there that can interface with an SQL Server in real time, like add, edit, delete, update and search the DB?

myLittleAdmin : http://www.myLittleTools.net/mla_sql

This is a web-based GUI for MS Sql.

best regards|||You can link to your SQL Server database via a Microsoft Access database Access Data Project (.adp file extension) and control many things such as table, view, and procedure creation as well as data manipulation. It acts like a stripped down Enterprise Manager.

But again, why not just use Enterprise Manager?

blindman