C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Reviews   Communities   Interview   Jobs   Projects   Training   Your Ad Here    
Silverlight Games | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Polls | Revenue Sharing | Lobby | Gift Shop |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...




Forums » .NET » SQL Server »

Can not login to sql server using sql browser


Posted Date: 03 Nov 2009      Posted By: Johney Joseph      Member Level: Silver     Points: 1   Responses: 3



I deleted the database from sqlserver so as to restore from a backup. during deletion i just checked the close all active connections also checkbox. Since i couldnot connect after that i closed sql and tried reconnecting . it gave the message : login failed. Message: Cannot open default database. The database deleted was the default one. What shall be done now than reinstalling ?

thanks & Regards,
Johney
First Orange Properties, Palarivattom, kochi



Responses
Author: Dharmaraj    03 Nov 2009Member Level: DiamondRating: 1 out of 5     Points: 1

Hi,
The problem may be due to you may have created a login for the database.If you have removed the database, all the login associated with the database may be lost. Try to create the same login before restoring the database.

Regards,
Dharma
Editor,Mentor,MVM
Try and fail but don't fail and try
Me and DNS


Author: Anil Kumar Pandey    03 Nov 2009Member Level: DiamondRating: 1 out of 5     Points: 1

create the new login.... for same as the previous for that data base..

Thanks & Regards
Anil Kumar Pandey



Author: Johney Joseph    03 Nov 2009Member Level: SilverRating: 2 out of 52 out of 5     Points: 2

I havenot created any logins. only windows authentication is used.

thanks & Regards,
Johney
First Orange Properties, Palarivattom, kochi


Post Reply
You must Sign In to post a response.
Next : Pls chk arrow marks in this sp
Previous : How many columns in a Select?
Return to Discussion Forum
Post New Message
Category: SQL Server

Related Messages


dotNet Slackers

About Us    Contact Us    Privacy Policy    Terms Of Use