Forums Register Login

Problem with SQL Server

+Pie Number of slices to send: Send
When I try to connect SQL Server I get this error: database cannot be opened
I'm hoping someone here has experience in this and knows how to make sql db fix

Any help/advice would be appreciated,

Damon
+Pie Number of slices to send: Send
How are you attempting to connect to the database - command line, Java/JDBC application, IDE such as Visual Studio, ???

Is there any more information in the error message?  If there is, can you copy the complete message here?
+Pie Number of slices to send: Send
I connect  to data in a SQL Server database using the .NET Framework Data Provider for SQL Server.
+Pie Number of slices to send: Send
There is no info, just annoying error : Database cannot be opened
+Pie Number of slices to send: Send
Hi Damon,

Is the SQL Server local to your machine ?

Are you sysadmin on it (scary though) ?

If not a sysadmin, does your user exists in the Target database ?

And before all of the above, is the Database in Read/Write mode or is in Suspect state ?

You can take assistance of SQL DBA who can set you up with the necessary and sufficient privileges.
+Pie Number of slices to send: Send
Welcome to the Ranch, Devesh, and thank you for your contribution.
+Pie Number of slices to send: Send
Hello,

The solution to log on is: From the Connect to Server dialog, click Options. Change value of Connect to database: to any valid database on the server. The permanent solution to fix the server is to run SQL like: ALTER LOGIN [test] WITH DEFAULT_DATABASE = master GO.  Other method to troubleshoot this is - https://www.fixtoolbox.com/sqlserverfix.html


Best Regards
+Pie Number of slices to send: Send
I want to say thank you for taking the time to share how to go about fixing this.
+Pie Number of slices to send: Send
Damon, does that mean you've resolved the problem to your satisfaction?
You don't know me, but I've been looking all over the world for. Thanks to the help from this tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 579 times.
Similar Threads
RMI Problem
how to connect to SQL server 2000 in WSAD 5.1
Doubt in closing connection, resultset, statemnet object???
Netbeans: Problems with Database Connections
Sudden database connection problem
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 19, 2024 03:19:35.