domain.com\domain users was added as a user and the default database was set to a database that domain users do not have permissions. Now when trying to connect through the enterprise manager, I get.
A connection could not be established to (LOCAL).
Reason: Cannot open user default database. Login failed..
Is there anyway to clear the default database for domain.com\domain users? I do not have the password for the SA or I would have used it. The domain user account is a domain admin which has permissions in sql. Does anyone know how I can remotely reset the default database, like with a VB script?
Start, Help. You'll be surprised what's there. A+/MCP/MCSE/MCDBA
A connection could not be established to (LOCAL).
Reason: Cannot open user default database. Login failed..
Is there anyway to clear the default database for domain.com\domain users? I do not have the password for the SA or I would have used it. The domain user account is a domain admin which has permissions in sql. Does anyone know how I can remotely reset the default database, like with a VB script?
Start, Help. You'll be surprised what's there. A+/MCP/MCSE/MCDBA