sql server intance and password

Question

sql server intance and password

sql_2005_fan

SSCommitted

Points: 1871
More actions
February 4, 2013 at 12:01 pm

#273771

Hi,
I have installed an instance of sql server 2008 R2 in the year 2010 and I have'nt used it for last two years. I don't have the password and login of any user account and my windows login is not working as well.
How can I connect to this database engine? Is this possible at all?
Thanks.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Here is one possible solution

http://sqlblog.com/blogs/argenis_fernandez/archive/2011/07/10/think-your-windows-administrators-don-t-have-access-to-sql-server-2008-by-default-think-again.aspx

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

iamradhas SSC Rookie Points: 43 More actions · Answer 2

iamradhas

SSC Rookie

Points: 43

February 4, 2013 at 12:14 pm

#1584081

try using default login and password - sa/sa

Sean Lange SSC Guru Points: 286590 More actions · Answer 3

Do you have any applications that use this database? If so, look at the connection string. 😛

If not, wouldn't it be easier to just uninstall and reinstall?

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

Sean Lange (2/4/2013)
Do you have any applications that use this database? If so, look at the connection string. 😛
If not, wouldn't it be easier to just uninstall and reinstall?

Particularly if it is just on your own workstation

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events