Attaching SQL Server DB

Question

0.00/5 (No votes)

See more:

Hi all,

I changed my SQL server options so the specific DB
is the default DB and the other day I detatched the DB for some reason
and know I can't connect to my SQL server because its
looking for that specific DB that I detatched.

When I press the connect button in SQL Server Management Studio
it gives me this error: And doesn't connect

CSS

Connect to Server

Cannot connect to BEN-PC.

ADDITIONAL INFORMATION:

Cannot open user default database. Login failed.
Login failed for user 'BEN-PC\Ben'. (Microsoft SQL Server, Error: 4064)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=4064&LinkId=20476

Please help what can I do?

Posted 23-Jan-12 21:29pm

Ben Paxton

Updated 23-Jan-12 22:02pm

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2012-01-23T21:48:00

Solution 1

Go to SQL Server Management Studio.
Log in as normal, then right click "Databases" in the Left hand pane ("Object explorer").
Select "Attach..." and follow the dialogs.

Posted 23-Jan-12 21:48pm

OriginalGriff

Comments

Ben Paxton 24-Jan-12 3:54am

Thats just the problem I can't connect as normal. It shows an error

OriginalGriff 24-Jan-12 4:01am

No, just run SSMS - not your application. All it requires is your usual log in (which needs no specific database). You can then reconnnect the DB.
You do not need to connect to a DB just to log in to SSMS

Ben Paxton 24-Jan-12 4:04am

I changed the logging settings of SSMS and set a deafualt DB

OriginalGriff 24-Jan-12 4:07am

When you get the log in screen, Press the "Options" button - you should be able to change the default DB from there.

Ben Paxton 24-Jan-12 4:10am

I did try that aswell. It shows a message box asking to connect to SQL server management studio. If I press "Yes" it just shows once again that it can't connect and when I press "No" nothing happens

OriginalGriff 24-Jan-12 4:21am

Oops! :laugh:
I think you are going to be on your own to a certain extent - I can't change my installation to match yours, nothing else would work - but you may be able to get round it with the command line, or by editing the SQL application config file.
There is some info here that may be helpful, but I would start taking notes about what I tried / did so I could undo the unsuccessful ones. The other alternative is to un-install and reinstall, or try a repair install.
http://www.mssqltips.com/sqlservertip/1602/sql-server-management-studio-customized-startup-options/
Good luck! I hope you won't need it!

Ben Paxton 24-Jan-12 4:24am

Hehe thanks for the help, gonna see what I can do

Manoj Kumar Choubey · Answer 2 · 2012-01-23T21:50:00

Quote:
http://www.linglom.com/2009/08/11/restore-database-from-sql-server-2008-to-sql-server-2005-part-1-introduction/

http://www.c-sharpcorner.com/uploadfile/raj1979/how-to-attach-a-database-in-sql-server-2005/

http://www.packtpub.com/article/moving-a-database-from-sql-server-2005-to-sql-server-2008-in-three-steps

http://www.mssqltips.com/sqlservertip/1894/attach-a-sql-server-database-with-a-missing-transaction-log-file/