Flummoxed by Connection Problem

Everything was working fine until suddenly this problem appeared from
nowhere:
Boot up the pc and go into SQL Server Management Studio. The database is
present and the data can be accessed.
Go into VB2005 Express and run the project. Everything works fine.
Open Database Explorer and connect to the database and the following
happens:
1. The project no longer works and this error appears at cnn.open()
'Cannot open user default database. Login failed. Login failed for user'
2. The database is no longer available in Management Studio. It appears
but no longer has the little + sign next to it and the data is no longer
accessible. If I try and view the database properties I get this error:
Cannot show requested dialog.
ADDITIONAL INFORMATION:
Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt)
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.Express.ConnectionInfo)
Database 'T:\VS_DATA\NORTHWND.MDF' cannot be opened due to inaccessible
files or insufficient memory or disk space. See the SQL Server errorlog
for details. (Microsoft SQL Server, Error: 945)
The only way I can get out of this situation is to reboot my pc. I am ok
as long as I don't try and connect to the database via Database Explorer.
I have tried disconnecting from and even deleting the database in Database
Explorer to no avail. HELP!
Des
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/I have narrowed down the sequence:
If I close the connection to the database in VB2005 Database Explorer
(very important) and then restart the server my project works again. But
as sonn as I connect vian Database Explorer it breaks again.
On Tue, 17 Jul 2007 12:32:05 +0100, DesCF <descf@.aol.com> wrote:

> Everything was working fine until suddenly this problem appeared from
> nowhere:
> Boot up the pc and go into SQL Server Management Studio. The database
> is present and the data can be accessed.
> Go into VB2005 Express and run the project. Everything works fine.
> Open Database Explorer and connect to the database and the following
> happens:
> 1. The project no longer works and this error appears at cnn.open()
> 'Cannot open user default database. Login failed. Login failed for user'
> 2. The database is no longer available in Management Studio. It appears
> but no longer has the little + sign next to it and the data is no longer
> accessible. If I try and view the database properties I get this error:
> Cannot show requested dialog.
> ADDITIONAL INFORMATION:
> Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt)
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.Express.ConnectionInfo)
> Database 'T:\VS_DATA\NORTHWND.MDF' cannot be opened due to inaccessible
> files or insufficient memory or disk space. See the SQL Server errorlog
> for details. (Microsoft SQL Server, Error: 945)
>
> The only way I can get out of this situation is to reboot my pc. I am
> ok as long as I don't try and connect to the database via Database
> Explorer. I have tried disconnecting from and even deleting the
> database in Database Explorer to no avail. HELP!
>
>
> Des
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Fixed It

Hey all, trying to attach to a database in SQL Server 2k5 Management Studio and I am getting the following Error:
--
TITLE: Microsoft SQL Server Management Studio

Attach database failed for Server '[MYDBSVRHERE]'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Could not find row in sysindexes for database ID 7, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
Could not open new database '[MYDBNAMEHERE]'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)

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

--

Does anybody have ANY idea about how to fix? Is this a permissions thing?
Thanks in advance!

So... I am a complete idiot!. I spent a DAY trying to figure out the problem. In the end, I had not installed SQL2k5. I had installed the tools, but they were connecting to SQL 2k.

thanks,

Dork|||Glad to hear you "fixed" the problem!|||

Hi,

my server have SQL Server 2000. I detach a database in this server and copy to my laptop.

I attact that database to SQL Server 2005 and do so many things on it.

some days after, i copy this file from my laptop to my server i try to attact it to SQL server 2000.

the same prolem appear.!!!

Does anyone know HOW TO fix? Thanks!

First time use of Analysis Services

I'm trying to connect to Analysis Services from my computer using Management Studio. MSAS is on a server outside the firewall, so I cannot connect to it using Window Authenication. When I try to connecting to it the option of changing the authenication is grayed out. Can someone help me figure out how to do this?You might be able to get around it by making creating a user on the AS box with the same name and password as you. I've been able to do that successfully in some scenarios, but not always.

first setup

I setup yesterday sql server 2008 on VPC for studio Orcas. Everything was smooth, however when I finished setup I did not see familiar enterprise management studio which allows to manage database files. what I can do?

Did you install management studio? During install there's a question about components you wish to install, you have to mark "Workstation components, Books Online and development tools". If you click the "Advanced" button you'll see that Management Studio is located in Client Components -> Management Tools branch.

Actually, I had a similar problem. After full install (including workstation components) Management Studio wasn't in my program list, no idea why. I started the setup program again, chose to install workstation components again and now it works perfectly.

|||i did exactly as you wrote. I nade setup twice. And third time it did not allow me to pass by because everything is installed. However the only thing that I have installed is configuration tools.|||

I'm running into a similar problem. I had SQL Server 2005 w/ SQL Server Manager loaded on XP SP2. I uninstalled SQL Server 2005, and loaded SQL Server 2008. However the SQL Server Mgr application didn't load. I attempted to reinstall SQL Server 2008, but it says they're no components that have changed...which indicates that the SQL Server 2008 Manager must be loaded already (but I don't see it)?

first setup

I setup yesterday sql server 2008 on VPC for studio Orcas. Everything was smooth, however when I finished setup I did not see familiar enterprise management studio which allows to manage database files. what I can do?

Did you install management studio? During install there's a question about components you wish to install, you have to mark "Workstation components, Books Online and development tools". If you click the "Advanced" button you'll see that Management Studio is located in Client Components -> Management Tools branch.

Actually, I had a similar problem. After full install (including workstation components) Management Studio wasn't in my program list, no idea why. I started the setup program again, chose to install workstation components again and now it works perfectly.

|||i did exactly as you wrote. I nade setup twice. And third time it did not allow me to pass by because everything is installed. However the only thing that I have installed is configuration tools.|||

I'm running into a similar problem. I had SQL Server 2005 w/ SQL Server Manager loaded on XP SP2. I uninstalled SQL Server 2005, and loaded SQL Server 2008. However the SQL Server Mgr application didn't load. I attempted to reinstall SQL Server 2008, but it says they're no components that have changed...which indicates that the SQL Server 2008 Manager must be loaded already (but I don't see it)?