Thanks alot 😉

Evil Kraig F (7/24/2014)

---

You lack research, young padawan. Let us show you where you errored.

so we decided...

master.huricane (2/25/2013)

---

AndrewSQLDBA (2/25/2013)

---

You can try renaming the database database

EXEC sp_renamedb 'oldName', 'newName'

Or you can detach it and attach it again, giving it a new name and a new location...

AndrewSQLDBA (2/25/2013)

---

You can try renaming the database database

EXEC sp_renamedb 'oldName', 'newName'

Or you can detach it and attach it again, giving it a new name and a new location on...

AndrewSQLDBA (2/25/2013)

---

I see now, that entire path statement is your database name. You do not name the database as a path statement to a file. SQL does not work that...

David Webb-200187 (2/25/2013)

---

What database are you trying to open in the login? I've seen this when the database specified in an ODBC connection doesn't exist on the server or...

AndrewSQLDBA (2/25/2013)

---

A couple things.

First

You should Never, Ever use the SysAdmin account for any app/website to database connections. That is for a SysAdmin only.

Second

What is your front-end app? That connection...