SQL Server Error when accessing Geodatabase

TimHayes — Sat, 26 Jan 2013 16:34:12 GMT

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=4064

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.

Re: SQL Server Error when accessing Geodatabase

TimHayes — Sat, 26 Jan 2013 21:00:05 GMT

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=4064

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-login-failed-login-failed-for-user/

topic Re: SQL Server Error when accessing Geodatabase in Data Management Questions

SQL Server Error when accessing Geodatabase

Re: SQL Server Error when accessing Geodatabase