Community

SQL Server Error when accessing Geodatabase

829
1
01-26-2013 08:34 AM
TimHayes
by
Occasional Contributor III
‎01-26-2013 08:34 AM
I am using ArcSDE 10.1.0 and SQL Server Express 2008 R2.

I created two databases using SQL Server Management Studio; Database1 and Database2.

I am the DBO of both these databases.

I then exited SQL Server Management Server Studio and began doing the rest of the database administration work via ArcCatalog and ArcMap.

I then realized I no longer needed Database 1. I disconnected it from ArcGIS using ArcCatalog.

I then went into SQL Server Management Studio and right clicked on Database1 and chose Delete. In the Delete Database Dialog Box, I put a check in the "Close Connection" Box. Then hit ok. Database1 was then deleted.

However, now when I try and log into SQL Server Management Studio, I get an error saying:
"Cannot connect to MYSERVER\INSTANCENAME"
Additional Information:
"Cannot open user default database. Login failed."
"Login failed for user MYUSERNAME (Microsoft SQL Server, Error: 4064)"

I checked the Help and I was taken to this link:
http://www.microsoft.com/products/ee/transform.aspx?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer...

It says under ACTION that I need to use AlterLogin. Any ideas on how I can log back into SQL Server Management Studio?

I checked my SDE connections to Database 2 in ArcCatalog and it works fine inside ArcMap and ArcCatalog; the data is all there. No problems.
1 Reply
TimHayes
by
Occasional Contributor III
‎01-26-2013 01:00 PM
I am using ArcSDE 10.1.0 and SQL Server Express 2008 R2.

I created two databases using SQL Server Management Studio; Database1 and Database2.

I am the DBO of both these databases.

I then exited SQL Server Management Server Studio and began doing the rest of the database administration work via ArcCatalog and ArcMap.

I then realized I no longer needed Database 1. I disconnected it from ArcGIS using ArcCatalog.

I then went into SQL Server Management Studio and right clicked on Database1 and chose Delete. In the Delete Database Dialog Box, I put a check in the "Close Connection" Box. Then hit ok. Database1 was then deleted.

However, now when I try and log into SQL Server Management Studio, I get an error saying:
"Cannot connect to MYSERVER\INSTANCENAME"
Additional Information:
"Cannot open user default database. Login failed."
"Login failed for user MYUSERNAME (Microsoft SQL Server, Error: 4064)"

I checked the Help and I was taken to this link:
http://www.microsoft.com/products/ee/transform.aspx?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer...

It says under ACTION that I need to use AlterLogin. Any ideas on how I can log back into SQL Server Management Studio?

I checked my SDE connections to Database 2 in ArcCatalog and it works fine inside ArcMap and ArcCatalog; the data is all there. No problems.


I found the solution, this works: 
http://blog.sqlauthority.com/2008/11/04/sql-server-fix-error-4064-cannot-open-user-default-database-...