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&EvtID=4064It 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.
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
